-
Alert log doesn't have timestamp
Hello all..
ORacle 9.2/sun 5.8
I was looking into alertlog and i see some errors, but it doesn't say at what time those errors occured or on which date they happened ?...
how do we find that out ?...
any help is appreciated.
Thanks
Ron
-
What where the errors? Did they generate trace files? If so you will be able to establish the time and date from the trace output.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
thanks jovery...
this is what i see on my alert log.
*******************************************************************
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
****************************************************************
now how do i see if it generated the trace file ?...and where can i find that trace file ?
Thanks
Ron
-
Do you have a process which is trying to take an online backup of the temp tablespace or is trying to alter the storage parameters both or which are not possible/required with a locally managed temp tablespace?
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|