Oracle

One what is the Pmon process The Process Monitor performs processrecovery when a user process fails. Pmon is responsible to cleaning up thecache and freeing resources, the process was using. Pmon also checks on Thedispatcher processes (described

Pga The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA

First, users 1, the use of SQL to create the user's syntax format is as follows: Create user user_name--username/ [identified by password | externally | Globally as ' external_name ']--how to authenticate the user , the authentication

The procedure for swapping partitions is as follows: 1. Create the partition table T1, assuming there are 2 partitions, P1,P2. 2. Create the base table T11 the data that holds the P1 rule. 3. Create the base table T12 the data that holds the P2

Oracle's security is divided into four parts, namely user management, access control, data protection and monitoring, specific reference to the [Oracle] Database Security Overview http://blog.csdn.net/u010415792/article/details/9008089 One of the

ORACLE10GR2 new features: Asynchronous COMMIT For Oracle's commit mechanism, I believe that we are already very familiar with. Oracle takes a synchronous write transaction log for a commit, that is, once a commit is issued, all redo that must wait

SELECT * from Dba_data_files; Col name format A15 Col failgroup format A20 Col path format A30 Oracle kfed and Kfod Tools description 1. Check V$asm_disk.header_status toverify that the disk header was in a ' member ' state. Check the status of

On the itpub see a forall execute update post, feel a little meaning, simple record. Previously studied INSERT statements in ForAll, found that the statement through the binding array, the way to achieve a batch binding, a run of the way, thereby

Because the B*tree index does not store null values, some Oracle queries do not use indexes when the indexed field is allowed to be empty. Most of the time, it appears that we can use a full index scan, which may give Oracle the chance to discard

1. Database version Leo1@leo1>select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle database11g Enterprise Edition release 11.2.0.1.0-64bit Production Pl/sql

First, the theory Source ADD EXTRACT , Tranlog, BEGIN , [, THREADS] ADD exttrail , EXTRACT EDIT PARAMS --Identify the Extract group: EXTRACT --Specify database login information as needed for the database: [Sourcedb ,] [USERID [, PASSWORD

Database environment Leo1@leo1> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release 11.2.0.1.0-64bit Production Pl/sql Release 11.2.0.1.0

Today to increase the data file, the database file name more than one point, although it can be used, but in the operating system to see the file but feel very uncomfortable, check some data, modify the method summarized as follows: 1. Close the

In an Oracle database system, there are two ways to authenticate users if they want to log on to an Oracle database as a privileged user (Internal/sysdba/sysoper): Using authentication that is integrated with the operating system or using the Oracle

The Pl/sql code in Oracle involves two execution engines, one that specializes in standard SQL statements, and another process code that handles Pl/sql, which typically leads to extra CPU overhead on engine switching. For example, the difference

Today, I learned about the latest popular Ruby on Rails, which is that when a code generator links an Oracle database, it checks for half a day of data. Finally found a way, ^______^. 1. Installation drive http://rubyforge.org/projects/ruby-oci8/

1, configure the connection pool through the Http://localhost:7001/console into the management console In the left-hand menu, enter mydomain (the custom domain name)-Service-jdbc-connection buffer pool Click "Configure the new JDBC Connection Pool

Oracle allows up to 148 enabled when user roles are enabled. In fact, this limit is strange, because 148 and 2 of the power difference is large, do not know what the reason for Oracle to determine this value: Sql> CREATE USER U_role identified by

In 11.2, Oracle optimized the execution plan for all outer joins. In previous releases, the execution plan for the full outer join was as follows: Sql> SELECT * from V$version; BANNER --------------------------------------------------------------

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 Oracle