Help - Search - Members - Calendar
Full Version: Finding Alert log file
Oracle DBA Forums > Oracle > Oracle Forum
yogesh.chandane73
Hi All ,

I m yogy new to Oracle .(This might not be a interesting question to you guys)


How can i come to know that which current alert log file is being used for database?

Is their a command at database level to find out the current alert log file to which database is using ?
merrillcd_mem
10g -- select name, value from v$parameter where name = 'background_dump_dest'

11g - select name, value from v$parameter where name = 'diagnostic_dest'
For 11G read up on ADRCI



QUOTE (yogesh.chandane73 @ Dec 23 2011, 06:16 AM) *
Hi All ,

I m yogy new to Oracle .(This might not be a interesting question to you guys)


How can i come to know that which current alert log file is being used for database?

Is their a command at database level to find out the current alert log file to which database is using ?



burleson
Hi Yogy,

>> I m yogy new to Oracle .(This might not be a interesting question to you guys)

>> If you are a bear from Jellystone Park, then yes

**************************************************
>> that which current alert log file is being used for database?

http://www.dba-oracle.com/t_alert_log_location.htm

And in generic SQL you can use this command to find the location of the alert log:

CODE
select
   name
from
   v$parameter
where
   name = ‘background_dump_destination’;


This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.