Category: Uncategorized

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 and fills up archive file system in couple of hours. Below script will help DBA…

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 all the databases. It doesn’t look for secondary files and you can update the script…

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 utility, and works outside of RMAN. Complete documentation on this utility is in the Oracle…

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 the filename is generated. If you have any weird characters it might generate an invalid…

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 to NT. In NT, there is only a single process (i.e., oracle.exe). In order to…

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 from these results, my best compression ratio resulted from the bzip2 compression, though this command…

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 memory in these two pools will cause Oracle to generate ORA-4031. Another reason for ORA-4031…

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 easy way is to get to the remote machines registry key settings and search for…

nnnnnUsing Excel to Pull Data from SQL ServernUsing Excel to Pull Data from SQL ServernMichael SchmalznnBefore I start, I want to emphasize that this example uses Excel for the functionality as opposed to Enterprise Manager or any of the SQL Server User Interface functionality. In the first article that I wrote about getting data from…