nnnnnRDBMS Version: 8.1.7.2Operating System & Version: AIX 4.3.2Error Number (if applicable):Product (i.e. SQL*Loader, Import, etc.): RMAN w/ TDPProduct Version:RMAN + TDP backup failureHi,I have Oracle 8.1.7.3 running on an IBM AIX 4.3.2 OS. TDP has been configured w/ RMAN for…

nnnnnStarting RMAN backup based on Archive File System Usage: nStarting RMAN Backup Based on Archive File Systemnby Avnish RastoginnOften when DBAs do export/import to load data from one database to another database, it gerenartes archive logs at very high pace…

nnnnnattach all the datababses on a SQL Server:If you are trying to attach all the files to a simillar location as the current server, you can use the script below. It will print out the script with sp_attach_db statements for…

nnnnnORACLE-BASE – Oracle9i DBNEWID UtilityDBNEWID Utility

nnnnnChanging an Oracle DBID (Database Identifier) in Oracle 8i and 9i Release 2 Oracle 9i Release 2 (9.2.0.1) In Oracle 9i Release 2 (9.2.0.1), Oracle provides the ability to change the DBID and/or DBNAME through a new feature, the DBNEWID…

nnnnnHow to script a SQL Server a Job with Visual Basic and SQL-DMO…Try this. Fill in the blanks as indicated by >. Put it in a job with a ActiveX Script step.One thing you might want to check is where…

nnnnnMonitoring Oracle processes on Windows NT:Monitoring Oracle processes in Windows NTRavinder Bhalla06 Oct 2004Rating: -4.33- (out of 5) It’s much easier to monitor CPU usage in a Unix environment for each individual Oracle process (i.e., PMON, SMON, DBWR) as compared…

nnnnnITworld.com – Zipping your way to free space: Part 2: “bash-2.03$ ./compressTestnnreal 1:55.6nuser 1:41.1nsys 11.2ncompress 57% reductionnnreal 54.6nuser 29.1nsys 22.1npack 26% reductionnnreal 2:33.0nuser 2:23.6nsys 5.7ngzip 71% reductionnnreal 2:39.5nuser 2:29.2nsys 6.1nzip 71% reductionnnreal 11:35.1nuser 11:14.3nsys 4.5nbzip2 74% reductionnnAs you can see…

Monitoring free memory in Large Pool and Shared pool on OracleMonitoring Free Memory in Large Pool and Shared Pool (Oracle)by Avnish Rastogi The below process was developed to monitor free memory in shared pool and large pool proactively. Lack of…

nnnnnGet CD Key and MDAC Version from SQL Server 2000 – ExtremeExperts: How can I find the SQL Server CD key I used to install? It would be great to get this information from my desktop. Answer: As said the…