Oracle veritas patch slowness

You may need to check locks,waitevents and archive log destinations. Is the statspack turned on in your database? Check udump and bdump directories and check whether large no of trace files generated? India Matrimony: Find your partner now.

No redistribution. Mail virus scanning helps detect nasty viruses! You may as well start at the server. How is swap? If swap is high there are things you can do to improve memory management. These things are rarely produced by committees. Even a simple select query is taking minutes to complete?

And rebuild the indexes. After that ur database performance will not improve then taqke a staspack report and tune the parameter regarding that report. India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

Is the server loaded with someother activity!! If below, your indexes are out of whack. Follow the suggestions to analyze or add indexes. Can you please tell me which are the tem files I should clean and from which directory? Prasad via oracle-db-tuning-l wrote: PostgreSQL vs. Hi, my database is gb running on solaris server and oracle 8.

I would recommend that you look into reviewing Statspack and if it is not set up on the database, set it up immediately to gather information about your performance issues. At this time, it is impossible to really tell you what the issue is.

We would need to see what queries are being executed and how much data they are retrieving. You might also want to consider upgrading your database to 9i or 10g, 10g being the preferred coice for upgrade. Hi, Thanks for your reply since from last few months no dba was there to manage,monitor and maintain oracle server, so we plan to go upgradation to either oracle9i or oracle 10g so if we want to go upgradation which one is best for medium organization and if any materials or url is there please provide me.

Thanks and regards. Too risky. Just stay on 8. Sustaining support starts: To be determined. End of support life: To be determined. Show more Show less. Eligibility Rules Launch Chat.

Update details. Translation Notice Please note that this content includes text that has been machine-translated from English. Translate Content Print details Download.

File ID:. Checksum: 5ff6e96affe5f4c56cf1a9fd8adecc28b74ab2fa5 Copy. Knowledge base. Access Level:. Related articles. Was this content helpful? Yes No Rating submitted. Please provide additional feedback optional Cancel Submit. Translated Content Please note that this document is a translation from English, and may have been machine-translated. Read me. Critical Obsolete. Checksum type: :. Access policy. Limited release.

OSvC customer. Public access. OSvC partner. Internal Rules. OSvC Internal. Live chat. Chat is available in English only. Please select from the list below to check availability. Chat type. Case type Only chat-supported case types are listed. Hours of operation: 24 hours per day, depending on agent availability. Case number Only chat-supported cases are listed. Hours of operation: Monday-Friday: 24 hours per day.

It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation.

You may also refer to the English Version of this knowledge base article for up-to-date information. Support Knowledge base Oracle backups delaying releasing channels during backups.

Article: Last Published: Ratings: 6 2. Product s : Appliances, NetBackup. Smaller databases and those with fewer datafiles may not experience this delay. Cause The dbclient debug log will show that during sbtend processing the nborautil program takes an excessive amount of time to complete.