Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
9
Newest
 Critic
Impact
~384 people reached

  • 0 posts edited
  • 2 helpful flags
  • 9 votes cast
2d
comment Metrics for performance of Oracle
I was going to use autotrace
Aug
1
comment Metrics for performance of Oracle
What we are trying to achieve is to work out the scalability of the system in these particular procedures and for the various versions of the software. An ideal graph will be linear and if there is a tipping point it would be nice to know it
Aug
1
asked Metrics for performance of Oracle
Jul
26
comment How to automatically Reset Query Cache for improve table cache hit in MySQL?
I did not realise that you can get computers with so little RAM
Jul
22
answered Two select in one query
Jul
20
awarded  Critic
Jul
20
accepted Oracle table and number of blocks
Jul
19
awarded  Student
Jul
19
asked Oracle table and number of blocks
Jul
17
comment Group or Order SQL output into a single row
.. Well it is better than the first username you thought of. I do hope you are able to keep this civil tongue. PS. I have reversed the -1
Jul
17
awarded  Teacher
Jul
17
comment Group or Order SQL output into a single row
It is not censored - children are watching. It is called being polite. I do hope one day you manage to get you leg over a DBA!!!!
Jul
17
awarded  Citizen Patrol
Jul
17
comment Group or Order SQL output into a single row
I would start by constructing a select statement
Jul
17
comment why update a table take so long on oracle
I would suggest that you find out what is going on under the hood - use autotrace and/or explain. What optimizer are you using (cost based or rule based)? Have you got up to date stats on those tables?
Jul
16
comment To trigger or not to trigger- That is the question
What do you mean by local versions
Jul
16
awarded  Commentator
Jul
16
comment To trigger or not to trigger- That is the question
I agree - personally I would do it once a week and archive it somewhere
Jul
16
answered To trigger or not to trigger- That is the question
Jul
15
awarded  Scholar