Oracle

Generally, the default port 1521 after Oracle is installed is used for security purposes. How to change.1. view the listening port:C: \ Documents ents and Settings \ mengzhaoliang> lsnrctl statusLSNRCTL for 32-bit Windows: Version

Vi Analyze_table.sh######################################## ######################################## ################## This for normal analyze, Added only after each step the following operations,# The default is 40% of the table, all indexes of

  1) SQL * Plus login. SQL File When you use SQL * PLUS to log on, SQL * PLUS reads and executes the script in the following order: · $ Oracle_home/sqlplus/admin/glogin. SQL · Login. SQL in the current directory, or set an environment variable

  There is an overhead space (overhead) at the beginning of the database block, which stores a transaction table for the block. For each "actual" transaction that locks some data in the block, there is a corresponding entry in this transaction table.

  1. Modify the font of jdk. [Oracle @ dbserver db_1] $ cd $ ORACLE_HOME/jdk/jre/lib/ [Oracle @ dbserver lib] $ mv font. properties font. properties_bak [Oracle @ racdbserver lib] $ [Oracle @ dbserver lib] $ cp font. properties. zh_CN.Redhat font.

  The ORA-28000: the account is locked error appears in the Oracle database log, which can be handled as follows:     1. query the default value of the FAILED_LOGIN_ATTEMPTS parameter. This parameter limits the number of consecutive logon failures

Flash back with SQL * Plus. 1. Shut down the database. SQL> shutdown abort;   2. Start the database to the Mount mode. SQL> startup mount;   3. Data flash back. SQL> recover database until time '2017-11-20: 07: 00: 00 '; (Another available

  In the Where clause, you can use the Like clause with wildcards to select columns of the datetime, char, and varchar field types... "Data records. The following are available wildcard characters: % Zero or multiple characters _ Any single

  Note:     Install oracle10g in ubuntu10.04. The main step is to configure the oracle runtime environment. The installation is a simple statement.   This is the oracle I installed, the ubuntu dual-system installed under Windows, with 2 GB memory.

Oracle transactions and locks 1. transaction concept: a transaction is used to ensure data consistency. It consists of a group of related dml (data operation language [add, delete, modify]) statements. The dml statements of this group are either all

Use the dbms_file_transfer package to copy files between asm and the file system. Use the dbms_file_transfer package to copy files between asm and the file system. SQL> create directory dgb AS '+ DATA/dbfiles'; SQL> CREATE DIRECTORY loc AS

Oracle Study Notes (1) -- oracle recursive queryFirst of all, we mentioned that connect by is used for Recursive queries. It is to traverse the link of the recursive application designed by the table structure in the database to meet our

RAC 11.2.0.4 installation encountered INS-06001 to solve the problem of installing grid software 11.2.0.4 today. When configuring passwordless SSH, click setup to see this error and start searching online. Everything is said, System bugs, and so on,

Oracle FAQ (1)01. How can I view oracle version information?02. How can I view the transaction information locked by the system?03. How to obtain which users are using the database?04. What is the maximum number of fields in the data table?The

Oracle flashback drop knowledge sorting 1) No downtime or backup is required. 2) You do not need to configure it. you can disable it through permissions. 3) Only data in non-SYSTEM tablespace managed locally (non-dictionary management) will enter

How to delete. the trc file bdump contains the alert file, and trace fileudump of some background processes. Generally, the trace file cdump of session after SQL trace is placed. Generally, some core trace files are placed. adump is generally audit

Cast (,) CAST, a data type conversion function in Oracle, explicitly converts a data type expression to another data type. Syntax: CAST (expression AS data_type) CAST (ytd_sales AS char (20) Example: declare @ I intset @ I = 0 while @ I   Create

DBA classic interview questions (3) the answers here are not very comprehensive. These questions can be explained from multiple perspectives. Maybe you do not have to give full and detailed answers during the interview, you only need to answer your

Detailed description of Timestamp type BC and post-numeric values in Oracle and PostgreSQL and JDBC access field: datevalue1: 2010-01-01value2: 2010-01-01BC1. when inserting a value directly into the database: oracle needs to use to_timestamp ('1970-

Restart Oracle 11g RAC record the process of restarting Oracle ========================== Node 1 (oracle user) 1. lsnrctl stop // close listener 2. sqlplus/nolog // close database connect/as sysdba shutdown immedidate Node 2 (oracle user) 1. lsnrctl