Oracle

There is no universal, universally applicable value for the size of the shared pool, and different system loads require a shared pool of different sizes to manage. Usually when we set up shared pool, we should follow the "Don't be too big, not too

The characteristics of a DSS system are to produce meaningful reports from a large number of data. DSS applications may often be used with OLTP, but because their design requirements vary widely, it is not a good idea to use OLTP systems for

Oracle 10g + REDHAT5, install use all normal, install user Oracle. Starting Sqlplus with an Oracle user is normal today [Abc@rhel4 admin]$ Sqlplus/as SYSDBA Sql*plus:release 10.2.0.1.0-production on Thu Apr 23 12:11:25 2009 Copyright (c) 1982, +,

One what is the Smon process The systemmonitor performs recovery when a failed instance starts up again. In a oraclereal application clusters database, the Smon process of one instance Canperform instance for other Stances that have failed. Smon

Concepts and considerations 1, group function: to a set of data operation, and finally return a value for statistical analysis, all non-null values. 2, keyword DISTINCT can exclude duplicate values. 3, the type of parameter can be

Data files (Details of the data file are documented in the control file) • Each Oracle database must have at least one data file for storing database data • Multiple data files should be placed on different disk to improve access speed 1. Main

The collection of Pl/sql languages is similar to arrays and is a necessary structure for managing multiple rows of data. A set is a list that may be ordered or unordered. The Pl/sql collection types are: union arrays, nested tables, and variable

1. Synonyms: In a distributed database environment, to identify a database object, you must specify the host name, the server name, the owner of the object, and the object name. This undoubtedly increases the access difficulty of the visitor. You

ORA-01555 snapshots are too old to be a common mistake in the database, such as when our transaction needs to use Undo to build the CR block, and the corresponding undo does not exist, this time will report the ORA-01555 error. The ORA-01555 error

--View the Locked object Select A.session_id,a.object_id,a.oracle_username,b.object_type,b.object_name from V$locked_object a,all_objects b where a.object_id = b.object_id; --Unlocking method 1 Find SID, serial# Select c.sid,c.serial# from

Although Oracle's deterministic statement is intended to ensure the certainty of functions, it can be used to raise performance when used rationally. This article describes the effect of parameter order on performance. In the previous article, it

Although Oracle's deterministic statement is intended to ensure the certainty of functions, it can be used to raise performance when used rationally. This article describes the effect of array on performance. With regard to the deterministic

As mentioned earlier, the processing of the ORACLE10G reconstruction procedure has increased, and when I first saw this enhancement, I wondered if this enhancement would reduce the already-troubled library cache competition. Let's take a look at

As an enhancement to the flashback operation (flashback), ORACLE10G provides a function to convert the SCN and timestamp to each other. The current SCN value of the system can be obtained first through Dbms_flashback.get_system_change_number: Sql>

Errors in File/home/oracle/diag/rdbms/orarpt/orarpt/trace/orarpt_mmon_22508.trc:ora-19815:warning:db_ Recovery_file_dest_size of 2147483648 bytes is 98.55% used, and has 31102976 remaining bytes. You have following choices Om Flash recovery area:1.

1. Install Linux (RedHat Linux6.2). Note Select "Expert mode (expert)" To manually increase the network card. (for the specific settings of the network parameters, depending on the situation). About partitions: /boot:16 M (should be at the front of

During the installation of the oracle10g RAC, the network settings need to be cautious and extremely important. The following is a list of my oracle10g RAC Environment's network configuration for your reference. 1.hosts File Settings Since RAC

Partition change tracking: no MV Log Required To understand this enhancement, you must first understand the concept of zoning trimming in the materialized view (MV) refresh process. Suppose the table ACCOUNTS is partitioned based on column acc_mgr_

Database security problem has been one of the focus of attention, we know that a business or organization of the database if the hacker attacks, and these databases and the preservation of very important data, such as banks, communications and other

1 Create a script (replace is to modify a script that already exists) Rman> Create script Users_bak { 2> backup datafile '/u01/app/oracle/oradata/prod/users01.dbf ' format '/disk1/rman/prod/users_%s.bak '; 3>} Created Script Users_bak 2 View