checking running instance in Oracle
i have already installed oracle Database 10G Client . i want to see how many instance is running on the background ?.is there any way to check running instance on the system. let me know please .any help would be highly appreciated.
Last edited by firoz.raj; Aug 29th, 2012 at 01:41 PM.
If you want to check how many clients are connected to a specific database, you can query the v$session views in oracle.Originally Posted by firoz.raj
I guess that's not what you want to know. So what do you mean by "many instances"?
Is the Oracle database installed on a Windows or a Unix box?
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text File
Posting Permissions
Reply With Quote
