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.
Printable View
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.
If you want to check how many clients are connected to a specific database, you can query the v$session views in oracle.Quote:
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?