Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
10
Newest
 Editor
Impact
~1k people reached

  • 0 posts edited
  • 2 helpful flags
  • 15 votes cast
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
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