redo logs again... ( dumping )

[raztaboule]

hi !

I still have a database that switch too often the redologs files.
And we can't see what is making this....

So we are trying to dump them to try to see what is happening ....
but it doesn't work ( ORA-02819: Write failed ) .
- The size of redolog file i wan't to dump is 10M
- There is 2g of free space in the fs storing the udump directori.
- The database is not in an archive mode .
- The command i use is alter system dump logfile '/.....' ;

I managed to dump a logfile of the same size ( 10M ), in the same FS, from a database in archive mode.
Do i need to be in archive mode ?

Does anyone knows a way to see who or what is wrting/deleting/updating data ??

thank in advance.

 

[alexhu]

depends on your version (which you don't mention)

8i has Log Miner which can examine archive logs

Alex

 

[DBAwhosaysNIE]

why noy go after the root cause instead of the symptoms?

select * from v$sqlarea where command_type!-3

 

[raztaboule]

thanks for the responds,

I've found logminer a few minutes after posting my message( i'm not good when looking for something for Oracle : missing some vocabularie...) .
It works well an perhaps gives me the reason why i've some problems.

I'll try the select from v$sqlarea .
what command_type != 3 means ? ( i mean what is the different value for command_type ? ) . perhaps you can give me a link to learn more about it ?

I'still not understand why I can't do and alter system dump logfile on my dataabse. but i don't need it anymore...

Thanks again.