ORACLE管理
learningnew
这个作者很懒,什么都没留下…
展开
-
Oracle中的锁
SELECT a.* FROM V$LOCKED_OBJECT a,DBA_OBJECTS b where a.object_id=b.object_id and b.object_name like '%TDW_CARTOON_ROW_D%' and b.owner='VGOPDW' select T2.USERNAME,t1.SID,t1.TYPE,t1.LMODE,t1.REQUE原创 2015-06-25 18:17:54 · 441 阅读 · 0 评论 -
Oracle中创建数据库链接
PEAKSTS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.248.3.45)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tmda) ) ) create datab原创 2015-06-25 18:16:18 · 891 阅读 · 0 评论