perfstat

Brief overviewThe Perfstat is a NetApp storage diagnostic data Command-line collection tool that collects detailed information about NetApp storage, including configuration information and performance data, with two versions for NetApp storage OS 2 modes: Storage mode Perfstat version 7 mode Perfstat 7 Clust

As the saying goes, to do a good job, you must first sharpen it. A good tool is also required for database performance analysis. Statspack is a powerful and free performance analysis tool provided by oracle.To install statspack, you must have sysdba permissions. First, log in with sysdba to create a separate tablespace for statspack.SQL code1. SQL> create tablespace perfstat datafile 'd: \ oracle \ oradata \ epcit \ data_file \

-- Physical zookeeper operationSelect distinct to_char (snap_time, 'yyyy-mm-dd hh24: MI: ss') datetime,(Newreads. Value-oldreads. Value) reads,(Newwrites. Value-oldwrites. Value) writesFrom perfstat. Stats $ sysstat oldreads,Perfstat. Stats $ sysstat newreads,Perfstat. Stats $ sysstat oldwrites,Perfstat. Stats $ syssta

service $ srvctl add service-d orcl10-s statspack_suse11a_srvc-r orcl101 $ srvctl add service-d orcl10-s restart-r orcl102 $ srvctl start service-d orcl10-s restart $ srvctl start service-d orcl10-s statspack_suse11b_srvc $ srvctl status service-d orcl10Service orcl10_srv is running on instance (s) orcl102, orcl101Service statspack_suse11a_srvc is running On instance (s) orcl101Service running is running on instance (s) orcl102 $ srvctl config service-d orcl10 orcl10_srv PREF: orcl102 orcl101 A

The performance collection using Statspack is achieved through snapshot, that is, Statspack takes a snapshot of the system performance data at a certain time point, and saves the snapshot in perfst. The performance collection using Statspack is achieved through snapshot, that is, Statspack takes a snapshot of the system performance data at a certain time point, and saves the snapshot in perfst. Perfcreate Use the sys user to connect to the database and run the spcreate. SQL script. First, en

Environment: CentOS 6.2 + Oracle 11.2.0.3 1. the Statspack installation and installation process is to create a user perfstat and create corresponding objects under this user. Oracle provides existing scripts to create these objects, we only need to use SYSDBA to run this script. The Statspack creation script spcreate. the SQL statement is located in the $ ORACLE_HOME/rdbms/admin directory. The process for creating Statspack is as follows: SQL> @/u/or

How to delete historical data generated by statspack When $ Oracle_HOME/rdbms/admin/spauto is used. after SQL creates a default job, snapshots are collected every hour in the database, so that you can use $ ORACLE_HOME/rdbms/admin/spreport at any time. SQL generates a report diagnosis analysis report, but the amount of sampled data is quite astonishing. If this job is ignored or the remaining space is not regularly checked, some production environments may cause other unpredictable conditions du

to delete it: manual deletion and automatic script deletion. 1. Back up objects under the perfstat user[Oracle @ rac1 ~] $ Export NLS_LANG = american_america.ZHS16GBK[Oracle @ rac1 ~] $ Cd/data[Oracle @ rac1 ~] $ Exp perfstat/oracle @ orcl file =./perfstat_backup.dmp wner = perfstat[Oracle @ rac1 ~] $ Ll-t-Rw-r -- 1 oracle dba 1893620736 Apr 27 perfstat_backup.d

add the service$ Srvctl add service-d orcl10-s statspack_suse11a_srvc-r orcl101$ Srvctl add service-d orcl10-s statspack_suse11b_srvc-r orcl102$ Srvctl start service-d orcl10-s statspack_suse11a_srvc$ Srvctl start service-d orcl10-s statspack_suse11b_srvc$ Srvctl status service-d orcl10Service orcl10_srv is running on instance (s) orcl102, orcl101Service statspack_suse11a_srvc is running on instance (s) orcl101Service statspack_suse11b_srvc is running on instance (s) orcl102$ Srvctl config serv

Recently used Statspack on a customer's 8i production library and found an error in alert: Mon June 16 13:17:52 2014 Errors in FILE/ORACLE/8.1.7/ADMIN/PROD/BDUMP/SNP0_96626_PROD.TRC: Ora-12012:error on Auto execute of Job 304 Ora-01631:max # Extents (505) reached in table Perfstat. Stats$sql_summary Ora-06512:at "Perfstat. Statspack ", line 978 Ora-06512:at "Perfs