ITPub博客

查看用户连接断掉某一连接查看连接ip[@more@]oracle中查看用户连接select username,sid,serial#,status from v$session where username <>'1'; select sid,ses.serial#,ses.username,pro.username,pro.spid,status from v$session ses,v$process pro where ses.username='PRODUCT' and ses.paddr=pro.addr;select ses.username,pro.* from v$process pro,v$session ses where ses.paddr=pro.addr and ses.username<>'1';从上面的sql中可以获得连接的用户、oracle sid以及os的进程号等信息利用上述信息，可以停掉连接alte

早上上班检查alert文件，发现有很多警告信息Tue Oct 16 18:41:06 2007Memory Notification: Library Cache Object loaded into SGAHeap size 5118K exceeds notification threshold (2048K)Details in trace file /home/oracle/ora10g/admin/capdb/udump/capdb_ora_19717.trc[@more@]早上上班检查alert文件，发现有很多警告信息Tue Oct 16 18:41:06 2007 Memory Notification: Library Cache Object loaded into SGA Heap size 5118K exceeds notification threshold (2048K) Details in trace file /home/oracle/ora10g/admin/capdb/u

rman使用COPY的镜像文件进行基于表空间数据文件的恢复先使用copy备份数据文件的镜像拷贝，然后删除一个数据文件，在恢复[@more@]RMAN>backup as copy tag "07032001" database;RMAN> list copy;List of Datafile CopiesKey File S Completion Time Ckp SCN Ckp Time Name------- ---- - --------------- ---------- --------------- ----1197 1 A 20-MAR-07 22116361 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-SYSTEM_FNO-1_8fid33oj1204 2 A 20-MAR-0