Oracle

Select substr (V $ lock. Sid, 1, 4) "Sid ",Substr (username, 1, 12) "username ",Substr (object_name, 1,25) "objectname ",V $ lock. Type "locktype ",Decode (rtrim (substr (lmode, 1, 4 )),'2', 'row-s (SS) ', '3', 'row-X (SX )','4', 'share', '5','s/row-

Eg: Create materialized view mv_asset_query_countRefresh force on commitEnable query rewriteAsSelect count (T. sbbh)From pmsbi. f_sb_sbxx T, d_pm_company T1, pmsbi. d_bds T2, d_pm_asset_style T4, d_pm_zzc T5, d_pm_asset_type T6Where T. ssjdm =

24. query table space usage select. tablespace_name, round (. abytes/1024/1024) totalmb, round (. abytes-f. fbytes/1024/1024) usedmb, round (F. fbytes/1024/1024) freemb, (1-round (F. fbytes/. abytes, 2) * 100 "% used", round (F. fbytes/. abytes, 2) *

###### Analyze the log file logmnr ############## 1) in init. set utl_file_dir parameter in ora 2) Restart oracle3) create directory file DESC dbms_logmnr_d; dbms_logmnr_d.build; 4) add Log File Add/Remove log handler) Start

1) acess_info_null The exception corresponds to the ORA-06530 error code. When developing an object type application, you must initialize the object before referencing the object property. If the object property is directly referenced without

As shown in the following figure, Table A is an existing table in the database, and table B is the table to be copied and created based on table:   1. copy only the SQL statements of the Table Structure Create Table B as select * from a where 1

What can I do if I continue my experiment for 10 minutes today? I chose to introduce Oracle indexes. The results are as follows: Search for information from Google:1: 15 seconds. Read the overview section:3: 15 seconds. Oracle indexes mainly include

An error occurred while running an ocacle sqlldr (import data) command in Linux today.   Sqlldr username/password control = 'tbl _ EMP. CTL'   /Opt/Oracle/APP/Oracle/product/10.2.0/db_1/bin/sqlldr (Switch the user to a user in Oracle first)   1.

Oracle storage hierarchy Overview1) A database consists of one or more tablespaces.2) a tablespace consists of one or more files. The files that make up the tablespace can be various files in the file system, and the tablespace contains segments.3)

Start DatabaseIn.Use Oracle to install the user to log on to the host and start database and service listening. The operations are as follows:[Ora @ localhost ora] $ sqlplus "/As sysdba" SQL * Plus: release 9.2.0.4.0-production on Sun Mar 22 23:55:

Association is the most useful in Oracle Data Query. Flexible applications can solve many practical problems. The following are some examples: Create a tableCreate Table AB(AB _id number (5 ),AB _name varchar2 (30));Create Table bb(Bb_id number (5

KingSoft Antivirus online update module is an online anti-virus update module.The ActiveX control in the online upgrade module of KingSoft Antivirus improperly processes user-submitted parameter data. Remote attackers can exploit this vulnerability

OverviewEnabling the database to automatically start when the operating system starts makes database maintenance easier and more convenient.I have written an article "Oracle Auto Start and Stop in Linux (I)" http://blog.csdn.net/chenxiao#/archive/200

11. View the parameter information of a data table: Select partition_name, high_value, partition, tablespace_name, pct_free, upper, lower, max_trans, upper, next_extent, min_extent, max_extent, upper, freelists, lower, logging, buffer, num_rows,

1. Check the table space name and size. Select T. tablespace_name, round (sum (Bytes/(1024*1024), 0) ts_sizefrom dba_tablespaces T, dba_data_files dwhere T. tablespace_name = D. tablespace_namegroup by T. tablespace_name; 2. view the names and sizes

################## Managing password security and resources ################# ### alter user user_name account unlock/open; ---- lock/open the user; Alter user user_name password expire; --- set the Password Expiration/* set the password

-- Controlfile/* examplaestartup nomountcreate controlfile reuse Database "x201006" noresetlogs noarchivelog maxlogfiles 16 maxlogmembers 3 maxdatafiles 100 maxinstances 8 maxloghistory 292 logfile group 1 'd: \ oracle \ product \ 10.2.0 \ oradata \

######################### Enhanced Group by clause ######### ############### select [column,] group_function (column )... from table [Where condition] [group by [rollup] group_by_expression] [having having_expression]; [order by column]; -------

########## Managing Tables ############/* char type maxlen = 2000; varchar2 type maxlen = 4000 bytesrowid is an 18-bit 64-digit string (10 bytes 80 bits) consisting of rowids: Object # (object number) -- 32 bits, 6-bit rfile # (relative file number)

Can be downloaded here Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html   Decompress it to C:/oracleinstantclient1. Set Path = C:/oracleinstantclient2. Set tns_admin = C:/oracleinstantclient3. Create a