Oracle basic questions

[Mark2010_1]

Hi,

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

BR

[Peter Godron]

Hi,
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]

Try this:

http://www.freeprogrammingresources.com/oracle.html

Here you can get a lot of stuff on Oracle.

Andrey

[Steven E. Protter]

Shalom,

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.

http://technet.oracle.com
http://metalink.oracle.com # support site.

SEP

[Rick Garland]

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,

http://www.lazydba.com
http://www.tech-tips.com

[Frank de Vries]

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 :)

[Mark2010_1]

Hi Guys,

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

You are really nice.

BR