Oracle

I saw a post on the itpub forum and summarized the Oracle Index classification in a concise manner. So I added it to my favorites. I have been reading RAC recently, and I just added a bit of reverse indexing. Logically:Single Column

  1. Poor connection managementEach time an application interacts with a database, the connection is opened and closed. This problem is often related to stateless middleware in the application server. It affects performance by more than two orders

On Windows, you can set a task to start some tasks at regular intervals, for example, once a week or once a day. I also saw a lot of applications write PL/SQL batch in Oracle, and then use Windows task to start these batch, which is quite tedious.

If only English software is used, character sets are rarely considered. However, if other languages are used, character sets must be considered. Otherwise, a lot of garbled characters may occur accidentally.   Many other software also has

In Oracle, due to some special characters, If we directly input these special characters in the input string, the SQL statement will be incorrect, here we will explain how to input the "&" character in Oracle.   The "&" character in Oracle

1. Obtain the values of 6th to 10th records in the table. 1.1 Method 1: Use the minus statementAssume that the DDL statement is as follows: Create Table T (ID varchar2 (4) primary key, value INT). The first method is to retrieve the first five and

I. Caught error exceptions 1: capture predefined error exceptions in the Oralce system. 2: capture custom error exceptions. Ii. Methods for capturing error exceptions In the Oralce database object. 1: Definition error variable User_Exception

Two different database servers read data from one user on one database server from another database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database. When creating dblink, you need to know the IP

When the database is an SQL Server, the Enterprise Library is very accessible. You can use the Enterprise Library Configuration tool to configure and then access the database in the code, however, it is not that convenient when data is replaced with

When Oracle checks the operating system compatibility, it does not pass the check. At this time, when we click "Next" for installation, it cannot be installed. The error message in the second picture is displayed, therefore, Oracle can only be

The content of the example export9.par is as follows: USERID = CTGPC/xuyunsheng @ ctgpcwebOWNER = CTGPCROWS = YINDEXES = YGRANTS = YCONSTRAINTS = YCONSISTENT = Y (Note: CONSISTENT indicates consistency. CONSISTENT = Y indicates that when multiple

Environment: RHEL 3, Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 SQL> connect sys/passwd @ db as sysdba;SQL> col name for a30SQL> col value $ for a30SQL> select name, value $ from props $ where name like '% NLS % ';Name value $--------

Installing oracle on the SLES-10 character Interface I read a post on the CU Forum Http://bbs.chinaunix.net/viewthr .. 1% 26 filter % 3 DdigestThe installation speed is too fast. A command is completed in two or three minutes. # Installing oracle

Create or replace and resolve java source named "J1"... Create or replace function f1(P1 in varchar2,P2 in varchar2) Return varchar2As language javaName 'j1. M1 (java. lang. String, java. lang. String) return java. lang. string '; Function call.

Oracle uses block technology to ensure the serializability of concurrent operations. Oracle locks fall into two categories: Data locks (also known as DML locks) and dictionary locks. Dictionary locks are used internally by Oracle DBMS to block

The recovery mechanism in Oracle also uses two technologies: dumping and registering log files. Oracle provides DBA with a variety of methods for dumping backup copies, such as file copying, using the Oracle Export utility, using the SQL command

1. The hosts file before installation L CAT/etc/hosts # Check the host's domain name resolution. In addition to 127.0.0.1, there are also host IP hostname entries. Otherwise, there may be no response during the installation process for a long time. 2

　 Preface In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of Oracle. One of the most effective

---- In Oracle databases, DBAs can observe tables or views to understand the current space usage and make possible adjustments. ---- 1. Free Space of the tablespace ---- By observing the free space of a table space, you can determine whether the

INITRANS, MAXTRANS, FREELISTS and freelist groups, PCTFREE and PCTUSED Mike AultJuly29th, 2004? The Automatic Segment Space Management features (bitmap freelists) is a wonderful features for most shops .? However, using ASSM in some high-DML