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

¹ØÓÚoracleËÀËø

 Èç¹û½ö½öÊÇlock£¬ÒÔÏÂÓï¾ä¿ÉÒÔ·¢ÏÖËùÓÐÓû§Ëø  :
SELECT s.username,
       decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
       o.owner,
       o.object_name,
       o.object_type,
       s.sid,
       s.serial#,
       s.terminal,
       s.machine,
       s.program,
       s.osuser
  from v$session s, v$lock l, all_objects o
 WHERE l.sid = s.sid
   AND l.id1 = o.object_id(+)
   AND s.username is NOT Null
Èç¹ûÓÐËøµÈ´ý»òËÀËø£¬¿ÉÒÔͨ¹ýÒÔÏÂÓï¾ä·¢ÏÖ:
select lpad('   ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
       o.owner,
       o.object_name,
       o.object_type
  from v$locked_object l, dba_objects o
 where l.object_id = o.object_id
 order by o.object_id desc


Ïà¹ØÎĵµ£º

oracle ¸ü¸Ä²ÎÊý nls_length_semantics


alter system set nls_length_semantics='BYTE' scope=both
sql>show parameter length
NAME                                 TYPE
------------------------------------ --------------------- ......

OracleµÄ·ÖÒ³ÏÔʾ

 Õâ¸öOracleµÄ·ÖÒ³ÏÔʾ¾Ý˵ÊÇ×îÂé·³µÄ£¨MySQL×î¼òµ¥£©£¬µ«ÊÇÕâ¸ö·ÖÒ³ÏÔʾºÜÓÐÓá£ÏÖÔںܶàÍøÕ¾ÉϵÄÌõÄ¿¶¼·Ç³£¶à£¬ÀýÈçÐÂÎÅ£¬¿ÉÄܾ͸ոüеľÍÓÐÉϰÙÌõ£¬ÔÙ¼ÓÉÏÒÔǰµÄ£¬Ò»ÕÅÒ³Ãæ¿Ï¶¨¾ÍÊǷŲ»ÏÂÁË£¬ËùÒÔ·ÖÒ³µÄºÃ´¦¾ÍÊÇ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£
ÏÂÃæÒ»ÅÅÅŵĽÐÄãÑ¡ÔñµÚ¼¸Ò³£¬Ò»Ñ¡Ôñ£¬Ö±½Ó¾ÍÌøµ½ºóÃæµÄ¼¸Ò³È¥ÁË£¬²»ÓÃÕâÑù´ÓÉÏÒ ......

×ªÔØoracle rollupºÍcubeº¯ÊýʹÓÃÐĵÃ

 ×ª×Ô£ºhttp://blog.csdn.net/wangdongzjk/archive/2005/11/18/532424.aspx
ʹØCUBE ROLLUP GROUPING SETS£¨1£©
Ô­ÎÄÒý×Ô£º
¾ÛºÏÊÇÊý¾Ý²Ö¿âµÄ»ù´¡¡£ÎªÁËÌá¸ß¾ÛºÏµÄÐÔÄÜ¡£OracleÌṩÁËGroup By Ìõ¿îµÄÀ©Õ¹¡£
1£® CUBE, ROLLUPÀ©Õ¹
2£® 3¸ögroupingº¯Êý
 ......

Oracle(listener.sqlnet.tnsnames)ÉèÖÃ


Ê×ÏÈÀ´ËµOracleµÄÍøÂç½á¹¹£¬Íù¸´ÔÓ´¦ËµÄܼÓÉϼÓÃÜ¡¢LDAPµÈµÈ¡£¡£ÕâÀï²»×öÌÖÂÛ£¬Öصã·ÅÔÚ»ù±¾µÄÍøÂç½á¹¹Ò²¾ÍÊÇÎÒÃÇ×î³£ÓõÄÕâÖÖÇé¿ö
¡¡¡¡
¡¡¡¡Èý¸öÅäÖÃÎļþ
¡¡¡¡
¡¡¡¡listener.ora¡¢sqlnet.ora¡¢tnsnames.ora £¬¶¼ÊÇ·ÅÔÚ$ORACLE_HOME\network\adminĿ¼Ï¡£
¡¡¡¡
¡¡¡¡Öصã:Èý¸öÎļþµÄ×÷ÓúÍʹÓÃ
¡¡¡¡
¡¡¡¡#------- ......

OracleÊý¾Ý¿â¼àÌýÅäÖÃ

½ü¶Îʱ¼äºÜ¶àÍøÓÑÌá³ö¼àÌýÅäÖÃÏà¹ØÎÊÌ⣬¿Í»§ÖÕ¶Ë(Client)ÎÞ·¨Á¬½Ó·þÎñÆ÷¶Ë(Server)¡£±¾ÎÄÏÖ¶Ô¼àÌýÅäÖÃ×÷Ò»¼òµ¥½éÉÜ£¬²¢Ìá³öһЩ¿Í»§ÖÕ¶ËÎÞ·¨Á¬½Ó·þÎñÆ÷¶ËµÄ½â¾ö˼·£¬Ô¸¶Ô¹ã´óÍøÓÑÓë¶ÁÕßÓÐһЩ°ïÖú¡£
 
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ