Oracle¶¯Ì¬ÐÔÄܱí
(1) v$sql
¡¡¡¡Ò»ÌõÓï¾ä¿ÉÒÔÓ³Éä¶à¸öcursor,ÒòΪ¶ÔÏóËùÖ¸µÄcursor¿ÉÒÔÓв»Í¬Óû§(ÈçÀý1)¡£Èç¹ûÓжà¸öcursor(×ÓÓαê)´æÔÚ£¬ÔÚV$SQLAREAΪËùÓÐcursorÌṩ¼¯ºÏÐÅÏ¢¡£
Àý1£º
ÕâÀï½éÉÜÒÔÏÂchild cursor
user A: select * from tbl
user B: select * from tbl
´ó¼ÒÈÏΪÕâÁ½ÌõÓï¾äÊDz»ÊÇÒ»ÑùµÄ°¡£¬¿ÉÄÜ»áÓкܶàÈË»á˵ÊÇÒ»ÑùµÄ£¬µ«ÎÒ¸æËßÄã²»Ò»¶¨£¬ÄÇÎªÊ²Ã´ÄØ£¿
Õâ¸ötblA¿´ÆðÀ´ÊÇÒ»ÑùµÄ£¬µ«ÊDz»Ò»¶¨Å¶£¬Ò»¸öÊÇAÓû§µÄ, Ò»¸öÊÇBÓû§µÄ£¬ÕâʱËûÃǵÄÖ´Ðмƻ®·ÖÎö´úÂë²î±ð¿ÉÄܾʹóÁËŶ£¬¸ÄÏÂд·¨´ó¼Ò¾ÍÃ÷°×ÁË:
select * from A.tbl
select * from B.tbl
¡¡¡¡ÔÚ¸ö±ðcursorÉÏ£¬v$sql¿É±»Ê¹Ó᣸ÃÊÓͼ°üº¬cursor¼¶±ð×ÊÁÏ¡£µ±ÊÔͼ¶¨Î»session»òÓû§ÒÔ·ÖÎöcursorʱ±»Ê¹Óá£
¡¡¡¡PLAN_HASH_VALUEÁд洢µÄÊÇÊýÖµ±íʾµÄcursorÖ´Ðмƻ®¡£¿É±»ÓÃÀ´¶Ô±ÈÖ´Ðмƻ®¡£PLAN_HASH_VALUEÈÃÄã²»±ØÒ»ÐÐÒ»ÐжԱȼ´¿ÉÇáËɼø±ðÁ½ÌõÖ´Ðмƻ®ÊÇ·ñÏàͬ¡£
V$SQLÖеÄÁÐ˵Ã÷£º
l SQL_TEXT£ºSQLÎı¾µÄǰ1000¸ö×Ö·û
l SHARABLE_MEM£ºÕ¼ÓõĹ²ÏíÄÚ´æ´óС(µ¥Î»£ºbyte)
l PERSISTENT_MEM£ºÉúÃüÆÚÄڵĹ̶¨ÄÚ´æ´óС(µ¥Î»£ºbyte)
l RUNTIME_MEM£ºÖ´ÐÐÆÚÄڵĹ̶¨ÄÚ´æ´óС
l SORTS£ºÍê³ÉµÄÅÅÐòÊý
l LOADED_VERSIONS£ºÏÔʾÉÏÏÂÎĶÑÊÇ·ñÔØÈ룬1ÊÇ0·ñ
l OPEN_VERSIONS£ºÏÔʾ×ÓÓαêÊÇ·ñ±»Ëø£¬1ÊÇ0·ñ
l USERS_OPENING£ºÖ´ÐÐÓï¾äµÄÓû§Êý
l FETCHES£ºSQLÓï¾äµÄfetchÊý¡£
l EXECUTIONS£º×ÔËü±»ÔØÈ뻺´æ¿âºóµÄÖ´ÐдÎÊý
l USERS_EXECUTING£ºÖ´ÐÐÓï¾äµÄÓû§Êý
l LOADS£º¶ÔÏó±»ÔØÈë¹ýµÄ´ÎÊý
l FIRST_LOAD_TIME£º³õ´ÎÔØÈëʱ¼ä
l INVALIDATIONS£ºÎÞЧµÄ´ÎÊý
l &n
Ïà¹ØÎĵµ£º
2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚȡֵ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖÆ±íÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
table ......
oracle Âß¼±¸·ÝÃüÁîEXP/IMP²ÎÊý²Î¿¼ÊÖ²á
°ïÖúÃüÁexp help=y
Export: Release 10.2.0.1.0 - Production on Thu Jul 20 10:39:50 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed b ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄǰÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......
µ¼¶Á£º
¡¡¡¡2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ ......