Oracle

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. 1. Sqlnet.ora is used on

This article to you to explain the Latch mechanism of Oracle , Latch, with PowerWord translation is the door plug, blocking, professional terminology called latch , I began to contact when I do not understand why not write lock, not all locks? It's

1. Monitor whether the index is usedIn addition to the primary key being an integrity constraint and automatically becoming indexed, the purpose of creating a normal index is to improve the query speed, and if we create indexes that are not used,

1, do not use ' * ' instead of all column names, especially if the field is more than the caseUse SELECT * To list all column names for a table, but there is a dynamic parsing problem with Oracle. The Oracle system translates ' * ' into all column

ASH (Active Session history)Ash is based on v$session, sampling once per second, recording events waiting for an active session. Inactive sessions are not sampled, and sampling work is done by the newly introduced background process MMNL. The

Number can be an integer, or it can be a decimal action item with a decimal point: A (number (18,2)), B (number (18,2)),+ add)1. If the action item has a null, the add result is null, a+null= Null2. Correct notation: NVL (a,0) +NVL (b,0) sum sumand

The name explanation in OracleDb_name database nameThe database name is an identifier for the entire database and cannot be more than 8 charactersThere is no default value and cannot be changed. In Oracle RAC, you must set this parameter for each

Grant SELECT on Yizhen123.tpp_t_dz_liandong to Wangyd;Grant SELECT on Yizhen123.tpp_t_dz_yilian to Wangyd;Grant SELECT on Yizhen123.tpp_t_dz_yinglian to Wangyd;Grant update on Yizhen123.tpp_t_dz_liandong to Wangyd;Grant update on

Enter cmd-->SqlplusSysAs SysdbaTo delete a table space:DROP tablespace tseve_data including CONTENTS and datafiles;To create a table space:Create Tablespace Tseve_dataLoggingDataFile ' D:\allworkplace\oracleWS\TSEVE_DATA.dbf 'Size 50mAutoextend

Sqlplus-s/As SysdbaSet Trimspool onSet Linesize 10000Set pagesize 50000Set heading onSet term offSet heading onSet feedback off;Set NEWP none;Set echo offSet markup HTML onSpool onSpool Xj.xls--Table Space usage query:Select

1 Enabling a set listenerThe listener name is taken as "LDJ", configuring the listening address, listening service has two "orcl.com, Weina". 650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M02/72/DC/wKioL1Xu6cLB11dLAADFzacN-jQ580.jpg " Style=

PublicListCREATEZTREEDEP (String compid) {List DD =NewArraylist(); Find SQL statements for all child departmentsString SQL = "Select Dep_id,dep_name,super_id,folder from Td_department" + "Start with super_id in (" + "Select dep_id from Td_department"

I. Naming rules for table and column names1), must start with a letter2), length cannot exceed 30 characters3), cannot use Oracle's reserved words4), can only use the following characters a-z,a-z,0-9,$, #等Ii. Types of data1), character classChar has

Oracle Connect by usageExperiment with the EMP table from the Scott user first.EMP table has a field, one is Empno (employee number), the other is MGR (higher manager number)Here is all the data in the table1SELECT * from emp start with empno=7698

1. Single Grouping function650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/72/F2/wKiom1XwLKPAAOrjAAB9Ym73cYI651.jpg "style=" float: none; "title=" 2015-09-09_204103.png "alt=" Wkiom1xwlkpaaorjaab9ym73cyi651.jpg "/>650) this.width=650;

A lot of the time, we do Oracle DBA, when the application administrator informs us that now the application is very slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, some time we

Excerpt from: http://www.linuxidc.com/Linux/2012-07/66288.htm1thDual is not an abbreviation but a complete word. Dual noun means logarithm, when doing adjectives refers to two heavy, two yuan.2ndThe dual table in Oracle is a single-row,

Select UPPER (f.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space size (M)",D.tot_grootte_mb-f.total_bytes "used Space (M)",To_char (ROUND ((d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2), ' 990.99 ') | | '% ' "use

Oracle GoldenGate 4. Data Filtering and data item matching, oraclegoldengateBefore you start I spent a lot of time reading the official GoldenGate documents from two weeks ago, and learned about GoldenGate based on the practices and further details.

The stored procedure is used to determine whether a person stays in the path of a day beyond the specified time.1. Problem Description In a project, the patrol staff's hand-held GPS will report the location of the staff to the total database at a