Tuesday, November 25, 2014
To find out impdp/expdp OS pid
›
set pages 200 set linesize 300 col vs.spid for a10 col SID format 9999 col vp.spid format 99999 col vs.PROGRAM format a35 col USERNAME form...
Wednesday, November 7, 2012
As a normal user how to check SID
›
select sys_context('USERENV','SID') from dual; (or) select sid from v$mystat where rownum <=1;
Tuesday, May 22, 2012
Shell script for Tablespace alert via email
›
for sid in `ps -ef | grep pmon | awk '{print $8}' | egrep -i "ora_pmon" | sed 's/ora_pmon_//'` do DB=${sid} ...
Monday, May 14, 2012
Getting TNS strings from tnsnames.ora file in Linux
›
grep '^[A-Za-z]' tnsnames.ora | sed 's/=.*//;s/,.*//'
Saturday, February 5, 2011
DBMS_WORKLOAD_REPOSITORY
›
MODIFY_SNAPSHOT_SETTINGS Procedure This procedure controls two aspects of snapshot generation. The INTERVAL setting affects how often sna...
›
Home
View web version
