performance tuning in oracle 11g tips

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

1024 C. vi /etc/pam.d/login [[Email protected] ~] # vi/etc/pam.d/login/*session required/lib/security/pam_limits.sosession required PAM_ limits.so*/ D. vi /etc/profile [[Email protected] ~] # vi/etc/profile/*"Oracle" ]; Then"/bin/ksh" ]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fifi*/ E. Configuring environment variables[Email protected] ~]# vi/home/oracle/.bash_profile/*export or

--------------------------------------------------------------------------------------------------------------- ---------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

sequential access to each record in the table. ORACLE optimizes full table scan by reading multiple data blocks at a time. B. Access the table through ROWID You can use ROWID-based access to improve the efficiency of accessing tables. ROWID contains the physical location information recorded in the table .. ORACLE uses indexes to establish a connection between data and the physical location where data is s

Nowadays, Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Readers may wish to consider the following aspects to ensure the permanent performance of Oracle databases. PartitionBased on actual experience, in a large database, the vast majority of database space is occupied by a small number of table

Nowadays, Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance for Oracle databases. I suggest you consider the following aspects. Partition Based on actual experience, in a large database, the vast majority of da

Today, Oracle databases are favored by more and more enterprises because of their high reliability, security and compatibility. The reader may wish to consider some of the following aspects of how to keep the Oracle database permanently in good performance. Partition According to practical experience, in a large database, the vast majority of database space is o

Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see! Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle