performance tuning in oracle 11g

The database of the Oracle 11g virtual column Acme contains a table named SALES, as shown in the preceding figure. The table structure is as follows: SALES_IDNUMBERCUST_IDNUMBERSALES_AMTNUMBER some users want to add a column named SALE_CATEGORY to identify the sales type based on the sales volume and the current customer: LOW, MEDIUM, HIGH, and ULTRA. This column will help them identify the corresponding ac

Imitating the example of Oracle performance diagnostics in two experiments, the book says that if you don't use relies_on, the change action on the object that the function depends on does not cause the result cache to fail operation (Result_cache relies_on (test1, TEST2), the test proves wrong, the function F1 () does not use relies_on, but the changes on the table affect the function. C:\Documents and Set

database ADD STANDBY LOGFILE ' srl1.f ' SIZE 52428800; ALTER DATABASE ADD STANDBY LOGFILE ' srl2.f ' SIZE 52428800; ALTER DATABASE ADD STANDBY LOGFILE ' srl3.f ' SIZE 52428800; ALTER DATABASE ADD STANDBY LOGFILE ' srl4.f ' SIZE 52428800; ALTER DATABASE ADD STANDBY LOGFILE ' srl5.f ' SIZE 52428800; Waiting-non-current orls to be archived ... All Non-current Orls has been archived. Clearing online redo logfile 1/u01/app/oracle/oradata/sbdb1/sbdb1/onlin

ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and asynchronous delay transmission mode, it can even become a remote disaster recovery solution. Regardless of the purpo

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 for storage infrastructure (such as disks, arrays, etc.) That is, the mapped copy (shadow copy). It can create a mapped copy on multiple volumes or on a single volume without affecting the system's system performance. (must not be started)2.

Oracle 11g r2 Enterprise Manager (EM) Chinese page adjusted to English page, oracle11g Oracle 11g r2 Enterprise Manager (EM) in Chinese language environment, Some functions (such as querying database instances that contain time: orcl> Guidance Center> SQL optimization Overview: SQL _TUNING_1419222457832 will report an

Tags: ima ACL date base least using SYN sum action--================ Oracle ADG operations and Maintenance ================--======== Test Log Transfer ========1. On primary, view the last archived log, Force log switchoverALTER SESSION SET nls_date_format= ' dd-mon-yyyy HH24:MI:SS ';SELECT sequence#, First_time, Next_timeFrom?? V$archived_logORDER by sequence#;ALTER SYSTEM SWITCH LOGFILE;2. On standby, check that the new archived log has reached stan

Oracle 11g has made some improvements in optimization. Oracle automates the following optimization: Redo Logfile Sizing Advisor-this feature recommends Redo the optimal size of log files to avoid excessive disk I/O caused by frequent checkpoints. Automatic Checkpoint Tuning-Oracle database can now optimize checkp

Odp.net 11g is an Oracle-released Ado.net component for. NET programs to access Oracle databases, better performance than Microsoft's own Oracle components, more access to the UDT (User Defined type) type, Procedure, Ref and so on advanced

First, the partition tablePartitioning technology, Oracle allows you to divide a large table into parts, each part called a partition, and then put each part on a different physical disk to improve the performance of the entire database.Each partition can be divided into several more, so that the resulting partition is called a sub-partition (subpartition). The partitioned table is logically a whole.1. Adva

the instance using the previously backed up spfile, to create a new database, you must create a new one. Use this parameter file to start the instance to the mount status. Use scripts to create database files. After the script is complete, continue to run the script set to generate database objects. In my previous script set, the catctx of 11g is missing. the SQL script is added. Otherwise, oracle text can

After half a month of Oracle Dataguard physical repository configuration and learning, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. In the process of nearly 10 dataguard configuration, it is found that it is very convenient and fast to create the physical repos

Tags: Modify OCA res scope control File View 11g routed iOS1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam and DG that have an impact on performance (good bad)2. T

: The file is no longer usefulAs you can see from the above output, there are 3 redo log groups in the database, and 1 redo log files per log group.Redo log groups and their member managementTo create a redo log group:There are too few Oracle database log groups that can cause log files to switch frequently and affect system performance, so it is sometimes necessary to add new log groups. If there is only o

conversion is complete, you can reset the standby run mode as needed. The operating mode of the conversion repository is because the standby is running in maximum protected mode and cannot be failover, and if the primary library is running in maximum protected mode and the standby is in communication, the SQL operation to change the standby to the best performance mode will not succeed. Because the failover operation moves the main library out o