Statspack install and overview
Generally PERFSTAT offers a good possibility of a performance evaluation and, more importantly, also on a Oracle Standard Edtion. Preliminary The following parameters must be set or checked on the database: alter system set statistics_level=typical; alter system set timed_statistics=TRUE; Installation SQL> @?/rdbms/admin/spcreate.sql For the installation of perfstat we need the following user input Choose the…