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

ºÜ¼òµ¥µÄÎÊÌ⣬Çó¸ßÊÖÀ´£¬oracle Êý¾Ý¿âÃûÁбíµÄ»ñÈ¡

ÎÒÒª»ñÈ¡±¾»úÉÏÃæËùÓеÄÊý¾Ý¿âÃû£¬±¾»úÉÏÓÐ2¸öÊý¾Ý¿â
±ð¸æËßÎÒÓÃselect * from v$database»òÕßglobal_name»òÕßV$INSTANCE,ÄÇÖ»ÊÇÏÔʾµ±Ç°µÄÊý¾Ý¿âÃû£¬
Ò²²»Òª¸æËßÎÒÈ¥¶Átnsnames.oraÎļþ£¬ÄÇÌ«Âé·³ÁË£¬
Çó¸ßÊÖÖ¸µ¼¡£
×Ô¼ºÐ´¸ö³ÌÐò...¼òµ¥ÓÖ¿ì


Ö»ÄܶÁtnsnames.oraÎļþ¡£ÒòΪÈç¹ûÒªÓÃSQL²éѯµÄ»°£¬Ò»°ã¶¼»áÐèÒªµÇ½¡£¶øµÇ½ÔòÐèÒªµÇ½µ½¾ßÌåµÄʵÀý²Å¿ÉÒÔдSQL²éѯ¡£

ÒýÓÃ
×Ô¼ºÐ´¸ö³ÌÐò...¼òµ¥ÓÖ¿ì


×Ô¼ºÐ´¸ö³ÌÐò¡£¡£¡£¸üÂé·³

¶à¸öÊý¾Ý¿âÏà¶Ô¶ÀÁ¢£¬²»ºÃ´ÓÊý¾Ý¿â±¾ÉíµÄ×Öµä±íÀ´È¡µÃ°É£¬
Ö»¿ÉÄÜ´Ó²Ù×÷ϵͳ·½ÃæµÄÅäÖÃÎļþÈ¥½â¾öÁË

²»ÖªµÀÕâ¸öÀïÃæÓÐûÓÐÄãÏëÒªµÄ¶«Î÷?
SQL code:

select
SYS_CONTEXT('USERENV','TERMINAL') terminal,
SYS_CONTEXT('USERENV','LANGUAGE') language,
SYS_CONTEXT('USERENV','SESSIONID') sessionid,
SYS_CONTEXT('USERENV','INSTANCE') instance,
SYS_CONTEXT('USERENV','ENTRYID') entryid,
SYS_CONTEXT('USERENV','ISDBA') isdba,
SYS_CONTEXT('USERENV','NLS_TERRITORY') nls_territory,
SYS_CONTEXT('USERENV','NLS_CURRENCY') nls_currency,
SYS_CONTEXT('USERENV','NLS_CALENDAR') nls_calendar,
SYS_CONTEXT('USER


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ