Oracle Logbook

October 4, 2007

Oracle Directories List

Filed under: Uncategorized — heliodias @ 7:13 pm

SELECT DISTINCT (SUBSTR(MEMBER,1,INSTR(MEMBER,’\’,-1))) FROM V$LOGFILE
UNION
SELECT DISTINCT (SUBSTR(NAME,1,INSTR(NAME,’\’,-1))) FROM V$CONTROLFILE
UNION
SELECT DISTINCT (SUBSTR(FILE_NAME,1,INSTR(FILE_NAME,’\’,-1))) FROM DBA_DATA_FILES
union
SELECT (SUBSTR(VALUE,1,INSTR(VALUE,’\’,-1)))  FROM V$PARAMETER WHERE NAME LIKE ‘%pfile%’
UNION
SELECT DISTINCT (SUBSTR(NAME,1,INSTR(NAME,’\’,-1))) FROM V$ARCHIVED_LOG WHERE NAME IS NOT NULL
UNION
SELECT DISTINCT DESTINATION FROM V$ARCHIVE_DEST WHERE DESTINATION IS NOT NULL

UNION
SELECT DISTINCT (SUBSTR(FILE_NAME,1,INSTR(FILE_NAME,’\’,-1))) FROM DBA_TEMP_FILES;

Advertisements

3 Comments »

  1. I couldn’t catch the reason you posted this one, but couldn’t stop myself to comment on the absence of temp files 🙂

    Best regards.

    Comment by H.Tonguç Yılmaz — October 4, 2007 @ 9:05 pm | Reply

  2. Yeah Yilmaz,
    I´d forget it. thank you a lot

    Comment by heliodias — October 4, 2007 @ 10:49 pm | Reply

  3. How about the ADMIN Directory (trace files etc.) In 11g, it can be diagnostics_dest.

    Missing Flash Recovery Area.

    Comment by ordba — March 27, 2008 @ 5:49 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: