Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the udump directory (SQL)

Re: How to find the udump directory (SQL)

From: James <james_at_nothing.com>
Date: Thu, 6 Mar 2003 22:27:25 +0200
Message-ID: <1046982446.536596@ftp.adept.co.za>


Thanks very much!

"Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message news:7oGcnTKpA7AMNvqjXTWchA_at_giganews.com...
> > Does anyone know how to find the value of the "USER_DUMP_DEST" of the
> > initialisation file using sql? This directory is the udump directory on
> the
> > server.
>
> select value from v$system_parameter where name='user_dump_dest';
>
> I think you need to be logged in as sys or system... Or with DBA privs,
> something like that
>
>
Received on Thu Mar 06 2003 - 14:27:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US