Oracle

(Transferred from: http://blog.csdn.net/marshalchen/article/details/6552103)SELECT * from User_tab_cols where column_name=upper (' xxxxx '); query which tables have a columnSelect status from User_objects where Object_name=upper ('

Overview under the Oracle installation directory $home/network/admin, you often see Sqlnet.ora Tnsnames.ora Listener.ora these three files, in addition to Tnsnames.ora, the other two files detailed use many people do not understand.The Sqlnet.ora is

Before giving you a specific introduction to Oracle Hints, let us first understand what Oracle Hints is and then fully introduce Oracle Hints, which I hope will be useful to you. The cost-based optimizer is very smart, and in most cases it chooses

In Oracle, sequence is the so-called serial number, each time it takes its own initiative to add, usually in order to be ordered by serial number place.1. Create SequenceYou first have to have create sequence or create any sequence

Creating temporary tables in Oracle stored proceduresDDL statements cannot be used directly in a stored procedure, so only dynamic SQL statements can be used to perform--on Commit Delete rows indicates that the staging table is a transaction

 1 start and end time of the fetch week The start time of the week is taken, beginning with Monday. Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' D ') + 1 ASA from DUAL;A-----------2013/11/25

Recently because of the upgrade of Mac OS X 10.10 Yosemite, suddenly a few days ago, a night, the boot found stuck in the start-up interface, it seems that beta is not reliable, and then think of themselves this is not a few days ago back up,

Select a.file_name,a.autoextensible,a.maxbytes,a.increment_by from Dba_data_files A;Whether the--autoextensible is automatically extended--maxbytes Max--increment_by number of auto-expansion blocksSql> Show Parameter Db_blockNAME TYPE VALUE----------

Normalization represents the process of removing data redundancy (redundancy) from your data store. If the database design is fully standardized, then all tables are concatenated with the keyword, and no copy of the data (repetition) occurs. The

Configure Oracle Environment It is recommended this user sets the specific environment for Oracle installation on ~/.bash_profile file prior to Instanc E creation. VI ~/.bash_profileCreate $Oracle _base, $ORACLE _home, $ORACLE _sid and append

Summary of how clients connect to Oracle DatabaseDirectoryJava program connections typically use jar-driven connections. ... 1Desktop GUI generally takes C language driver Oci.dll1Direct connection ... 1Indirect connection (need to configure TNS and

Sql> Select COUNT (*) from v$session #连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Show parameter processes Process: This parameter limits the number of operating system processes that can connect to the SGA (or the

--1. To view locked tablesSELECT p.spid, a.serial#, C.object_name, b.session_id, B.oracle_username,b.os_user_nameFrom V$process p, v$session A, v$locked_object B, all_objects cWHERE p.addr = a.paddrand a.process = b.processand c.object_id = b.object_

Oracle Data Import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import the DMP file from a local to a distant database

1. Pricemysql: cheap (partly free): Currently, MYSQL uses dual authorization (duallicensed), which is a commercial license agreement developed by the GPL and Mysqlab. If you use MySQL in a free (open source) project that follows the GPL, you can use

Rediscover Oracle's too-beautiful awr-related script for a brief introductionAs you know, under $oracle_home/rdbms/admin, there is a script (my environment is 11.2.0.4.2):[Email protected] ~]$ CD $ORACLE _home/rdbms/admin[Email protected] admin]$ ls-

SelectMsn. From_organization_code started the inventory organization,Msn. From_organization_name Start inventory name,Msn. To_organization_code End of inventory organization,Msn. To_organization_name End inventory name,Decode (MSN. intransit_type,1,

This blog introduces the installation process and simple configuration of Oracle data to help you simply run Oracle. It is just a basic tutorial.   Preparations: If you have installed an Oracle database before and want to change the installation

Oracle Database Compression When you hear this word, you must have thought of saving hard disk space. Yes, it is used to do this, but extending it out not only saves hard disk space, it can also save bandwidth and memory usage (cpu consumption is

-- 1. view the locked tableSELECT p. spid, a. serial #, c. object_name, B. session_id, B. oracle_username, B. OS _user_nameFROM v $ process p, v $ session a, v $ locked_object B, all_objects cWHERE p. addr = a. paddrAND a. process = B. processAND c.