-
编辑 删除
[转]How to Execute Alter Session Statements for Remote Sessions [ID 369154.1]
How to Execute Alter Session Statements for Remote Sessions [ID 369154.1]Modified 22-JUN-2011 Type HOWTO Status PUBLISHED In ...
-
编辑 删除
redhat change hostname, ip address
转自: https://access.redhat.com/knowledge/articles/8645How do I change the IP address/netmask and hostname on the command line WITHOUT rebooting the machine? ...
-
编辑 删除
session lock
對于9i:1. select * from v$lock where block = 1;可查到當前占有鎖而block了其他session的session.2. 可查出誰正block了誰:select a.SID “Blocking Session”, b.SID “Blocked Session” from v$lock a, v...
-
编辑 删除
dba_objects.data_object_id
use data_object_id instead of object_id to find a object. After truncate table, the object_id will change, but data_object_id will not.
