How To Use And Know If Your System Is Read And Or Write Centric - Introduction
How To Use And Know If Your System Is Read And/Or Write Centric
Recently an OraPub member SLACK'd the community asking, "Does anyone know a way to find out if my database is read or write intensive?" While this question was motivated because of an upcoming migration, it could have been asked with a future focus, is IO generally increasing or perhaps to gain insight into the R/W database cycles.
Oracle Ace, Craig Shallahamer, will demonstrate how to answer these questions and others using SQL scripts based on v$sysstat and the AWR dba_hist_sysstat. Bonus: I'll chart the results using R.
For more information on how you can watch the whole webinar - go to www.orapub.com