Oracle

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

Oracle laying off its Java evangelists? Er, no comment, says OracleSoon-to-be-redundant chap in pink slip slip on Facebook4 Sep at 23:04, Simon SharwoodOracle appears to is making redundancies in the ranks of its Java evangelists team.One of 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

1.Oracle string concatenationOracle supports string concatenation with the concat () function and automatically converts other types to strings except for "| |", but unlike MySQL's concat () function, Oracle's CONCAT () function supports only two

1. Create the original table and materialized view logsql> CREATE TABLE t1 (ID int,name varchar2 (30)); Table created. Sql> ALTER TABLE t1 ADD constraint Pk_t1 primary key (ID) using index; Table altered. Sql> create materialized view Log on T1 with

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

When analyzing SQL performance, it is often necessary to determine how much SQL is consumed by resources, as summarized below:1 View questionable SQLSelect substr (To_char (s.pct, ' 99.00 '),2) || '% ' load,S.executions executes,P.sql_textFrom

Restart the Oracle database and listener summary under Linux:Method 1:Log in to Linux with root SSH and open the terminal to enter the following command:CD $ORACLE _home #进入到oracle的安装目录Dbstart #重启服务器Lsnrctl Start #重启监听器CD $ORACLE _home

1. This is a block of code executed under Oracle's SQL windowDeclareV_CHAR1 varchar2 (100);V_CHAR2 varchar2 (100);V_c char (1); --Intermediate variablesBeginV_CHAR1: = ' &no '; --Replace transformationDbms_output.put_line (' Input data is: ' | |

SELECT * from XMLTABLE (' $B/deal_basic/user_deal_info ' passingXMLTYPE (' &xml ') as BCOLUMNS user_deal_id VARCHAR2 () PATH'/user_deal_info/user_deal_id ',Deal_inure_time VARCHAR2 () PATH'/user_deal_info/deal_inure_time ',Deal_expire_time VARCHAR2 (

Today, there is a very strange problem, directly in the eclipse in the SQL copy, and then paste directly copied in the database will be executed very slowly, but after using PLSQL to format the SQL statement, the speed of execution is very fast, and

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

Reprint to Http://www.blogjava.net/itspy/archive/2007/12/20/169072.htmlOracleProblem Description:The following error occurred while using JDBC to connect to the Oracle 10.2.0.1.0 database today:Connection refused (description= (tmp=) (vsnnum=15309312

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

In fact, the XML string is like an external table in Oracle, so Oracle has some rules for parsing XML strings that are very demanding. The data provided by the XML string is a table, so Oracle must provide a column header that is consistent with the

MISSES in library cache during parse:1Translation: The number of hard parse occurrences in the resolution is 1, which means hard parsingMISSES in library cache during parse:0Translation: The number of hard resolutions that occur in the resolution is

Oracle EBS reports cannot be copied.A long time ago, my colleague mentioned that EBS reports cannot be copied ..You can set the font size in the upper-right corner ..We can solve the problem that cannot be copied. Click "tool" to copy the file.In

Summary of Oracle functions in the first week of work 1.Oracle row-to-column and column-to-row The most common principle of Row-to-column conversion is the use of decode functions, Aggregate functions (sum () Max (), and group by grouping. MAX

Use ORACLE online redefinition to change a common table to a partitioned table1. First create a test table and insert the test data: create table myPartition(id number,code varchar2(5),identifier varchar2(20));insert into myPartition values(1,'01','0