Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¨1£©

Oracle°²×°Æª
°æ±¾£ºwin32_11gR1_database_1013
ϵͳ£ºwin7
Äڴ棺3g£¨Å¼×Ô¼ºµØ-0-£©
1¡¢ÒòΪ²Ù×÷ϵͳѡÔñÁËwin7£¬ËùÒÔÔÚ°²×°Ö®Ñ¡ÐèÒªÐÞ¸ÄÒ»ÏÂÅäÖÃÎļþ£¬database\stage\prereq\db\refhost.xml
2¡¢ÐÞ¸ÄÍêÅäÖÃÎļþºó£¬µãinstall°²×°¼´¿É£¬µÈdos½çÃæ¼ÓÔØÍêºóÌø³öÈçϽçÃæ
 
 3¡¢ÏÂÒ»²½
4¡¢Ñ¡ÔñÆóÒµ°æ£¬È»ºó ......

´óÐÍÊý¾Ý¿âÓÅ»¯Éè¼ÆÇ³Ì¸(ORACLE) £¨Ò»£©

  
   ¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû,µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû,×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¼¸¸ö²»Í¬·½Ã ......

Oracle SQLÓÅ»¯¼¼ÇÉ

ÎÒ¾õµÃÖ÷ÒªÓ¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
ÏÖÔÚ¼òµ¥µÄ¾Ù¼¸¸öÀý×Ó
Where×Ó¾äÖÐÓГ!=”½«²»Ê¹ÓÃË÷Òý
select account_name from test where amount != 0  (²»Ê¹ÓÃ) ......

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ºÅ