Skip to content

Instantly share code, notes, and snippets.

@TrevorS

TrevorS/comverse-talk-notes.md

Created July 15, 2014 19:35
Show Gist options
  • Save TrevorS/5245bfb8370da433b6c3 to your computer and use it in GitHub Desktop.
Save TrevorS/5245bfb8370da433b6c3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
comverse-talk-notes.md

database analysis discussion points

  1. what is the growth of the top tablespaces over time?
  2. why are they keeping 1 year of data in the billing system?
  3. are there tablespace files that are less than 64 GB?
  4. we have to find out what these tablespaces are being used for
  • are the tables and indexes used in temporarily during bill runs and then cleaned out?
  1. what are the current memory settings?
  • pga
  • sga
  1. what do these wait events mean?
  • how often do these wait event counters get reset?
  • these average wait times are very bad
  • depending on how often the total wait time counters are reset, they are worse
  1. what are the average reads/writes to datafiles with high contention?
  2. what is the total size of all data
  3. what is the total size of all tablespaces
  4. what is the total size of all indexes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment