Oracle

First, view the user index in the system table In Oracle, the system table is created automatically when the database is installed, containing all of the database's data dictionaries, the definitions of stored procedures, packages, functions, and

(1) Establish B*tree index 3:11:08 sql>create index Emp1_job_ind on EMP1 (Job); (2) Analysis of index structure 3:11:08 sql> ANALYZE INDEX emp1_job_ind VALIDATE STRUCTURE; Index analyzed. (3) View Index storage information 03:11:41 sql> SELECT

1, Redo Log Buffer Redo Log Buffer is a cache of database modification information stored in the SGA. This information is stored in the Redo entry (Redo Entry). The redo entry contains the necessary information to rearrange or redo the database

1. Concept (1) User: User (account) is a name defined in the database. (2) Privileged User: A privileged user is a database user with special permissions (SYSDBA or Sysoper). SYSDBA automatically has all the privileges of the DBA role, while

# Legal Oracle Identification symbol 1, cannot be reserved keyword 2, must use 1 to 30 characters. The name of the database is up to 8 characters. 3, must start with the letter character in the database character set 4. Can only contain

If you use the Oracle default creation method when you create a foreign key constraint, it cannot be deleted when the referenced data is deleted, which gives us more flexibility in oracle9i, but we use on DELETE cascade and on delete set Null

This article describes in detail the Oracle 11G failure to connect to the database instance troubleshooting ORACLE 11G If the report--enterprise Manager is unable to connect to the database instance, you can troubleshoot the problem by following

In the process of using Oracle, we will often encounter some Oracle errors, this article analyzes the use of the more frequent error code one by one, hoping to help you find a reasonable way to solve these errors, but also hope you can put forward

In order to achieve maximum performance, the general database has concurrent mechanism, but the problem is the conflict of data access. To solve this problem, most databases use the method of data locking. Data locking is divided into two methods,

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

In Oracle 9i, data can be easily exported to a file or imported from a file. With Oracle's Management Server (Oracle Management server,oms) can be easily implemented, there are many places to explain the entire operation, but the complete guidance

Oracle is always different for advanced features (I hate this, if it's a product that needs to be programmed specifically for this product, and that's why I never looked at a platform like WebLogic), the big object access is set to use its own LOB

We know that user-owned role permissions are not available in stored procedures. Such as: 　　SQL> select * from dba_role_privs where grantee='SUK';　　GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE------------ ------------SUK DBA NO YESSUK CONNECT NO

select * from test..TEST.TEST1 Server: Message 7356, Level 16, State 1, line 1 OLE DB provider ' oraoledb.oracle ' provides inconsistent metadata for the column. Meta data information was changed while executing. OLE DB Error Tracking

Import java.sql.Connection;Import Oracle.jdbc.pool.OracleConnectionCacheImpl; /*** Connection Pool Management class*/public class Dbpool { /** Connection Pool * *private static Oracleconnectioncacheimpl pool = null; /*** Initialize Connection

Looking at the optimized document, it is found that the hint of the specified index can also be column-style. In 9i and previous versions, the index hint format is/*+ index (table_alias) * * * or/*+ index (table_alias index_name) * *, but in 10g it

In general, the automatic management of standby database file files is used, but sometimes manual management, such as the standby database using bare devices. Look at an example: Sql> select Name, Open_mode, Database_role, Db_unique_name 2 from V$

In the actual production environment we may need to quickly replicate the existing database, also hope that the new library and the original library is not the same name, or we need to replicate the production library to do research and development

Oracle's Range,hash,list three major partitions Maybe we're all familiar with it, but what each partition applies to what scenario may be a lot of people's puzzles, what should be noted when choosing a different partition, why, and what needs to be

The previous article describes how to migrate AWR data, which describes how to delete snapshot data that you no longer need. For the current database-generated snapshot, no manual processing is required, and Oracle automatically deletes expired