Oracle

1--first look at which locks are2 Select /*+ Rule*/S.username,3Decode (L.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL) Lock_level,4 O.owner,5 O.object_name,6 O.object_type,7 s.sid,s.serial#,8 s.terminal,9 S.machine,Ten S.program, One S.osuser A

Manually Brush Oracle StatisticsSelect COUNT (1) from Log_trx_detail;SELECT * FROM user_tab_statistics WHERE table_name = ' log_trx_detail ';exec dbms_stats.gather_table_stats (' Ardb ', ' acct_balance ', cascade = TRUE);exec dbms_stats.gather_table_

Recently the Department of testing staff found a problem, said the Oracle user password prompt to expire, ask me what happened?The discovery found that the Oracle user password is only valid for 180 days, communicating with the responsible person

First, the functionFunctions are stored as database objects in an Oracle database, and functions are called PL/SQL subroutines. Oracle processing uses system-provided functions, and users can define their own functions. A function is usually called

Master key constraint, FOREIGN KEY constraint, uniqueness constraint, check constraint, default value constraint-—————— five constraintsFirst, the primary key constraint;--Create a PRIMARY KEY constraint for the tableCREATE TABLE Student (student_id

CREATE OR REPLACE FUNCTION f_pinyin (p_name in VARCHAR2) RETURN VARCHAR2 as V_compare VARCHAR2 (100);V_return VARCHAR2 (4000);FUNCTION F_nlssort (P_word in VARCHAR2) return VARCHAR2 as BEGIN return Nlssort (P_word, ' Nls_sort=schinese_pinyin_m

 sql>set Colsep '; -The field output delimiter.  sql>set Term {on| OFF}; On: The query results are displayed both in the spool file and in the Sqlplus;  off: The query results are displayed only in the spool file. Sql>set Echo {on| OFF}; Sets

Attention:Host name needs to be checked and the Hosts file modifiedCheck the size of the system table space. If the system does not scale automatically. Need to add data files or modify ask auto-extensionLsnrctl's check (this step I took a long time

Concept:The logical structure of Oracle can generally be divided into:table Spaces (tablespace), segments (segment), zones (extent), data blocks. Oracle consists of table spaces, which consist of segments, segments composed of blocks, and extents

Create tablespace user3 datafile ' e:\test\user3_data.dbf ' size 20M--Table space Initial Size: 20MAutoextend on next 5M maxsize 50M--auto-grow and 5M per expansion, table space Max is 50M--View table Space storage path and informationSELECT * FROM

Two different database servers, one user from one database server, reads data from a user under another database server, which can use Dblink.In fact, Dblink and the database in the same view, build dblink need to know the IP address of the database

Usage of Aggregate functions count, max, min, sum, avg, and NVL in oracleUsage of Aggregate functions count, max, min, sum, avg, and NVL in oracle The grouping function aggregate function performs computation on a column in a group of rows and

Oracle installation and configuration process I had to install oracle myself for the first time. I had no idea about oracle installation and configuration before, and finally finished it. 1. Install the oracle10g Server 2. Install the oracle10g

How to export a table as a txt file in oracle This article lists several methods to export data from an oracle table to a txt file. Currently, only three methods are listed. If better methods are found later, they will be added continuously. 1. In

Oracle cannot import empty table Solution Oracle cannot import empty tables C: \ Users \ Administrator> sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Sunday August 17 19:24:29 2014 Copyright (c) 1982,201 0, Oracle. All rights

Solving ORA-28000: theaccountislocked In oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the account is locked. This

OR causes Cartesian Product Recently, I monitored the database and found that the following statement ran very slowly. The original execution plan went through, resulting in Cartesian Product. Let's look at the following statement:   SQL> explain

Full-text index-custom chinese_lexer dictionary, Full-text index its data dictionary is originally its own encrypted data format. It can be modified only after it is translated. After this modification, generate its own data format file, overwrite

One of the most comprehensive oracle tablespace query and maintenance commands (data table space) in history A tablespace is the logical division of a database. A tablespace can belong to only one database. All database objects are stored in the

Oracle Chinese garbled solution summary, oracle garbled Solution AMERICAN_AMERICA.WE8ISO8859P1, this character encoding is the Western European character encoding, corresponding to. Net is the iso-8859-1 character encoding, so only need to change to