daily pastebin goal
25%
SHARE
TWEET

oracleperf

mms1973 Jun 13th, 2018 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Training on 13/06
  2.  
  3. tuning, two things to look at: wait events and statistics
  4.  
  5. 80% of AWR report is for Oracle
  6.  
  7. Automatic perfomance tuning features:
  8. -AWR Automatic Workload Repository
  9. -Automatic Db diagnostic monitor (ADDM)
  10.  
  11. Top 10 foreground events by Total Wait Time
  12.  
  13. @v_sys_time_model
  14.  
  15. list of waits:
  16. select name from $v_sys_time_model
  17.  
  18. enq:TX - row lock contention (used while insert, update, etc)
  19. log file sync: wit for commit (no more than 4ms)
  20.  
  21. desc v$system_event
  22.  
  23. !ls v*
  24.  
  25. top20 wait reason
  26. +-----------------------------------+
  27. DB time = DB CPU time + DB wait time
  28. +-----------------------------------+
  29.  
  30. v$sysstat
  31. select name, value from v$sysstat order from 1;
  32.  
  33. check for sorts in disk, memory
  34.  
  35. Displaying SGA stattistics:
  36. SELECT * FROM v$sgainfo;
  37.  
  38. BUFFER BUSY WAITS
  39. =================
  40. ---> Increase PCTFREE (per table) - to fix buffer busy waits
  41. !ls *seg*
  42. v$segment_statistics
  43.  
  44. desc dba_tables -> PCT_FREE
  45.  
  46. SHRINK SPACE COMPACT
  47. SHRINK SPACE
  48.  
  49. FREE BUFFER WAIT
  50. ================
  51.  
  52. solution increase buffer cache
  53. increase DBWR
  54.  
  55. LATCHES
  56. ======
  57.  
  58. increase memory
  59.  
  60. if a table has many users updating, then we do partioning
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top