- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SQL-Tuning with ADDM (Implement Execution Plan...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2006 01:22 AM
тАО08-31-2006 01:22 AM
SQL-Tuning with ADDM (Implement Execution Plan)
i have updated Oracel from 8.1.7 to 10G-R2, and now their are any recommandations (in the ADDM) to do:
- SQL statements consuming significant database time where found
- time spent on the CPU by the instance was responsible for a substantial part of database time
- individual SQL statments responsible for significant user I/O wait where found
....
My Question:
Can i implement the suggestions for the "Exectuion Plan modify" blindly, or is their any to attend?
Could the "new" Execution Plan gives an different output to the "old"?
Can i go back to the "old" execution plan ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2006 02:04 AM
тАО08-31-2006 02:04 AM
Re: SQL-Tuning with ADDM (Implement Execution Plan)
it is advisable not to blindly implement the solution provided.
I would suggest that you sit with the developers and try to take appropriate measures and implement solution (e.g. create new indexes) manually.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2006 07:22 PM
тАО08-31-2006 07:22 PM
Re: SQL-Tuning with ADDM (Implement Execution Plan)
u could go back to the old plan if you remove the implementations.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2006 09:58 PM
тАО08-31-2006 09:58 PM
Re: SQL-Tuning with ADDM (Implement Execution Plan)
i think i will test step by step all advisoris and check in this way the performance. If the performance will be worse, than i could back to the old execution plan - Can i do this with the EM (Grid Control) ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2006 08:29 AM
тАО09-06-2006 08:29 AM
Re: SQL-Tuning with ADDM (Implement Execution Plan)
u can go back to ADDM and select specific recommendations.
but then if permissible, you could run another addm to see how the changes affect.
-Mandar