perfstat

schema command in RMAN to view the name of the tablespace. Man> report Schema;Report of database schema List of permanent datafiles======================================File size (MB) tablespace RB segs datafile name---------------------------------------------------------------480 system ***/home/Oracle/oradata/ora10g/system01.dbf2 25 undotbs1 ***/home/Oracle/oradata/ora10g/undotbs01.dbf3 250 sysaux ***/home/Oracle/oradata/ora10g/sysaux01.dbf4 5 Users ***/home/Oracle/oradata/ora10g/users01.dbf

types of events that cause slow system response time. By optimizing these events, the system response speed is improved.L SQL statements sorted by resource consumption. Generally, slow system response speed is related to parameter settings and writing of nonstandard SQL statements. Optimize the captured SQL statements to improve the response speed.L I/O load of each tablespace and each file in the tablespace. Use this part to determine whether the I/O of each file is balanced.L rollback segment

The following is tested under Window xp,oracle9.2.0.1, under Linux/unix the path "" is replaced by the "/" Installation of 1.Statspack Sqlplus/nologConn/as SYSDBA --Create a statspack table space, require more than 80M or use existing tablespace, but must have more than 80M of free space Sql>create tablespace statspack datafile ' Size 100M autoextend onEXTENT MANAGEMENT Local uniform SIZE 128K--Execute the installation script, under Oracle_home dbmsadminSql>@? Dbmsadminspcreate.sql --During

alarm is triggered when the threshold value is exceeded through the data in the SQL timing analysis table. At the same time, based on the data in the table, we can also make a system performance trend report. 　　◆ Vmstat script and steps 　　1. Install statspack Sqlplus "/as sysdba" SQL> @? /Rdbms/admin/spcreate. SQL After setting the password for the perfstat user as prompted, I chose the SYSAUX tablespace as the default tablespace FOR THE

1. telnet to a remote database serverCMD> telnet the IP address of the remote database2. Users switching to the databaseDQXXDBS01:/> su-oracle3. Use a super user to access the database$ Sqlplus "/as sysdba"4. Check the parameters and whether a job can be used (you can use a job to automatically collect Statpack Report data)SQL> show parameter job_queue_processes5. This parameter can collect operating system informationSQL> show parameter timed_statistics6. In order to create a tablespace, which

In Linux Redhat 5.4, the recovery process for RM accidental deletion of database files is as follows:(Found online, tested OK)1. First, test RM's accidental deletion of database files. [Oracle @ primary dbwdn] $ LLTotal 2153164-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control01.ctl-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control02.ctl-RW-r ----- 1 Oracle DBA 8536064 Nov 27 control03.ctl-RW-r ----- 1 Oracle DBA 104865792 Nov 27 ggs01.dbf-RW-r ----- 1 Oracle DBA 525344768 Nov 27

1. telnet to a remote database server CMD> telnet the IP address of the remote database 2. Users switching to the database DQXXDBS01:/> su-oracle 3. Use a super user to access the database $ Sqlplus "/as sysdba" 4. Check the parameters and whether a job can be used (you can use a job to automatically collect Statpack Report data) SQL> show parameter job_queue_processes 5. This parameter can collect operating system information SQL> show parameter timed_statistics 6. In order to create a tablespa

1. View tablespaces Select tablespace_name, file_name from dba_data_files; 2. Create a statspack tablespace Create tablespace perfstat datafile 'd:/Oracle/oradata/perfstat. dbf' size 500 m The tablespace should be as big as possible. 3. Install statspack. Run the following command in the ORACLE_HOME/rdmbs/admin/directory: @ Spcreate. SQL If creation fails, run @ spdrop. SQL in the same directory. 4. test: S

To generate an oracle statpack 1. telnet to a remote database serverCMD> Telnet the IP address of the remote database 2. Users switching to the databaseDqxxdbs01:/> Su-Oracle 3. Use a super user to access the database$ Sqlplus "/As sysdba" 4. Check the parameters and whether a job can be used (you can use a job to automatically collect statpack report data)SQL> show parameter job_queue_processes 5. This parameter can collect operating system informationSQL> show parameter timed_statistics 6. In

This article describes how to configure STATSPACK in ORACLE. For more information, see This article describes how to configure STATSPACK in ORACLE. For more information, see 1. telnet to a remote database server CMD> telnet the IP address of the remote database 2. Users switching to the database DQXXDBS01:/> su-oracle 3. Use a super user to access the database $ Sqlplus "/as sysdba" 4. Check the parameters and whether a job can be used (you can use a job to automatically collect Statpack Report

1, Telnet to the remote database server Cmd>telnet The remote database IP 2, switch to the database users Dqxxdbs01:/> su-oracle 3, access to the database with super users $ sqlplus "/as sysdba" 4, check the parameters, whether you can use the job (can be used to automatically collect Statpack data) Sql> Show Parameter job_queue_processes 5, this parameter can collect the information of the operating system Sql> Show Parameter Timed_statistics 6, in order to create a table space, the table space

Oracle| Notes | performance Oracle Performance Diagnostics-Learn Statspack notes (i) Author: Liu Yingbo Time: 2004-3-2 Mail:liuyingbo@126.com, please correct me. Reprint please indicate the source and the author Description: oracle8.1.6 began to introduce Statspack,statspack is a powerful tool for diagnosing Oracle performance Prepare before installation A. First, the confirmation of system parameters: Job_query_processes: In order to establish automatic task, perform data coll

/sec), but requires it to execute within (hours/minute/second). Used (the amount of resources), but it cannot be used over. 2. Measurement and recording of current performance Focus: (1) The need to obtain a snapshot of the current system capability at peak activity Time (2) The key is to collect information in the time period during which the performance problem occurs (3) must be collected at a reasonable time period, typically taking a few 15-minute snapshots during the peak period Method: Pe

AUTOTRACE report only displays the execution STATISTICS of SQL statements. · Set autotrace on: The AUTOTRACE report includes both the optimizer execution path and SQL statement execution statistics. · Set autotrace traceonly: similar to set autotrace on, but does not display the user's query output (if any ). In addition, you can use the explain plan statement to obtain the execution plan. By default, the execution plan is saved to plan_table. You can use the DBMS_XPLAN package to view the res

%/var /Dev/hd3 3145728 3140388 1% 69 1%/tmp /Dev/fwdump 1048576 1048080 1% 5 1%/var/adm/ras/platform /Dev/hd1 2097152 2096488 1% 5 1%/home /Dev/hd11admin 262144 261744 1% 5 1%/admin /Proc---/proc /Dev/hd10opt 4194304 3945520 6% 8748 1%/opt /Dev/livedump 262144 261776 1% 4 1%/var/adm/ras/livedump #/Usr/bin/getconf HARDWARE_BITMODE 64 The system content requires at least 1 GB memory. The SWAP partition size requires 75% memory for 8 GB memory. The current configuration is 50% memory size. Although

hardware_bitmode645. We can use the following command to confirm the number and clock speed of the system CPU:# Lsdev-c | grep procProc0 available 00-00 ProcessorProc1 available 00-01 Processor# Lsattr-e-l proc0Frequency 752010000 processor speed falseState enable processor state falsePowerPC_RS64-III Processor type false# Lsattr-e-l proc1Frequency 752010000 processor speed falseState enable processor state falsePowerPC_RS64-III Processor type false2. Confirm the system software environment1. A

Statspack Installation Use and analysis 1. View table Space Select Tablespace_name,file_name from Dba_data_files; 2. Create Statspack table Space Create tablespace perfstat datafile ' d:\oracle\oradata\perfstat.dbf ' size 500m The table space should be as large as possible. (If the table space is small, there will be an error in the installation, causing the next installation to prompt "xxx synonym (synonymous) has been installed ...", you must

Step 1. telnet to the remote database server CMD> telnet to the remote database IP address www.2cto.com 2. Switch to the Database User DQXXDBS01: /> su-oracle 3. Use a super user to access the database $ sqlplus "/as sysdba" 4. view the parameters, can I use a job? (I can use a job to automatically collect Statpack Report data) SQL> show parameter job_queue_processes 5. This parameter can collect information about the operating system. SQL> show parameter timed_statistics 6. To create a tablespa

execution STATISTICS of SQL statements.· Set autotrace on: The AUTOTRACE report includes both the optimizer execution path and SQL statement execution statistics.· Set autotrace traceonly: similar to set autotrace on, but does not display the user's query output (if any ). In addition, you can use the explain plan statement to obtain the execution plan. By default, the execution plan is saved to plan_table. You can use the DBMS_XPLAN package to view the result. For example:Explain plan for sele

Running statspack. snap can generate a System Snapshot and run it twice. Then, execute spreport. SQL to generate a report based on two time points. If everything works properly, the installation is successful. SQL> execute statspack. snapPL/SQL procedure successfully completed.SQL> execute statspack. snapPL/SQL procedure successfully completed.SQL> @ spreport. SQL... However, you may get the following error: SQL> exec statspack. snap;BEGIN statspack. snap; END;*ERROR at