HI all!
Queries:
1.What is the approach to tune sql queries!
2.How to detect that LGWR hanged,what caused it to hang and how to resolve it!
Regards,
Amit.
Printable View
HI all!
Queries:
1.What is the approach to tune sql queries!
2.How to detect that LGWR hanged,what caused it to hang and how to resolve it!
Regards,
Amit.
Look in the alert logs for things such as checkpoint not complete. To resolve these problems you may try to re-sizeQuote:
Originally posted by amitstora
HI all!
Queries:
1.What is the approach to tune sql queries!
2.How to detect that LGWR hanged,what caused it to hang and how to resolve it!
Regards,
Amit.
your current redo logs are add more redo log groups
Hi!
Thanks for your reply!
1.Would Shutdown Abort command be accepted when LGWR hangs!!!
Regards,
Amitstora.
Try always the shutdown immediate. Before you try the abort, since it requires recovery.
Sam