Tag: database administration

Database Administration is becoming tough

Database Administration is becoming tough

January 4, 2012 | By | Add a Comment

Hi friends, What are you thinking about this point? Does database administration becoming more tough nowadays? Some of people replied “no” and some of people replied “yes”. It means, actually we are not understanding my topic accurately. Database administration is becoming tough and in future it will be difficult too. I can prove this thing. […]

Read More

Knowing your application is best way to resolve issues quickly

Knowing your application is best way to resolve issues quickly

June 12, 2011 | By | Add a Comment

Hi Friends, There are no Oracle DBA taking interest to know applications usage and type or nature of applications which are running on Oracle database. We published an nice article regarding same topic that How important to known with your applications? Article explains familiarize with your applications which are running on Oracle database useful to […]

Read More

SLA based Remote services

SLA based Remote services

October 4, 2010 | By | Add a Comment

SLA based Remote services What is SLA? Service Level Agreement (SLA) is document, which represents requirements and expectations of client and end-users. The SLA aids in ensuring that the operations staff and the end-user community are on the same instance and that there are no assumptions about the quality of service desired for Oracle. A […]

Read More

Hidden parameter checking script for Oracle

Hidden parameter checking script for Oracle

October 1, 2010 | By | Add a Comment

Hi friends, So many times we need to check hidden parameters of Oracle. Sometime we forgot script of data dictionary views for writing sql script. Here I am providing you SQL script for check hidden parameters of Oracle. For executing this script you should need to login as SYSDBA. Because only X$ tables are providing […]

Read More

DBVERIFY error DBV-00102: File I/O error on FILE

DBVERIFY error DBV-00102: File I/O error on FILE

September 29, 2010 | By | Add a Comment

Hi Friends, Today we are going to discuss about well known DBVERIFY error called DBV-00102. Error Code: DBV-00102: File I/O error on FILE Error itself indicates File I/O contention. Root Cause of Error: When we are executing dbv command for checking of corruption issue in datafile, that time if DBV read the contains of files […]

Read More