Oracle

Unix/linux topic: 1. How to view host CPU, memory, IP and disk space? cat /proc/cpuinfocat /proc/meminfoifconfig –afdisk–l2. What are your common process management and host Performance view commands?Ps–efIostat3. Set up DBA and reorganize user

A transaction is a logical unit of work used to split a database activity, where the transaction has a starting point and an end point;When one of the following events occurs, the transaction begins: Connected to the database and executed

Quoted http://blog.csdn.net/lejuo/article/details/4479065The ID is automatically incremented, just like when you create a table in Ms-sql server, the primary key for the table is set to auto-increment.In Oracle, the following SQL statements are

1. Wait for the monitor case Select Event,sum (Decode (wait_time,0,0,1)) "Prev", Sum (Decode (wait_time,0,1,0)) "Curr", COUNT (*) "Tot" From V$session_wait Group BY event order by 4;Note: ORDER by 4 refers to sort by 4th column2. Race Conditions

Oracle optimization of database memory parametersØ Oracle -related system kernel parameters Ø SGA,PGA parameter setting Oracle lower disk storage performance OptimizationØ File System selection (ext2/ext3,xfs,ocfs2) Ø Oracle ASM storage 1. What

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

"Cause/Trigger factor" This is due to the fact that "password_life_time=180 days" is set in the default profile in oracle11g. "Impact and risk" Effect After the password expires, the business process connects to the database exception, affecting

1. What is NULL?Null represents Unknow (unknown), which does not represent any value. For example, a column in a row has no value and is null.Oracle allows fields of any one data type to be empty, except for the following two scenarios:1) Primary

When the data in the table is deleted, it does not actually delete the data, but instead hits a delete tag, which can be restored as long as it has not been overwritten. The experimental process is as follows:[Email protected]>create table bbed_test

This is an Oracle's column change function: Listagg ()Look at the sample code first:With temp as ( select ' China ' Nation, ' Guangzhou ' to dual union ALL Select ' China ' Nation, ' Shanghai ' city F ROM Dual UNION All Select ' China ' Nation, '

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

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

Oracle 11g-Network ConfigurationWhen we finish installing Oracle, we need a network connection, which of course requires two things: the server and the client. Through the configuration of the two we can achieve network connectivity. So, how do we

/*The following code is the display width setting for the EMP table*/Col empno for 9999;Col ename for A10;Col job for A10;Col Mgr for 9999;Col hiredate for A12;Col Sal for 9999;Col Comm for 9999;Col deptno for 99;Col tname for A12;Set pagesize 50;//-

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,

Statement:This is not a technical document, since a few strokes of Oracle's simple moves, can not endure in front of people show off a few. Pure for the gossip and a few friends of the gag, only for easy with a hint of humor, it technology can also

This article introduces the import and export of Oracle Data imp and exp commands, and describes the corresponding parameters. Drills to deepen understanding. At last, the article discusses the problems that may occur when using these two commands

Some time ago, I helped a friend recover a damaged dmp file, which is more than 100 Gb. I recorded the recovery process and briefly summarized it.I. DescriptionThis dmp file is exp from an Oracle 9i Database. Two types of errors may occur randomly

-- 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.

Problem: For system version reasons, the client can only install 32-bit Timesten, but the client platform is 64-bit win 7, after the installation is complete, follow the conventional control panel-> Administrative Tools-> data source (ODBC) Open