ORACLEµ÷ÓÅÖ® ¶à»º´æ³ØÃüÖÐÂÊ£¨Õª×ÔÎÄƽÊ飩
ÆÀ¹ÀÊý¾Ý¸ßËÙ»º´æЧÂʵÄÖ¸±êÊÇÃüÖÐÂÊ¡£¸ÃÃüÖÐÂÊͨ¹ý²éѯV$SYSSTAT ºÍ$BUFFER_POOL_STATISTICSÊÓͼ¿ÉÒԵõ½¡£Õâ¸öÊÓͼ¿ÉÒÔ
²éѯÿ¸ö»º´æ³Ø¸÷×ÔµÄÃüÖÐÂÊ¡£»º´æ³ØµÄÃüÖÐÂʵļÆËã²ÉÓÃÏÂÃæµÄ¹«Ê½:
1-(physical_reads/(db_block_gets+consistent_gets))
ÏÂÃæµÄSQLÓï¾ä³£ÓÃÀ´²éѯµ±Ç°¸÷¸ö»º´æ³ØµÄÃüÖÐÂÊÇé¿ö:
SQL>select name,physical_reads,db_block_gets,consistent_gets,
1-(physical_reads/(db_block_gets+consistent_gets)) "ÃüÖÐÂÊ"
from v$buffer_pool_statistics;
SQL> select name,physical_reads,db_block_gets,consistent_gets,
2 1-(physical_reads/(db_block_gets+consistent_gets)) "ÃüÖÐÂÊ"
3 from v$buffer_pool_statistics;
NAME PHYSICAL_READS DB_BLOCK_GETS CONSISTENT_GETS ??????
-------------------- -------------- ------------- --------------- ----------
DEFAULT 3806 1541 44202 .916796013
ͨ¹ý¶ÔV$BHÊÓͼµÄ²éѯ¿ÉÒÔ»ñµÃµ±Ç°´æ·ÅÔÚSGAÖеÄËùÓÐÊý¾Ý¿éµÄ¿éID£¬ÏÂÃæÁгöÁËÁ½ÖÖ·½·¨£¬ÓÃÀ´ÕÒ³öÊý¾Ý¿â¶ÔÏó£¨±í¡¢Ë÷ÒýµÈ
¶Î¶ÔÏó£©Õ¼ÓÃÊý¾Ý»º´æµÄ״̬£¬»òÕßij¸ö¶ÎʹÓûº´æµÄÇé¿ö¡£ÏÂÁеIJéѯÓï¾äÁгöÁ˵±Ç°Êý¾Ý¸ßËÙ»º´æÖдæ·ÅµÄËùÓÐÊý¾Ý¿éµÄ¶ÎÃû£¬
ÒÔ¼°¸Ã¶ÎÔÚÊý¾Ý»º´æÖÐÊý¾Ý¿éµÄ¼ÆÊý:
SQL>select o.object_name OBJECT_NAME,count(*) number_of_blocks
from dba_objects o,v$BH bh
where o.data_object_id=bh.objd
and o.owner not in('SYS','SYSMAN')
 
Ïà¹ØÎĵµ£º
sql serverºÍoracleÐÐתÁеÄÒ»ÖÖµäÐÍ·½·¨
Ç°ÑÔ£ºÍøÉÏÓв»ÉÙÎÄÕÂÊǽ²ÐÐתÁеģ¬µ«ÊǴ󲿷ֶ¼ÊÇÖ±½ÓÌù´úÂ룬ºöÊÓÁËÖмä¹ý³Ì£¬±¾ÈË×Ô¼ºË¼¿¼ÁËÏÂΪʲôҪÕâÑùʵÏÖ£¬²¢ÇÒ×öÁËÈçϵıʼǣ¬¶ÔÓÐЩ¶®µÄÈËÀ´Ëµ¿ÉÄÜûÓмÛÖµ£¬Ï£Íû¶Ô»¹²»¶®µÄÈËÓÐÒ»µã½è¼øÒâÒå¡£
¶ÔÓÚÓÐЩҵÎñÀ´Ëµ£¬Êý¾ÝÔÚ±íÖеĴ洢ºÍÆä×îÖÕµÄGrid±íÏÖÇ¡ºÃÏ൱ÓÚ°ÑÔ ......
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌض¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
¡¡¡¡* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄֵʹÓû§¾ßÓвÙ×÷Êý¾Ý¿âµÄijÖÖȨÀû¡£
¡¡¡¡# ¿ÉÒÔ»ùÓÚʱ¼äÏÞÖÆÓû§µÄ²Ù×÷£¬ÀýÈç²»ÔÊÐíÏ°àºóºÍ½Ú¼ÙÈÕÐÞ¸ÄÊý¾Ý¿âÊý¾Ý¡£ ......
Can you connect to an Oracle database with a 64-bit Oracle client?
Technote (FAQ)
Question
You are unable to connect to an Oracle database with a 64-bit Oracle client. Does Lotus Enterprise Integrator (LEI), Lotus Domino Enterprise Connection Services (DECS), or LSX ......
select sid,
p1,
p1raw,
p2,
p2raw,
p3,
p3raw,
&n ......
MySQL:
SELECT column from table
ORDER BY RAND()
LIMIT 1
PostgreSQL:
SELECT column from table
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server:
SELECT TOP 1 column from table
ORDER BY NEWID()
IBM DB2
SELECT column, RAND() as IDX
from table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Thanks Ti ......