¡¾×ª¡¿oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
PID£ºoracle½ø³ÌID
SPID£º²Ù×÷ϵͳ½ø³ÌID
V$PROCESSÖеÄÁ¬½ÓÁÐ
Column View Joined Column(s)
ADDR V$SESSION PADDR
v$sessionÊÓͼ
V$SESSIONÊÇ»ù´¡ÐÅÏ¢ÊÓͼ£¬ÓÃÓÚÕÒÑ°Óû§SID»òSADDR¡£²»¹ý£¬ËüÒ²ÓÐһЩÁлᶯ̬µÄ±ä»¯£¬¿ÉÓÃÓÚ¼ì²éÓû§¡£
³£ÓÃÁУº
SID£ºSESSION±êʶ£¬³£ÓÃÓÚÁ¬½ÓÆäËüÁÐ
SERIAL#£ºÈç¹ûij¸öSIDÓÖ±»ÆäËüµÄsessionʹÓõĻ°Ôò´ËÊýÖµ×ÔÔö¼Ó(µ±Ò»¸öSESSION½áÊø£¬ÁíÒ»¸öSESSION¿ªÊ¼²¢Ê¹ÓÃÁËͬһ¸öSID)¡£
AUDSID£ºÉó²ésession IDΨһÐÔ£¬È·ÈÏËüͨ³£Ò²ÓÃÓÚµ±Ñ°ÕÒ²¢Ðвéѯģʽ
USERNAME£ºµ±Ç°sessionÔÚoracleÖеÄÓû§Ãû¡£
STATUS£ºÕâÁÐÓÃÀ´ÅжÏsession״̬ÊÇ£º
Achtive£ºÕýÖ´ÐÐSQLÓï¾ä(waiting for/using a resource)
Inactive£ºµÈ´ý²Ù×÷(¼´µÈ´ýÐèÒªÖ´ÐеÄSQLÓï¾ä)
Killed£º±»±êעΪɾ³ý
paddr, process addr, ͨ¹ýÕâ¸ö×Ö¶ÎÎÒÃÇ¿ÉÒԲ鿴µ±Ç°½ø³ÌµÄÏà¹ØÐÅÏ¢, ϵͳ½ø³Ìid,²Ù×÷ϵͳÓû§ÐÅÏ¢µÈµÈ.
(sql_address,sql_hash_value) (prev_sql_addr,prev_hash_value) ¸ù¾ÝÕâÁ½×é×Ö¶Î, ÎÒÃÇ¿ÉÒÔ²éѯµ½µ±Ç°sessionÕýÔÚÖ´ÐеÄsqlÓï¾äµÄÏêϸ
ÐÅÏ¢.
v$sqltextÊÓͼ
v$sqltextÊÓͼ°üÀ¨Shared poolÖÐSQLÓï¾äµÄÍêÕûÎı¾£¬Ò»ÌõSQLÓï¾ä¿ÉÄֳܷɶà¸ö¿é±»±£´æÓÚ¶à¸ö¼Ç¼ÄÚ¡£
³£ÓÃÁУº
HAS
Ïà¹ØÎĵµ£º
1.ÔÚORACLEÖÐʵÏÖ·Ö²¼Ê½¿ìËÙ´æÈ¡ºÍ³äʵÄÚ´æÊǺÜÖØÒªµÄ¡£
¡¡¡¡
¡¡¡¡Òª²»Ï§Èκδú¼Û±ÜÃâÒ³Ãæµ÷¶ÈºÍ½»»»﹐ÿ´Î¶¼±ØÐë°Ñϵͳȫ¾ÖÇø(SGA)·Åµ½ÄÚ´æ¡£
¡¡¡¡
¡¡¡¡½«SGA·Åµ½ÄÚ´æÖÐ﹐ÔÚINIT.ORAÖÐÉèÖòÎÊý PRE_PAGE_SGA
¡¡¡¡
¡¡¡¡PRE_PAGE_SGA=YES
¡¡¡¡
¡¡¡¡2.»Ø¾í¶ÎµÄ¾¹Õù»á½µµÍϵͳµÄÐÔÄÜ¡£
¡¡¡¡
¡¡¡¡SELECT¡ ......
ϵͳҪÇó£º
¡¡¡¡Äڴ棺ÍƼö1G
¡¡¡¡Swap·ÖÇø£ºÉèΪÄÚ´æµÄ2±¶
¡¡¡¡/tmp´ÅÅ̿ռ䣺400MBÒÔÉÏÈý
¡¡¡¡´ÅÅ̿ռ䣺Èí¼þ3.5G Êý¾Ý1.2G
¡¡¡¡ËùÐèÈí¼þ£º
¡¡¡¡SuSE Linux10 for x86
¡¡¡¡Oracle database 10gR2 for Linux32
¡¡¡¡Orarun-1.8-109.15.i586.rpmÈí¼þ°ü£¬¿ÉÒÔ´Óhttp://Ftp.novell.com/partners/Oracle/sels-9ÏÂÔØ
&n ......
ORACLEÊý¾Ý¿âµÄÈÕÖ¾Îļþ$ORACLE_BASE/admin/orasid/bdump/alert_orasid.log¼Ç¼ÁËÖØ×÷ÈÕÖ¾µÄת»»£¬
Êý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ£¬Êý¾Ý¿â½á¹¹µÄ¸Ä±ä£¬»ØÍ˶εÄÐ޸ģ¬ËÀËø£¬ÄÚ²¿´íÎóµÈÐÅÏ¢.
Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¼ì²éÕâ¸öÎļþÓÐÎÞORA-´íÎ󲢶¨ÆڵضÔÕâ¸öÈÕÖ¾Îļþ½øÐд浵ÕûÀí ......
centos 4.5Ï°²×°oracle 9204
Linux localhost.localdomain 2.6.9-55.ELsmp
Ò»£¬½âѹËõOracle9204µÄ°²×°Îļþ
1£® Oracle 9iR2 (9.2.0.4)
(1) ¼ò»¯¹ý³Ì£¨ÒÔoracleµÇ¼£¬ÊÍ·Å°²×°Îļþ,ʹÓøüÉٵĴÅÅ̿ռ䣬Ëٶȸü¿ì£©
ÔÚ°²×°LINUXʱ×îºÃ·ÖÒ»¸öÇø/orasetup,ÕâÑùÒ»À´¼´Ê¹ÏµÍ³»µÁË,Ò²Ö»ÊÇÖØװϵͳ,¶øÎÞÐëÖØÐ ......
ÔÚOracleÖв鿴ËùÓеıí:
select * from tab/dba_tables/dba_objects/cat;
¿´Óû§½¨Á¢µÄ±í :
select table_name from user_tables; //µ±Ç°Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§µÄ±í   ......