Tag: oracle dba tips

Oracle Utilities Undocumented-dbfsize

Oracle Utilities Undocumented-dbfsize

December 6, 2010 | By | Add a Comment

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 […]

Read More

ORA-01078 with LRM-00109 errors

ORA-01078 with LRM-00109 errors

March 19, 2010 | By | Add a Comment

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 […]

Read More

How to kill session in Oracle

How to kill session in Oracle

March 4, 2010 | By | Add a Comment

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 […]

Read More

Oracle 8i Hidden Parameters

Oracle 8i Hidden Parameters

November 9, 2009 | By | Add a Comment

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 […]

Read More

Oracle 9i Hidden Parameters

Oracle 9i Hidden Parameters

October 5, 2009 | By | Add a Comment

Oracle 9i hidden and undocumented parameters with default values and description dowload from following link
http://www.dbametrix.com/download_info.php

Read More

Oracle 10g Hidden Parameters

Oracle 10g Hidden Parameters

October 5, 2009 | By | Add a Comment

Oracle 10g hidden parameters with default value and description download from following link.
http://www.dbametrix.com/download_info.php

Read More