APPLIES TO
• Microsoft SQL Server 7.0 Standard Edition
???
In my env, we still hit the problem with SQL server 2000 SP4.
Popular Posts
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
Database audit records for statement, privilege, and object auditing are stored in the table SYS.AUD$. Depending on how extensive your audit...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
Being a DBA or system administrator, simple ENTER may bring us into a nightmare. It is unavoidable, however what we can do is to prevent ...
-
我们可以使用logminer分析其它instance（版本可不一致）的重做日志文件，但是必须遵循以下要求： 1. LogMiner日志分析工具仅能够分析Oracle 8以后的产品 2. LogMiner必须使用被分析数据库实例产生的字典文件，且安装LogMin...
-
got two useful articles about compression. Marked here 11g Release 2 RMAN Backup Compression Oracle 11g Release 2 – RMAN compressi...
-
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
-
sqlplus commands
-
V$log_history retention is defined by MAXLOGHISOTRY when you create the database (or recreate the controlfile) MAXLOGHISTORY Clause This...
