performance tuning in oracle 11g

Tags: Oracle 11g database management Data 11g DBA1. Oracle Database Overview1.1. Structure and compositionOracle Database 11G has a total of 4 versions, Enterprise, standard, standard 1, and personal.1.1.1, Enterprise EditionAdvantages:High reliability. Prevent server failur

Oracle 11g has added a lot of functionality to backup and recovery, with varying degrees of performance, functionality, security, and operability. This article describes the validation when Rman deletes an archive log. In the previous version of 11g, Oracle's Rman was not tightly integrated with other log application

Label:About audits: 11g By default, the auditing option is enabled, and the default value of the Audit_trail parameter is DB, which indicates that the audit data will be recorded on the sys.aud$ Audit Dictionary base table in the database. In Oracle 10g, the default value of this parameter is none, which means that auditing is not enabled. Oracle claims that the

Oracle 11g audit file and oracle11g audit file Audit: The audit option enabled by default for 11g. The default value of the AUDIT_TRAIL parameter is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in the database. In Oracle 10 Gb, the default value of this parameter is non

Two test samples were made in the art of simulating Oracle performance diagnostics. The book says not to bear relies_on. Cache (Result_cache relies_on (test1,test2)). The test proved incorrect, and the function F1 () did not use relies_on, but the changes on the table affected the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday

transaction to the APPLIER process, monitors the transaction dependency and coordinates the submission order APPLIER: there can be multiple COORDINATOR processes, it is responsible for applying LCR to the standby database. 3. Creating a logical standby database [SQL] view plaincopyprint? A. There are many ways to create a physical standby database first. For Oracle 11g, you can create a physical standby da

Tags: Bring your own impact ROR home remote Access Basic Web SHA ResourceAfter the successful installation of Oracle 11g, there are 7 services, the meanings of these seven services are:1. Oracle ORCL VSS Writer Service:Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images (Shadow copy

Starting to test Oracle 11g RAC, the current performance is limited, so a single node RAC is installed. The procedure is as follows: Nic binding Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts * I will not talk more here Configure xmanager connection VI/usr/share/TPD/defaults. conf Change enable = false under [XDMCP] t

follows:SQL> Alter system set event= ‘28401 trace name context off‘ scope=spfile ;Summary:About a large number of concurrent error passwords connecting to the database can cause the database to hang, or cause performance problems, the impact on the database is very large, recently encountered such a case. Of course, Oracle itself is a very good feature, but in the present there are some problems, you can d

ORACLE 11g R2 database installation hardware environment requirements, 11gr2 Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1. Virtual Memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2 GB and 16 GB Equal to the size of RAM More than 16 GB 16 GB Database Software hard disk space

Tags: des blog http tar com strongDirect NFS ClientNAS storage devices Use the Network File System (NFS) to access data. In Oracle Database 10g, NAS devices were accessed using operating system–specific kernel NFS drivers. This required, tune many parameters, and the configuration varied across the platforms. The NFS clients tended to be inconsistent across the different operating system platforms. Manageability wasn ' t easy because your had to conte

executed, for insert fortunately, for the update,delete operation must be able to uniquely locate the database to update the record. If the tables in the primary library are not set properly, you may not be able to confirm unique conditions. Therefore, Oracle recommends creating a primary key or non-null unique index/constraint for the table to ensure that the SQL application can effectively apply the redo data and update the logical standby database

technology, you can virtual a few physical hard disks into a large hard disk, or n blocks of hard drives. RAID Technology has two implications: data protection, increased I/O throughput. C. Introduction to the Network(1) Public network: Client pass, Web Access to RAC through public network(2) Private network: Used for mutual communication between node members, that is, node interconnection, only the node can use the private network. cannot be used in public networks to avoid communication del

1. Configure a minimum of 2 data Group (datagroup), the Fra datagroup as the flash back Zone side archive, backup, etc.) mainly consider the IO performance problem2. Oracle Official documentation recommends a minimum of 4 disks per DG and the same size and performance. No IO will be limited by the slowest disk3. The hardware RAID strip size takes the power of 2,

Recently began to learn Oracle database, according to my understanding of Oracle database is a powerful, complex, high-performance database, and expensive, the use of large enterprises, local tyrants dedicated. Learning a database to get started is to install such a database, in view of the large number of friends installed problems, I installed the database of t

views are primarily v$ views, which are named because the views are constantly updated to reflect the health of the current instance and database. Dynamic performance tables are used to record the activity of the current database, only during the database run, and the actual information is taken from the memory and control files. DBAs can use dynamic views to monitor and maintain databases. Illustrate the use of dynamic Data dictionariesAs can be see

Many new changes in Oracle Database (Database) 11g Ensure that this dream is closer to reality. Oracle released Oracle Database 11g Release 2 For Linux. For example, a database replay tool allows you to capture the production database load and replay it in a test (or even th

Starting to test Oracle 11g rac, the current performance is limited, so a single node rac is installed. The procedure is as follows: Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts by binding the NIC * I will not talk more here Configure Xmanager connection Vi/usr/share/TPD/defaults. conf Change Enable = false under [xdm

is created on the virtual column, but it is actually a function-based index), and the virtual column partition supports all partition policies and can be partitioned using scopes, lists, and hashes. 5. Divisional Advisors14. read-only table15.RAC one Node and RAC patchingThe RAC one node indicates that the Oracle RAC database is running only on an active Oracle instance and, like an

OriginRecent 10g and 11g physical standby configuration experiments found that Data Guard is actually easy, but lacks good documentation. I was experimenting with the official documentation and thought it wasn't very clear.Google out of two PDF documents, read it feel much stronger than official documents. It may be useful for some friends to translate. I am also better acquainted with these two documents while translating. I have not translated Engli