+ Reply to Thread
Results 1 to 2 of 2

Hybrid View

  1. 02-26-2003 09:02 PM #1
    yls177
    yls177 is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 02-26-2003 10:10 PM #2
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    select instance from v$thread;

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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