Oracle

1. Account Lockout Failed_login_attempts: Used to specify the maximum number of failed consecutive logons. Password_lock_time: Used to specify the number of days the account is locked. 03:34:13 sql> Create profile Lock_account limit 03:36:51 2

The whole process of connection 1. A. Client: (1) A-->b initiates the connection (9) interacts with the server process to complete the connection 2, B. Listening process: (2) b-->c fork Process and wait (7) B-->d Transfer Client Information 3,

First, ensure Oracle installation succeeds and start Oracle service Installation method for details: http://showerlee.blog.51cto.com/2047005/1118568 Oracle users use Sqlplus to log in to Oracle database backend Sqlplus sys/123456 as Sysdba 1,

1. In Oracle, the data table alias cannot be added as. Such as: Select A.appname from AppInfo a;--correct Select A.appname from appinfo as a;--error Perhaps, is afraid and Oracle in the stored procedure in the key word as conflict problem bar 2.

Objective Oracle provides several packages that can be used to accomplish many tasks, from internal process communication to file I/O, to dynamically create and execute SQL statements in Pl/sql blocks. All of these packages are owned by the SYS

--View the current library file location Sql> select name from V$datafile 2 Union 3 Select member from V$logfile 4 Union 5 Select name from V$controlfile 6 Union 7 select name from V$tempfile; NAME -------------------------------------------

Many users in a database instance of the Redo01~03.log three redo log deleted, there will be no normal landing database phenomenon, the following example is the specific recovery process, hoping to solve the problem for everyone: One: c:/>sqlplus /

1. The statements that have been validated are exactly the same as those already in the shared pool 2. Variable names as consistent as possible 3. Rational use of outer joins 4. Use fewer layers of nesting 5. Multi-use concurrency The

As we all know, the quality of database design is directly related to the efficiency of database operation. According to the author's experience, to enhance the database performance, reasonable database design, than upgrade the server hardware

HINT is often used in SQL statement optimization, so let's take a look at the 30 uses of "HINT" in Oracle during the SQL optimization process: 1./*+all_rows*/ It is shown that the cost-based optimization method is chosen for the statement block,

1. Original table structure information 06:49:50 sql> Analyze table EMP1 compute statistics; Table analyzed. 06:50:00 sql> Select Table_name,blocks,empty_blocks,num_rows from User_tables 06:50:18 2 where table_name= ' EMP1 '; TABLE_NAME BLOCKS

1, delete Column 03:44:40 sql> CREATE TABLE test as SELECT * from EMP; Table created. 03:45:06 sql> desc test; Name Null Type ----------------------------------------------------------------------  -------- ----------------- EMPNO Number (4)

Create or Replace package Pg_encrypt_decryptIsIkey VARCHAR2 (8): = ' oracle9i ';function Gen_raw_key (Ikey in varchar2) return RAW;function Decrypt_3key_mode (ivalue in Raw,imode on Pls_integer) return varchar2;function Encrypt_3key_mode (ivalue in

V$session + v$session_wait (in 10g function is integrated, make up 1.) V$process V$sql V$sqltext V$BH (preferring to be x$bh) V$lock V$latch_children V$sysstat V$system_event Several groups of important performance views by component 1.

It is time-consuming to perform data manipulation language (DML) in a pl/sql loop because each loop is diverted from the Pl/sql engine to the SQL engine. Applying ForAll is a better way to submit a set of temporary values to a SQL statement at a one-

1 indexes in SQL Server An index is a disk structure that is associated with a table or view to speed up the retrieval of rows from a table or view. An index contains keys that are generated by one or more columns in a table or view. These keys are

In a RAC environment, logging into an instance can result in a GC global wait generation when the data being processed is completely unrelated to the data in the other instance's memory. This article describes the performance impact. The previous

The Rman Page command allows users to determine the current recoverable state of the database and to provide specific information about the database backup. 1. Specify data files that have not been backed up recently The query does not have a

AWR snap generation, not necessarily to generate reports on the original database, you can use AWR provided by the export, import functions, the AWR data migration to the test database for further analysis. AWR's export is not complicated, and

AWR snap generation, not necessarily to generate reports on the original database, you can use AWR provided by the export, import functions, the AWR data migration to the test database for further analysis. By copying the DMP file exported from the