Re: Performance Difference

From: Joel Garry <joel-garry_at_home.com>
Date: 16 Jun 2004 15:47:22 -0700
Message-ID: <91884734.0406161447.9fbf3c@posting.google.com>

"Greg Chang" <ychang10_at_houston.rr.com> wrote in message news:<nNPzc.31058$KL2.7221_at_fe2.texas.rr.com>...
> where can I find the alert log?

Probably in %ORACLE_HOME%\admin\%ORACLE_SID%\bdump, or search for files with your SID in the name. Might be named something like a concatentation of your SID with alrt. Things can vary based on the setup and installation. You might also try show parameter background_dump_dest from SQL. In fact, you might spool a file and just say show parameter so you can see all of them in a file at your leisure.

--
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/23.41.html#subj4

Received on Wed Jun 16 2004 - 17:47:22 CDT