performance tuning in oracle 11g

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

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

undotbs1 DATAFILE '/u01/app/oracle/oradata/test1/undotbs01.dbf' SIZE 200 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED 5. Create a data dictionary Data Dictionary script: [Oracle @ rh6 ~] $ Cat cr_dict. SQL @? /Rdbms/admin/catalog. SQL @? /Rdbms/admin/catproc. SQL Conn system/oracle @? /Sqlplus/admin/pupbld. SQL At 11:00:12 SYS @ test1> @/home/

)----Multiple instances to open a database• Stream----Multiple Oracle servers propagate transactions to one another• Data protection----The primary database to update the standby database Determine if it is a single instance Select parallel from V$instance; --NO Single InstanceSelect Protection_level from V$database; --Standby database protection, unprotected not protected SELECT * FROM dba_streams_administrator;--has not been configured and returns n

cluster software files and database files. Network File System (NFS)-shared storage via NFS, but requires Oracle-certified NFS to support CRS cluster software files and database files. asm--Collection RAW mode I/O high performance and cluster file system easy to manage the advantages of oracle10g, the introduction of shared storage, but itself ASM is required to support

Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle

About Oracle ASM instances About Oracle ASM disk groups About grouping and failure groups About Oracle ASM Disks About Oracle ASM files About Oracle ASM instances The Oracle ASM instance is built based on the same technology a

L CRSD. Log: $ORA _crs_home/log/hostname/crsd/crsd. Log L OCSSD. Log: $ORA _CRS_HOME/LOG/HOSTNAME/CSSD/OCSD. Log L EVMD. Log: $ORA _CRS_HOME/LOG/HOSTNAME/EVMD/EVMD. Log Nodeapp Log Location$ORA _crs_home/log/hostname/racg/This is a log of Nodeapp, including ONS and VIPs, such as ORA. Rac1.ons.Log Tool Execution log: $ORA _crs_home/log/hostname/client/Clusterware provides a number of command-line tools such as Ocrcheck, Ocrconfig,ocrdump,oifcfg, and Clscfg, and the logs gen

documents Oracle's three highly available cluster scenarios Introduction to cluster Concept: The Oracle Advanced Course--theoretical textbook Oracle one-off RAC Survival Guide Oracle 11gR2 RAC Management and performance optimization Article Navigation Introduction to cl

-typically for OLTP.(v) To save hardware costs, you can use a number of inexpensive PC servers instead of minicomputer mainframe, saving the corresponding maintenance costs.(vi) Scalability is good, you can easily add delete nodes, expand Hardware resources.RAC disadvantage(i) more complex management and higher requirements(ii) Poor system planning design performance may be less than a single node(iii) Software costs may be increased (per CPU charge)"

aspects of performance improvement. At the Oracle OpenWorld Conference held on October 23, 2006, Oracle's executive vice president Chuck Rozwat had personally addressed Oracle 11g performance. According to Chuck Rozwat, Oracle mo

), captures the information associated with the event, and automatically checks the database for health and notifies the DBA. In addition, this information can be packaged and sent to the Oracle support team. Event Packaging Services (Incident packaging service) If you need to test further or retain relevant information, this feature can package information related to an event. And you can also send packaged information to the

Oracle 10g and Oracle 11g hand-built case--oracle 10gSystem environment:Operating system: RedHat EL6Oracle:oracle 10g and Oracle 11gThe Manual construction of the library is relatively easy to implement, this case is from 10g and 11g