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: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Thu, 6 Mar 2003 12:10:34 -0800
Message-ID: <7oGcnTKpA7AMNvqjXTWchA@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:10:34 CST

Original text of this message

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