Operating System - HP-UX
1748226 Members
4583 Online
108759 Solutions
New Discussion юеВ

oracle on hpux help for hpux admin

 
Basheer_2
Trusted Contributor

oracle on hpux help for hpux admin

oracle on hpux admin help
did unix and informix for 9 years. Transition to oracle help.

as an hpux admin need some oracle help

1) list DBs, Tot # of tables, small/big tables, most/least active
2) # of instances
3) SGA sizing
4) monitoring
5) list installed oracle products, versions, serial #s
6) tuning
7) Any links/scripts/books etc
3 REPLIES 3
Sivakumar TS
Honored Contributor

Re: oracle on hpux help for hpux admin

Check this link,

http://www.dbasupport.com
Nothing is Impossible !
Rick Garland
Honored Contributor

Re: oracle on hpux help for hpux admin

To list the DBs,
# ps -ef | grep pmon
This will list the currently running databases.
You can look at the /etc/oratab file to get an idea of what is on the system that may not be running. To get the number of tables, small/big, active, etc. you will need to login to SQL and issue the appropriate 'select' SQL commands to obtain the info.

Number of instances - again, count the pmon processes.

For SGA sizing, review the init.ora files to get this info. There is a lot more important information in the init.ora files as well.

List of products, serial #s, - SQL commands.
For the version you can get just from the login to SQL. It will display.

As to tuning, this is dependent on the environment, number of users, number of instances on the HPUX system, the power of the HPUX system, how that HPUX system is tuned itself, etc. Many variables.

The http://metalink.oracle.com site is a very useful resource. Do need a current contract to get a login. The are other free sites as well (tek-tips as example). Books from Oracle Press are good as well.

Arturo Galbiati
Esteemed Contributor

Re: oracle on hpux help for hpux admin

Hi,
I suggest you to join the Oracle metalink where you can find a lot of doc/scripts/patches and so on:
http://metalink.oracle.com/

Other interesting links:
http://www.dba-village.com
Oracle 9i manuals:
http://www.stanford.edu/dept/itss/docs/oracle/9i/nav/docindex.htm

HTH,
Art