- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SQL TRACE
Operating System - HP-UX
1753481
Members
4871
Online
108794
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО07-02-2001 11:18 PM
тАО07-02-2001 11:18 PM
SQL TRACE
Clay:
- We have reindexed database and review programming. We tkprof all the sqlcode structures to minimize CPU usage.
- We notice certain improve but it wasn't enough for resolve the whole problem.
- When database is performing poorly we can see with top all Oracle processes (ora"sid") on the top of the list. Top load averages grows up very fast but idle time doesn't goes down with same speed. We can have 5 or 6 load points and 80% idle. That?s make as thing to have an I/O problem but we are not sure. We are not either sure if we are suffering any problem with kernel parameters.
- We continue reviewing code to minimize accesing to database but the experience is we are not going to improve enough performance to resolve the problem.
Thanks a lot Clay.
- We have reindexed database and review programming. We tkprof all the sqlcode structures to minimize CPU usage.
- We notice certain improve but it wasn't enough for resolve the whole problem.
- When database is performing poorly we can see with top all Oracle processes (ora"sid") on the top of the list. Top load averages grows up very fast but idle time doesn't goes down with same speed. We can have 5 or 6 load points and 80% idle. That?s make as thing to have an I/O problem but we are not sure. We are not either sure if we are suffering any problem with kernel parameters.
- We continue reviewing code to minimize accesing to database but the experience is we are not going to improve enough performance to resolve the problem.
Thanks a lot Clay.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-02-2001 11:22 PM
тАО07-02-2001 11:22 PM
Re: SQL TRACE
Hi Manuel,
Please APPEND your comments and responses to your ORIGINAL question to allow to everyone to follow the discussion. Thanks alot.
Magdi
Please APPEND your comments and responses to your ORIGINAL question to allow to everyone to follow the discussion. Thanks alot.
Magdi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2001 12:09 AM
тАО07-03-2001 12:09 AM
Re: SQL TRACE
Manuel,
keep in mind to calculate statistics for tables and indexes after your created new indexes.
Check for buffer-qualities using utlbstat.sql and utlestat.sql.
Check for io and swaps with sar and/or vmstat.
Check for lock activity in V$LOCK.
Volker
keep in mind to calculate statistics for tables and indexes after your created new indexes.
Check for buffer-qualities using utlbstat.sql and utlestat.sql.
Check for io and swaps with sar and/or vmstat.
Check for lock activity in V$LOCK.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2001 11:45 PM
тАО07-08-2001 11:45 PM
Re: SQL TRACE
Manuel
What are the oracle processes that you see, (or saw) at the top of top? If they were something like
ora_lgwr_SID then it could be that you are generating a lot of redo, and could benefit from multiple redo log writer processes.
ora_dbwr_SID this it could be that you are making a large number of changes on the database, and you could benefit from multiple database writer processes - and maybe a larger SGA. (Depending on what is going on at the time.)
If the database is at fault, then the real answers will be in the utlbstat reports - although they take alot of deceiphering.
rgds
Steve
What are the oracle processes that you see, (or saw) at the top of top? If they were something like
ora_lgwr_SID then it could be that you are generating a lot of redo, and could benefit from multiple redo log writer processes.
ora_dbwr_SID this it could be that you are making a large number of changes on the database, and you could benefit from multiple database writer processes - and maybe a larger SGA. (Depending on what is going on at the time.)
If the database is at fault, then the real answers will be in the utlbstat reports - although they take alot of deceiphering.
rgds
Steve
If at first you do not succeed. Destroy all evidence that you even attempted.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP