Oracle

Load balancing is to increase the overall performance by allocating the load evenly to each node in the cluster. Oracle RAC provides two ways to achieve load balancing, the first is pure technology, that is, when users connect, depending on the

Multiple Oracle databases that are physically stored on the network can logically be viewed as a single, large database. Users can access the data in the remote database at the same time through the network. Collaborative processing between servers

Friends who recently saw a lot of novice Oracle on the Web or upgraded from an older version of Oracle to 10G asked how to build the library manually in Oracle 10G. Today is free, so the Oracle 10G in the process of hand-built library, for you to

Password complexity is an important aspect of it auditing staff to check whether a system is secure. It policies often indicate that passwords should have a minimum length and should contain a mix of uppercase letters, small letters, numbers, and

There was a problem with the system last night, a stored procedure was performing an exception, and observation only found that the higher the logic read. When the situation was more urgent, I had to change the original into the old way. In fact,

Example of invoking an Oracle stored procedure using a Ruby script: 1. First create Oracle stored procedure test: SQL> create OR REPLACE PROCEDURE test(p1 in varchar2,p2 out varchar2 ) is 2 BEGIN 3 select p1　　’ PROCEDURE executeD！’ into p2 from

Create or Replace package Pg_encrypt_decryptIsIkey VARCHAR2 (8): = ' oracle9i ';function Gen_raw_key (Ikey in varchar2) return RAW;function Decrypt_3key_mode (ivalue in Raw,imode on Pls_integer) return varchar2;function Encrypt_3key_mode (ivalue in

1 The value of the 6th to 10th record in the table 1.1 The first method, using the minus statement Suppose the DDL statement is as follows: CREATE TABLE T (ID VARCHAR2 (4) PRIMARY KEY, VALUE INT) Then the first method is

DML performance is low, one of the most serious reasons is the existence of useless indexes. All SQL inserts, updates, and deletions become slower when they need to modify a large number of indexes when each row of data is changed. Many Oracle

In Sql_plusSpool Execcompproc.sqlSelect ' Alter PROCEDURE ' | | object_name| | ' compile; ' From all_objects where status = ' INVALID ' and object_type = ' PROCEDURE ';Spool off@ExecCompProc. Sql; Organize into a stored procedureCreate Or Replace

Recently done projects encountered ORA-01000 errors, reference to some solutions, to solve their own problems to write down some of the experience.Java accesses an Oracle database, and in the For loop code, if you omit the connection that was

A lot of friends only use the Oracle deletion, but in many cases, he will find the reinstall, point to the next installation of the interface disappeared, often reluctantly had to reload the system, in fact, only your database did not delete clean,

Q: I installed in the REDHAT8 on the oracle9i process, prompted to change the second disc, but my optical drive is not back out, how to do?The CD-ROM drive is loaded with the Mount command, but when I change the disk, I use the Umount command prompt

In Sql_plus, spool ExecCompProc.sqlselect 'alter procedure '||object_name||' compile;' From all_objects where status = 'INVALID' and object_type = 'PROCEDURE';spool off@ExecCompProc.Sql; Organize into a stored procedure Create Or Replace

A lot of friends in Java development, the use of Oracle database, often encounter a ora-01000:maximumopencursorsexceeded error. In fact, the reason for this error is mainly caused by code problems. Ora-01000:maximumopencursorsexceeded. Represents

The merge statements introduced in Oracle 9i R2 are often referred to as "update Inserts" (Upsert), because the merge allows you to update and insert (insert) rows of data in the same step, for extraction, Converting and loading types of

We know from the beginning of oracle9i that Oracle introduced the characteristics of the peeking of user-defined Bind variables, which can be used to rectify the execution plan when there is data skew.However, this feature may also have some side

In 9i, initialization parameters Audit_trail only the None, DB, and OS three optional values, while in 10g Oracle added several new options. This article describes the XML options. Database version and default audit_trail parameter settings: Sql>

The previous article briefly describes the method for restoring statistics, which describes the relevant views and functions. In the previous article, it was mentioned that if you want to restore statistics, you must provide the timestamp of the

From 10g, Oracle can recover the wrong statistics. This article briefly describes the statistical information recovery feature. Inaccurate statistical information may lead to the inability to produce optimal execution plans, and for the most part,