Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the udump directory (SQL)
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