Oracle

This article mainly introduces the Oracle database startup and shutdown methods, the need for friends can refer to the next First, start data$sqlplus "Sys/pass as SYSDBA"Sql>startup Second, start the listenerafter the database is started, if the

Data Guard offers two main services:1 Redo Transport service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby

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,

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,

What is an Oracle character set An Oracle character set is a collection of symbols that are interpreted by a byte of data, having a size and a mutual containment relationship. Oracle's support for the national language architecture allows you to

Comments: Oracle Table Space Recovery scheme includes user table space, temporary table space, system table space, rollback table space, control files and other recovery schemes, in which user table space and rollback table space, control file

Oracle database Export and re-import one, export database? 1 2 3 4 5 6 1, the database TEST completely exported, user name Scott password Tiger, exported to d:testdb.dmp: [plain] exp scott/tiger@test file=d:testdb.dmp full=y 2, To

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

Organize the inner join, left JOIN, right join,Two main tables: dept, EMPOne is the department, one is the employee table structure is as follows:These two tables dept is the primary table EMP is the child table, the associated column is deptnodept

--cmd Import and Export database BMP file　1. Execute the statement in the query result ( select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0 '2. Then execute cmd = = "Import: Imp admin/[email protected]

--The following are the related tablesSELECT * from V$lock;SELECT * from V$sqlarea;SELECT * from V$session;SELECT * from V$process;SELECT * from V$locked_object;SELECT * from All_objects;SELECT * from v$session_wait;--View the locked tableSelect

PS: The following are the most common basic management commands for Oracle 11g, including creating users, table spaces, permission assignments, and so on. The following commands I have verified the operation, and added my summary and instructions.1.

1.dbms is built on the operating system, so the operating system to be familiar with the operation, especially the server UNIX system-based, the general understanding of UNIX is not as good as windows, so need to learn.Common knowledge to learn:

Docker has strict requirements for installing the kernel version of the system, which is explained in Oracle Linux 6.5, and other systems are described in the following:https://docs.docker.com/v1.5/installation/Here's a quote from the official

This article mainly introduces TM lock in Oracle, understand that when we access the same table object in the database through SQL statements, if more than one user operates on the same table object, it may result in inconsistent data and data

Oracle on linux multiple servers can be installed with a single copy of multiple clones, simple and fast. ******************************************************* 1. Check if the following packages are installed ***************************************

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to

Tag:com    change    int    rollback    idle    Disk     server     own    serial    -1. --System parameter configuration connect Sys/[email protected]_link as SYSDBA select * from Dba_profiles where resource_name like ' failed_l　　Ogin_attempts% ';　　

After executing an SQL statement for the first time in Oracle, the SQL statement is parsed hard, and the execution plan and parse tree are cached in the shared pool. It is convenient to perform this SQL statement again without having to do hard

In the oracle10g and 11g versions, the ORACLE default log archive path is the Flashback recovery area ($ORACLE _base/flash_recovery_area). For this path, Oracle has a limitation, that is, the default is only 2G of space, and not just the default