Anuj Singh Oracle DBA
Sunday, 4 March 2012
dbms_scheduler example
›
dbms_scheduler example prompt Show Scheduler database objects TTITLE 'Scheduler Objects:' COL owner FORMAT A20 HEADIN...
ORA-00845: MEMORY_TARGET not supported on this system
›
SQL> show parameter memory NAME TYPE VALUE ------------------------------------ ----------- ----...
Oracle database all file info
›
@all_file.sql @dba_all_file.sql All file in database SET LINESIZE 147 SET PAGESIZE 9999 SET VERIFY OFF COLUMN tablespace FORMAT a29 HEAD...
2 comments:
Thursday, 1 March 2012
Oracle 10g standby Archive Gap
›
Oracle standby Archive Gap On Primary ~~~~~~~~~~ SELECT THREAD# "Thread",SEQUENCE# "Last Sequence Generated" FROM V$AR...
Saturday, 11 February 2012
Alternate command to top in solaris
›
Alternate command to top in solaris solaris top command top in solaris prstat -a (in solaris) = top ( in Linux ) # prstat -a PID USE...
ASMCMD-08102: no connection to ASM; command requires ASM to run
›
ASMCMD> lsdg ASMCMD-08102: no connection to ASM; command requires ASM to run +ASM variables are not set properly set following ...
1 comment:
Sunday, 29 January 2012
Oracle RAC faq metalink 220970.1
›
RAC: Frequently Asked Questions [ID 220970.1]
‹
›
Home
View web version