Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
11
Impact
~3k people reached

  • 0 posts edited
  • 2 helpful flags
  • 15 votes cast
Mar
3
awarded  Popular Question
Feb
14
comment Order by taking less time than max() in oracle
Perhaps the query plan would enlighten us
Oct
30
comment simple SELECT EXISTS takes about two hours to execute
Where is the explain plan? BTW Screen shots are not a good idea as some people access this site via mobile devices
Oct
30
comment simple SELECT EXISTS takes about two hours to execute
Use explain to find out what is going on. Have you got the appropriate indexes
Oct
5
comment SQL developer - procedure just for a session
@Mat - Thanks for the SQL snippet feature - will give it a go as it might fulfil my requirements
Oct
5
comment SQL developer - procedure just for a session
I was hoping that this would be available in the start up script that is automatically loaded on connection
Oct
5
asked SQL developer - procedure just for a session
Aug
27
comment Oracle and execution plans
Is it not better just to look into the v$active_session_history table and not bother with the v$session table?
Aug
27
comment Oracle and execution plans
... It just makes life a little easier to have it as a procedure
Aug
27
asked Oracle and execution plans
Aug
19
comment MySQL growth 500k records/day
The number of tables is a give away that you are doing something wrong. Look into the design
Aug
13
awarded  Editor
Aug
8
comment Avoid foreign keys on an 800-GB database?
What is a performance penalty is having inconsistent data! The performance being the company being open for business or closed.
Aug
5
comment When backup a database
Periodically test that you can recover. Also have multiple backups and some off site. Perhaps a full backup once a week and taken home
Aug
2
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
22
answered Two select in one query
Jul
20
awarded  Critic
Jul
20
accepted Oracle table and number of blocks