Showing results for 
Search instead for 
Did you mean: 

Oracle basic questions

Frequent Advisor

Oracle basic questions


I am beginner with Oracle and would like to know if some one have some resources regarding:

- Log files of Oracle on HP-UX to be checked (preventive and corrective maintenance)
to ensure healthy operating

- Description of tables and views (how to check and make some select queries)

- Any synthesis documentation

Peter Godron
Honored Contributor

Re: Oracle basic questions

installing the Enterprise manager will give you a nice web-based tool to check the status of the database.

For logfiles you could look at the alert.log file in the bdump directory.

You could install iSQLPLUS which gives to query access via the web.
Andrey Tumanov
Frequent Advisor

Re: Oracle basic questions

Try this:

Here you can get a lot of stuff on Oracle.

Steven E. Protter
Exalted Contributor

Re: Oracle basic questions


Oracle is a fun and wonderful world.

You need to know a few things.

Is the database up.

I would suggest a sqlplus script for that.

On the OS side, you want the filesystem of your oracle redo logs and archive logs to be checked so it does not fill up. # support site.

Steven E Protter
Owner of ISN Corporation
Rick Garland
Honored Contributor

Re: Oracle basic questions

An open question that can have multiple answers depending on the configuration.

A log file that can be useful is what is called the 'alert log'. Typically found in the bdump directory. The actual name will vary - often has the instance name included "alert.log

The metalink site is a good one. A couple of others I like,
Frank de Vries
Respected Contributor

Re: Oracle basic questions

As mentioned above the alert.log is
your main log to check.
For internal queries these are the main
once , a report you can run
in sqlplus (so no need to install
other tools )

(to take advantage of the advanced features
of this script rapport you best create
a repository table to store historical
info for trend analysis)
If you are interested in these repository
tables let me know.

See script/rapport attached:)

Keep it simple :)

Look before you leap
Frequent Advisor

Re: Oracle basic questions

Hi Guys,

Sorry for the delay, I was out of office. Thanks for the information.

You are really nice.