Oracle

Two consecutive companies as a foreign staff to the client side work, lack of sense of belonging at the same time, the database technology love is my only consolation, after all, this is their favorite thing, but also can do.Because of the needs of

This article lists only simple action statements for indexes, triggers, and views1. IndexA. CreateCreate INDEX Idx_name on fdh_client_info (name); --General index (single row index)Create unique index uni_idx_id on fdh_client (ID); --Unique

Link Address:http://www.jydba.net/aix-filesystemcache%e5%bc%95%e5%8f%91%e7%9a%84oracle%e4%ba%8b%e6%95%85/AIX uses the free physical memory as a file system cache to improve the system IO capability, and the default parameter can use 90% of physical

OracleBoot auto StartThe database and the Tomcat program need to be started automatically when the server shuts down the rebootOracle Database self-bootingThe Oracle database comes with a self-launching script that can be modified to useVim $ORACLE _

OracleBoot auto StartThe database and the Tomcat program need to be started automatically when the server shuts down the rebootOracle Database self-bootingThe Oracle database comes with a self-launching script that can be modified to useVim $ORACLE _

SGA (System global Area). This is a very large memory range and why it takes a lot of memory to start Oracle.The SGA is divided into different pools, which we can view v$sgastat by view, as shown below.sql> Select Pool, sum (bytes) bytes from

--Query Lock tableSelect Sess.sid, sess.serial#, Lo.oracle_username, Lo.os_user_name, Ao.object_name, Ao.objec   T_type, Lo.locked_mode, ao.status from V$locked_object Lo, dba_objects ao, v$session sess where ao.object_id = lo.object_id and

1. Create normal table spaces and usersCreate a temporary table spaceCreate temporary tablespace oa_tempTempfile ' D:\app\Administrator\oradata\orcldjoa_temp.dbf 'Size 32mAutoextend onNext 32m MaxSize 20480mExtent management Local;Create a data

package Javaapplication2;import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.resultset;import Java.sql.sqlexception;import java.sql.PreparedStatement; public class JavaApplication2 {public static void main (string[] args) throws

1. Create a temporary table spaceCREATE temporary tablespace test_temptempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf ' SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;2. Create a user table spaceCREATE tablespace

The concept of Locks A lock is a mechanism that a database uses to control concurrent access to shared resources. Locks are used to protect data that is being modified No other user can update the data until the transaction is

SQL codeSelect from T_menu_item t;Ten CLARKTen KINGTen MILLERADAMSFORDJONESSCOTTSMITHALLENBLAKEJAMESMARTINTURNERWARD--------------------------------We pass the Wmsys provided by 10g. Wm_concat function to complete row-to-column effectsSQL

First, the Database system architecture:The outer layer (External level) is provided to the user for direct operationThe concept layer (conceptual level) is used to describe the types of data stored in the database, the relationships between tables,

Install the Oracle database in Linux Http://download.csdn.net/detail/jaune161/9312775 (PDF) Note Because there are too many images, only the main part is written in this article. For installation steps and subsequent settings, see PDF.This

Oracle rman catalog backup and recovery1. the loss control file starts the database to the nomount status: restore controlfile from autobackup/restore controlfile from '+ data/backup/contrlbak /... '-> alter database mount-> open; 2. accidentally

ORACLE lag () and lead () FunctionsI. Introduction lag and lead functions are two analysis functions related to offset. The two functions can be used to retrieve the data of the first N rows of the same field in a query (lag) and the next N rows of

Three methods for connecting Java JDBC Thin Driver to Oracle (reproduced), jdbcthin1. JDBC connection to Oracle An error occurred while connecting JDBC applications to Oracle: ORA-12505, TNS: listener does not currently know of SID given in connect

Obtain the first day of the month, the last day of the year, and the last day of the month based on the accounting period. Simply record it to avoid forgetting: DECLARE V_PERIOD_BEGIN_DATE DATE; V_PERIOD_END_DATE DATE; 1_date; V_PERIOD_NAME

Oracle study notes seven locks, oracle Study NotesLock Concept A lock is a mechanism used by a database to control concurrent access to shared resources. The lock is used to protect the data being modified. Other users can update the data only

Create the PLUSTRACE role in the SQL * Plus environment. Common users encounter a SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled error when enabling AUTOTRACE reports in SQL * Plus. As follows: SQL> SQL> set autotrace