oracle 11g tuning

Tags: OracleThis blog post focuses on installing Oracle 11g in a CentOS environment. The system environment is CentOS7.2.Pre-installation Environment preparationTo install the required packages:Yum install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel LIBGCC Libs tdc++ libstdc++-devel libxi libxtst make Sysstat unixodbc-devel-yYum install binutils* compat-lib

/yum.repos.dMV Centos-base.repo Centos-base.repo.bakwget Http://mirrors.163.com/.help/CentOS-Base-163.repo or wget Http://mirrors.sohu.com/help/CentOS-Base-sohu.repoRun the Yum Makecache build cache4 Console page Some of the text on the button is garbled solution (such as login screen: Login button) Workaround: EM garbled is caused by Java, the EM button is generated by the Java diagram, Oracle 11g using th

Installing Oracle 11g R2 in LinuxI. installation environment Linux Server: CentOS 6.4 64-bit Oracle Server: Oracle 11gR2 64-bitIi. System Requirements Requirements for installing Oracle in Linux System Requirements Description Memory Physical memor

1. directpath reads description In versions earlier than Oracle 11g, if a full table scan is performed on a large table, the wait event is: DB file scattered read; in 11g, if a full table scan is performed on a large table, wait event is: direct path read; that is, in 11 GB, full table scan of large tables directly reads data blocks into the PGA region of the se

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive. SQL> alter system set cluster_database = false scope = spfile sid = '*'; 2. Shut down all instances (shutdown on both sides) SQL> shutdown imm

This article will share with you the Problems and Solutions encountered when installing Oracle 11g on Windows 7. First, on the Windows 7 flagship edition, the Oracle 11g prompts the following error when "product-specific precognition condition check: In the first image, we can see that the check fails when

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 performance. Prior to 11g

Prior to 11.1, many people might have known that Oracle database history passwords could be restored through alter user identified by values password, but several problems occurred in 11g:1. Dba_users no password record (null value), this problem can be directly queried User$.password still have recordsSql> Select password from dba_users where username= ' SYS ';PASSWORD------------------------------Sql> Sel

Tags: dump 11g r2 Pat ROR use path Comm limit exportSelection:32-bit memory is a bottleneck, already 64-bit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In virtual machine installation, the network is set up by hostonly modeNote: Network adapter to set up ICS (Internet Connection Sharing) to the VMware network Adapter VMnet1So for virtual machines, the gateway

Oracle 11G 64-bit automatic restart and shutdown commands in RHEL (Red Hat Enterprise Linux, the same below) 5.5 64-bit: Log On As an oracle user and enter: VI/etc/init. d/Oracle On the Edit page, add the following content: (assume that the Oracle main directory is/u01

Running Oracle 11g root.sh script ... The following environment variables isSet as: Oracle_owner=Oracle Oracle_home=/opt/oracle/product/Orahomeenter the full pathname of the Local bin directory: [/usr/local/bin]: Here enter Copying Dbhome to/usr/local/bin ... Copying oraenv to/usr/local/bin ... Copying coraenv to/usr

-------------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |-------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 11 | 189 (1) | 00:00:03 || 1 | RESULT CACHE | 27yjysxpdun18b2utun82bynny | | | | || 2 | SORT AGGREGATE | | 1 | 11 | | ||* 3 | INDEX RANGE scan| idx$$_003600

corresponding technical operation and maintenance capacity, project input costs, business system load level. With Oracle's own component capabilities, no Logical Standby, stream, and 11g physical Standby (Active Data Guard), the stream is the most flexible, but most unstable, 11g Physica L Standby supports recovery and read-only parallelism, but because it is not a logical application mechanism of logs, it

can be fixed, you may need to re-build the DG or Apply the new Standby, and then switch back to the Primary role. Failover may cause data loss due to the fault type of the Primary site.There are many tools for Switchover and Failover. The most common tools are SQL Command, Data Guard Broker, and DB Grid Control. This article describes how to use SQL Command to perform Switchover operations. References: Important configuration parameters of Oracle Dat

New Features of Oracle 11g: User rename Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :" 1. Export data from exp in the Development Library 2. Delete the Test Database User 3. Use imp to import exported data to the Test Database T

Install Oracle 11g in RedHat Linux 6.0 Steps for installing Oracle in Linux Preparations before installation Transmit oracle to the root directory through ssh (this installation is under VMware) Installation Package for Linux for Oracle