Oracle: See list of databases

1136685 pts.
Tags:
Oracle
Oracle Database
In Oracle, is there a way I can see a list of my databases? Something like MySQL's SHOW DATABASE statement? I need to find the databases in a cluster too. Thank you.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello,

You can list all of your tables with:

select TABLE_NAME from all_tables;

You can list all tables in a database using dba_tables.

more here:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2105.htm#REFRN20286

But if you want to list all running database in a host(linux):
ps -ef | grep smon
This will list all SID of current running databases.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    No, there is no similar statement in Oracle.

    One way to determine the list of database running on a server would be analyzing running processes at the operating system level.
    84,630 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: