Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Showing results for 
Search instead for 
Did you mean: 

Check database SQL Statement?

Go to solution
Jacky Wong_1
Occasional Advisor

Check database SQL Statement?

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!
Jacky Wong
Regular Advisor

Re: Check database SQL Statement?

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.
# 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
$ sqlplus username/password

sqlplus> select * from user_tables;

Hope, it may helps you!!!
Let's share the great thing "THE KNOWLEDGE"
John Strang
Regular Advisor

Re: Check database SQL Statement?

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


If you never make a mistake you'll never make anything.
Alexander M. Ermes
Honored Contributor

Re: Check database SQL Statement?

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.
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"