DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: getting the SID of oracle in sqlplus

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    getting the SID of oracle in sqlplus

    hi, from dbs directory, we can get the SID of oracle just by looking at the initSID.ora. BUT is there anyway where we can get the SID from sqlplus? thanks

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    select instance from v$thread;

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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