Performance tuning any database takes time, patience and some know-how. It’s an ongoing challenge for any DBA manager and if not handled with a focused approach, can bring your system to a screeching halt.
I’ve been looking forward to presenting a webinar for awhile on a unique approach to tuning that I’ve honed while working at Datavail, which we refer to as The 5S Approach. I’m proud to say the hope is now a reality and I will get one hour, sans interruptions, where I get to talk about each stage of the process as well as key performance issues:
• SQL: Slicing, dicing, and selecting the data.
• Space: Addressing where the data lives.
• Sessions: Who, what, where?
• Statistics: Judging a book by its cover.
• Scheduled Processes: Developing the best scheduling plans.
If you’re interested, the live version will be presented on Thursday, Nov. 14 at 2 p.m. Eastern. Register Here.
For play back, we will update the site with the information as soon as possible.
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.
Imagine over 100 logins on the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?