topic Re: Check database SQL Statement? in Operating System - HP-UX

Check database SQL Statement?

Jacky Wong_1 — Wed, 27 Feb 2002 07:20:44 GMT

Dear All,

Any one know the SQL statement if I want to check how many database, what database, what table inside the database and the owner of database inside the oracle DB server?

Thousand thanks!

Re: Check database SQL Statement?

Shahbaz_1 — Wed, 27 Feb 2002 08:08:57 GMT

Hi,
At the o/s level (unix) you can know how many database instances are running by follwing command

$ ps -ef | grep pmon
--- It gives you the SID of all the database instances, which are running now.

Generally the owner of database will be Oracle.
goto
# su - oracle
# ls -lt

If you want to know, what tables the database containts, then you'll have to login to database.

$ sqlplus username/password@connect_string
or
$ sqlplus username/password

sqlplus> select * from user_tables;

Hope, it may helps you!!!
Regards
Syed

Re: Check database SQL Statement?

John Strang — Wed, 27 Feb 2002 08:58:05 GMT

Hello Jacky,

There is a file /etc/oratab which gives information about the database instances on the machine.

It contains 1 line for each instance, with 3 fields on each line.
1st field is the SID name
2nd field is the Oracle home directory
3rd field is Y or N for whether database should be started when machine is booted

Regards,

John

Re: Check database SQL Statement?

Alexander M. Ermes — Wed, 27 Feb 2002 09:08:09 GMT

Hi there.
Did you try to get the Oracle Enterprise Manager ? This tool ( standard no extra packages ) should help to find and log all the necessary info.
Rgds
Alexander M. Ermes