Results 1 to 2 of 2

Thread: checking running instance in Oracle

  1. Aug 29th, 2012, 01:38 PM #1
    firoz.raj
    firoz.raj is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Question 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.
    Reply With Quote Reply With Quote
  2. Sep 1st, 2012, 11:15 AM #2
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: checking running instance in Oracle

    Quote Originally Posted by firoz.raj View Post
    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.
    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 Filemy blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width