how do i check how many instances running?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how do i check how many instances running?

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Location
    usa
    Posts
    3

    Smile how do i check how many instances running?

    How do I check to see how many instances runing via sql plus? what is the command.

    thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    windooze or unix?

    though unix you can grep for a backgroun process like PMON,
    throuhg sql may you might create db links to all your instances and the query status from v$instance
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    That's one way ot doing it:

    SQL> !ps -ef | grep ora_dbwr_ | grep -v grep | wc -l

    Of course - you need to be on UNIX, or have the Win32 ports of the UNIX commands. if you need the link to these bin's - let me know.


    Hope that helps,

    clio_usa

    OCP 8/8i/9i DBA

  4. #4
    Join Date
    Nov 2002
    Posts
    80
    the cygwin 'ps' command doesn't pick it up (maybe there's a version in the windows resource kit??).

    another way is to look at the output of the 'net start' command.. or look in the services applet in control panel.

Posting Permissions

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


Click Here to Expand Forum to Full Width