Hi,
We have a database that becomes unavailable every so often, which log files are useful for analzying the issue? This seems like a resource issue i think.
I was also told that the system produces alot of archive log files, but when i did the below:
SQL> ARCHIVE LOG LIST;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination D:\app\oracle\product\1020\db_1\RDBMS
Oldest online log sequence 94250
Current log sequence 94252
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
Why do i have a log sequence if there is no archving?