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

oracleɾ³ýËÀËøµÄsession

²é¿´Ëø±í½ø³ÌSQLÓï¾ä1£º
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   'sid,serial#';
ÈçÓмǼÔò±íʾÓÐlock£¬¼Ç¼ÏÂSIDºÍserial# £¬½«¶þÕßÁ¬½ÓÆðÀ´£¬¾Í¿ÉÒÔkill¡£ÈçÏ£º
alter system kill session '1458,15829';


Ïà¹ØÎĵµ£º

Oracle´óÎı¾ÔÚASPÖдæÈ¡ÎÊÌâµÄ½â¾ö


ÔÚÎÒ¿ª·¢BS½á¹¹³ÌÐòÖУ¬ÓÉÓÚ¾­³£ÐèÒªÔÚORACLEÖд¦ÀíһЩÈÝÁ¿½Ï´óµÄÎı¾Êý¾Ý£¬ËùÒÔ¾­¹ý·´¸´²âÊÔÖÕÓÚÓÃASP³É¹¦½â
¾öÁË´óÎı¾Êý¾ÝÔÚORACLEÏ´æÈ¡ÎÊÌâ¡£
¡¡¡¡
¡¡¡¡Ò»¡¢ÔËÐл·¾³£º
¡¡¡¡1¡¢Microsoft Windows 2000 Server + IIS 5.0
2¡¢Oracle8iÖÐÎıê×¼°æ
¡¡¡¡
¡¡¡¡¶þ¡¢½¨Á¢Êý¾Ý±í£º
¡¡¡¡CREATE TABLE SYSTEM.TEST(
B ......

[ÍÆ¼ö] Éî¶È¶Ô±ÈOracleÓëSQL Server [1]

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

jsp·ÖÒ³£¨oracle+jsp+apache£©

Ò» Ç°Ìá 
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
±í£ºmytable 
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......

oracleÖÐjdbcÇý¶¯°üµÄ˵Ã÷

´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......

¡¾×ܽ᡿oracle»Ö¸´Îóɾ³ýÊý¾Ý£¬½â³ýËø¶¨µÄµÈsqlÓï¾ä

1.Ôø¾­²»Ð¡Ðİѿª·¢¿âµÄÊý¾Ý¿â±íÈ«²¿É¾³ý£¬µ±Ê±ÏŵÄÒªËÀ¡£½á¹ûÕÒµ½ÏÂÃæµÄÓï¾ä»Ö¸´µ½ÁË1¸öСʱ֮ǰµÄÊý¾Ý£¡ºÜ¼òµ¥¡£
×¢ÒâʹÓùÜÀíÔ±µÇ¼ϵͳ£º
select * from ±íÃû as of timestamp sysdate-1/12 //²éѯÁ½¸öСʱǰµÄij±íÊý¾Ý£¡¼ÈÈ»Á½Ð¡Ê±ÒÔǰµÄÊý¾Ý¶¼µÃµ½ÁË£¬¼ÌÐøÔõô×ö£¬ÖªµÀÁ˰ɡ£¡£

Èç¹ûdropÁË±í£¬Ôõô°ì£¿£¿¼ûÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ