Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

²éѯOracle×ÊԴʹÓÃÇé¿ö

SELECT trim(NAME) ||'            '|| VALUE from v$parameter
WHERE NAME IN ('sga_max_size','db_cache_size','shared_pool_size',
'shared_pool_reserved_size','large_pool_size','java_pool_size',
'db_block_size','db_block_buffers','log_buffer','sort_area_size',
'sort_area_retained_size','hash_area_size','sessions','open_cursors')
ORDER BY NAME;
TRIM(NAME)||''||VALUE
--------------------------------------------------------------------------------
db_block_buffers                        0                        0          
db_block_size                               8192                           8192       
db_cache_size                                   2,281,701,376                 8,589,934,592 
hash_area_size                                4194304                       131072     
java_pool_size             &


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âµÄÆÕÍ¨Ç¨ÒÆ·½·¨

ÔÚÏàͬ²Ù×÷ϵͳ»·¾³Ï£¬Ïàͬ°æ±¾OracleÊý¾Ý¿âµÄÇ¨ÒÆ±È½Ï¼òµ¥¡£
 
´óÖ²½Ö裺
1¡¢È·¶¨Ô´»úµÄ²Ù×÷ϵͳÀàÐͺͰ汾£¬Ô´»úÖ÷»úÃû£»Oracle°æ±¾£¬°²×°Ä¿Â¼£¬SID¡£
±¾ÀýÖУ¬Ô´»úΪ£º  Win2k Adv£¬ ywxt£¬Oracle v8.17,  d:\oracle, orcl
Ä¿±ê»úΪ£ºWin2003£¬ywxt£¬Oracle v8.17,  d:\oracle, orcl
  ......

oracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´

oracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨°üÀ¨»úÆ÷¹ÊÕÏ¡¢½éÖʹÊÕÏ¡¢Îó²Ù×÷µÈ£©£¬Êý¾Ý¿âÓÐʱҲ¿ÉÄÜÔâµ½ÆÆ»µ£¬ÕâʱÈçºÎ¾¡¿ì»Ö¸´Êý¾Ý¾Í³ÉΪµ±ÎñÖ®¼±¡£Èç¹ûƽʱ¶ÔÊý¾Ý¿â×öÁ˱¸·Ý£¬ÄÇô´Ëʱ»Ö¸´Êý¾Ý¾ÍÏԵúÜÈÝÒס£Óɴ˿ɼû£¬×öºÃÊý¾Ý¿âµÄ±¸·ÝÊǶ ......

OracleÖ´ÐÐÍⲿÎļþ£º

OracleÖ´ÐÐÍⲿÎļþ£º
c:>sqlplus user/pwd@db
sql>@new.sql
Ö´Ðжà¸ösqlÎļþ:
1.°ÑËùÓеÄÎļþ¶¼·ÅÔÚͬһ¸öĿ¼Ï£¬È»ºóÔÚÃüÁîÐÐÀïÖ´ÐÐÃüÁ
         c:>dir/b > d:\1.sql
   »á°ÑËùÓеÄsqlÎļþÃû¶¼Êä³öµ½Ò»¸ösqlÎļþÖС£
2.ÓÃUltraEdit´ò¿ªÉú³ÉµÄ ......

oracleÖе÷Óôø²ÎÊýµÄ´æ´¢¹ý³Ì

create or replace procedure proc_test
( a in number, b out number )
as
begin
b:=a+1;
end    proc_test;
ÏÖÔÚÒªµ÷Óõϰ¾ÍÊÇÕâÑù
SQL> c number;
SQL>exec proc_test(1,:c);
ǧÍòҪעÒâ±ðÍüÁËдðºÅ ......

oracle uptimeµÄbug

Ö¢×´£ºoracle sqlplusû·´Ó¦
oracle10gµÄÓÐÊ®¼¸¸ö»úÆ÷¿Í»§¶Ë10.2.0.1.0£¬Ö´ÐÐsqlplusÕâ¸öÃüÁîû·´Ó³¡£´ËʱcpuʹÓÃΪ99.9%£¬¹Û²ìÁËÒ»»á£¬²»ÊÍ·Å¡£
oracleÆäËûÃüÁî¶¼ºÃʹ¡£
»·¾³±äÁ¿¡¢ping tnsnameµÈ¶¼Ã»ÎÊÌâ¡£¡£ÇÒÕâЩ»úÆ÷¶¼ÊÇÖÁÉÙÔËÐÐÁË200¶àÌì×óÓÒ£¬
µ«Ò»µ©ÖØÆôOS¾ÍºÃʹÁË¡£¡£
»òÕß²»ÖØÆôOS£¬»»³É9iµÄ¿Í»§¶Ë£¬sqlplus ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ