Hi Friends, There is hidden and undocumented Oracle utility available called DBFSIZE. This Oracle utility provides exact size of file, which is connected with Oracle software. Means we can get size of control file, redo log file, datafile size using DBFSIZE undocumented Oracle utility. DBFSIZE utility doesn’t available for Windows platforms. How to use DBFSIZE [...]
Hi friends, How to resolve LRM-00109 with ORA-01078 errors? New article has been realeased for solution of ORA-01078 with LRM-00109 errors. Generally these errors are occurring due to not exist of pfile or spfile on system. May be oracle doesn’t find out parameter file in default location. Or may be file there but contents of [...]
Hi friends, In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. Then question is raised that in which type of situation remote dba should need to kill session and process. We are explaining those situations and incidences here. When blocking lock occurs and other [...]
Hello friends, As per our promise we are providing Oracle tips and technical papers for about some internals of Oracle database.It is very important for every advance Oracle DBA. http://www.dbametrix.com/resource_database.html Day by day in new version of Oracle we found hidden parameters are being increased.Oracle 8i is having 555 hidden parameters. Hidden parameters called as [...]
Oracle 9i hidden and undocumented parameters with default values and description dowload from following link
http://www.dbametrix.com/download_info.php
Oracle 10g hidden parameters with default value and description download from following link.
http://www.dbametrix.com/download_info.php
This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.