Home » RDBMS Server » Performance Tuning » Oracle Server Information
Oracle Server Information [message #121640] Tue, 31 May 2005 05:45 Go to next message
Messages: 3
Registered: May 2005
Location: Delhi
Junior Member

Can anyone suggest me, what i need to use to get the following information from my database.

* Mount Point Structure of
Filesystem -blocks Free-%Used-Iused-%Iused-Mounted on

* Database Information – Physical Structure of my current database

* v Control Files,v REDO Log Files

* Logical Structure of my current database

* v Invalid Objects with Owner Names

* v Existing Backup Policy

Please suggest me with above questions.

Thanks a lot.

Re: Oracle Server Information [message #121689 is a reply to message #121640] Tue, 31 May 2005 09:07 Go to previous message
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
v$parameter, dba_objects, and dba_datafiles would be a start.
Previous Topic: What are the steps to tune a query
Next Topic: The same sql runs very slowly in jboss-cmp,very quickly in native jdbc.
Goto Forum:

Current Time: Tue Feb 27 01:43:23 CST 2024