Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö±·½Í¼½âÎö
Ò»¡¢    ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»­³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......

Oracle ÒÆ¶¯Êý¾Ý¿âÎļþ


Oracle
ÒÆ¶¯Êý¾Ý¿âÎļþ

OracleÊý¾Ý¿âÓÉÊý¾ÝÎļþ£¬¿ØÖÆÎļþºÍÁª»úÈÕÖ¾Îļþ
ÈýÖÖÎļþ×é³É¡£
ÓÉÓÚ´ÅÅ̿ռäµÄ±ä»¯£¬»òÕß»ùÓÚÊý¾Ý¿â´ÅÅÌI/OÐÔÄܵĵ÷ÕûµÈ£¬ÎÒ們¿ÉÄܻῼÂÇÒÆ¶¯Êý¾Ý¿âÎļþ¡££¨×¢:
»Ö¸´Êý¾Ý¿âʱ·Ç³£
ÓÐÓã¬ÊôÓÚÀ䱸·Ý£©
²éѯµ±Ç°Êý¾Ý¿âÖÐ,Ïà¹ØÎļþ·¾¶

select * from v$datafile;
se ......

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 SQL Developer¹¤¾ß²»ÄÜÆô¶¯½â¾ö°ì·¨

ÏÂÔØ½âѹÁËOracle SQL Developer¹¤¾ß£¬ÔËÐÐʱ£¬Æô¶¯²»ÁË£¬±¨´íÐÅÏ¢ÈçÏ£º
---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<SQLDEVELOPER>\jdk\jre\bin\client\jvm.dll
---------------------------
ÊÇJVM²ÎÊýÉèÖõÄÎÊÌ⣬ÎҵĽâ¾ö·½°¸ÈçÏ£º
<SQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ