We are going to learn how to install, configure and use statspack in oracle.
Introduction to Statspack
If the DB server running very slow, then we need to perform DB tuning and it is very important to have an established baseline for later comparison. On the behalf of baseline data, we identify the performance problems.
00:00 Introduction
00:30 check statspack is installed or not
01:02 Check existing datafiles details
01:13 Create dedicated tablespace for statspack
02:14 run spcreate.sql
04:08 Taking a statspack snapshot
05:24 Automatic statspack snapshot gathering
07:21 Creating statspack report
09:39 purge perfstat schema data
10:59 uninstall statspack
Website Link: ocptechnology.com/how-to-inst...
#oracledatabase #statspack #spreport #oracle21c
Join WhatsApp Group: whatsapp.com/channel/0029VaS0...
Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
MY Gadgets:
Mic amzn.to/3lYLBW8
Laptop amzn.to/3ndktCa
Mouse amzn.to/3jn58Ok
Chat with me on:
Oracle Interview application play.google.com/store/apps/de...
Facebook page / ocptechnology
Instagram / digitalshripal
Website ocptechnology.com/
Twitter / ocptechnology