Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

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²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿Ö ......

Oracle sqlplusÔ¶³ÌÁ¬½ÓÊý¾Ý¿â

Oracle sqlplusÔ¶³ÌÁ¬½ÓÊý¾Ý¿â
sqlplus username/password@yunSID_192.168.1.5
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾­³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus  username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö&ldq ......

JAVA Á¬½ÓORACLEÊý¾Ý¿â´úÂë

import java.net.url;
import java.sql.*;
public class javaoracle {
public javaoracle() {
}
public static void main(string[] args){
try
{
try{
class.forname("oracle.jdbc.driver.oracledriver");
}
catch(java.lang.classnotfoundexception e)
{
system.err.print(e.getmessage());
} ......

oracle for linux°²×°

ÕÛÌÚÁËÁ½¸öÍíÉϵÄlinuxºÍoralce£¬×ÜËã³öÀ´µã¶«Î÷ÁË¡£Oralce°²×°ÒªÑ¡ÓÃÊÊÓõİ汾£¬²»È»°²×°²»»á³É¹¦£¬×îºóÎҵľö¶¨ÊÇlinuxÑ¡ÓÃcentos 5.0£¬oracleÑ¡ÓÃ10¡£
Ò»¡¢        ×¼±¸¹¤×÷£º
1.       ʹÓÃrootÓû§µÇ¼
ÎÒʹÓõÄÊÇÔÚ±¾»ú×°£¬ËùÒÔÖ±½Ó´ò¿ªÖÕ¶Ë¾Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ