Oracle

How does an Oracle database view information about a partitioned table? I wonder if you have summed up this knowledge. Here we create two table test, GPRS_CELLTOPVOL_WK to do the experiment, the script is as follows: CREATE TABLE Gprs_celltopvol_wk

Use of case, simple case functionA simple case expression that uses an expression to determine the return value. Grammar: Case Search_expression When Expression1 THEN RESULT1 When Expression2 THEN result2 ... When Expressionn THEN Resultn

First, users View the default table space for the current user Sql>select username,default_tablespace from User_users; View the role of the current user Sql>select * from User_role_privs; View system and table-level permissions for the current

When diagnosing a problem with a lock, check with the holder, the person who is blocked. Often is very troublesome, if you do not accumulate the script, rely on Manual Check to check a lot of tables, such as V$lock,v$process p, v$session s,

According to ORACLE10G's characteristics, when I execute the drop table or delete all, Oracle places the deleted table or data record in the database Recycle Bin (db RecycleBin). So we can use the Flashback Table command to recover the deleted table

Create or replace procedure test_table is L_table_name VARCHAR2 (50); Query_stat varchar2 (100); L_zyq T_djjcxx.zyq%type; L_jh varchar2 (20); L_djjcxx T_djjcxx%rowtype; Begin L_JH: = ' 7874 '; Select name into L_table_name from Testa;

Recently saw a lot of people talk about TNS or database can not log in and so on, simply summed up the following dongdong. First of all, Oracle's network structure, to complex to say can add encryption, LDAP and so on. There is no discussion here,

1. Choose the appropriate Oracle Optimizer There are 3 Oracle optimizer types: A. Rule (rule-based) B. Cost (based on costs) c. CHOOSE (optional). Set the default optimizer to pass various declarations of optimizer_mode parameters in the Init.ora

Oracle databases have three standard backup methods, namely, export/import (EXP/IMP), hot and cold backup. Exporting spare parts is a logical backup, and cold and hot backups are physical backups. First, export/import (Export/import) Export can be

Oracle Data Guard Create a physical standby database Create a physical repository Machine name A1 A2 ip:192.168.1.10 192.168.1.20 Net_name A1 A2 SID A1 A2 Db_unique_name A1 A2 Note: Create the database A1 on the master node, install only

Oracle Monitoring Index UsageOracle provides a way to monitor indexes to determine if the index is being used. If the indexes are not used, you can delete them to reduce the overhead of unnecessary statements. Because of the large number of

Oracle 11g Installation Photo GuideOh, spent one hours, around the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to

Read Catalogue 1.Oracle (Regular expression) Brief introduction 2.Oracle Regular special characters 3.Oracle Regular character clusters 4. Operation priority for various operators 5. Simulation Test examples 6.Oracle

Http://d.hatena.ne.jp/yohei-a/20100515/1273954199dtraceでoracle databaseのサーバー?プロセスをトレースしてみたOracle, Mac2010-03-22-Future のいつか/hyoshiokの Day102th back カーネル Reading book will occupies line ってきて, Dtraceを make ってみようと think ってもう2ケ month near くすぎた.やっと makes

Buffer busy waits (Hot block contention)Website Explanation:This wait indicates that there is some buffers in the buffer cache that multiple processes is attempting to access C oncurrently. Query V$waitstat for the wait statistics for each class of

DB file Scattered readWebsite Explanation:This event signifies, the user process is reading buffers to the SGA buffer cache and is waiting for a physical I/O call to return. A db file scattered read issues a scattered read to read the data into

Oracle has its own Dblink function, which is to logically treat multiple Oracle databases as a single database, meaning that objects in another database can be manipulated in one database, for example, we create a new data database1, We need to

I. Oracle LOG classificationThere are three main categories: Alert log files--alarm logs, Trace files--trace logs (user and process), andRedo log Redo logs (records database changes).This article focuses on Oracle's redo logs.Redo logs are divided

Database written interview question Bank (Oracle, MySQL, etc.)⊙"DB written interview 67" in Oracle, about table partitioning the following description is incorrect ()⊙"DB written interview 65" in Oracle, which table partitioning method suggests a

The database dictionary generation tool that was previously found relies largely on office Com components and cannot be used without office installed. Anger, so I wrote one in C #.Features are as follows:I. Supported databases MS SQL Server 2005+,