Oracle

Oracle Database lock tables and unlock processes in Oracle Database Operations, we sometimes use lock table queries, unlock and kill processes, and so on. How can these operations be implemented? This article mainly introduces this part. The lock

Oracle rollback notes savepoint a1; -- set a storage Point a1; update tmp set username = 'zhangsan' where userid = '000000' -- modify a data savepoint a2; -- set a storage Point a1; update tmp set username = 'lily' where userid = '000000' -- modify

First, you must have a table! Create table example (ID Number (4) not null primary key, name varchar (25), phone varchar (10), address varchar (50); then, you need a custom sequence create sequence emp_sequence increment by 1 -- add several start

Oracle user-maneged recovery (3)Oracle user-maneged recovery (2) http://www.bkjia.com/database/201305/210502.html Full recovery: 3. recover the opened database (Database Failure Causes downtime). If a media or hardware failure causes the database to

Usage of rank () over (order by column name) [SQL] --- rank () over (order by column name sorting) results are discontinuous. If there are four people, three of them are tied for 1st, so the final sorting result is as follows: 1 1 1 4 [SQL] select

Method 1 for querying table field attributes in Oracle: search for all indexes in the table (including index names, types, and columns): select t. *, I. index_type from user_ind_columns t, user_indexes I where t. index_name = I. index_name and t.

Last_ddl_time the correct meaning of the test has always thought that the last_ddl_time is the ddl end time, but the actual results are not like this, the test results are very confusing. I was impressed with some of the items. -- Test results of

Relationship between Oracle Database Name and Oracle Instance name 1 Database Name 1.1 Concept Database Name db_name is a database ID, just like a person's ID card number. If multiple databases are installed on a machine, each database has a

Oracle initialization or shutdown in progress solution this year has been testing server migration issues, constantly creating tablespaces, creating databases, and creating users. After that, I thought that creating so many things would take up too

Oracle study note (4) Foreign key-create table major_ning (mid number (2) primary key, mname varchar2 (30) referenced in the master table (parent table )); -- from the table (sub-table), refer to the create table student_ning (id number (5) primary

Oracle 11g Undo tablespace switchover -- 1. view the undo tablespace currently used by the instance and the undo related parameters SQL> show parameter undo NAME TYPE VALUE =----------- export undo_management string AUTOundo_retention integer

Oracle global indexes and Local index tables can be partitioned by range, hash, list, and table partitions. After partitioning, the indexes on these indexes are different from those on normal tables, oracle has two types of indexes for Partitioned

STATSPACK installation and use 1. execute $ ORACLE_HOME/rdbms/admin/spcreate to install STATSPACK. SQL file. after statspack is installed, the perfstat user is created, and the system prompts you to enter the default and default tablespaces of

To set the remote connection and client access for Oracle to allow remote access for multiple users, perform the following settings: 1. Path: D: \ app \ Administrator \ product \ 11.1.0 \ db_1 \ NETWORK \ ADMIN \ listener. ora, set its content to

The usage of V $ PGA_TARGET_ADVICE Oracle 10g provides a series of Automatic Optimization suggestions, telling us how powerful The PGA allocation can bring The maximum performance to The system? The V $ PGA_TARGET_ADVICE view provides a good

On commit preserve rows define declarative global temporary tables each session has its own unique temporary table description. When the session ends, both the table row and the description of the temporary table are deleted. The following options

Oracle has been using racle to delete users and tablespaces for a long time, and many new users and tablespaces have been added. You need to clear the following commands for a single user and tablespace. Step 1: Delete userdrop user ×× cascade

IMP/EXP data migration (2) EXP/IMP data migration http://www.bkjia.com/database/201306/220928.html Exp: Based on the predicate phrase, export part of the table data. You can specify the partition: [lubinsu @ localhost orcl] $ exp lubinsu/lubinsu

EBS concurrency manager requests summary (Summary by concurrency consumed time, wait time, average wait event, etc.) This dataset is used to determine that the concurrent manager is in use, and can be allocated with the actual concurrency manager at

Upgrade 11.2.0.1 to 11.2.0.3 For rac on aix [plain] recently upgraded two systems For a bank. Here we will sort out the upgrade steps and precautions. [Plain] Preparation [plain] $ create pfile from spfile; $ select file_id, file_name from