Anuj Singh Oracle DBA
Monday, 8 November 2010
Active Sql Monitor
›
SYS AS SYSDBA>l 1 select sesion.sid, 2 sesion.serial#, 3 sesion.username, 4 sesion.sql_id, 5 s...
Successful archiving of previously failed ORA-16014 ORA-00312
›
ORA-16038: log 1 sequence# 106 cannot be archived Mon Nov 8 09:36:43 2010 ORA-16014: log 1 sequence# 106 not archived, no available destina...
1 comment:
Thursday, 4 November 2010
cron run hourly ...
›
cron run every hr every Hr .... 59 min =hr 59 * * * * echo " ">/var/log/warn > /dev/null 2>&1 59 * * * * echo " ...
Tuesday, 2 November 2010
expdp with Query
›
expdp "'/ as sysdba'" directory=datapump_dir DUMPFILE=user_sites.dmp TABLES=cccprod1.user_sites QUERY=ANUJ.user_sites:\...
Monday, 1 November 2010
Oracle OCR and voting disk
›
OCR : File that manages the cluster and RAC configuration Voting Disk : Contains and manages information of all the node memberships...
Oracle Licensing Option usage
›
Oracle Licensing Option usage set pagesize 200 select name,last_usage_date from dba_feature_usage_statistics where detected_usages>0 ord...
1 comment:
RAC database user lock script
›
SQL> connect sys@rac1/sys as sysdba Connected. SQL> SELECT o.name object_name, u.name owner, lid.* FROM (SEL...
‹
›
Home
View web version