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

oracle ¼ì²é±»ËøµÄ±í¼°½âËø

Ô­ÎĵØÖ·£ºhttp://tech.e800.com.cn/articles/2009/710/1247207067745_1.html
´¦Àí·½·¨Ò» £º

¼ì²éÄĸö±í±»Ëø
select sess.sid,sess.serial#,
lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from
v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id =
lo.object_id
and lo.session_id = sess.sid;

½âËø
alter
system kill session 'xxx,yyy';
×¢£º'xxx,yyy'ÊÇÉÏÃæ¼ìË÷µÃµ½µÄsess.sid,sess.serial#
´¦Àí·½·¨¶þ £º
ÕÒµ½ÄãҪɱµôµÄÄǸöSESSION,
²¢¼ÇÏÂpaddr
SELECT sid, username, paddr, status from v$session WHERE
username = 'JCUSER' and sid=ÉÏÃæ²é³öÀ´µÄsid;

ÕÒµ½Õâ¸öSESSIONËù¶ÔÓ¦µÄspid
SELECT
ADDR,PID,SPID,USERNAME,SERIAL#,TERMINAL from v$process WHERE addr¡¡=
'ÉÏÃæµÄPADDR';

ɱµôspidËù±êʶµÄÄǸö½ø³Ì
orakill sid spid


Ïà¹ØÎĵµ£º

oracleµÄ·ÖÇø±í¡¢·ÖÇøË÷ÒýºÍÈ«¾ÖË÷Òý²¿·Ö×ܽá


·ÖÇø±í¡¢·ÖÇøË÷ÒýºÍÈ«¾ÖË÷Òý£º
ÔÚÒ»¸ö±íµÄÊý¾Ý³¬¹ý¹ý2000ÍòÌõ»òÕ¼ÓÃ2G¿Õ¼äʱ£¬½¨Ò齨Á¢·ÖÇø±í¡£
create table ta(c1 int,c2 varchar2(16),c3 varchar2(64),c4 int constraint pk_ta primary key (c1)) partition by range(c1)(partition p1 values less than (10000000),partition p2 values less than (20000000),part ......

About query oracle tablespace

SELECT UPPER(F.TABLESPACE_NAME) "±í¿Õ¼äÃû",
       D.TOT_GROOTTE_MB "±í¿Õ¼ä´óС(M)",
       D.TOT_GROOTTE_MB - F.TOTAL_BYTES "ÒÑʹÓÿռä(M)",
       TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_G ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨


1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿Ö ......

iis7 asp ado oracle ÂÒÂëÎÊÌâ

»·¾³£ºÊý¾Ý¿â oracle 64bit ϵͳ win2008 64bit IIS7 ÔÚasp ÍøÒ³ÖÐʹÓÃadoÁ¬½ÓÊý¾Ý¿â ODBCÓõÄÊÇMicrosft ODBC for oracle
Çé¿ö£ºÔÚÍøÒ³µÄ²éѯÓï¾äÖв»º¬ÖÐÎĵĿÉÒÔ£¬Ö»ÒªÓï¾äÖк¬ÓÐÖÐÎľͻ᷵»Ø´íÎó½á¹û¡£
Èç:select 'Ò»¶þÈý' from dual;ÕâÑùµÄÓï¾ä ·µ»Ø»ØÀ´¾ÍÊÇ£¿£¿£¿
»¹ÒªËµÃ÷µÄÊÇoracleµÄ×Ö·û¼¯ÊÇAMERICAN_AMERICA.U ......

LinuxÏÂOracleÖØÆôºÍÐÞ¸ÄÁ¬½ÓÊý

Ò»¡¢Æô¶¯
 
1.#su - oracle              Çл»µ½oracleÓû§ÇÒÇл»µ½ËüµÄ»·¾³
2.$lsnrctl status           ²é¿´¼àÌý¼°Êý¾Ý¿â״̬
3.$lsnrctl start      &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ