performance tuning in oracle 11g

After successfully installing Oracle 11g in accordance with the methods in Windows 7 64-bit installation of Oracle 11g R2, there are 7 services that have the meanings of seven services, respectively:1. Oracle ORCL VSS Writer service:oracle Volume Mapping copy write service,

Label:the following is from: Http://www.51cto.com/art/200806/76223.htm35.2 Execution Plan management35.2.1 OverviewThe execution plan for the same SQL statement may vary depending on the optimizer's version, optimization statistics, optimization parameters, and system settings. The execution plan of the SQL statement automatically changes, usually resulting in performance gains, but in some cases may result in degraded system

Oracle Racfailover: Http://www.51CTO remind you not to spam ads!/bbs/thread-31215-1-1.htmlHow to Configure Server Side transparentapplication Failover [ID 460982.1]1. Create Tafservice[Email protected] bin]$./srvctl add service-d orcl-s server_taf-r "Orcl1,orcl2"-p BASICThe ORCL here are the database NAME,ORCL1 and Orcl2 are instance name.2. Start the SERVER_TAF service[Email protected] bin]$/srvctl start service-d orcl-s server_taf3. Check service

*********************************************** Declaration **********************************************original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held responsible for copyright law. Please leave a message or email ([email protected]) to indicate the error.This reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216069Deep Blue Blog:http://blog.csdn.net/huangyanlong************

Performance of different Oracle client and Oracle versions **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible. Please leave a message

. Select event, total_waits, time_waited, average_wait from v $ system_event where event like 'Log file switch (arch % '; If there is a wait, check whether the storage device that saves the archived logs is full. Add a log file group and adjust log_archiver_max_processes. F. DB_block_checksum = true, which increases the performance burden. (To ensure data consistency, add a checksum to the block when writing data in

) this.width=650; "src="%5c "title=" \ "20.png\"/"alt=" Wkiol1lwsvusqhp4aaap7zlxa7y993.png-wh_50 "/>into a good curve like the following650) this.width=650; "src="%5c "title=" \ "21.png\"/"alt=" Wkiom1lwswxacrtvaaasx-5dkfm707.png-wh_50 "/>3.2 Key points to solve the problem review1) Analyze the Oracle wait events without fragmentationSmall y in this case by combing wait events in common is log file sync, thus finding a breach2) Understand the characte

can be stored in the loop buffer. So this data needs to be written to disk periodically, and that is, the Mmon process periodically writes part of the data to the AWR. The policy used by AWR is to sample the V$active_session_history once per hour and save the information to disk for 8 days (11g default) and 8 days before the old record is overwritten. These sampling information is saved in the view wrh$_active_session_history. This sampling frequency

Oracle initialization parameter performance view 1. database version LEO1 @ LEO1select * fromv $ version; BANNER -------------------------------------------------------------------------- Oracle initialization parameter performance view 1. database version LEO1 @ LEO1select * fromv $ version; BANNER -------------------

dynamic views such as V $ sesstat v $ SYSSTAT. Therefore, any shutdown operation on the database system will reset these statistics. Oracle System Performance Statistics: Oracle 10g/11g contains the following types of statistics: AWR statistics, accumulative statistics on system operation; Measurement value, the chang

JAR paths in the CLASSPATH environment variables. For example, you may include the following paths: ORACLE_HOME/jdbc/lib/ojdbc6.jarORACLE_HOME/jlib/orai18n.jar If the Oracle database has been installed on your computer, the thin driver has been installed on your computer along with the Oracle database. However, since the thin driver is independent of any other

statistical data, can be obtained through dynamic views such as V $ sesstat v $ SYSSTAT. Therefore, any shutdown operation on the database system will reset these statistics. Oracle 10g/11g contains the following types of statistics: AWR statistics, accumulative statistics on system operation; Measurement value, the change value of the differential description of accumulative statistics; Sample data, stati

trace_file_nameFrom v $ instance I,V $ session s,V $ process p,V $ px_process pp,V $ shared_server ssWhere s. PADDR = p. ADDRAnd s. SID = pp. SID (+)And s. PADDR = ss. PADDR (+)And s. TYPE = 'user'And s. SID = 'your Sid'Order by s. SID Replace the above 'your Sid' with your session sid to find out the name of the trace file generated by the specified session. The session sid is obtained in the v $ session view, or directly query the sid of the current session: ? 1 Select usere

Tags: color extend directory issues Oracle Database Insert Tutorial OCA official websiteArticle turned from: http://www.shsnc.cn/show-109-970-1.html For further details, refer to: http://xlsxwriter.readthedocs.io/tutorial01.html 1.Why do you want to generate graphs For Oracle database operations, sometimes it takes a week to see how the database is running, and the per