Oracle

Test the use of indexes for select statements in Oracle -- I have read many articles on SQL Optimization in Oracle and introduced a lot of cases where indexes are not used. I tested some cases when I was free today. -- Test Data create table EMP

Install sqlplus and shell in Linux to query the database and download the rpm file, install orcacle sqlplus Java code rpm-ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm rpm-ivh oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm after installation

In-depth understanding of Oracle partitions (1): How to implement and evaluate partitionsAlthough this blog post aims to guide everyone in how to create partitions in the production environmentBut never be bound by some so-called Design Guides,

How to reconfigure the redo log location 1. shut down database shutdown2. use the OS command to copy redo log files to the new location mv/u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b _. log/home/o1_mf_000089y70t1b_test.log3. start the

Rac10201 for RHEL5 Checking existence of VIP node application (required) Check failed solve today this 10201 for rhel5 is really killing me last step oracle cluster verfication utilityChecking existence of VIP node application (required) check

Listener error handling 1: Host Name and IP misplacement error message: [plain] [oracle @ odd ~] $ Lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0-Production on 01-MAY-2013 15:40:54 Copyright (c) 1991,200 5, Oracle. all rights reserved.

Use note amdu to recover from a hard disk fault database is a free tool provided in Oracle 11g. It is used to analyze the metadata of the ASM disk group and extract data files from an unmounted disk group. NOTE: 553639.1 Placeholder for AMDU

Oracle wait event-1. Knowledge about waiting events 1. The concept of waiting events from the source is introduced from ORACLE 7.0.12, with approximately 100 waiting events. In ORACLE 8.0, this number has increased to approximately 150, with

Oracle rac ssh equivalence configuration (I). To facilitate communications between nodes in the RAC environment, you must configure the SSH equivalence statement: when a user or program is connected from one machine to another without a password,

Oracle share serverI attended training with my colleagues today and mentioned this part. I will review it here.This block is different from the connection pool in PG. pgpool, pgbounce, and pgbouncer are lightweight connection pools, which are small

Change the location of data files in multiple tablespaces 1. the database is in the mounted state: Optionally, the database does not have to be closed, but the datafiles (or tempfiles) must be offline. 2. use the OS command copy and rename the

Oracle rowid and postgresql ctid first introduces oracle rowid, the physical identification SQL> select rowid from book_info where rownum select dbms_rowid.rowid_object (rowid) object _ Id, struct (rowid) file_id, dbms_rowid.rowid_block_number

Oracle backup recovery overview introduces that backup recovery is an important technology of oracle. Of course, we 'd better not use this technology, just as we do not need to go to the hospital. When you open the database, oracle compares the

Watch the Oracle video note of Shang xuetang 1. go to sqlplus: Method 1.c:\ Users \ Dell> sqlplus sys/sys as sysdba; method 2.C: \ Users \ Dell> sqlplus/nolog/* Start sqlplus */SQL> connect sys/sys as sysdba; /* connect to the database */method 3.C:

Dataguard Online redo log and Standby redo log Dataguard classification: Physical Standby (Redo Apply) Logical Standby (SQL Apply) Dataguard protection mode: maximize performance (maximum performance mode) maximize availability (maximum available

The entire process from software installation to running in Oracle 1. When the software is just installed, there is only a bunch of software, and no database-related files and content are generated. 2. sqlplus/nolog connects to the database software

Some problems with importing data from oracle11g to oracle9i when exporting the dmp file from oracle11 and then importing data to oracle9i, there are many errors. To sum up: Problem 1: solution: log in AS sys in the 11g database and modify the

All about oracle smallfile and bigfile tablespace Oracle Tablespace tablespace is the highest level of the logical structure, and others correspond to segment object segment, partition extent, and block respectively. The Oracle database on the

New Feature of Oracle 11g R2: Deferred Segment Generation when you install an application that contains thousands of tables and indexes, if each table and index are initially allocated a 10 MB initial extent. You will soon realize that if each

Oracle trigger (1): Generally, trigger is similar to procedure and function, but it cannot be displayed and called. It can only be triggered by an event and then automatically called by oracle. generally, you can create a trigger for a table or view