jcob_l
asked on
slowd
a session or database is slow
we are responsiblie to check what?
we are responsiblie to check what?
http://www.bigdbahead.com/?p=103
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oversimplying, but much of relational database performance is to identify and remediate unnecessary idle time.
Look again at slightwv's last line in 39429936. I mentor juniors to deconstruct a complex problem down to it's basic parts, such as a SQL transaction. If and when the SQL statement appears to perform satisfactorily, at a SQL*Plus session, then resume layering the complexity and retest at each layer.
Are we experts helping, or making your head hurt :) ? Share additional details if you want.
Look again at slightwv's last line in 39429936. I mentor juniors to deconstruct a complex problem down to it's basic parts, such as a SQL transaction. If and when the SQL statement appears to perform satisfactorily, at a SQL*Plus session, then resume layering the complexity and retest at each layer.
Are we experts helping, or making your head hurt :) ? Share additional details if you want.
>> a session or database is slow
- Are all sessions slow?
- How did you determine that something is slow?
- Has anything changed to your system or database?
As said already: share some more details if possible.
- Are all sessions slow?
- How did you determine that something is slow?
- Has anything changed to your system or database?
As said already: share some more details if possible.
ASKER
good link
I suggest deleting the question. There really isn't anything here that stands out and isn't readily available out in the wild.
I agree with closing - lots of info out there.