Results 1 to 4 of 4

Thread: how many instances are in my server?how to check?

  1. 03-01-2008, 09:44 PM #1
    madhu10srp
    madhu10srp is offline Registered User
    Join Date
    Mar 2008
    Posts
    3

    how many instances are in my server?how to check?

    how many instances are existing in our server?
    Reply With Quote Reply With Quote
  2. 03-02-2008, 02:49 AM #2
    kommuri
    kommuri is offline Registered User
    Join Date
    Mar 2008
    Posts
    1
    how to resolve ORA-1555 snapshot too old error
    in 9i using undosegments ?
    Reply With Quote Reply With Quote
  3. 03-03-2008, 03:16 AM #3
    muralimohan
    muralimohan is offline Registered User
    Join Date
    Mar 2008
    Posts
    1
    see gv$instance
    Reply With Quote Reply With Quote
  4. 03-04-2008, 01:37 AM #4
    rockyonramp
    rockyonramp is offline Registered User
    Join Date
    Mar 2008
    Posts
    1

    Post v$instance

    Quote Originally Posted by madhu10srp
    how many instances are existing in our server?
    select instance_number,instance_name from v$instance;
    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