performance tuning in oracle 11g with examples

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a database, there are some attributes (if enabled) it will have a long-term impact on the

iorequests],[physical Read Total bytes],[physical write total io requests],[physicalwrite total IO requests] value per second because we io calibration is also counted in units per second. we can calculate the physical read and write total requests per second for 70.74+80.62 ≈ 151 times, the size of the physical read and write per second is 1.32+1.09 ≈ 2.41mbs=19.28mbps, with this reference, we store the maximum calibration IOPS should not be less than 151 , the throughput per second ca

Database_role Switchover_status--------- -------------------- ---------------- --------------------ENMO1 MAXIMUM Availability Physical STANDBY to STANDBY Standby Confirm mode: [Email protected] hey~1->select name,protection_mode,database_role,switchover_status from V$database; NAME Protection_mode Database_role Switchover_status--------- -------------------- ---------------- --------------------ENMO1 MAXIMUM Availability Physical STANDBY not allowed Second, maximum available switch to maximum p

How to configure the STATSPACK performance report of ORACLE 11g adg, adgstatspack Create a normal STATSPACK report user on the master database Sqlplus/as sysdbaSQL> @? /Rdbms/admin/spcreate. SQL SQL> -- cancel some settings of $ ORACLE_HOME/sqlplus/glogin. SQL. SQL> -- in some cases, the password, tablespace, and temporary files are required. Perfstat 235619

How to configure the STATSPACK performance report of Oracle 11g ADG Create a normal STATSPACK report user on the master database Sqlplus/as sysdba SQL> @? /Rdbms/admin/spcreate. SQLSQL> -- cancel some settings of $ Oracle_HOME/sqlplus/glogin. SQL.SQL> -- in some cases, the password, tablespace, and temporary files are required. Perfstat 235619 -- Create an SB use

Tags: style blog http color using OS IO strongOne, automatic workload library (Automatic Workload Repository,awr)The Automated Workload library (Automatic Workload repository,awr) is a tool provided by Oracle Corporation. AWR can automatically collect, process, and save performance statistics, which are stored in memory and then saved in a database that can be displayed in a report or queried through a view

--------------------------------------------------------------------------------------------------------------- ---------Plan Hash value:1131838604---------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |---------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 5 | 3335 (1) | 00:00:41 || 1 | SORT AGGREGATE | | 1 | 5 | | || 2 | INDEX FAST full SCAN

Create a normal statspack report user on the main librarySqlplus/as SYSDBASql>@?/rdbms/admin/spcreate.sqlSql>--Notice to cancel $oracle_home/sqlplus/glogin.sql some settingsSql>--some normal words will appear asking for password and tablespace and temporary filesPerfstat 235619--Create SB UserSql>@?/rdbms/admin/sbcreate.sqlEnter the password tablespace temporary table space.Then ask if you want to configure network (y/n) input yConfigure the Tnsname of the standby library;Build Dblink use Perfst

Tags: problem BSP phi Common Oracle Pen comparison nbsp + +Examples of common tools, methods for diagnosing Oracle performance problemsAnswer: 1) A simple point can be used toad and dbartisan such tools. 2) Pure performance monitoring, more excellent spolight and EMC I3, bot