Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚOracleµÄsession

¹ØÓÚOracleµÄsession
      1.ÈçºÎ²é¿´session¼¶µÄµÈ´ýʼþ£¿
µ±ÎÒÃǶÔÊý¾Ý¿âµÄÐÔÄܽøÐе÷Õûʱ£¬Ò»¸ö×îÖØÒªµÄ²Î¿¼Ö¸±ê¾ÍÊÇϵͳµÈ´ýʼþ¡£$system_event,v$session_event,v$session_waitÕâÈý¸öÊÓͼÀï¼Ç¼µÄ¾ÍÊÇϵͳ¼¶ºÍsession¼¶µÄµÈ´ýʼþ£¬Í¨¹ý²éѯÕâЩÊÓͼÄã¿ÉÒÔ·¢ÏÖÊý¾Ý¿âµÄһЩ²Ù×÷µ½µ×Ôڵȴýʲô£¿ÊÇ´ÅÅÌI/O£¬»º³åÇøÃ¦£¬»¹ÊDzåËøµÈµÈ¡£
ͨ¹ýÈçÏÂsqlÄã¿ÉÒÔ²éѯÄãµÄÿ¸öÓ¦ÓóÌÐòµ½µ×Ôڵȴýʲô£¬´Ó¶øÕë¶ÔÕâЩÐÅÏ¢¶ÔÊý¾Ý¿âµÄÐÔÄܽøÐе÷Õû¡£
Select s.username,s.program,s.status,se.event,se.total_waits,se.total_timeouts,se.time_waited,se.average_wait
from v$session s, v$session_event se
Where s.sid=se.sid  And se.event not like 'SQl*Net%'  And s.status ='ACTIVE'  And s.username is not null
2.oracleÖвéѯ±»ËøµÄ±í²¢ÊÍ·Åsession
SELECT A.OWNER,A.OBJECT_NAME,B.XIDUSN,B.XIDSLOT,B.XIDSQN,B.SESSION_ID,B.ORACLE_USERNAME, B.OS_USER_NAME,B.PROCESS, B.LOCKED_MODE, C.MACHINE,C.STATUS,C.SERVER,C.SID,C.SERIAL#,C.PROGRAM
from ALL_OBJECTS A,V$LOCKED_OBJECT B,SYS.GV_$SESSION C
WHERE ( A.OBJECT_ID = B.OBJECT_ID ) AND (B.PROCESS = C.PROCESS ) ORDER BY 1,2
ÊÍ·Åsession Sql:
alter system kill session 'sid, serial#'
alter system kill session '379, 21132'
alter system kill session '374, 6938'
3.²é¿´Õ¼ÓÃϵͳio½Ï´óµÄsession
SELECT se.sid,se.serial#,pr.SPID,se.username,se.status,se.terminal,se.program,se.MODULE,se.sql_address,st.event,st.p1text,si.physical_reads,si.block_changes
from v$session se,¡¡v$session_wait st,v$sess_io si,v$process pr
WHERE st.sid=se.sid ¡¡AND st.sid=si.sid AND se.PADDR=pr.ADDR AND se.sid>6¡¡AND st.wait_time=0 AND st.event NOT LIKE '%SQL%' ORDER BY physical_reads DESC
4.ÕÒ³öºÄcpu½Ï¶àµÄsession
select a.sid,spid,status,substr(a.program,1,40) prog,a.terminal,osuser,value/60/100 value
    from v$session a,v$process b,v$sesstat c
    where c.statistic#=12 and c.sid=a.sid and a.paddr=b.addr order by value desc
5.²éѯsession±»ËøµÄsql¿ÉÒÔÓÃÒ»ÏÂÓï¾ä


Ïà¹ØÎĵµ£º

Ò»¸öÊý¾Ý¿â²Ù×÷À࣬ÊÊÓÃÓÚOracle£¬ACCESS,SQLSERVER

     ×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶Ó­Ö¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......

ÈçºÎ¿´¶®ORACLEÖ´Ðмƻ®

ÈçºÎ¿´¶®ORACLEÖ´Ðмƻ®
Ò»¡¢Ê²Ã´ÊÇÖ´Ðмƻ®
An explain plan is a representation of the access path that is taken when a query is executed within Oracle.
¶þ¡¢ÈçºÎ·ÃÎÊÊý¾Ý
At the physical level Oracle reads blocks of data. The smallest amount of data read is a single Oracle block, the largest is con ......

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......

OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ

Ê×ÏÈÓÃÒ»¸öÃüÁÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREAT ......

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB
1 Ïà¹Ø±í¡¢ÊÓͼ
2 ÎÊÌâÃèÊö
Ϊͬʽâ¾öÒ»¸öÒòÎªÍøÂçÁ¬½ÓÇé¿ö²»¼Ñʱ£¬Ö´ÐÐÒ»¸ö³¬³¤Ê±¼äµÄSQL²åÈë²Ù×÷¡£
¼ÈÈ»ÍøÂç×´¿ö²»ºÃ£¬¾ÍÑ¡ÔñÁËʹÓÃÒ»´ÎÐÔʹÓÃJOBÀ´Íê³É¸Ã²åÈë²Ù×÷¡£ÔÚJOBÖ´ÐÐÒ»¶Îʱ¼äºó£¬ÎÒ·¢ÏÖ±»²åÈë±íÓÐЩÎÊÌ⣨²ÑÀ¢£¬µ±Ê±Ò²Ã»ÓÐÏȼì²é¼ì²é¾Í×öÁË£©¡£×¼±¸Í£Ö¹JOB£¬ÒòΪÔÚJOBÔËÐÐÇé¿öÏ£¬ÎÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ