That's a cool video - can't you do the same thing with Database Control (or Grid Control)?
kyle Hailey wrote:
Like Cary said, profiling is the way to go. Profile the database see
if there are issues at the
machine (io,cpu)
application - locks, invalid SQL
database configuration - cache sizes, storage settings, log file sizing
SQL - slow ore high resource
The easiest way I know to see this is with DB Optimizer at Embarcadero.
Check it out at
http://sites.google.com/site/embtdbo/
There is a free 14 day dowload on the above URL as well as some videos
showing how to profile and tune a database. One video that isn't
linked on the above URL is
http://www.youtube.com/watch?v=LtjYRSJ48fk
which shows a case of log file IO issues, first identifying the
problem then fixing it.
The methodology is based on Oracle wait events which are the keys to
to profiling the database and identifying issues.
Best Wishes
Kyle Hailey
http://perfvision.com
--
//www.freelists.org/webpage/oracle-l
-- Jeremy Schneider Chicago, IL http://www.ardentperf.com -- //www.freelists.org/webpage/oracle-l
