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:
- http://www.orakle.com (for a great list of links to dozens of other good sites)
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.