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.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
Become familiar with these 9 uses for SharePoint that you can execute in just a few clicks without using any code. Learn more about using SharePoint here!