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

oracleÁÙʱ¶ÎµÄ´¦Àí

Ó¦ÓÃϵͳ²»ÄÜÔËÐУ¬¸æ¾¯ÈÕÖ¾±¨¸æÁÙʱ±í¿Õ¼ä²»ÄÜÀ©Õ¹£¬¹À¼ÆÊÇÒµÎñsql´æÔÚ´óÁ¿ÅÅÐò£¬Ö»ÄÜÔö¼ÓÁÙʱ±í¿Õ¼ä»º½âÕâ¸öÎÊÌâ¡£
ÁíÍ⻹¿ÉÄÜÒªÇåÀíÁÙʱ¶ÎÖØÕûÁÙʱ±í¿Õ¼äÊͷſռ䣺
²é¿´Ò»ÏÂÈÏË­ÔÚÓÃÁÙʱ¶Î£º
SQL> SELECT /*+ rule */ se.username,se.sid,se.serial#,se.sql_address,se.machine,se.program,
su.tablespace,su.segtype, su.contents
from v$session se,v$sort_usage su
WHERE se.saddr=su.session_addr;
USERNAME        SID    SERIAL# SQL_ADDR MACHINE          PROGRAM          TABLESPACE       SEGTYPE   CONTENTS
-------- ---------- ---------- -------- ---------------- ---------------- ---------------- ---------
SYS             154         12 257A8240 WORKGROUP\LENOVO sqlplusw.exe     TEMP             SORT      TEMPORARY
                                        -94B4B86F
ɱµôÕâ¸ö»á»°£º
SQL> Alter system kill session '154,12';
»ØËõ TEMP±í¿Õ¼ä
    È·¶¨TEMP±í¿Õ¼äµÄts#
SQL> select ts#, name from v$tablespace;
       TS# NAME
---------- --------------------------------------------------
         0 SYSTEM
         1 UNDOTBS1
         2 SYSAUX
         4 USERS
         6 EXAMPLE
         7 DNA
     


Ïà¹ØÎĵµ£º

ÔÚ64λLinux»·¾³Ï°²×°OracleÊý¾Ý¿â10g

¾­¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´Î֨װ£¬ORACLE֨װN´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 ϰ²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹ØËµ ......

³öÏÖOracle ORA 24343µÄÒ»ÖÖÇé¿ö

    ¶ÔÓÚOracle ORA-24343ÕâÖÖ´íÎó£¬OracleµÄ¹Ù·½½âÊÍÊÇ£º
Error Message: ORA-24343 user defined callback error
Error Cause:
The only valid return value for a user defined callback function is OCI_ CONTINUE. Any other value will cause this error.
Action:
Make sure that OCI_CONTINUE i ......

Oracleʱ¼äÈÕÆÚ²Ù×÷

Oracleʱ¼äÈÕÆÚ²Ù×÷
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
add_months(sysdate,-5) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
add_months(sysdate,-5*12) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
ÉÏÔÂÄ©µÄÈÕÆÚ£ºsel ......

oracle to_dateÏÝÚå

ORACLE to_date ÏÝÚå
oracle Öв»´øÊ±·ÖÃëµÄ×Ö·û´® to_date ת»»Ê±¼äºóÓë´øÊ±·ÖÃëµÄdateÐÍ×Ö¶Î×ö´øµÈÖµµÄ±È½Ï (>=,<=,=)ʱ£¬ÓÉÓÚ×Ö·û´®²»´øÊ±·ÖÃ룬ËùÒÔת»»ºóʱ·ÖÃëĬÈÏΪ00:00:00,oracleÖбȽÏdateÊÇÒÔÒ»¸öʱ¼äµãÀ´±È½ÏµÄ£¬¾«È·µ½ÃëÉõÖÁºÁÃë΢ÃëÄÉÃë,ËùÒÔdate×ֶεÄʱ·ÖÃ벻Ϊ00:00:00µÄ¾ÍÓë²»´øÊ±·ÖÃë×Ö·û´®×ª»»º ......

Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ

Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡ÒªÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬±ØÐëÒªÒÔ¾ßÓÐOracle ¹ÜÀíԱȨÏÞµÄÓû§µÇ½£¬Í¨³£Ò²¾ÍÊÇÒÔ¾ßÓÐSYSDBAȨÏÞµÄÓû§µÇ½¡£Ò»°ãÎÒÃdz£ÓÃINTERNALÓû§À´Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¨INTERNALÓû§Êµ¼ÊÉÏÊÇSYSÓû§ÒÔSYSDBAÁ¬½ÓµÄͬÒå´Ê£©¡£OracleÊý¾Ý¿âµÄа汾½«Öð²½ÌÔÌ­INTERNALÕâ¸öÄÚ²¿Óû§£¬ËùÒÔÎÒÃÇ×îºÃ»¹ÊÇÉèÖÃDB ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ