Q
Problem solve Get help with specific problems with your technologies, process and projects.

Checking status of a database that has no documentation

I just got a job as a DBA at an Oracle 8 site. Can you suggest a starting point for checking the status of the...

database? This database was being maintained by one of the developers, so there isn't any documentation.

You need to familiarize yourself with how the database is configured. You need to look at the init.ora to see the parameters in use and this will also tell you where certain files are located (the control file(s) and the archive destination for example). Look at dba_tablespaces and dba_data_files to see where your datafiles are located. Look to see how users are defined and if there are any profiles, password management schemes and anything else related to security. The bottom line is that you need to get familiar with how things are set up before you can do much of anything.

Besides taking some time to look about this site, here are a few good sites to visit for scripts you can use to help you pull as much info from your database as possible:

For More Information


This was last published in February 2003

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close