Month: February 2005

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…