First, the database structure.
1, table space monitoring is an important task, we must always be concerned about the table space settings, whether to meet the needs of current applications, the following statements can query the table space for more information. .
SELECT TABLESPACE_NAME,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS, 。.
MAX_EXTENTS, PCT_INCREASE, MIN_EXTLEN, STATUS,. .
CONTENTS,LOGGING, 。.
EXTENT_MANAGEMENT, - Columns not available in v8. .0. . X. .
ALLOCATION_TYPE, -- Remove these columns if running 。.
PLUGGED_IN, - against a v8. .0. . X database. .
SEGMENT_SPACE_MANAGEMENT --use only in v9。.2。.x or later 。.
FROM DBA_TABLESPACES. .
ORDER BY TABLESPACE_NAME; 。.
2, for some of the data file is not set to automatically expand the table space, if table space is full, it will mean that the database may be stopped because there is no space. Monitoring table space, the most important is monitoring the size of the remaining space or usage. Following is a table space monitoring space utilization and the remaining statements. .
SELECT D。.TABLESPACE_NAME,SPACE "SUM_SPACE(M)",BLOCKS SUM_BLOCKS,SPACE-NVL(FREE_SPACE,0) "USED_SPACE(M)", 。.
ROUND ((1-NVL (FREE_SPACE, 0) / SPACE) * 100,2) "USED_RATE (%)", FREE_SPACE" FREE_SPACE (M) ". .
FROM 。.
(SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024), 2) SPACE, SUM (BLOCKS) BLOCKS..
FROM DBA_DATA_FILES 。.
GROUP BY TABLESPACE_NAME) D,. .
(SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) FREE_SPACE 。.
FROM DBA_FREE_SPACE. .
GROUP BY TABLESPACE_NAME) F 。.
WHERE D. . TABLESPACE_NAME = F. . TABLESPACE_NAME (+). .
UNION ALL --if have tempfile 。.
SELECT D. . TABLESPACE_NAME, SPACE "SUM_SPACE (M)", BLOCKS SUM_BLOCKS,. .
USED_SPACE "USED_SPACE(M)",ROUND(NVL(USED_SPACE,0)/SPACE*100,2) "USED_RATE(%)", 。.
NVL (FREE_SPACE, 0) "FREE_SPACE (M)". .
FROM 。.
(SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024), 2) SPACE, SUM (BLOCKS) BLOCKS..
FROM DBA_TEMP_FILES 。.
GROUP BY TABLESPACE_NAME) D,. .
(SELECT TABLESPACE_NAME,ROUND(SUM(BYTES_USED)/(1024*1024),2) USED_SPACE, 。.
ROUND (SUM (BYTES_FREE) / (1024 * 1024), 2) FREE_SPACE. .
FROM V$TEMP_SPACE_HEADER 。.
GROUP BY TABLESPACE_NAME) F. .
WHERE D。.TABLESPACE_NAME = F。.TABLESPACE_NAME(+) 。.
3, in addition to monitoring tablespace free space, and sometimes we need to know whether the table space automatically expand space capabilities, although we recommend pre-production system in the allocated space. The following statement will accomplish this function. .
SELECT T。.TABLESPACE_NAME,D。.FILE_NAME, 。.
D. . AUTOEXTENSIBLE, D. . BYTES, D. . MAXBYTES, D. . STATUS. .
FROM DBA_TABLESPACES T, 。.
DBA_DATA_FILES D. .
WHERE T。. TABLESPACE_NAME =D。. TABLESPACE_NAME 。.
ORDER BY TABLESPACE_NAME, FILE_NAME. .
4. I believe that using a dictionary-managed tablespaces quite right, because the dictionary-managed tablespaces, each sheet the size of the next interval is not predictable, so we must monitor those tables in the dictionary-managed tablespaces in next interval distribution will cause performance problems, or as a non-extended table space and cause the system to stop. The following statement to check that table extensions will cause table space expansion.
SELECT A. . OWNER, A. . TABLE_NAME, A. . NEXT_EXTENT, A. . TABLESPACE_NAME. .
FROM ALL_TABLES A, 。.
(SELECT TABLESPACE_NAME, MAX (BYTES) BIG_CHUNK..
FROM DBA_FREE_SPACE 。.
GROUP BY TABLESPACE_NAME) F. .
WHERE F。.TABLESPACE_NAME = A。.TABLESPACE_NAME 。.
AND A. . NEXT_EXTENT> F. . BIG_CHUNK. .
Paragraph 5, of the space and the interval is also one of the issues that need attention, if a segment's footprint is too big, or too many leaps of interval (in dictionary-managed tablespaces, there will be a severe performance impact), if the section is no longer allocated interval, it will cause database errors. Therefore, the size of the paragraph and interval monitoring is also a very important work.
SELECT S. . OWNER, S. . SEGMENT_NAME, S. . SEGMENT_TYPE, S. . PARTITION_NAME,. .
ROUND(BYTES/(1024*1024),2) "USED_SPACE(M)", 。.
EXTENTS USED_EXTENTS, S. . MAX_EXTENTS, S. . BLOCKS ALLOCATED_BLOCKS,. .
S。.BLOCKS USED_BOLCKS,S。.PCT_INCREASE,S。.NEXT_EXTENT/1024 "NEXT_EXTENT(K)" 。.
FROM DBA_SEGMENTS S. .
WHERE S。.OWNER NOT IN ('SYS','SYSTEM') 。.
ORDER BY Used_Extents DESC. .
6. space allocation and utilization of space, in addition to the aspects of analysis, such as analysis of the table, query the rowid and, in fact, oracle provides a query space package dbms_space package, it will be a very handy thing.
CREATE OR REPLACE PROCEDURE show_space. .
(p_segname in varchar2, 。.
p_type in varchar2 default 'TABLE',. .
p_owner in varchar2 default user) 。.
AS. .
v_segname varchar2(100); 。.
v_type varchar2 (10);. .
l_free_blks number; 。.
l_total_blocks number;. .
l_total_bytes number; 。.
l_unused_blocks number;. .
l_unused_bytes number; 。.
l_LastUsedExtFileId number;. .
l_LastUsedExtBlockId number; 。.
l_LAST_USED_BLOCK number;. .
PROCEDURE p( p_label in varchar2, p_num in number ) 。.
IS. .
BEGIN 。.
dbms_output. . Put_line (rpad (p_label, 40 ,'。.')|| p_num);. .
END; 。.
BEGIN. .
v_segname := upper(p_segname); 。.
v_type: = p_type;. .
if (p_type = 'i' or p_type = 'I') then 。.
v_type: = 'INDEX';. .
end if; 。.
if (p_type = 't' or p_type = 'T') then. .
v_type := 'TABLE'; 。.
end if;. .
if (p_type = 'c' or p_type = 'C') then 。.
v_type: = 'CLUSTER';. .
end if; 。.
- The following sections can not be used ASSM. .
dbms_space。.free_blocks 。.
(Segment_owner => p_owner,..
segment_name => v_segname, 。.
segment_type => v_type,. .
freelist_group_id => 0, 。.
free_blks => l_free_blks);. .
--Some of the above cannot be used for ASSM.
dbms_space. . Unused_space. .
( segment_owner => p_owner, 。.
segment_name => v_segname,. .
segment_type => v_type, 。.
total_blocks => l_total_blocks,. .
total_bytes => l_total_bytes, 。.
unused_blocks => l_unused_blocks,. .
unused_bytes => l_unused_bytes, 。.
LAST_USED_EXTENT_FILE_ID => l_LastUsedExtFileId,. .
LAST_USED_EXTENT_BLOCK_ID => l_LastUsedExtBlockId, 。.
LAST_USED_BLOCK => l_LAST_USED_BLOCK);. .
--Display the result.
p ('Free Blocks', l_free_blks);. .
p( 'Total Blocks', l_total_blocks ); 。.
p ('Total Bytes', l_total_bytes);. .
p( 'Unused Blocks', l_unused_blocks ); 。.
p ('Unused Bytes', l_unused_bytes);. .
p( 'Last Used Ext FileId', l_LastUsedExtFileId ); 。.
p ('Last Used Ext BlockId', l_LastUsedExtBlockId);. .
p( 'Last Used Block', l_LAST_USED_BLOCK ); 。.
END;. .
Implementation of the results will be as follows.
SQL> set serveroutput on;. .
SQL> exec show_space('test'); 。.
Free Blocks. .1. .
Total Blocks。.8 。.
Total Bytes. .65536. .
Unused Blocks。.6 。.
Unused Bytes. .49152. .
Last Used Ext FileId。.1 。.
Last Used Ext BlockId. .48521. .
Last Used Block。.2 。.
PL / SQL procedure successfully completed. .
8, database compare index if there is a Delete operation, frequently may cause the index to be generated a lot of debris, so sometimes you need to REBUILD all indexes, again to merge index block, reduce fragmentation and improve query speed.
SQL> set heading off. .
SQL> set feedback off 。.
SQL> spool d: index. . Sql. .
SQL> SELECT 'alter index ' || index_name || ' rebuild ' 。.
| | 'Tablespace INDEXES storage (initial 256K next 256K pctincrease 0);'. .
FROM all_indexes 。.
WHERE (tablespace_name! = 'INDEXES'..
OR next_extent != ( 256 * 1024 ) 。.
). .
AND owner = USER 。.
SQL> spool off. .
This time, we open spool files, it can be run directly.
9, table primary key is necessary, not the primary key of the table can be said to meet the design specifications, so we need to monitor whether the primary key table. .
SELECT table_name 。.
FROM all_tables. .
WHERE owner = USER 。.
MINUS. .
SELECT table_name 。.
FROM all_constraints. .
WHERE owner = USER 。.
AND constraint_type = 'P'. .
II. performance monitoring.
1, the data buffer hit ratio performance tuning is not the main problem, but low hit rate is certainly not, in any case, we must ensure that there is a large data buffer and a high hit rate. .
This statement allows you to obtain comprehensive data buffer hit rate, the higher the better.
SELECT a. . VALUE + b. . VALUE logical_reads,. .
c。.VALUE phys_reads, 。.
round (100 * (1-c.. value / (a.. value + b.. value)), 4) hit_ratio. .
FROM v$sysstat a,v$sysstat b,v$sysstat c 。.
WHERE a. . NAME = 'db block gets'. .
AND b。.NAME='consistent gets' 。.
AND c. . NAME = 'physical reads'. .
2, library buffer describes SQL statements overload rate, of course, an SQL statement should be executed, the more the better, if you overload the rate is high, consider increasing the size of the shared pool or improving the use of the Bind variable.
The following statement queries the Sql statement reload rate, the lower the better. .
SELECT SUM(pins) total_pins,SUM(reloads) total_reloads, 。.
SUM (reloads) / SUM (pins) * 100 libcache_reload_ratio. .
FROM v$librarycache 。.
3, user lock, lock the database is more sometimes a drain on resources, particularly that which occurs when the lock wait, we must find place to wait for the lock, if possible, kill the process. .
This statement will locate to the database all the DML statements produced by the lock, you can find any DML statement actually creates two lock, a lock on a table, a row lock.
Can alter system kill session 'sid, serial #' to kill the session. .
SELECT /*+ rule */ s。.username, 。.
decode (l.. type, 'TM', 'TABLE LOCK',..
'TX','ROW LOCK', 。.
NULL) LOCK_LEVEL,. .
o。.owner,o。.object_name,o。.object_type, 。.
s. . Sid, s. . Serial #, s. . Terminal, s. . Machine, s. . Program, s. . Osuser. .
FROM v$session s,v$lock l,dba_objects o 。.
WHERE l. . Sid = s. . Sid. .
AND l。.id1 = o。.object_id(+) 。.
AND s. . Username is NOT NULL. .
4, lock and wait, if lock wait, we might even want to know who locked the table who wait arising.
The following statement can inquire who locked the table, and who is waiting. .
SELECT /*+ rule */ lpad(' ',decode(l。.xidusn ,0,3,0))||l。.oracle_username User_name, 。.
o. . Owner, o. . Object_name, o. . Object_type, s. . Sid, s. . Serial #. .
FROM v$locked_object l,dba_objects o,v$session s 。.
WHERE l. . Object_id = o. . Object_id. .
AND l。.session_id=s。.sid 。.
ORDER BY o. . Object_id, xidusn DESC. .
The above query results in a tree structure, if there are child nodes, it means that there are waiting to happen. If you want to know which lock the rollback segment, also may be associated to V $ rollname, xidusn is a USN rollback segment.
5, in case of a business or lock, would like to know what rollback segments are being used it? In fact, through the transaction table, we can make detailed inquiries into the relationship between transaction and rollback segments. Also, if associated with the session table, we can know which session to launch this transaction. .
SELECT s。.USERNAME,s。.SID,s。.SERIAL#,t。.UBAFIL "UBA filenum", 。.
t. . UBABLK "UBA Block number", t. . USED_UBLK "Number os undo Blocks Used",. .
t。.START_TIME,t。.STATUS,t。.START_SCNB,t。.XIDUSN RollID,r。.NAME RollName 。.
FROM v $ session s, v $ transaction t, v $ rollname r. .
WHERE s。.SADDR=t。.SES_ADDR 。.
AND t. . XIDUSN = r. . Usn. .
7. If you use session tracking or would like to see a session trace file, then the query to the OS on a process or thread number is very important, because the name of the file, it contain this information, the following statement can query to a process or thread ID, which you can find the corresponding file.
SELECT p1. . Value ||''|| p2. . Value | | '_ora_' | | p. . Spid filename. .
FROM 。.
v $ process p,. .
v$session s, 。.
v $ parameter p1,. .
v$parameter p2 。.
WHERE p1. . Name = 'user_dump_dest'. .
AND p2。.name = 'db_name' 。.
AND p. . Addr = s. . Paddr. .
AND s。.audsid = USERENV ('SESSIONID'); 。.
8, in ORACLE 9i, you can monitor the use of the index, if not used to index, completely removed, reducing the operation of DML operation. .
The following is the starting index monitoring and stop indexing monitor script.
set heading off. .
set echo off 。.
set feedback off. .
set pages 10000 。.
spool start_index_monitor. . Sql. .
SELECT 'alter index '||owner||'。.' ||index_name||' monitoring usage;' 。.
FROM dba_indexes. .
WHERE owner = USER; 。.
spool off. .
set heading on 。.
set echo on. .
set feedback on 。.
------------------------------------------------. .
set heading off 。.
set echo off. .
set feedback off 。.
set pages 10000. .
spool stop_index_monitor。.sql 。.
SELECT 'alter index' | | owner | | '. . '| | Index_name | |' nomonitoring usage; '. .
FROM dba_indexes 。.
WHERE owner = USER;. .
spool off 。.
set heading on. .
set echo on 。.
set feedback on. .
If you need to monitor more users, you can set the owner = rewrite other User.
Monitoring results in the view v $ object_usage query. .
Thanks fenng, he provides an updated version of the show_space script.
CREATE OR REPLACE PROCEDURE show_space. .
( p_segname IN VARCHAR2, 。.
p_owner IN VARCHAR2 DEFAULT USER,. .
p_type IN VARCHAR2 DEFAULT 'TABLE', 。.
p_partition IN VARCHAR2 DEFAULT NULL). .
-- This procedure uses AUTHID CURRENT USER so it can query DBA_* 。.
- Views using privileges from a ROLE and so it can be installed. .
-- once per database, instead of once per user who wanted to use it。.
AUTHID CURRENT_USER. .
as 。.
l_free_blks number;. .
l_total_blocks number; 。.
l_total_bytes number;. .
l_unused_blocks number; 。.
l_unused_bytes number;. .
l_LastUsedExtFileId number; 。.
l_LastUsedExtBlockId number;. .
l_LAST_USED_BLOCK number; 。.
l_segment_space_mgmt varchar2 (255);. .
l_unformatted_blocks number; 。.
l_unformatted_bytes number;. .
l_fs1_blocks number; l_fs1_bytes number; 。.
l_fs2_blocks number; l_fs2_bytes number;. .
l_fs3_blocks number; l_fs3_bytes number; 。.
l_fs4_blocks number; l_fs4_bytes number;. .
l_full_blocks number; l_full_bytes number; 。.
- Inline procedure to print out numbers nicely formatted. .
-- with a simple label。.
PROCEDURE p (p_label in varchar2, p_num in number). .
IS 。.
BEGIN. .
dbms_output。.put_line( rpad(p_label,40,'。.') || 。.
to_char (p_num, '999, 999,999,999 '));. .
END; 。.
BEGIN. .
-- This query is executed dynamically in order to allow this procedure 。.
- To be created by a user who has access to DBA_SEGMENTS / TABLESPACES. .
-- via a role as is customary。.
- NOTE: at runtime, the invoker MUST have access to these two. .
-- views! 。.
- This query determines if the object is an ASSM object or not. .
BEGIN 。.
EXECUTE IMMEDIATE. .
'select ts。.segment_space_management 。.
FROM dba_segments seg, dba_tablespaces ts. .
WHERE seg。.segment_name = :p_segname 。.
AND (: p_partition is null or..
seg。.partition_name = :p_partition) 。.
AND seg. . Owner =: p_owner. .
AND seg。.tablespace_name = ts。.tablespace_name' 。.
INTO l_segment_space_mgmt. .
USING p_segname, p_partition, p_partition, p_owner; 。.
EXCEPTION. .
WHEN too_many_rows THEN 。.
dbms_output. . Put_line. .
( 'This must be a partitioned table, use p_partition => '); 。.
RETURN;. .
END; 。.
- If the object is in an ASSM tablespace, we must use this API. .
-- call to get space information; else we use the FREE_BLOCKS 。.
- API for the user managed segments. .
IF l_segment_space_mgmt = 'AUTO' 。.
THEN. .
dbms_space。.space_usage 。.
(P_owner, p_segname, p_type, l_unformatted_blocks,..
l_unformatted_bytes, l_fs1_blocks, l_fs1_bytes, 。.
l_fs2_blocks, l_fs2_bytes, l_fs3_blocks, l_fs3_bytes,. .
l_fs4_blocks, l_fs4_bytes, l_full_blocks, l_full_bytes, p_partition); 。.
p ('Unformatted Blocks', l_unformatted_blocks);. .
p( 'FS1 Blocks (0-25) ', l_fs1_blocks ); 。.
p ('FS2 Blocks (25-50)', l_fs2_blocks);. .
p( 'FS3 Blocks (50-75) ', l_fs3_blocks ); 。.
p ('FS4 Blocks (75-100)', l_fs4_blocks);. .
p( 'Full Blocks ', l_full_blocks ); 。.
ELSE. .
dbms_space。.free_blocks( 。.
segment_owner => p_owner,. .
segment_name => p_segname, 。.
segment_type => p_type,. .
freelist_group_id => 0, 。.
free_blks => l_free_blks);. .
p( 'Free Blocks', l_free_blks ); 。.
END IF;. .
-- And then the unused space API call to get the rest of the 。.
- Information. .
dbms_space。.unused_space 。.
(Segment_owner => p_owner,..
segment_name => p_segname, 。.
segment_type => p_type,. .
partition_name => p_partition, 。.
total_blocks => l_total_blocks,. .
total_bytes => l_total_bytes, 。.
unused_blocks => l_unused_blocks,. .
unused_bytes => l_unused_bytes, 。.
LAST_USED_EXTENT_FILE_ID => l_LastUsedExtFileId,. .
LAST_USED_EXTENT_BLOCK_ID => l_LastUsedExtBlockId, 。.
LAST_USED_BLOCK => l_LAST_USED_BLOCK);. .
p( 'Total Blocks', l_total_blocks ); 。.
p ('Total Bytes', l_total_bytes);. .
p( 'Total MBytes', trunc(l_total_bytes/1024/1024) ); 。.
p ('Unused Blocks', l_unused_blocks);. .
p( 'Unused Bytes', l_unused_bytes ); 。.
p ('Last Used Ext FileId', l_LastUsedExtFileId);. .
p( 'Last Used Ext BlockId', l_LastUsedExtBlockId ); 。.
p ('Last Used Block', l_LAST_USED_BLOCK);. .
END; 。.
Implicit parameters:. .
select a。.ksppinm "parameter ", a。.ksppdesc "descriptoin " 。.
from x $ ksppi a, x $ ksppcv b, x $ ksppsv c. .
where a。.indx=b。.indx and a。.indx=c。.indx and a。.ksppinm like '/_%' escape '/';。.
Check OS process id from Oracle sid. .
select spid from v$process 。.
where addr in (select paddr from v $ session where sid = [$ sid)]. .
Check Oracle sid from OS process id。.
select sid from v $ session. .
where paddr in ( select addr from v$process where spid=[$pid) ] 。.
Check current SQL in a session. .
select SQL_TEXT from V$SQLTEXT 。.
where HASH_VALUE =. .
( select SQL_HASH_VALUE from v$session 。.
where sid = & sid). .
order by PIECE 。.
Checking v $ session_wait. .
select * from v$session_wait 。.
where event not like 'rdbms%'. .
and event not like 'SQL*N%' 。.
and event not like '% timer';. .
Dictionary Cache Hits。.
SELECT sum (getmisses) / sum (gets) FROM v $ rowcache;. .
/*It should be < 15%, otherwise Add share_pool_size*/ 。.
Check DB object name from file id and block #. .
select owner,segment_name,segment_type 。.
from dba_extents. .
where file_id = [$fno and &dno between block_id and block_id + blocks – 1 ] 。.
# Find hot block. .
select /*+ ordered */ 。.
e. . Owner | | '. . '| | E. . Segment_name segment_name,. .
e。.extent_id extent#, 。.
x. . Dbablk - e. . Block_id + 1 block #,. .
x。.tch, 。.
l. . Child #. .
from 。.
sys. . V $ latch_children l,. .
sys。.x$bh x, 。.
sys. . Dba_extents e. .
where 。.
l. . Name = 'cache buffers chains' and. .
l。.sleeps > &sleep_count and 。.
x. . Hladdr = l. . Addr and. .
e。.file_id = x。.file# and 。.
x. . Dbablk between e. . Block_id and e. . Block_id + e. . Blocks - 1;. .
# Identify each file on the wait event.
select df. . Name, kf. . Count from v $ datafile df, x $ kcbfwait kf where (kf.. Indx +1) = df. . File #;. .
# Identify causes the SQL statement to wait for the event.
select sql_text from v $ sqlarea a, v $ session b, v $ session_wait c where a. . Address = b. . Sql_address and b. . Sid = c. . Sid and c. . Event = [$ ll]. .
# Monitoring shared pool which object raises a large memory allocation.
SELECT * FROM X $ KSMLRU WHERE ksmlrsiz> 0;. .
Judge you start from the pfile or spfile start easy way!!!.
You start to judge or spfile from pfile easy way to start! ! ! . .
select decode(count(*), 1, 'spfile', 'pfile' ) 。.
from v $ spparameter. .
where rownum=1 。.
and isspecified = 'TRUE'. .
/ 。.
DECODE. .
------ 。.
spfile. .
ORACLE common skills and scripts.
ORACLE commonly used techniques and scripts. .
1. How do I view the implicit parameters? ORACLE.
ORACLE explicit parameters, in addition to the INIT. . ORA file defined, the in svrmgrl using "show parameter *", can be displayed. However, there are some parameters ORACLE with "_", at the beginning of the. If we are very familiar "_offline_rollback_segments" and so on. .
These parameters can be in sys. .x $ ksppi identified in the table.
Statement: "select ksppinm from x $ ksppi where substr (ksppinm, 1,1 )='_';". .
2. how to view what ORACLE components installed?.
Into the $ (ORACLE_HOME) / orainst /, run. . / Inspdver, the installation component and version number. .
。.
3. . How to view the ORACLE shared memory size occupied? . .
Available UNIX command "ipcs" view the starting address of the shared memory, semaphores, and Message Queuing.
In svrmgrl, using "oradebug ipc", we can see the sub-ORACLE occupation and size of shared memory. .
example:。.
SVRMGR> oradebug ipc. .
-------------- Shared memory --------------。.
Seg Id Address Size. .
1153 7fe000 784。.
1,154,800,000,419,430,400. .
1155 19800000 67108864.
4. . How to view the current SQL * PLUS user's sid and serial #?. .
In SQL * PLUS, run:.
"Select sid, serial #, status from v $ session..
where audsid=userenv('sessionid');”。.
. .
5. how to view the current character set of the database?.
In SQL * PLUS, run:. .
“select userenv('language') from dual;”。.
Or: "select userenv ('lang') from dual;". .
。.
6. . How to view the database a user, what SQL statement is run? . .
According to the MACHINE, USERNAME, or SID, SERIAL #, connection table V $ SESSION and V $ SQLTEXT, can be identified.
SQL * PLUS statement:. .
“SELECT SQL_TEXT FROM V$SQL_TEXT T, V$SESSION S WHERE T。.ADDRESS=S。.SQL_ADDRESS。.
AND T. . HASH_VALUE = S. . SQL_HASH_VALUE. .
.MACHINE AND S. = ' XXXXX ' OR USERNAME = ' XXXXX '--view a hostname or username.
/. ".
7. how to delete duplicate records in a table?.
Listen:. .
DELETE。.
FROM table_name a. .
WHERE rowid > ( SELECT min(rowid)。.
FROM table_name b. .
WHERE b。.pk_column_1 = a。.pk_column_1。.
and b. . Pk_column_2 = a. . Pk_column_2);. .
8. change the server manually to temporarily forced. character set
To sys or system log, sql * plus run: "create database character set us7ascii;". .
The following error:.
* Create database character set US7ASCII. .
ERROR at line 1:。.
ORA-01031: insufficient privileges. .
In fact, look at v $ nls_parameters, character set has been changed successfully. But after a restart of the database, the database character set changes back to its original.
This command can be used for temporary data between different character set server switching purposes. .
9. how to query each instance assigned to the number of PCM locks.
With the following command:. .
select count(*) "Number of hashed PCM locks" from v$lock_element where bitand(flags,4)<>0。.
/. .
select count(*) "Number of fine grain PCM locks" from v$lock_element 。.
where bitand (flags, 4) = 0. .
/。.
10. . How to judge what is currently using SQL optimization methods? . .
Use explain EXPLAIN PLAN plan generation, check the PLAN_TABLE ID = 0 in the value of the column POSITION.
e. . G. .
select decode(nvl(position,-1),-1,'RBO',1,'CBO') from plan_table where id=0。.
/. .
11. When you do, can I EXPORT DUMP file into multiple?.
ORACLE8I EXP increase in a parameter FILESIZE, can be divided into more than one file:. .
EXP SCOTT/TIGER FILE=（ORDER_1。.DMP,ORDER_2。.DMP,ORDER_3。.DMP) FILESIZE=1G TABLES=ORDER；。.
. .
Other versions of ORACLE under UNIX can make use of the pipeline and split split:.
mknod pipe p. .
Split-b 2048m pipe order & # file divided into each of the 2 GB size, to order a prefix of the file:.
# Orderaa, orderab, orderac,. . And the process on the background. .
EXP SCOTT/TIGER FILE=pipe tables=order。.
Users how to effectively use the data dictionary. .
The user how to effectively utilize the data dictionary.
ORACLE data dictionary is an important part of the database, which arise as the production database, along with changes in the database changes. .
Reflected in a number of sys user tables and views. Data dictionary name is in uppercase characters.
Data dictionary, there is user information, the user's permission information, all data object information, table constraints, such as statistical analysis of the database view. .
We cannot manually modifying information in the data dictionary.
In many cases, the general ORACLE users do not know how to effectively use it. .
Dictionary of all the name of the data dictionary tables and explained that it is a synonym for dict.
dict_column all the data dictionary table field names and explanations. .
If we want to query and index the data dictionary, you can use the following SQL statement:.
SQL> select * from dictionary where instr (comments, 'index')> 0;. .
If we want to know the name of the field user_indexes tables of detailed meaning that you can use the following SQL statement:.
SQL> select column_name, comments from dict_columns where table_name = 'USER_INDEXES';. .
And so on, you can easily know the name of the data dictionary and explained in detail, not look for Oracle's other documentation.
Some are listed by category below ORACLE users query the data dictionary used to use. .
First, the user.
View the current user's default tablespace. .
SQL>select username,default_tablespace from user_users;。.
View the current user role. .
SQL>select * from user_role_privs;。.
View the current user's system privileges, and table-level privileges. .
SQL>select * from user_sys_privs;。.
SQL> select * from user_tab_privs;. .
Second, the table.
View the table of all users. .
SQL>select * from user_tables;。.
View name contains the log-character table. .
SQL>select object_name,object_id from user_objects 。.
where instr (object_name, 'LOG')> 0;. .
View a table creation time.
SQL> select object_name, created from user_objects where object_name = upper ('& table_name');. .
View the size of a table.
SQL> select sum (bytes) / (1024 * 1024) as "size (M)" from user_segments. .
where segment_name=upper('&table_name');。.
View on ORACLE memory area in the table. .
SQL>select table_name,cache from user_tables where instr(cache,'Y')>0;。.
Third, the index. .
View the index numbers and categories.
SQL> select index_name, index_type, table_name from user_indexes order by table_name;. .
View the index of the indexed field.
SQL> select * from user_ind_columns where index_name = upper ('& index_name');. .
View the size of the index.
SQL> select sum (bytes) / (1024 * 1024) as "size (M)" from user_segments. .
where segment_name=upper('&index_name');。.
4, serial number. .
View the serial number, current value last_number is. ..
SQL> select * from user_sequences;. .
5. view.
See the view name. .
SQL>select view_name from user_views;。.
View create view select statement. .
SQL>set view_name,text_length from user_views;。.
SQL> set long 2000; Note: You can view text_length value is set according to set long size. .
SQL>select text from user_views where view_name=upper('&view_name');。.
6, synonyms. .
View the name of the synonym.
SQL> select * from user_synonyms;. .
7. the constraint.
View a list of constraints. .
SQL>select constraint_name, constraint_type,search_condition, r_constraint_name。.
from user_constraints where table_name = upper ('& table_name');. .
SQL>select c。.constraint_name,c。.constraint_type,cc。.column_name 。.
from user_constraints c, user_cons_columns cc. .
where c。.owner = upper('&table_owner') and c。.table_name = upper('&table_name')。.
and c. . Owner = cc. . Owner and c. . Constraint_name = cc. . Constraint_name. .
order by cc。.position; 。.
8, stored functions and procedures. .
View the status of functions and procedures.
SQL> select object_name, status from user_objects where object_type = 'FUNCTION';. .
SQL>select object_name,status from user_objects where object_type='PROCEDURE';。.
View the source code functions and procedures. .
SQL>select text from all_source where owner=user and name=upper('&plsql_name');。.
9, the trigger. .
View triggers.
set long 50000;. .
set heading off;。.
set pagesize 2000;. .
select。.
'Create or replace trigger "' | |..
trigger_name || '"' || chr(10)||。.
decode (substr (trigger_type, 1, 1),..
'A', 'AFTER', 'B', 'BEFORE', 'I', 'INSTEAD OF' ) ||。.
chr (10) | |. .
triggering_event || chr(10) ||。.
'ON "' | | table_owner | | '". . "'| |..
table_name || '"' || chr(10) ||。.
decode (instr (trigger_type, 'EACH ROW'), 0, null,..
'FOR EACH ROW' ) || chr(10) ,。.
trigger_body. .
from user_triggers;。.
- Analysis of database performance SQL. .
--To see which instance which operations using a number of temporary segments.
SELECT to_number (decode (SID, 65535, NULL, SID)) sid,. .
operation_type OPERATION,trunc(EXPECTED_SIZE/1024) ESIZE, 。.
trunc (ACTUAL_MEM_USED/1024) MEM, trunc (MAX_MEM_USED/1024) "MAX MEM",. .
NUMBER_PASSES PASS, trunc(TEMPSEG_SIZE/1024) TSIZE 。.
FROM V $ SQL_WORKAREA_ACTIVE. .
ORDER BY 1,2; 。.
--- Check hot block SQL query statement. .
select hash_value 。.
from v $ sqltext a,. .
(select distinct a。.owner,a。.segment_name,a。.segment_type from 。.
dba_extents a,. .
(select dbarfil,dbablk 。.
from (select dbarfil, dbablk..
from x$bh order by tch desc) where rownum < 11) b。. 11)="">
where a. . RELATIVE_FNO = b. . Dbarfil. .
and a。.BLOCK_ID <= b。.dbablk="" and="" a。.block_id="" +="" a。.blocks=""> b。.dbablk) b。.
where a. . Sql_text like'%'|| b. . Segment_name ||'%' and b. . Segment_type = 'TABLE'. .
order by a。.hash_value,a。.address,a。.piece;。.
- Full table scan. .
select opname,target,b。.num_rows,b。.tablespace_name,count(target) from v$session_longops a,all_all_tables b。.
where a. . TARGET = b. . Owner | | '. . '| | B. . Table_name. .
having count(target)>10 group by opname,target,b。.num_rows,b。.tablespace_name。.
- View disk sorting, and sorting the number of cache. .
select to_char(sn。.snap_time,'yyyy-mm-dd hh24') time_,。.
avg(newdsk。.value - olddsk。.value) disk_sort。.
from stats $ sysstat oldmen,. .
stats$sysstat newmen,。.
stats $ sysstat newdsk,. .
stats$sysstat olddsk,。.
stats $ snapshot sn. .
where newdsk。.snap_id=sn。.snap_id。.
and olddsk. . Snap_id = sn. . Snap_id-1. .
and newmen。.snap_id=sn。.snap_id。.
and newdsk. . Snap_id = sn. . Snap_id -1. .
and oldmen。.name='sorts (memory)'。.
and newmen. . Name = 'sorts (memory)'. .
and olddsk。.name='sorts (disk)'。.
and newdsk. . Name = 'sorts (disk)'. .
group by to_char(sn。.snap_time,'yyyy-mm-dd hh24')。.
- The implementation of the slowest first 10 SQL? ? ? . .
select * from (。.
select. .
to_char(snap_time,'dd Mon HH24:mi:ss') mydate,。.
executions exec,. .
loads loads,。.
parse_calls parse,. .
disk_reads reads,。.
buffer_gets gets,. .
rows_processed rows_proc,。.
sorts sorts,. .
sql_text,。.
hash_value. .
from。.
perfstat. . Stats $ sql_summary sql,. .
perfstat。.stats$snapshot sn。.
where. .
sql。.snap_id > 。.
(Select min (snap_id) min_snap..
from stats$snapshot where snap_time > sysdate-$days_back)。.
and. .
sql。.snap_id = sn。.snap_id。.
order by $ sortskey desc) tt where rownum <11;. .
--SQL query cache pool hit ratio (pinhitratio, gethitratio should be greater than 90 percent).
select namespace, gethitratio, pinhitratio, reloads, invalidations. .
from v$librarycache 。.
where namespace in ('SQL AREA', 'TABLE / PROCEDURE', 'BODY', 'TRIGGER'). .
--The General parameters of the database and I do not say, apart from V $ parameter in the generic parameters, there are a lot of implied ORACLE parameters, the following statement to query to the database of all implicit parameter and its value and a description of the parameter.
SELECT NAME. .
,VALUE 。.
, Decode (isdefault, 'TRUE', 'Y', 'N') as "Default". .
,decode(ISEM,'TRUE','Y','N') as SesMod 。.
, Decode (ISYM, 'IMMEDIATE', 'I',..
'DEFERRED', 'D', 。.
'FALSE', 'N') as SysMod. .
,decode(IMOD,'MODIFIED','U', 。.
'SYS_MODIFIED', 'S', 'N') as Modified. .
,decode(IADJ,'TRUE','Y','N') as Adjusted 。.
, Description. .
FROM ( --GV$SYSTEM_PARAMETER 。.
SELECT x. . Inst_id as instance. .
,x。.indx+1 。.
, Ksppinm as NAME. .
,ksppity 。.
, Ksppstvl as VALUE. .
,ksppstdf as isdefault 。.
, Decode (bitand (ksppiflg/256, 1), 1, 'TRUE', 'FALSE') as ISEM. .
,decode(bitand(ksppiflg/65536,3), 。.
1, 'IMMEDIATE', 2, 'DEFERRED', 'FALSE') as ISYM. .
,decode(bitand(ksppstvf,7),1,'MODIFIED','FALSE') as IMOD 。.
, Decode (bitand (ksppstvf, 2), 2, 'TRUE', 'FALSE') as IADJ. .
,ksppdesc as DESCRIPTION 。.
FROM x $ ksppi x. .
,x$ksppsv y 。.
WHERE x. . Indx = y. . Indx. .
AND substr(ksppinm,1,1) = '_' 。.
AND x. . Inst_id = USERENV ('Instance'). .
) 。.
ORDER BY NAME. .
-Want to know which users are using temporary segments? this statement will tell you which user is using temporary segments.
SELECT b. . Tablespace, b. . Segfile #, b. . Segblk #, b. . Blocks, a. . Sid, a. . Serial #,. .
a。.username, a。.osuser, a。.status,c。.sql_text 。.
FROM v $ session a, v $ sort_usage b, v $ sql c. .
WHERE a。.saddr = b。.session_addr 。.
AND a. . Sql_address = c. . Address (+). .
ORDER BY b。.tablespace, b。.segfile#, b。.segblk#, b。.blocks; 。.
- View disk fragmentation. .
select tablespace_name,sqrt(max(blocks)/sum(blocks))*。.
(100/sqrt (sqrt (count (blocks)))) FSFI. .
from dba_free_space。.
group by tablespace_name order by 1. .
1. view the table space name and size.
select t. . Tablespace_name, round (sum (bytes / (1024 * 1024)), 0) ts_size. .
from dba_tablespaces t, dba_data_files d 。.
where t. . Tablespace_name = d. . Tablespace_name. .
group by t。.tablespace_name; 。.
2. . See the table space and the size of the physical file name. .
select tablespace_name, file_id, file_name, 。.
round (bytes / (1024 * 1024), 0) total_space. .
from dba_data_files 。.
order by tablespace_name;. .
3. view the rollback segment name and size.
select segment_name, tablespace_name, r. . Status,. .
(initial_extent/1024) InitialExtent,(next_extent/1024) NextExtent, 。.
max_extents, v. . Curext CurExtent. .
From dba_rollback_segs r, v$rollstat v 。.
Where r. . Segment_id = v. . Usn (+). .
order by segment_name。.
15. Consumption of resources, the process (top session). .
select s。.schemaname schema_name, decode(sign(48 - command), 1, 。.
to_char (command), 'Action Code #' | | to_char (command)) action, status. .
session_status, s。.osuser os_user_name, s。.sid, p。.spid , s。.serial# serial_num, 。.
nvl (s.. username, 'Oracle process') user_name, s. . Terminal terminal,. .
s。.program program, st。.value criteria_value from v$sesstat st, v$session s , v$process p 。.
where st. . Sid = s. . Sid and st. . Statistic # = to_number ('38 ') and (' ALL '=' ALL '..
or s。.status = 'ALL') and p。.addr = s。.paddr order by st。.value desc, p。.spid asc, s。.username asc, s。.osuser asc 。.
16. View lock (lock) the situation. .
select /*+ RULE */ ls。.osuser os_user_name, ls。.username user_name, 。.
decode (ls.. type, 'RW', 'Row wait enqueue lock', 'TM', 'DML enqueue lock', 'TX',..
'Transaction enqueue lock', 'UL', 'User supplied lock') lock_type, 。.
o. . Object_name object, decode (ls.. Lmode, 1, null, 2, 'Row Share', 3,..
'Row Exclusive', 4, 'Share', 5, 'Share Row Exclusive', 6, 'Exclusive', null) 。.
lock_mode, o. . Owner, ls. . Sid, ls. . Serial # serial_num, ls. . Id1, ls. . Id2. .
from sys。.dba_objects o, ( select s。.osuser, s。.username, l。.type, 。.
l. . Lmode, s. . Sid, s. . Serial #, l. . Id1, l. . Id2 from v $ session s,. .
v$lock l where s。.sid = l。.sid ) ls where o。.object_id = ls。.id1 and o。.owner 。.
<> 'SYS' order by o.owner, o.object_name
- View the low efficiency of SQL statements. .
SELECT EXECUTIONS , DISK_READS, BUFFER_GETS,。.
ROUND ((BUFFER_GETS-DISK_READS) / BUFFER_GETS, 2) Hit_radio,. .
ROUND(DISK_READS/EXECUTIONS,2) Reads_per_run,。.
SQL_TEXT. .
FROM V$SQLAREA。.
WHERE EXECUTIONS> 0. .
AND BUFFER_GETS > 0 。.
AND (BUFFER_GETS-DISK_READS) / BUFFER_GETS <0. .8. .
ORDER BY 4 DESC501。. DBA_COL_PRIVS。.
Listed in the database with all the privileges granted. .
502. DBA_COLL_TYPES。.
Display the database of all named collection types. .
503. DBA_CONS_COLUMNS。.
Included in the constraint definition, can access the column information. .
504. DBA_CONSTRAINTS。.
All table constraint definition. .
505. DBA_CONTEXT。.
All context namespace information. .
506. DBA_DATA_FILES。.
Database file. .
507. DBA_DB_LINKS。.
Database of all the database links. .
508. DBA_DDL_LOCKS。.
Database locks held by all of the DDL. .
509. DBA_DEPENDENCIES。.
Dependencies between objects are listed. .
510. DBA_DIM_ATTRIBUTES。.
And functions of the Victoria-class dependent relationship between the columns. .
511. DBA_DIM_JOIN_KEY。.
On behalf of the connection between the two dimensions. .
512. DBA_DIM_LEVEL_KEY。.
Column represents a dimension level. .
513. DBA_DIM_LEVELS。.
Represents a dimension level. .
514. DBA_DIMENSIONS。.
Dimensional object on behalf of. .
515. DBA_DIRECTORIES。.
All objects provide database information. .
516. DBA_DML_LOCKS。.
Listed in the database of all DML locks, and a DML lock on the pending requests stored. .
517. DBA_ERRORS。.
Lists all the database objects stored in the current error. .
518. DBA_EXP_FILES。.
Contains the exported file. .
519. DBA_EXP_OBJECTS。.
Incremental way to export the list of objects. .
520. DBA_EXP_VERSION。.
Contains the version number of the last export session. .
521. DBA_EXTENTS。.
Composed of all segments listed in the database of information. .
522. DBA_EXTERNAL_TABLES。.
Description of the database of all the external table. .
523. DBA_FREE_SPACE。.
List all tables in the free space partition. .
524. DBA_FREE_SPACE_COALESCED。.
Combined space that contains the table space statistics. .
525. DBA_HISTOGRAMS。.
Is DBA_TAB_HISTOGRAMS synonym. .
526. DBA_IND_COLUMNS。.
Included in all tables and clustered index columns in the description of the composition. .
527. DBA_IND_EXPRESSIONS。.
Included in all tables and indexes gathered in the function type expression. .
528. DBA_IND_PARTITIONS。.
An index for each district, district-level describes the partition information, partition storage parameters and various partition statistics determined by ANALYZE data. .
529. DBA_IND_SUBPARTITIONS。.
For the current user has an index for each district, district-level describes the partition information, partition storage parameters and determine the various sub-ANALYZE. .
District statistical data.
530. . DBA_INDEXES. .
All indexes in a database description.
531. . DBA_INDEXTYPE_COMMENTS. .
Database of all user-defined index type.
532. . DBA_INDEXTYPE_OPERATORS. .
Lists all supported index type operator.
533. . DBA_INDEXTYPES. .
All index types.
534. . DBA_INTERNAL_TRIGGERS. .
Database of all internal triggers.
535. . DBA_JOBS. .
Database of all jobs.
536. . DBA_JOBS_RUNING. .
Database of all currently running jobs.
537. . DBA_JOIN_IND_COLUMNS. .
Description of the database in which all the join condition.
538. . DBA_KGLLOCK. .
KGL objects listed in all the locks and PINS.
539. . DBA_LIBRARIES. .
Lists the database all of the library.
540. . DBA_LOB_PARTITIONS. .
Included in the list of users can access JOB.
541. . DBA_LOB_SUBPARTITIONS. .
Display LOB data subpartitions in partition-level properties.
542. . DBA_LOBS. .
Included in all tables in a LOB.
543. . DBA_LOCK_INTERNAL. .
Contains each held a lock or a simple lock, and one row of information in each row of a pending request.
544. . DBA_LOCKS. .
Lists the database that holds the lock or simple locks, and each pending request info.
545. . DBA_LOG_GROUP_COLUMNS. .
Describes the log group specified in all the columns in the database of information.
546. . DBA_METHOD_PARAMS. .
The database type of the method parameter description.
547. . DBA_METHOD_RESULTS. .
Database of all types in the description of the results.
548. . DBA_MVIEW_AGGREGATES. .
In a clustered instance of the view SELECT list grouping function.
549. . DBA_MVIEW_ANALYSIS. .
Represents potentially support query rewriting.
550. . DBA_MVIEW_LOG_FILTER_COLS. .
Lists all records in the materialized view all the columns in the log.
551. . DBA_MVIEW_REFRESH_TIMES. .
Description in the database refresh materialized views for all time.
552. . DBA_MVIEWS. .
Describes all materialized views in the database.
553. . DBA_NESTED_TABLES. .
In all tables in the description of the nested table.
554. . DBA_OBJ_AUDIT_OPTS. .
Lists a user object auditing options.
555. . DBA_OBJECT_SIZE. .
Lists the various types of objects the size in bytes.
556. . DBA_OBJECT_TABLES. .
Displays all objects in the database a description of the table.
557. . DBA_OBJECTS. .
Lists all objects in the database.
558. . DBA_OPANCILLARY. .
Lists the operations of the connector's additional information.
559. . DBA_OPARGUMENTS. .
Lists the action parameter information for the connector.
560. . DBA_ORPHAN_KEY_TABLE. .
Reports for those in the base table has a bad block key value in the index.
561. . DBA_OUTLINE_HINTS. .
Lists the composition of the outline of the prompt.
562. . DBA_OUTLINES. .
Lists summary information about.
563. . DBA_PART_COL_STATISTICS. .
All the partition table of the column statistics and histograms.
564. . DBA_PART_HISTOGRAMS. .
All table partition histogram histogram data.
565. . DBA_PART_INDEXES. .
All partition index object-level partition information.
566. . DBA_PART_KEY_COLUMNS. .
All partitions of the partition keyword column object.
567. . DBA_PART_LOBS. .
Description of table-level partition LOB information.
568. . DBA_PART_TABLES. .
Lists all the partition table of object-level partition information.
569. . DBA_PARTIAL_DROP_TABS. .
The description section of the deleted table.
570. . DBA_PENDING_TRANSACTIONS. .
Information on incomplete transaction information.
571. . DBA_POLICIES. .
Lists the database all of the security policy.
572. . DBA_PRIV_AUDIT_OPTS. .
Through the system and user privileges for the current system of the audit.
573. . DBA_PROCEDURES. .
All functions and processes and their associated properties.
574. . DBA_PROFILES. .
Show all startup files and restrictions.
575. . DBA_PROXIES. .
Displays the system information for all agent connections.
576. . DBA_PUBLISHED_COLUMNS. .
Describes all of the source column of the table exists.
577. . DBA_QUEUE_SCHEDULES. .
Describes the current programme for the dissemination of information.
578. . DBA_QUEUE_TABLES. .
Description in the database of all teams in the list of the queue name and type.
579. . DBA_QUEUES. .
Describes the database every queue properties.
580. . DBA_RCHILD. .
List any refresh all subgroups.
581. . DBA_REFRESH. .
Lists all refresh Group.
582. . DBA_REFRESH_CHILDREN. .
List refresh all objects in the group.
583. . DBA_REFS. .
All the tables in the database object type column in the columns and the ref attribute REF.
584. . DBA_REGISTERED_MVIEW_GROUPS. .
Lists all the locations of reorganization of the materialized view.
585. . DBA_REGISTERED_MVIEWS. .
Database of all registered materialized views.
586. . DBA_REGISTERED_SNAPSHOT_GROUPS. .
Lists the site all snapshots registered group.
587. . DBA_REGISTERED_SNAPSHOTS. .
Retrieve the local table to remote snapshot of information.
588. . DBA_REPAIR_TABLE. .
By DBA_REPAIR. .CHECK_OBJECT process any damage found.
589. . DBA_RESUMABLE. .
Lists the system perform restore statement.
590. . DBA_RGROUP. .
Lists all refresh Group.
591. . DBA_ROLE_PRIVS. .
Lists the role granted to user roles.
592. . DBA_ROLES. .
Database of all the roles.
593. . DBA_ROLLBACK_SEGS. .
Contains a description of the rollback segment.
594. . DBA_RSRC_CONSUMER_GROUP_PRIVS. .
List all resources that have been authorized by the consumer groups, the administrator, the users and roles.
595. . DBA_RSRC_CONSUMER_GROUPS. .
All resources in the database of consumer groups.
596. . DBA_RSRC_MANAGER_SYSTEM_PRIVS. .
List all resources that have been granted belongs to the administrator system privileges and roles.
597. . DBA_RSRC_PLAN_DIRECTIVES. .
Database of all resource plan directives.
598. . DBA_RSRC_PLANS. .
Database of all resources.
599. . DBA_SEGMENTS. .
Allocated to all segments of the information store database.
600. . DBA_SEQUENCES. .
All sequences in database description.
601. . DBA_SNAPSHOT_LOG_FILTER_COLS. .
Lists the records in a snapshot log filtering columns on all.
602. . DBA_SNAPSHOT_LOGS. .
Database snapshot log in all.
603. . DBA_SNAPSHOT_REFRESH_TIMES. .
Lists the snapshot refresh times.
604. . DBA_SNAPSHOTS. .
A snapshot of the database.
605. . DBA_SOURCE. .
All of the storage object in the database of sources.
606. . DBA_SOURCE_TABLES. .
Allow the Publisher to view all existing tables.
607. . DBA_SQLJ_TYPE_ATTRS. .
Database with all the all the properties of the object SQLJ.
608. . DBA_SQLJ_TYPE_METHODS. .
Database of all types of methods.
609. . DBA_SQLJ_TYPES. .
The database all the information about the SQLJ object type.
610. . DBA_STMT_AUDIT_OPTS. .
Describes the system and current user auditing systems audit option.
611. . DBA_STORED_SETTINGS. .
Lists the privileged execution store with PL/SQL module Permanent parameter info.
612. . DBA_SUBPART_COL_STATISTICS. .
Lists the columns in table subpartitions statistics and histograms.
613. . DBA_SUBPART_HISTOGRAMS. .
Lists the tables in the histogram of subdivisions to the actual data.
614. . DBA_SUBPART_KEY_COLUMNS. .
Allow the Publisher to view their scheduled all release column.
615. . DBA_SUBPART_TABLES. .
Allow the Publisher to view their scheduled all release tables.
616. . DBA_SUBSCRIPTIONS. .
Allow the Publisher to see all of the booking.
617. . DBA_SYNONYMS. .
All synonyms in the database.
618. . DBA_SYS_PRIVS. .
Grant the user and roles of system privileges.
619. . DBA_TAB_COL_STATISTICS. .
Included in the DBA_TAB_COLUMNS view column statistics and histograms.
620. . DBA_TAB_COLUMNS. .
All tables, views, and gather information describing the column.
621. . DBA_TAB_COMMENTS. .
All the columns in the database and tables of note.
622. . DBA_TAB_HISTOGRAMS. .
All table columns of the histogram.
623. . DBA_TAB_MODIFICATIONS. .
Display the database after all the statistics of the last modification of a table.
624. . DBA_TAB_PARTITIONS. .
The partition table, describe its partition-level partition information, partition storage parameters and the decisions of the various partitions ANALYZE statistical data.
625. . DBA_TAB_PRIVS. .
Lists the role granted to a user's system privileges.
626. . DBA_TAB_SUBPARTITIONS. .
A subdivision of the tables, describe its partition-level partition information, partition storage parameters and the decisions of the various partitions ANALYZE statistical data.
627. . DBA_TABLES. .
All the relationships in the database table description.
628. . DBA_TABLESPACES. .
A description of all of the table space.
629. . DBA_TEMP_FILES. .
Name of the database temporary file information.
630. . DBA_TRANSFORMATIONS. .
All message delivery in the database.
631. . DBA_TRIGGER_COLS. .
All triggers the column usage.
632. . DBA_TRIGGERS. .
All triggers in a database.
633. . DBA_TS_QUOTAS. .
All the users tablespace quotas.
634. . DBA_TYPE_ATTRS. .
The database type of the property.
635. . DBA_TYPE_METHODS. .
Describes the database all types of methods.
636. . DBA_TYPES. .
Database of all abstract data types.
637. . DBA_UNDO_EXTENTS. .
In the undo tablespace is submitted for each scope.
638. . DBA_UNUSED_COL_TABS. .
All unused column describes.
639. . DBA_UPDATABLE_COLUMNS. .
On a connected view, by the database administrator to update the description of the column.
640. . DBA_USERS. .
All user information database.
641. . DBA_USTATS. .
Current user information.
642. . DBA_VARRAYS. .
Users can access the text of the view.
643. . DBA_VIEWS. .
All views in the database of the text.
644. . DBA_WAITERS. .
Lists all waiting for a lock on the session, as well as the lists are preventing their access to the lock on the session.
645. . USER_ALL_TABLES. .
Contains user available table description.
646. . USER_ARGUMENTS. .
Lists a user can access the parameter in the object.
647. . USER_ASSOCIATIONS. .
The current user has related objects in the user-defined statistics.
648. . USER_AUDIT_OBJECT. .
On the objects of statements audit trail record.
649. . USER_AUDIT_SESSION. .
About user connecting or disconnecting all the audit trail record.
650. . USER_AUDIT_STATEMENT. .
Lists the users GRANT, REVOKE, ALTER NOAUDIT, AUDIT, SYSTEM audit trail entry statement.
651. . USER_AUDIT_TRAIL. .
And user-related audit trail entry.
652. . USER_BASE_TABLE_MVIEWS. .
The current user owns all use materialized view logs of the materialized view.
653. . USER_CATALOG. .
The user owns a table, view, synonym, and sequence.
654. . USER_CLU_COLUMNS. .
User table columns to clustered column mappings.
655. . USER_CLUSTER_HASH_EXPRESSIONS. .
Users can access all clustered and hash function.
656. . USER_CLUSTERS. .
The user has a description of the aggregation.
657. . USER_COL_COMMENTS. .
Lists the user table or view column annotation.
658. . USER_COL_PRIVS. .
Lists the columns on the authorization of the user is the owner, the grantor or grantee.
659. . USER_COL_PRIVS_MADE. .
Lists the user owns objects in the columns of all authorization.
660. . USER_COL_PRIVS_RECD. .
Lists the columns on the authorization of the user who is granted.
661. . USER_COLL_TYPES. .
User name the collection type.
662. . USER_CONS_COLUMNS. .
The user owns the columns in the constraint definition.
663. . USER_CONSTRAINTS. .
User-defined constraints on the table.
664. . USER_DB_LINKS. .
Database chain information.
665. . USER_DEPENDENCIES. .
Because of the dependencies between objects.
666. . USER_DIM_ATTRIBUTES. .
Current user mode-level and feature dependencies.
667. . USER_DIM_CHILD_OF. .
The current user owns 1 to n-dimensional levels of the hierarchy.
668. . USER_DIM_HIERARCHIES. .
The current user owns a dimension hierarchy.
669. . USER_DIM_JOIN_KEY. .
The current user owns a connection between the dimension.
670. . USER_DIM_LEVEL_KEY. .
The current user owns a dimension level column.
671. . USER_DIM_LEVELS. .
The current user owns a dimension column.
672. . USER_DIMENSIONS. .
Current user mode dimension objects.
673. . USER_ERRORS. .
Users of all storage object on the current error.
674. . USER_EXTENTS. .
Belong to the user object in the scope of the paragraph.
675. . USER_EXTERNAL_TABLES. .
The current user owns all the external object.
676. . USER_FREE_SPACE. .
Users can access the tablespace in the idle range.
678. . USER_HISTOGRAMS. .
The view is a synonym for USER_HISTOGRAMS.
679. . USER_IND_COLUMNS. .
User index and table columns.
680. . USER_IND_EXPRESSIONS. .
The current user owns a table with an index based on function on an expression.
681. . USER_IND_SUBPARTITIONS. .
The current user owns a partition for each word, the properties of a partition-level partition information, child partition storage parameters, ANALYZE the various decision points.
District statistics. .
682. USER_INDEXES。.
The current user has a description of the index. .
683. USER_INDEXTYPE_COMMENTS。.
The current user has a user-defined index types for all comments. .
684. USER_INDEXTYPE_OPERATORS。.
The index of the current user has the type of all operations. .
685. USER_INDEXTYPES。.
The current user has all the index type. .
686. USER_INTERNAL_TRIGGERS。.
Current user have the internal triggers on all tables. .
687. USER_JOBS。.
Users have all the work. .
688. USER_JOIN_IND_COLUMNS。.
The current user has a connection to the database of all the conditions. .
689. USER_LIBRARIES。.
Lists all library users have. .
690. USER_LOB_PARTITIONS。.
The current user has the LOB data partition in the partition sub-level attributes. .
691. USER_LOBS。.
Show the user table contains LOB. .
692. USER_LOG_GROUP_COLUMNS。.
The current user has the specified column in the log. .
693. USER_LOG_GROUPS。.
Database, all tables owned by current user log group definitions. .
694. USER_METHOD_PARAMS。.
The current user has the user type of method parameters. .
695. USER_MVIEW_AGGREGATES。.
The current user has gathered examples in the SELECT list of view functions appear in groups. .
696. USER_MVIEW_ANALYSIS。.
All the current user has the potential to support materialized views for query rewrite and is available for the application of the additional information. .
697. USER_MVIEW_DETAIL_RELATIONS。.
Details on behalf of named relations. .
698. USER_MVIEW_JOINS。.
In one instance described in the WHERE clause of view, the connection between the two columns. .
699. USER_MVIEW_KEYS。.
Materialized views based on the current user mode columns in the SELECT list or expression. .
700. USER_MVIEW_REFRESH_TIMES。.
Database of all current users have materialized view refresh time. .
701. USER_MVIEWS。.
Database of all current users have materialized views. .
702. USER_NESTED_TABLES。.
The current user has the table of nested table. .
703. USER_OBJ_AUDIT_OPTS。.
User tables and views owned audit option. .
704. USER_OBJECT_SIZE。.
Users have the PL / SQL object size. .
705. USER_OBJECT_TABLES。.
Users have the object table. .
706. USER_OBJECT。.
User-owned objects. .
707. USER_OPANCILLARY。.
The operation of the current user has the supporting information. .
708. USER_OPARGUMENTS。.
The operation of the current user has the argument information. .
709. USER_OPBINDINGS。.
The operation of the current user has the binding. .
710. USER_OPERATOR_COMMENTS。.
The current user has a user-defined operations in all comments. .
711. USER_OPERATORS。.
The current user has all the action. .
712. USER_OUTLINE_HINTS。.
The composition of the current user has a summary of the implied settings. .
713. USER_OUTLINES。.
All summary of the current user has. .
714. USER_PART_COL_STATISTICS。.
The current user has a column partition table statistics and histogram data. .
715. USER_PART_HISTOGRAMS。.
The current user can access the table partition histogram data. .
716. USER_PART_KEY_COLUMNS。.
The partition current user has the object partition key column. .
717. USER_PART_INDEXES。.
The current user has all of the objects of all district-level partition information. .
718. USER_PART_LOBS。.
The current user has a large object table partition level information. .
719. USER_PART_TABLES。.
The current user has the partition table of the object-level partitioning information. .
720. USER_PARTIAL_DROP_TABS。.
Some of the current user mode, delete all the tables table operation. .
721. USER_PASSWORD_LIMITS。.
Assigned to the user's password parameter file. .
722. USER_POLICIES。.
All the objects owned by the current user's security policy. .
723. USER_PROCEDURES。.
The current user has all the functions and faults and their related properties. .
724. USER_PROXIES。.
Current users are allowed to proxy connection information. .
725. USER_PUBLISHED_COLUMNS。.
Description of the privileged existence of the source of all listed. .
726. USER_QUEUE_SCHEDULES。.
On the queue schedule information. .
727. USER_QUEUE_TABLES。.
Describe the user mode only team created a list of the queue. .
728. USER_QUEUES。.
User mode all the refresh group for each queue. .
729. USER_REFRESH。.
All current users have to refresh group. .
730. USER_REFRESH_CHILDREN。.
Lists all the objects in refresh groups. .
731. USER_REFS。.
User table object type column in the REF columns and REF attributes. .
732. USER_REGISTERED_MVIEWS。.
All current users have registered materialized views. .
733. USER_REGISTERED_SNAPSHOTS。.
The current user has a snapshot of all the registered. .
734. USER_RESOURCE_LIMITS。.
The current user's resource constraints. .
735. USER_RESUMABLE。.
Lists the current user to perform the restore statement. .
736. USER_ROLS_PRIVS。.
The role granted to users listed. .
737. USER_RSRC_CONSUMER_GROUP_PRIVS。.
Lists all of the resources granted to the user's consumption group. .
738. USER_RSRC_MANAGER_SYSTEM_PRIVS。.
All were granted DBMS_RESOURCE_MANAGER package system privileges of users. .
739. USER_SEGMENTS。.
Are listed in the database section of the user object storage allocation information. .
740. USER_SEQUENCES。.
Description of the user sequence. .
741. USER_SNAPSHOT_LOGS。.
Users have all the snapshot logs. .
742. USER_SNAPSHOT_REFRESH_TIMES。.
The number of snapshot refresh. .
743. USER_SNAPSHOTS。.
Users can view the snapshot. .
744. USER_SOURCE。.
Belongs to the user the source of all stored objects in the text. .
745. USER_SORCE_TABLES。.
Book allows you to view all the privileges of the existing source tables. .
746. USER_SQLJ_TYPE_ATTRS。.
Current users have all the properties on the SQLJ object. .
747. USER_SQLJ_TYPE_METHODS。.
The current user has the type of method. .
748. USER_SQLJ_TYPES。.
The current user has on the SQLJ object type information. .
749. USER_STORED_SETTINGS。.
Current users have stored PL / SQL unit permanent parameter. .
750. USER_SUBPART_COL_STATISTICS。.
Display the current user has the object of sub-sub-partition partition column statistics and histogram information. .
751. USER_SUBPART_HISTOGRAMS。.
The table shows the current user has sub-partition histogram of the actual histogram data. .
752. USER_SUBPART_KEY_COLUMNS。.
Display the current user has the object of sub-sub-partition partition column statistics and histogram information. .
753. USER_SUBSCRIBED_COLUMNS。.
Allow the issuer to see all the scheduled release of the columns of all. .
754. USER_SUBSCRIBED_TABLES。.
Allow the issuer to see all scheduled to release the list of all. .
755. USER_SUBSCRIPTIONS。.
Allow the issuer to see all scheduled. .
756. USER_SYSNONYMS。.
The current user has a private synonym. .
757. USER_SYS_PRIVS。.
Privileges granted to the user's system. .
758. USER_TAB_COL_STATISTICS。.
USER_TAB_COLUMNS view column contains statistics and histogram information. .
759. USER_TAB_COLUMNS。.
User table or view or information gathered on the column. .
760. USER_TAB_COMMENTS。.
User has on the table or view comments. .
761. USER_TAB_HISTOGRAMS。.
User table column histogram. .
762. USER_TAB_MODIFICATIONS。.
All users have changed after the last statistical tables. .
763. USER_TAB_PARTITIONS。.
Users have the name of each table sub-partition, storage properties, their own table and partition name. .
764. USER_TAB_PRIVS。.
Object privileges. .
765. USER_TAB_PRIVS_MADE。.
All the user has object privileges. .
766. USER_TAB_PRIVS_RECD。.
Contains object privileges are granted to those users. .
767. USER_TAB_SUBPARTITIONS。.
Users have the name of each sub-district, store attributes, its own table and partition name. .
768. USER_TABLES。.
Users have described the relationship between the tables. .
769. USER_TABLESPACES。.
Access to a description of the table space. .
770. USER_TRANSFORMATIONS。.
Specific users have to change the Information. .
771. USER_TRIGGER_COLS。.
Users trigger the use of columns. .
772. USER_TRIGGERS。.
Description of the user triggers. .
773. USER_TYPES。.
Table, the user types. .
774. USER_TYPE_ATTRS。.
The type of user attributes. .
775. USER_TS_QUOTAS。.
Limit the user's table space. .
776. USER_METHODS。.
Type the user's way. .
777. USER_UNUSED_COL_TABS。.
Contains all the unused columns table. .
778. USER_UPDATABLE_COLUMNS。.
In the connection the user can view a description of the column changes. .
779. USER_USERS。.
Current users. .
780. USER_USTATS。.
Users have user-defined statistics. .
781. USER_VARRAYS。.
Users have all the array. .
782. USER_VIEWS。.
Users have the text view. .
783. ALL_ALL_TABLES。.
Users can access all the tables. .
784. ALL_ARGUMENTS。.
Users can access all the parameters object. .
785. ALL_ASSOCIATIONS。.
User-defined statistics. .
786. ALL_BASE_TABLE_MVIEWS。.
Users can access information on all materialized views. .
787. ALL_CATALOG。.
Users can access all the tables, synonyms, depending on soil and sequence. .
788. ALL_CLUSTER_HASH_EXPRESSIONS。.
Users can access the aggregate of the HASH function. .
789. ALL_CLUSTERS。.
Users can access all together. .
790. ALL_COL_COMMENTS。.
Users can access the table or view the comments. .
791. ALL_COL_PRIVS。.
Listed on the authorization list, the user or PUBLIC is the grantee. .
792. ALL_COL_PRIVS_MADE。.
Listed on the authorization list, the user is owner or authorized. .
793. ALL_COL_PRIVS_RECD。.
Listed on the authorization list, the user or PUBLIC is authorized. .
794. ALL_COLL_TYPES。.
Users can access a named collection type. .
795. ALL_CONS_COLUMNS。.
Included in the constraint definition can access the column information. .
796. ALL_CONSTRAINTS。.
Can access the table lists the defined constraints. .
797. ALL_CONTEXT。.
Asked the information displayed activities up and down. .
798. ALL_DB_LINKS。.
Users can access the data link. .
799. ALL_DEF_AUDIT_OPTS。.
Included in the object is created by the application of the default object audit options. .
800. ALL_DEPENDENCIES。.
Users can access the dependencies between objects. .
801. ALL_DIM_HIERARCHIES。.
Show-dimensional level. .
802. ALL_DIM_JOIN_KEY。.
Describe the connection between the two dimensions. .
803. ALL_DIM_LEVEL_KEY。.
Describe the dimension level columns. .
804. ALL_DIM_LEVELS。.
Description dimensional level. .
805. ALL_DIMENSIONS。.
Dimensional object that contains the information. .
806. ALL_DIRECTORIES。.
Users can access all the catalog description. .
807. ALL_ERRORS。.
Users can access all the objects on the current error. .
808. ALL_EXTERNAL_TABLES。.
Users can access the external table. .
809. ALL_HISTOGRAMS。.
Equal ALL_TAB_HISTOGRAMS alias. .
810. ALL_IND_COLUMNS。.
Users can access the indexed columns. .
811. ALL_IND_EXPRESSIONS。.
Users can access the table functions of the index expression. .
812. ALL_IND_PARTITIONS。.
For the index partition, partition-level description of the partition information. .
813. ALL_IND_SUBPARTITONS。.
The index sub-partitions, describe the district-level sub-partition information. .
814. ALL_INDEXES。.
Users can access the index table description. .
815. ALL_INDEXTYPE_COMMNETS。.
Users can access the user-defined index types. .
816. ALL_INDEXTYPE_OPERATORS。.
Show index type supported by all operators. .
817. ALL_INDEXTYPES。.
Display all index types. .
818. ALL_INTERNAL_TRIGGERS。.
Users can access the internal trigger. .
819. ALL_JOBS。.
Database of all jobs. .
820. ALL_JOIN_IND_COLUMNS。.
Describe your connection to access the bit map index link conditions. .
821. ALL_LIBRARIES。.
Users can access all the libraries. .
822. ALL_LOB_PARTITIONS。.
Users can access the table contains LOB. .
823. ALL_LOB_SUBPARTITIONS。.
Display LOB data partition sub-district level. .
824. ALL_LOBS。.
Users can access the table contains LOB. .
825. ALL_LOG_GROUP_COLUMNS。.
Users can access the definition of a column in the log group. .
826. ALL_LOG_GROUPS。.
Users can access the table definition of the log group. .
827. ALL_METHOD_PARAMS。.
Users can access the type of method parameters. .
828. ALL_METHOD_RESULTS。.
Users can access the type of method results. .
829. ALL_MVIEW_AGGREGATES。.
Total class materialized view SELECT list grouping function appears. .
830. ALL_MVIEW_ANALYSIS。.
Description may support query rewrite and can be used for the application of the additional information, materialized views, but does not include remote and non-static. .
831. ALL_MVIEW_DETAIL_RELATIONS。.
Description materialized view FROM list, or indirectly, in the view FROM list references the name details of the relationship. .
832. ALL_MVIEW_JOINS。.
Materialized views described in the WHERE clause of the connection between the two. .
833. ALL_MVIEW_KEYS。.
Description materialized view FROM list, or indirectly, in the view FROM list references the name details of the relationship. .
834. ALL_MVIEW_REFRESH_TIMES。.
Users can access the materialized view refresh time. .
835. ALL_MVIEWS。.
Users can access all the materialized views. .
836. ALL_NESTED_TABLES。.
Users can access the table in the nested table. .
837. ALL_OBJECT_TABLES。.
Users can access the object table description. .
838. ALL_OPANCILLARY。.
Auxiliary information display operator. .
839. ALL_OPARGUMENTS。.
Shows a bundle of arguments operator information. .
840. ALL_OPBINDINGS。.
Show operator binding. .
841. ALL_OPERATOR_COMMENTS。.
Users can access the user-defined action of all comments. .
842. ALL_OPERATORS。.
Users can access operator. .
843. ALL_OUTLINE_HINTS。.
Users can access a summary of the tips. .
844. ALL_OUTLINES。.
Users can access all the summary. .
845. ALL_PART_COL_STATISTICS。.
Users can access the table partition column statistics and histogram information. .
846. ALL_PART_HISTOGRAMS。.
Users can access the partition table column data. .
847. ALL_PART_INDEXES。.
Users can access the current index of all object-level partition partition information. .
848. ALL_PART_KEY_COLUMNS。.
The current user can access the partition key partition object. .
849. ALL_PART_LOBS。.
The current user can access the partition table LOB-level information. .
850. ALL_PART_TABLES。.
The current user can access the partition table of the object-level partitioning information. .
851. ALL_PARTIAL_DROP_TABS。.
The current user can access a local table to delete the table. .
852. ALL_POLICIES。.
The current user can access all the tables and views on all the strategies. .
853. ALL_PROCEDURES。.
List all the functions and procedures and relevant properties. .
854. ALL_PUBLISHED_COLUMNS。.
Described the existence of privileged users the source listed. .
855. ALL_QUEUE_TABLES。.
The current user can access a list of all the team queue. .
856. ALL_QUEUES。.
Show users into the team or the team queue privileged information. .
857. ALL_REFRESH。.
The current user can access all the refresh group. .
858. ALL_REFRESH_CHILDREN。.
Lists all the objects in refresh groups. .
859. ALL_REFRESH_DEPENDENCIES。.
Shows the current mode summary or snapshot of the dependence of all the details or the name of the container table. .
860. ALL_REFS。.
The current user can access the object type column in the REF columns and REF attributes. .
861. ALL_REGISTERED_MVIEWS。.
The current user can access all the materialized views. .
862. ALL_REGISTERED_SNAPSHOTS。.
List of all registered snapshot. .
863. ALL_SEQUENCES。.
The current user can access all the sequences. .
864. ALL_SNAPSHOT_LOGS。.
The current user can access the materialized view log. .
865. ALL_SNAPSHOT_REFRESH_TIMES。.
Snapshot refreshes. .
866. ALL_SOURCE。.
The current user can access the text of the source of all stored objects. .
867. ALL_SOURCE_TABLES。.
View all there is to allow the issuer of the source table. .
868. ALL_SQLJ_TYPE_ATTRS。.
The current user can access all the properties on the SQLJ object. .
869. ALL_SQLJ_TYPE_METHODS。.
The current user can access the type of method. .
870. ALL_SQLJ_TYPES。.
The current user can access information on the SQLJ object type. .
871. ALL_STORED_SETTINGS。.
The implementation of the current user has privileges stored PL / SQL unit permanent parameter. .
872. ALL_SUBPART_COL_STATISTICS。.
Column contains statistics and columnar USER_TAB_COLUMNS information. .
873. ALL_SUBPART_HISTOGRAMS。.
Table sub-partition histogram shows the actual histogram information. .
874. ALL_SUBPART_KEY_COLUMNS。.
That the use of composite range / HASH method of sub-partition table partition key. .
875. ALL_SUBSCRIBED_COLUMNS。.
Allow the issuer to view their scheduled release of the columns in all. .
876. ALL_SUBSCRIBED_TABLES。.
Allow the issuer to view their scheduled release of the list of all. .
877. ALL_SUBSCRIPTIONS。.
Allow issuers see all of their reservations. .
878. ALL_SUMDELIA。.
Users can access the direct path load entries. .
879. ALL_SYNONYMS。.
Users can access all the synonyms. .
880. ALL_TAB_COL_STATISTICS。.
Column contains ALL_TAB_COLUMNS statistics and columnar information. .
881. ALL_TAB_COLUMNS。.
Users can access all the tables, views, and columns together. .
882. ALL_TAB_COMMENTS。.
Users can access the tables and views in the comments. .
883. ALL_TAB_HISTOGRAMS。.
Users can access the tables and views in the column information. .
884. ALL_TAB_MODIFICATIONS。.
Users can access the last statistics changed after the table. .
885. ALL_TAB_PRIVS。.
Authorization list object, the user or PUBLIC is granted by the user. .
886. ALL_TAB_PRIVS_MADE。.
Authorized list of users and user authorization object. .
887. ALL_TAB_PRIVS_RECD。.
Authorization list object, users, and was awarded by PUBLIC. .
888. ALL_TAB_SUBPARTITIONS。.
Users can access the sub-partition for each table name, store attributes, its own table and partition name. .
889. ALL_TABLES。.
Users can access a description of the relationship between the tables. .
890. ALL_TRIGGERS。.
Users have the trigger. .
891. ALL_TRIGGER_COLS。.
Users have the trigger out and usage. .
892. ALL_TYPE_ATTRS。.
Users can access the type of property. .
893. ALL_TYPE_METHODS。.
Users can access the type of approach. .
894. ALL_TYPES。.
Users can access the type. .
895. ALL_UNUSED_COL_TABS。.
Column contains all the tables are not used. .
896. ALL_UPDATABLE_COLUMNS。.
Mo connections view containing all columns can modify the description. .
897. ALL_USERS。.
Database for all users. .
898. ALL_USTATS。.
Users can access the user-defined statistics. .
899. ALL_VARRAYS。.
Users can access all the array. .
900. ALL_VIEWS。.
Users can access the text view. .201. . / * + NOCACHE (TABLE) * /. .
When a full table scan, the CACHE will prompts to retrieve a block of tables are placed in the buffer cache LRU list recently at least recently used, for example:.
SELECT / * + FULL (BSEMPMS) NOCAHE (BSEMPMS) * / EMP_NAM FROM BSEMPMS;. .
202. /*+APPEND*/。.
Directly inserted into the table's end, faster. .
insert /*+append*/ into test1 select * from test4 ;。.
203. . / * + NOAPPEND * /. .
Through the lifetime of the insert statement to stop the side-by-side mode to start regular insert.
insert / * + noappend * / into test1 select * from test4;. .
204. How to get the string's first character's ASCII value?.
ASCII (CHAR). .
SELECT ASCII('ABCDE') FROM DUAL;。.
Results: 65. .
205. How do I get digital value of the specified characters? N.
CHR (N). .
SELECT CHR(68) FROM DUAL;。.
Results: D. .
206. How links two string?.
CONCAT (CHAR1, CHAR2). .
SELECT CONCAT('ABC','DEFGH') FROM DUAL;。.
Results: 'ABCDEFGH'. .
207. How will the digital values in a column instead of as string?.
DECODE (CHAR, N1, CHAR1, N2, CHAR2..). .
SELECT DECODE(DAY,1,'SUN',2,'MON') FROM DUAL;。.
208. . INITCAP (CHAR). .
Make string CHAR of the first character of the new capital, the remaining for small year-round.
SELECT INITCAP ('ABCDE') FROM DUAL;. .
209. LENGTH(CHAR)。.
Take a string length of CHAR. .
SELECT LENGTH('ABCDE') FROM DUAL;。.
210. . LOWER (CHAR). .
All changes will be CHAR string into small year-round.
SELECT LOWER ('ABCDE') FROM DUAL;. .
211. LPAD(CHAR1,N,CHAR2)。.
Including the character string CHAR2 left fill CHAR1, its length N. .
SELECT LPAD('ABCDEFG',10'123') FROM DUAL;。.
Results: '123ABCDEFG '. .
212. LTRIM(CHAR,SET)。.
CHAR from the left side of the string SET in the string of characters removed, until the first date is not a SET of characters. .
SELECT ('CDEFG','CD') FROM DUAL;。.
Results: 'EFG'. .
213. NLS_INITCAP(CHAR)。.
CHAR characters take the first character uppercase and the remaining characters to lowercase. .
SELECT NLS_INITCAP('ABCDE') FROM DUAL;。.
214. . NLS_LOWER (CHAR). .
Will the character string CHAR, including all the small year-round.
SELECT NLS_LOWER ('AAAA') FROM DUAL;. .
215. NLS_UPPER(CHAR)。.
CHAR string of characters include all uppercase. .
SELECT NLS_UPPER('AAAA') FROM DUAL;。.
216. . REPLACE (CHAR1, CHAR2, CHAR3). .
Instead of using string CHAR3 per column value for a column, its CHAR2 EGM on CHAR1.
SELECT REPLACE (EMP_NO, '123 ', '456') FROM DUAL;. .
217. RPAD(CHAR1,N,CHAR2)。.
Fill the string with the right string CHAR2 CHAR1, to length N. .
SELECT RPAD('234',8,'0') FROM DUAL;。.
218. . RTRIM (CHAR, SET). .
Remove String CHAR string on the right side of my SET of characters, until the last one is not a character in the SET up.
SELECT RTRIM ('ABCDE', 'DE') FROM DUAL;. .
219. SUBSTR(CHAR,M,N)。.
Get string CHAR N starting from M Office characters. . Double-byte characters, a character as a character. .
SELECT SUBSTR('ABCDE',2,3) FROM DUAL;。.
220. . SUBSTRB (CHAR, M, N). .
Get the string CHAR from beginning of the start codon, M N personal character. -Word of the day, the character code for the two characters.
SELECT SUBSTRB ('ABCDE', 2,3) FROM DUAL;. .
221. TRANSLATE(CHAR1,CHAR2,CHAR3)。.
Will CHAR1 part of CHAR2 replaced with CHAR3. .
SELECT TRANSLATE('ABCDEFGH','DE','MN') FROM DUAL;。.
222. . UPPER (CHAR). .
Will all the new CHAR string year-round.
223. . ADD_MONTHS (D, N). .
Will N months increased to D.
SELECT ADD_MONTHS (SYSDATE, 5) FROM DUAL;. .
224. LAST_DAY(D)。.
D contains the date by the last day of the month date. .
SELECT LAST_DAY(SYSDATE) FROM DUAL;。.
225. . MONTH_BETWEEN (D1, D2). .
Get two months of the date of the now-digital.
SELECT MONTH_BETWEEN (D1, D2) FROM DUAL;. .
226. NEXT_DAY(D,CHAR)。.
Be later than the date of D CHAR named by the first weekday date. .
SELECT NEXT_DAY(TO_DATE('2003/09/20'),'SATDAY') FROM DUAL;。.
227. . ROUNT (D, FMT). .
Get the mode specified by the FMT rounded up to the date of the most advanced.
SELECT ROUNT ('2003 / 09/20 ', MONTH) FROM DUAL;. .
228. SYSDATE。.
Get the current system date and time. .
SELECT SYSDATE FROM DUAL;。.
229. . TO_CHAR (D, FMT). .
Put the date D perpetual string FMT.
SELECT TO_CHAR (SYSDATE, 'YYYY / MM / DD') FROM DUAL;. .
230. TO_DATE(CHAR,FMT)。.
By FMT CHAR string into date format. .
SELECT TO_DATE('2003/09/20','YYYY/MM/DD') FROM DUAL;。.
231. . ABS (N). .
Get the value of N 絕 to contribute.
SELECT ABS (-6) FROM DUAL;. .
232. CEIL(N)。.
Be greater than or equal to N the largest integer. .
SELECT CEIL(5。.6) FROM DUAL;。.
233. . COS (N). .
Get the cosine of the N. ..
SELECT COS (1) FROM DUAL;. .
234. SIN(N)。.
Get the sine of N. .
SELECT SIN(1) FROM DUAL;。.
235. . COSH (N). .
Get N the cosine of double-curved.
SELECT COSH (1) FROM DUAL;. .
236. EXP(N)。.
E by N, N-th power. .
SELECT EXP(1) FROM DUAL;。.
237. . FLOOR (N). .
Be less than or equal to the minimum N the whole DVD.
SELECT FLOOR (5. .6) FROM DUAL;. .
238. LN(N)。.
By N the natural logarithm. .
SELECT LN(1) FROM DUAL;。.
239. . LOG (M, N). .
Get to the bottom N M in order to contribute to a DVD.
SELECT LOG (2,8) FROM DUAL;. .
240. MOD(M,N)。.
Get the remainder of M divided by N. .
SELECT MOD(100,7) FROM DUAL;。.
241. . POWER (M, N). .
Get the n 冪 M.
SELECT POWER (4,3) FROM DUAL;. .
242. ROUND(N,M)。.
Will be rounded to the decimal point after the N M-bit. .
SELECT (78。.87653,2) FROM DUAL;。.
243. . SIGN (N). .
22 N <0時,得到-1;。.>
When N> 0, you get 1;. .
When N = 0, the time, got 0.
SELECT SIGN (99) FROM DUAL;. .
244. SINH(N)。.
By N hyperbolic sine. .
SELECT SINH(1) FROM DUAL;。.
245. . SORT (N). .
Get the square root of N, N > = 0.
SELECT SORT (9) FROM DUAL;. .
246. TAN(N)。.
By N the tangent. .
SELECT TAN(0) FROM DUAL;。.
247. . TANH (N). .
Get n-Koji tangent.
SELECT TANH (0) FROM DUAL;. .
248. TRUNC(N,M)。.
Be truncated at the N M-bit value. .
SELECT TRUNC(7。.7788,2) FROM DUAL;。.
249. . COUNT (). .
Calculation of the full foot conditions users digital.
SELECT COUNT (*) FROM TABLE1 WHERE COL1 = 'AAA';. .
250. MAX()。.
Seek maximum value for the specified column. .
SELECT MAX(COL1) FROM TABLE1;。.
251. . MIN (). .
To specify the minimum value for the column.
SELECT MIN (COL1) FROM TABLE1;. .
252. AVG()。.
Average value of the specified Sequence. .
SELECT AVG(COL1) FROM TABLE1;。.
253. . SUM (). .
Columns and calculation.
SELECT SUM (COL1) FROM DUAL;. .
254. TO_NUMBER(CHAR)。.
Convert the character value. .
SELECT TO_NUMBER('999') FROM DUAL;。.
255. . CHARTOROWID (CHAR). .
Will contain the external voice of CHAR by ROWID or VARCHAR2 digital value perpetual internal system language law, parameter CHAR must be contain external voice of ROWID of 18 characters of the string.
SELECT NAME FROM BSEMPMS WHERE ROWID = CHARTOROWID ('AAAAfZAABAAACp8AAO');. .
NAME : LEIXUE。.
256. . CONVERT (CHAR, DEST_CHAR_SET, SOURCE_CHAR_SET). .
Will CONVERT a character in CHAR string from the character set of the standard identification SOURCE_CHAR_SET perpetual DEST_CHAR_SET standard identification by the character.
SELECT CONVERT ('GroB', 'US7ASCII', 'WE8HP') 'CONVERSION' FROM PUBS;. .
CONVERSION: Gross。.
257. . HEXTORAW (CHAR). .
Will the system contains 16 CHAR perpetual a RAW digital values.
INSERT INTO BSEMPMS (RAW_COLUMN) SELECT HEXTORAW ('7 D ') FROM TEST;. .
258. RAWTOHEX(RAW)。.
The RAW value into a CHAR value containing hexadecimal. .
SELECT RAWTOHEX(RAW_COLUMN) 'CONVERSION' FROM BSEMPMS;。.
CONVERSION: 7D. .
259. ROWIDTOCHAR(ROWID)。.
Convert a ROWID value to VARCHAR2 data type. .
SELECT ROWID FROM BSEMPMS WHERE ROWIDTOCHAR(ROWID) LIKE '%BR1AAB%';。.
260. . TO_MULTI_BYTE (CHAR). .
Will list the words in the CHAR node perpetual equivalent word node.
SELECT TO_MULTI_BYTE ('ASFDFD') FROM TEST;. .
261. TO_SINGLE_BYTE(CHAR)。.
To CHAR in the multi-byte converted to an equivalent single-byte characters. .
SELECT TO_SINGLE_BYTE('ASFDFD') FROM TEST;。.
262. . TRANSLATE USING (TEXT USING (CHAR_CS | NCHAR_CS)). .
Make text TEXT in the specified conversion mode conversion into digital according to pass character sets and character set.
TEXT which is to be converted. .
USING CHAR_CS parameter TEXT for digital conversion according to pass the content of the document character set, a DVD category type VARCHAR2 is reported.
TEXT USING NCHAR_CS parameters for the database character set conversion, the output data type is NVARCHAR2. .
CREATE TABLE TEST(CHAR_COL CHAR(20),NCHAR_COL NCHAR(20));。.
INSERT INTO TEST VALUES ('HI, N'BYE');. .
SELECT * FROM TEST;。.
263. . DUMP (EXPR, RETURN_FORMAT, START_POSITION, LENGTH). .
Returns a category containing DVD-according to the type code, Word may grow, internal information return VARCHAR2 value. EGM is the current DVD according to pass character sets, DVD-follow the instructions below according to the type of internal DVD-according to the category of requirements as a DVD-return: auction.
Code data type. .
0 VARCHAR2。.
1 NUMBER. .
8 LONG。.
12 DATE. .
23 RAW。.
24 LONG RAW. .
69 ROWID。.
96 CHAR. .
106 MSSLABEL。.
Designated in accordance with the following parameters RETUEN_FORMAT base that return values. .
RETURN_FORMAT RESULT。.
88 hex. .
10 10 system.
16 16 hex. .
17 single character representation.
If the parameter RETURN_FORMAT not specified, according to the decimal that return. .
If the LENGTH parameter is specified and START_POSITION, humidity from beginning of long START_POSITION as the LENGTH of the word node will be returned, the default is to return the entire digital representation.
SELECT DUMP ('ABC', 1016) FROM TEST;. .
select dump(ename,8,3,2) 'example' from emp where name='ccbzzp';。.
264. . Empty_b | clob (). .
Returns an empty LOB Locator is initialized with the monthly amount, or LOB in INSERT and UPDATE statements to initialize the LOB column or attribute will be their home for empty.
INSERT INTO TABLE1 VALUES (EMPTY_BLOB ());。 .
UPDATE TABLE1 SET CLOB_COL=EMPTY_BLOB();。.
265. . BFILENAME ('DIRECTORY', 'FILENAME'). .
Returns a BFILE Locator, see System LOB physical files in the service of the file system., ... from DIRECTORY refers to a service of file system search path on the actual dimensions of the full name is the name of the individual. FILENAME is a service of the file name of the file system.
INSERT INTO FILE_TAB VALUES (BFILENAME ('LOB_DIR', 'IMAGE1.. GIF'));。 .
266. GREATEST(EXPR,EXPR,。.)。.
GREATEST returns the maximum value of parameters. .
SELECT GREATEST('HARRY','HARRIOT','HAROLD') 'SAMPLE' FROM TABLE1;。.
267. . LEAST (EXPR, EXPR ,。.)。 .
LEAST returns the parameters of the minimum values.
SELECT LEAST ('HARRY', 'HARRIOT', 'HAROLD') 'SAMPLE' FROM TABLE1;. .
268. NLS_CHARSET_DECL_LEN(BYTECNT,CSID)。.
Back to the width of an NCHAR column. .
SELECT NLS_CHARSET_DECL_LEN(200,NLS_CHARSET_ID('JA16EEFDFDF')) FROM TABLE1;。.
269. . NLS_CHARSET_ID (TEXT). .
Returns the character set that should be in the name of the NLS character set ID DVD-NLS.
SELECT NLS_CHARSET_D ('JADFDFFDF') FROM TABLE1;. .
270. NLS_CHARSET_NAME(N)。.
Return ID number corresponding to the N of the NLS character set name. .
SELECT NLS_CHARSET_NAME(2) FROM TABLE1;。.
271. . NVL (EXPR1, EXPR2). .
If EXPR1 is NULL, the logo here does not return EXPR2, EXPR1 no entering into returns.
SELECT NAME, NVL (TO_CHAR (COMM), 'NOT APPLICATION') FROM TABLE1;. .
272. UID。.
Back to uniquely identify the user's current database integer. .
SELECT UID FROM TABLE1;。.
273. . USER. .
Use the category type VARCHAR2 DVD according to return current ORACLE user's name.
SELECT USER, UID FROM TABLE1;. .
274. USERENV(OPTION)。.
Returns the current session information. .
OPTION = ' ISDBA ' if current is a DBA roles, rules for no entering into TRUE, FALSE.
OPTION = 'LANGUAGE' returns the database character set. .
OPTION = ' SESSIONID ' for the current meeting Tel/identification sign.
OPTION = 'ENTRYID' return to audit the session identifier. .
OPTION = ' LANG ' returns will telephone language ISO about Helsingborg..
OPTION = 'INSTANCE' returns the current instance. .
SELECT USERENV('LANGUAGE') FROM DUAL;。.
275. . VSIZE (EXPR). .
Returns EXPR internal representation of the character's Day DVD.
SELECT NAME, VSIZE (NAME) FROM TABLE1;. .
276. DEREF(E)。.
Return parameters E of the object reference. .
SELECT DEREF(C2) FROM TABLE1;。.
277. . REFTOHEX ?. .
Soak the parameter R perpetual 16 system.
SELECT REFTOHEX (C2) FROM TABLE1;. .
278. MAKE_REF(TABLE,KEY,KEY。.)。.
By the given key as a primary key to create the view object in a given reference line. .
CREATE TYPE T1 AS OBJECT(A NUMBER,B NUMBER);。.
CREATE TABLE TB1 (C1 NUMBER, C2 NUMBER, PRIMARY KEY (C1, C2));. .
CREATE VIEW V1 OF T1 WITH OBJECT OID(A, AS SELECT * FROM TB1;。.
SELECT MAKE_REF (V1, 1,3) FROM PUBS;. .
279. STDDEV(DISTINCT|ALL X)。.
STDDEV line gives the value of a standard deviation. .
SELECT STDDEV(SALARY) AS EXAMPLE FROM EMPLOYEE;。.
280. . VARIANCE (DISTINCT | ALL X). .
Returns the VARIANCE for a set of rows in all VALUE variance.
SELECT VARIANCE (SALARY) AS EXAMPLE FROM EMPLOYEE;. .
281. V$ACCESS。.
Displays the current locked objects in the database and are visiting their conversation. .
282. V$ACTIVE_INSTANCES。.
To appear in the database is currently installed in all instances to establish an instance name to the instance number from the map. .
283. V$ACTIVE_SESS_POOL_MTH。.
All activities of the session pool resource allocation. .
284. V$AQ。.
Queue the current database statistics. .
285. V$ARCHIVE。.
Archived redo log files needed for the information. .
286. V$ARCHIVE_DEST。.
The current instance of the purpose of all archived log files and their current value, mode, status. .
287. V$ARCHIVE_PROCESSES。.
To provide an example of different ARCH process state information. .
288. V$ARCHIVE_LOG。.
Control file in archive log information. .
289. V$BACKUP。.
All on-line data file backup status. .
290. V$BACKUP_ASYNC_IO。.
Shown from the control file backup set information. .
291. V$BACKUP_CORRUPTION。.
Display data from the control file backup in the damaged file information. .
292. V$BACKUP_DATAFILE。.
Shown from the control file backup data files and backup control file. .
293. V$BACKUP_DEVICE。.
Display information on the support of the backup device. .
294. V$BACKUP_PIECE。.
Shown from the control file backup pieces of information. .
295. V$BACKUP_REDOLOG。.
From the control file backup set is displayed on the archive log information. .
296. V$BACKUP_SET。.
Shown from the control file backup set information. .
297. V$BACKUP_SYNC_IO。.
Shown from the control file backup set information. .
298. V$BGPROCESS。.
Describe the background process. .
299. V$BH。.
9I Application Clusters is real-time view. . For the system global area of each buffer state and the exploration is given the number. .
300. V$BSP。.
Display block in the cache server with a background in the process of statistical information. .
301. V$BUFFER_POOL。.
Show examples of buffer pool information. .
302. V$BUFFER_POOL_STATISTICS。.
Show examples of buffer pool information. .
303. V$CACHE。.
SGA contains the current instance of each piece of header information. .
304. V$CACHE_LOCK。.
SGA contains the current instance of each piece of header information. . And V $ CACHE is very similar. .
In addition to the Special Envoy of the platform lock manager identifier numbers are different.
305. . V $ CACHE_TRANSFER. .
In addition to display only those be sniffing out at least one of the blocks of information, and V $ CACHE functionality.
306. . V $ CIRCUIT. .
Contains information about the virtual circuit, is a user through the Dispatcher and server all connections to the database.
307. . V $ CLASS_PING. .
Displays each block of classes and the number of exploration block.
308. . V $ COMPATIBILITY. .
Displays the database instance using features, you can stop the database back to the early version.
309. . V $ COMPATSEG. .
Displays the database instance using a permanent feature, you can stop the database back to the early version.
310. . V $ CONTEXT. .
Lists current settings for the properties dialogue.
311. . V $ CONTROLFILE. .
Lists the name of the control file.
312. . V $ CONTROLFILE_RECORD_SECTION. .
Display control file record segment of the information.
313. . V $ COPY_CORRUPTION. .
Displayed in the control file information of a data file is damaged.
314. . V $ CR_BLOCK_SERVER. .
Displays in the cache block server daemon on the statistical information.
315. . V $ DATABASE. .
Contains the control file database information.
316. . V $ DATAFILE. .
Contains the control file for the database file.
317. . V $ DATAFILE_COPY. .
Contains the control file is a copy of the database file.
318. . V $ DATAFILE_HEADER. .
Displays the data file header data file information.
319. . V $ DB_CACHE_ADVICE. .
According to the size of the cache is estimated the number of physical read out.
320. . V $ DB_OBJECT_CACHE. .
The cache is in the library database objects in the cache.
321. . V $ DB_PIPES. .
Show instance shared pool is currently portrayed in the pipeline.
322. . V $ DBFILE. .
Lists the composition of the database of all data files.
323. . V $ DBLINK. .
Query session open all database connections.
324. . V $ DELETED_OBJECT. .
Displayed in the control file is deleted archive logs.
325. . V $ DISPATCHER. .
Provide scheduling process information.
326. . V $ DISPATCHER_RATE. .
For scheduling processes to provide quality provide rate statistics.
327. . V $ DLM_ALL_LOCKS. .
Lists the current information for all locks.
328. . V $ DLM_CONVERT_LOCAL. .
Local lock conversion operation consumes time.
329. . V $ DLM_CONVERT_REMOTE. .
Remote lock conversion operation consumes time.
330. . V $ DLM_LATCH. .
It is obsolete, see V $ LATCH.
331. . V $ DLM_LOCKS. .
These are the lock manager known blocked or blocking other object lock information.
332. . V $ DLM_MISC. .
Display multiple DLM statistics.
333. . V $ DLM_RESS. .
Displays the current lock manager known all resource information.
334. . V $ ENABLEDPRIVE. .
Show privileges are granted.
335. . V $ ENQUEUE_LOCK. .
Displays the queue objects for all locks.
336. . V $ EVENT_NAME. .
The information contains the wait event.
337. . V $ EXECUTION. .
Displays the information in the side-by-side execution.
338. . V $ FALSE_PING. .
May be failing buffer.
339. . V $ FAST_START_SERVERS. .
Performing concurrent operations transaction recovery information for all dependent operations.
340. . V $ FAST_START_TRANSACTIONS. .
Recovery progress information in the transaction.
341. . V $ FILE_CACHE_TRANSFER. .
Display each data exploration blocks in the file..
342. . V $ FILE_PING. .
Displayed for each data file is sniffing block number.
343. . V $ FILESTAT. .
Include file on a read/write statistics information.
344. . V $ FIXED_TABLE. .
Show all dynamic performance in the database tables and views and derived tables.
345. . V $ FIXED_VIEW_DEFINITION. .
Show all fixed view definition.
346. . V $ GC_ELEMENTS_WITH_COLLISIONS. .
You can find protection against multiple locking of the cache.
347. . V $ GES_BLOCKING_ENQUEUE. .
These are the lock manager known blocked or blocking other object lock information.
348. . V $ GES_CONVERT_LOCAL. .
Local lock conversion operation consumes time.
349. . V $ GES_CONVERT_REMOTE. .
Remote lock conversion operation consumes time.
350. . V $ GES_ENQUEUE. .
Displays the current lock administrator know all locks.
351. . V $ GES_LATCH. .
See V $ LATCH.
352. . V $ GES_RESOURCE. .
Displays the current lock manager known all resource information.
353. . V $ GES_STATISTICS. .
Display multiple DLM statistics.
354. . V $ GLOBAL_BLOCKED_LOCKS. .
Displays the global block lock.
355. . V $ GLOBAL_TRANSACTION. .
Display the currently active global transaction information.
356. . V $ HS_AGENT. .
Identifies the current running on a given host on the collection of HS agent.
357. . V $ HS_SESSION. .
ORACLE server open HS session.
358. . V $ INDEXED_FIXED_COLUMN. .
Display the dynamic behavior of indexed columns in the table (X $ table).
359. . V $ INSTANCE. .
Displays the status of the current instance.
360. . V $ INSTANCE_RECOVERY. .
Used to monitor the implementation of a user-specified recovery reads restriction mechanism.
361. . V $ LATCH. .
For non-parents easy lock lists statistics.
362. . V $ LATCH_CHILDREN. .
About sub summary lock statistics.
363. . V $ LATCH_MISSES. .
An attempt was made to acquire a simple statistic lock failed.
364. . V $ LATCH_PARENT. .
Contains information about both the simple lock statistics.
365. . V $ LATCHHOLDER. .
The current holder of a simple lock.
366. . V $ LATCHNAME. .
Contains information about shows in V $ LATCH locks in simple decoding of simple lock name information.
367. . V $ LIBRARYCACHE. .
About cache performance and activity statistics.
368. . V $ LICENSE. .
License restrictions.
369. . V $ LOADCSTAT. .
Included in a direct mounted implementing procedures in the SQL * LOADER statistics.
370. . V $ LOCK. .
The current lock held by ORACLE.
371. . V $ LOCK_ACTIVITY. .
Displays the current instance of the DLM lock operation activities.
372. . V $ LOCK_ELEMENT. .
Each cached using PCM locks in V $ LOCK_ELEMENTS has an entry.
373. . V $ LOCKED_OBJECT. .
Lists each firm's exclusive locks.
374. . V $ LOCK_WITH_COLLISIONS. .
You can check out more buffer lock protection.
375. . V $ LOG. .
Control files in the log file information.
376. . V $ LOG_HISTORY. .
Control files in the log file history information.
377. . V $ LOGFILE. .
Contain the redo log file information.
378. . V $ LOGHIST. .
Control file for log file log history information.
379. . V $ LOGMNR_CONTENTS. .
The log history information.
380. . V $ LOGMNR_DICTIONARY. .
The log history information.
381. . V $ LOGMNR_LOGS. .
Log info.
382. . V $ LOGMNR_PARAMETERS. .
Log info.
383. . V $ MTS. .
Contains tuning multi-threaded server information.
384. . V $ MYSTAT. .
The statistics for the current session.
385. . V $ NLS_PARAMETERS. .
Current information about NLS parameters.
386. . V $ NLS_VALID_VALUES. .
Lists all the valid values for NLS parameters.
387. . V $ OBJECT_DEPENDENCY. .
To be able to pass the current load on the shared pool package, process, or a cursor to decided on what an object.
388. . V $ OBJECT_USAGE. .
To monitor the use of the index.
389. . V $ OBSOLETE_PARAMETER. .
Lists the old parameters.
390. . V $ OFFINE_RANGE. .
Displayed in the control file offline data file.
391. . V $ OPEN_CURSOR. .
Lists each session that is currently open and resolved by the cursor.
392. . V $ OPTION. .
Lists the status of ORACLE services installed.
393. . V $ PARALLEL_DEGREE_LIMIT_MTH. .
Show all effective parallelism limit resource allocation method.
394. . V $ PARAMETER. .
Lists information about the initialization parameters.
395. . V $ PARAMETER2. .
Lists the current session parameters and parameter values.
396. . V $ PGASTAT. .
Lists ORACLE memory usage statistics.
397. . V $ PING. .
As with the v $ CACHE.
398. . V $ PQ_SESSTAT. .
Lists the parallel query session statistics.
399. . V $ PQ_SLAVE. .
One instance for each activity-by-side execution server statistics.
400. . V $ PQ_SYSSTAT. .
Lists the parallel query system statistics.
401. . V $ PQ_TQSTAT. .
Contains parallel execution of operational statistics. help in one query for the determination of imbalances.
402. . V $ PROCESS. .
Contains information about the currently active process information.
403. . V $ PROXY_ARCHIVEDLOG. .
Contains archived log backup file that describes the information, these backup files with a known as a replica of the new features of PROXY.
404. . V $ PROXY_DATAFILE. .
Contains the data files and a description of the backup control file, these backup files with a known as a replica of the new features of PROXY.
405. . V $ PWFILE_USERS. .
Lists was awarded the SYSDBA and SYSOPER Privileges of the user.
406. . V $ PX_PROCESS. .
Running parallelism of session information.
407. . V $ PX_PROCESS_SYSSTAT. .
Running parallelism of session information.
408. . V $ PX_SESSION. .
Running parallelism of session information.
409. . V $ PX_SESSTAT. .
Running parallelism of session information.
410. . V $ QUEUE. .
Contains more information about the thread message queue.
411. . V $ QUEUEING_MTH. .
Display all the available query resource allocation method.
412. . V $ RECOVER_FILE. .
Display media recovery file status.
413. . V $ RECOVERY_FILE_STATUS. .
Contains each command for each data file row information.
414. . V $ RECOVERY_LOG. .
Lists the complete media recovery archive log information.. this information from v $ LOG_HISTORY.
415. . V $ RECOVERY_PROCESS. .
Can be used to track database recovery operation, so that they do not terminated.
Process is also used to estimate the time required to complete this operation. .
416. V$RECOVERY_STATUS。.
Contains the current recovery process of the statistics. .
417. V$REQDIST。.
MTS scheduler request lists the number of histogram statistics. .
418. V$RESERVED_WORDS。.
Given PL / SQL compiler list of keywords used. .
419. V$RESOURCE。.
Contains resource name and address information. .
420. V$RESOURCE_LIMIT。.
Shows the global resource use system resources information. .
421. V$ROLLNAME。.
List of all online rollback segment information. .
422. V$ROLLSTAT。.
Contains rollback statistics. .
423. V$ROWCACHE。.
Shows activity data dictionary statistics. .
424. V$ROWCACHE_PARENT。.
Display data dictionary information for all parent objects. .
425. V$ROWCACHE_SUBORDINATE。.
Subordinate object display data dictionary information. .
426. V$RSRC_CONSUMER_GROUP。.
Display the currently active resource consumer group associated with the user data. .
427. V$RSRC_CONSUMER_GROUP_CPU_MTH。.
The resource consumer group of users shows all available methods of resource allocation. .
428. V$RSRC_PLAN。.
Show all current activities in the name of the program resources. .
429. V$RSRC_PLAN_CPU_MTH。.
Show all available CPU resources program for resource allocation. .
430. V$SESS_IO。.
List for each user session I / O statistics. .
431. V$SESSION。.
Lists the current session information for each session. .
432. V$SESSION_CONNECT_INFO。.
Displays the current session of the network connection information. .
433. V$SESSION_CURSOR_CACHE。.
Cursor shows the current session usage information. .
434. V$SESSION_EVENT。.
Out a session waiting for a event. .
435. V$SESSION_LONGOPS。.
Shows the status of a long-running operation. .
436. V$SESSION_OBJECT_CACHE。.
Display the current user sessions on the local server object cache statistics. .
437. V$SESSION_WAIT。.
The activities listed in the session is waiting for resources or events. .
438. V$SESSTAT。.
Lists user session statistics. .
439. V$SGA。.
System global area that contains the president measurement. .
440. V$SGASTAT。.
System global area that contains more information. .
441. V$SHARED_POOL_RESERVED。.
Lists can help you adjust shared pool reserved pool and space statistics. .
442. V$SHARED_SERVER。.
Shared server process contains the information. .
443. V$SHARED_SERVER_MONITOR。.
Shared server process contains debug information. .
444. V$SORT_SEGMENT。.
Contains a given instance of a sort for each segment of information. .
445. V$SPPARAMETER。.
List the contents of SPFILE. .
446. V$SQL。.
Shared SQL areas are listed in statistics. .
447. V$SQL_BIND_DATA。.
If the data available in the server, it will query the view of the session each cursor owned by a different connection for each variable. .
Displays the client sends data to the actual connection.
448. . V $ SQL_BIND_METADATA. .
To query the view sessions have each cursor in a different connection variables, showing the client supplied connection metadata.
449. . V $ SQL_CURSOR. .
Display and query the view of session-related each cursor DEBUG info.
450. . V $ SQL_PLAN. .
Contains the mount to the library cache each child cursor execution plan information.
451. . V $ SQL_SHARED_CURSOR. .
Why a specific cursor no subqueries with exists of a shared interpretation.
452. . V $ SQL_SHARED_MEMEORY. .
About shared memory snapshot cursor information.
453. . V $ SQL_REDIRECTION. .
Identifies the redirection of the SQL statement.
454. . V $ SQL_WORKAREA. .
Display SQL cursor used by the workspace information.
455. . V $ SQL_WORKAREA_ACTIVE. .
Contains the currently assigned by the system of the client area of the information between. xu
456. . V $ SQLAREA. .
Shared SQL Statistics.
457. . V $ SQLTEXT. .
Contains the SGA belonging to a shared SQL cursor SQL statement text.
458. . V $ SQLTEXT_WITH_NEWLINES. .
You cannot use spaces instead of tabs, new lines, and V $ SQLTEXT functions the same way.
459. . V $ STATNAME. .
Display the V $ SESSTAT and V $ SYSTAT table statistics translated code statistics name.
460. . V $ SUBCACHE. .
Displays the currently loaded in the cache until the cached information.
461. . V $ SYSSTAT. .
Lists the system statistics.
462. . V $ SYSTEM_CURSOR_CACHE. .
System-wide information.
463. . V $ SYSTEM_EVENT. .
Contains all the waits for an event.
464. . V $ SYSTEM_PARAMETER. .
Contains the parameter information.
465. . V $ SYSTEM_PARAMETER2. .
ORACLE instance parameter and the current value of the parameter.
466. . V $ TABLESPACE. .
Control of file information table space.
467. . V $ TEMP_CACHE_TRANSFER. .
Display each data exploration block in the file..
468. . V $ TEMP_EXTENT_MAP. .
Show all temporary tablespace of each unit of the State information.
469. . V $ TEMP_EXTENT_POOL. .
Display is a given instance of the use of temporary space cache state.
470. . V $ TEMP_PING. .
Display each data file exploration blocks.
471. . V $ TEMP_SPACE_HEADER. .
Displays each temporary table space in each file of information that relates to each space first how much space is currently using and how much since.
By the space. .
472. V$TEMPFILE。.
Show temporary file. .
473. V$TEMPORARY_LOBS。.
Display temporary LOB. .
474. V$TEMPSTAT。.
Contains the file read / write statistics. .
475. V$THREAD。.
Thread control file contains the information. .
476. V$TIMER。.
1% seconds out the passage of time. .
477. V$TIMEZONE_NAMES。.
Lists the legal name of the time zone. .
478. V$TRANSACTION。.
The activities listed in the system matters. .
479. V$TRANSACTION_ENQUEUE。.
Owned by transaction state objects shows the lock. .
480. V$TYPE_SIZE。.
Lists the different components of the size of the database to be used to estimate the data block size. .
481. V$UNDOSTAT。.
Statistics show a history to show how the system works. .
482. V$VERSION。.
ORACLE server listed in the version number of the core library component. .
483. V$VPD_POLICY。.
A list of current cursor in the library cache all relevant security policies. .
484. V$WAITSTAT。.
Block out competition statistics. .
485. DBA_2PC_NEIGHBORS。.
Outstanding issues include the introduction or out of the connection information. .
486. DBA_ALL_TABLES。.
Show description of all tables in the database. .
487. DBA_APPLICATION_ROLES。.
All have the function definition of the role of verification strategy. .
488. DBA_ASSOCIATIONS。.
Display user-defined statistics. .
489. DBA_AUDIT_EXISTS。.
Listed AUDIT NOT EXISTS and AUDIT EXISTS audit trail generated. .
490. DBA_AUDIT_OBJECT。.
System audit trail records for all objects. .
491. DBA_AUDIT_SESSION。.
CONNECT and DISCONNECT are listed on all audit trail information. .
492. DBA_AUDIT_STATEMENT。.
Listed on the GRANT, REVOKE, AUDIT, NOAUDIT, ALTER SYSTEM statement audit trail information. .
493. DBA_AUDIT_TRAIL。.
All audit trail entries. .
494. DBA_BLOCKERS。.
List is someone waiting for a session of all sessions holding a lock, but not their own waiting for a lock. .
495. DBA_BASE_TABLE_MVIEWS。.
Description of the database of all the materialized views. .
496. DBA_CATALOG。.
List of all database standard, views, synonyms, and sequences. .
497. DBA_CLU_COLUMNS。.
Table column to column mapping together. .
498. DBA_CLUSTER_HASH_EXPRESSIONS。.
All together hash HASH function. .
499. DBA_CLUSTERS。.
Contains a description of the database all together. .
500. DBA_COL_COMMENTS。.
All tables and views in the comments column. .
You should use an Oracle time may be encountered are many looked not difficult problem, particularly suitable for novice may consist of a simple, today I put it on the floor of the declarant, in the hope that give everyone cloth market there is help! Join in on discussions, common advanced step!..
1. . Oracle installation is complete, the initial password?. .
internal/oracle。.
sys / change_on_install. .
system/manager。.
scott / tiger. .
sysman/oem_temp。.
2. . ORACLE9IAS WEB CACHE initial default user and password? . .
administrator/administrator。.
3. . Oracle 8. .0. .5 Ruffle create a database?. .
With orainst. If you have a motif interface, you can use the/m orainst.
4. . Oracle 8. .1. .7 Ruffle create a database?. .
dbassist。.
5. . Oracle 9i ruffle create a database?. .
dbca。.
6. . Oracle of the bare device refers Shiyao?. .
Raw device is to bypass the file system with direct access to the storage space.
7. . Oracle how to distinguish 64-bit/32bit version? ? ? . .
$ sqlplus '/ AS SYSDBA'。.
SQL * Plus: Release 9. .0. .1. .0. .0 - Production on Mon Jul 14 17:01:09 2003. .
(c) Copyright 2001 Oracle Corporation。. All rights reserved。.
Connected to:. .
。.
Oracle9i Enterprise Edition Release 9. .0. .1. .0. .0 - Production. .
。.
With the Partitioning option. .
JServer Release 9。.0。.1。.0。.0 - Production。.
SQL> select * from v $ version;. .
。.
BANNER. .
。.
-------------------------------------------------- --------------。 .
Oracle9i Enterprise Edition Release 9。.0。.1。.0。.0 - Production。.
PL / SQL Release 9. .0. .1. .0. .0 - Production. .
。.
CORE 9. .0. .1. .0. .0 Production. .
TNS for Solaris: Version 9。.0。.1。.0。.0 - Production。.
NLSRTL Version 9. .0. .1. .0. .0 - Production. .
SQL>。.
8. . SVRMGR Shiyao mean? . .
svrmgrl，Server Manager。.
Under 9i not have to use the SQLPLUS. .
sqlplus /nolog。.
Into the log file type. .
9. How to distinguish one user from which machine login ORACLE?.
SELECT machine, terminal FROM V $ SESSION;. .
10. Q: what statement query fields used?.
desc table_name can query the table structure. .
select field_name,。. from 。. You can query the value of the field.
select * from all_tables where table_name like '%'. .
select * from all_tab_columns where table_name='??'。.
11. . How are triggers, procedures, functions to create the script? . .
desc user_source。.
user_triggers. .
12. How to calculate the space used by a table's size?.
select owner, table_name,. .
NUM_ROWS,。.
BLOCKS * AAA/1024/1024 "Size M",. .
EMPTY_BLOCKS,。.
LAST_ANALYZED. .
from dba_tables。.
where table_name = 'XXX';. .
Here: AAA is the value of db_block_size ;。.
XXX is the table name you want to check. .
13. How to view the maximum number of sessions?.
SELECT * FROM V $ PARAMETER WHERE NAME LIKE 'proc%';. .
SQL>。.
SQL> show parameter processes. .
NAME TYPE VALUE。.
------------------------------------ ------- ------- -----------------------。 .
aq_tm_processes integer 1。.
db_writer_processes integer 1. .
job_queue_processes integer 4。.
log_archive_max_processes integer 1. .
processes integer 200。.
Here for 200 users. .
select * from v$license;。.
Which have reached the maximum sessions_highwater record number of sessions. .
14. How to view the system was locked by a transaction time?.
select * from v $ locked_object;. .
15. How to run the oracle archivelog mode.
init. . Ora. .
log_archive_start = true。.
RESTART DATABASE. .
16. Can get the name of the user who is using the database.
select username from v $ session;. .
17. The fields in the data table is?.
Table or view, the maximum number of columns in 1000. .
18. How to find the database SID?.
select name from v $ database;. .
Or you can directly view init. .ora.
19. . How Oracle server through SQLPLUS see the machine IP address?. .
select sys_context('userenv','ip_address') from dual;。.
If the landing of the aircraft database, can only return 127. .0. .0. .1, Huh, huh. .
20. Under unix can tune the database time?.
su-root. .
date -u 08010000。.
21. . How to crawl in the ORACLE TABLE MEMO data type of record field is empty?. .
select remark from oms_flowrec where trim(' ' from remark) is not null ;。.
22. . How to use the information to update the table BBB AAA information table (with associated field). .
UPDATE AAA SET BNS_SNM=(SELECT BNS_SNM FROM BBB WHERE AAA。.DPT_NO=BBB。.DPT_NO) WHERE BBB。.DPT_NO。.
IS NOT NULL;. .
23. P4 computer installation method.
Will SYMCJIT. . DLL to SYSMCJIT. . OLD. .
24. What is the query SERVER OPS?.
SELECT * FROM V $ OPTION;. .
If TRUE then the PARALLEL SERVER = OPS can have.
25. . Any query permissions for each user?. .
SELECT * FROM DBA_SYS_PRIVS;。.
26. . How to Form Mobile table space?. .
ALTER TABLE TABLE_NAME MOVE TABLESPACE_NAME;。.
27. . How to move the index table space?. .
ALTER INDEX INDEX_NAME REBUILD TABLESPACE TABLESPACE_NAME;。.
28. . In LINUX, UNIX how to activate DBA STUDIO?. .
OEMAPP DBASTUDIO。.
29. . Check the status of the objects have locks?. .
V$LOCK, V$LOCKED_OBJECT, V$SESSION, V$SQLAREA, V$PROCESS ;。.
Check table lock method:. .
SELECT S。.SID SESSION_ID, S。.USERNAME, DECODE(LMODE, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3,。.
'Row-X (SX)', 4, 'Share', 5, 'S / Row-X (SSX)', 6, 'Exclusive', TO_CHAR (LMODE)) MODE_HELD,. .
DECODE(REQUEST, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X。.
(SSX) ', 6,' Exclusive ', TO_CHAR (REQUEST)) MODE_REQUESTED, O. . OWNER | | '. . '| | O. . OBJECT_NAME | | '. .
('||O。.OBJECT_TYPE||')', S。.TYPE LOCK_TYPE, L。.ID1 LOCK_ID1, L。.ID2 LOCK_ID2 FROM V$LOCK L,。.
SYS. . DBA_OBJECTS O, V $ SESSION S WHERE L. . SID = S. . SID AND L. . ID1 = O. . OBJECT_ID;. .
30. How to unlock?.
ALTER SYSTEM KILL SESSION 'SID, SERIR #';. .
31. How to modify the SQLPLUS Editor?.
DEFINE _EDITOR = "..
<编辑器的完整路经>"--Must be in double quotation marks to define a new editor, or you can write it in.
$ ORACLE_HOME / sqlplus / admin / glogin. . Sql inside to make it permanent. .
32. ORACLE produces random function is?.
DBMS_RANDOM. . RANDOM. .
33. Linux query disk status command? competition.
Sar-d. .
33. LINUX CPU competition under the query command?.
sar-r. .
34. Queries the current user object?.
SELECT * FROM USER_OBJECTS;. .
SELECT * FROM DBA_SEGMENTS;。.
35. . How to get the error message?. .
SELECT * FROM USER_ERRORS;。.
36. . How to get link status?. .
SELECT * FROM DBA_DB_LINKS;。.
37. . View the status of the database character?. .
SELECT * FROM NLS_DATABASE_PARAMETERS;。.
SELECT * FROM V $ NLS_PARAMETERS;. .
38. Query table space information?.
SELECT * FROM DBA_DATA_FILES;. .
39. Oracle's users to password? INTERAL.
Changes SQLNET. . ORA. .
SQLNET。.AUTHENTICATION_SERVICES=(NTS)。.
40. . Appears JAVA. . EXE solution?. .
Generally be replaced manually activate ORACLEORAHOMEXIHTTPSERVER..
X is 8 or 9. .
41. How to tables, columns, plus comment?.
SQL> comment on table the table is 'table comment'; note has been created. .
SQL > comment on column is the column in table. ' comment '; note the column has been created.
SQL> select * from user_tab_comments where comments is not null;. .
42. How to view the individual table space disk?.
SQL> col tablespace format a20. .
SQL> select。.
b. . File_id file ID number. .
Table b., .tablespace_name space.
b. . Bytes bytes. .
(b。.bytes-sum(nvl(a。.bytes,0))) Already use.
sum (nvl (a.. bytes, 0)) the remaining space. .
Sum (nvl (a. .bytes, 0))/(b. .bytes) * 100% remaining.
from dba_free_space a, dba_data_files b. .
where a。.file_id=b。.file_id。.
group by b. . Tablespace_name, b. . File_id, b. . Bytes. .
order by b。.file_id。.
43. . If the MTS or ORACLE is set to private mode? . .
# Dispatchers = (PROTOCOL = TCP) (SERVICE = SIDXDB) plus is the MTS, the comment is dedicated mode, SID refers to your instance.
Name. .
44. How can I know the system's current SCN numbers?.
select max (ktuxescnw * power (2, 32) + ktuxescnb) from x $ ktuxe;. .
45. How do I get MS in Oracle?.
Prior to 9i do not support, 9i began timestamp. .
9i can select systimestamp from dual;.
46. . How to Enter the string of Riga? . .
select 'Welcome to visit'||chr(10)||'www。.CSDN。.NET' from dual ;。.
47. . Chinese is how to sort? . .
Oracle9i, Chinese is sorted according to the binary encoding.
Added in oracle9i in accordance with pinyin, radical, stroke order functions. Set NLS_SORT value. .
SCHINESE_RADICAL_M follow radical (first order), stroke (second order).
SCHINESE_STROKE_M in accordance with the stroke (first order), radicals (second order). .
Sort according to Pinyin SCHINESE_PINYIN_M.
48. . Oracle8i object name can be used in Chinese? . .
You can.
49. . How to WIN in the SQL * Plus to change the startup options? . .
SQL * PLUS its own set of options we can $ ORACLE_HOME/sqlplus/admin/glogin. setting the .sql.
50. . How to modify default date oracel database?. .
alter session set nls_date_format='yyyymmddhh24miss';。.
OR. .
You can add .ora init. previous line.
nls_date_format = 'yyyymmddhh24miss'. .
51. How to keep the small table placed in the pool?.
alter table xxx storage (buffer_pool keep);. .
52. How to check whether a patch is installed?.
check that oraInventory. .
53. How to make the results of the query to select statements are automatically generated number?.
select rownum, COL from table;. .
54. How do I know if a table in a data-pants the tablespace?.
select tablespace_name from user_tables where table_name = 'TEST';. .
Select * from a field in the user_tables TABLESPACE_NAME, (oracle).
select * from dba_segments where ...;. .
55. How you can quickly do a backup of the original table as table?.
create table new_table as (select * from old_table);. .
55. How to modify the sqlplus. procedure?
select line, trim (text) t from user_source where name = 'A' order by line;. .
56. How to unlock PROCEDURE being accidentally locked?.
alter system kill session, to the session to kill, but you must first find out she's session id. .
or。.
To the process of re change of name on it. .
57. SQL Reference is?.
Is the use of an sql manual, including syntax, functions, etc., oracle official website of the document center to download. .
58. How to view the status of the database?.
under unix. .
ps -ef | grep ora。.
under windows. .
Look up services.
Can connect to the database. .
59. How do I modify a table's primary key?.
alter table aaa. .
drop constraint aaa_key ;。.
alter table aaa. .
add constraint aaa_key primary key(a1,b1) ;。.
60. . To change the data file size?. .
Use ALTER DATABASE. DATAFILE 。. ;。.
Manually change the size of the data file for the original data files are not damaged. .
61. How to view what ORACLE programs are running?.
View v $ sessions table. .
62. How can you see how many of the database tablespace?.
select * from dba_tablespaces;. .
63. How to change Oracle database user connections?.
Changes initSID. . Ora, will process up, restart the database. .
64. How to find a record of the last update time?.
Can logminer look. .
65. How to PL/SQL to read and write files in?.
UTL_FILE package allows users to PL / SQL to read and write operating system files. .
66. How to put the "&" natural users?.
insert into a values (translate ('at (&) t', 'at {}',' at'));。 .
67. How to add QUERY parameters EXP?.
EXP USER / PASS FILE = A. . DMP TABLES (BSEMPMS). .
QUERY='"WHERE EMP_NO=\'S09394\'\" ﹔。.
68. . About oracle8i support simplified and traditional character set problem? . .
ZHS16GBK can be supported.
69. . Data Guard What is software? . .
It is the successor of Standby.
70. . How to create a SPFILE?. .
SQL> connect / as sysdba。.
SQL> select * from v $ version;. .
SQL> create pfile from spfile;。.
SQL> CREATE SPFILE FROM PFILE = 'E: \ ora9i \ admin \ eygle \ pfile \ init. . Ora ';. .
The file has been created.
SQL> CREATE SPFILE = 'E: \ ora9i \ database \ SPFILEEYGLE. . ORA 'FROM. .
PFILE='E:\ora9i\admin\eygle\pfile\init。.ora';。.
File has been created. .
71. Internal kernel parameter application?.
shmmax. .
Meaning: this setting does not determine whether the Oracle database, or how much physical memory used by the operating system, only determines the maximum use of the term.
Deposit number. This setting does not affect the operating system kernel resources. .
Settings: 0.5 * physical memory.
Examples: Set shmsys: shminfo_shmmax = 10485760. .
shmmin。.
Meaning: the minimum size of shared memory. .
Settings: General settings become 1.
Examples: Set shmsys: shminfo_shmmin = 1:. .
shmmni。.
Meaning: the system the maximum number of shared memory segment. .
Example: Set shmsys: shminfo_shmmni = 100.
shmseg. .
Meaning: each user processes can use the most number of shared memory segments.
Examples: Set shmsys: shminfo_shmseg = 20:. .
semmni。.
Meaning: the system the maximum number of semaphore identifierer. .
Setting method: the variable's value is set to the system on all instances of Oracle init. .ora in most of the processes.
That value plus 10. .
Example: Set semsys: seminfo_semmni = 100.
semmns. .
Meaning: the system the maximum number of emaphores.
Set Method: This value can be calculated as follows: each Oracle instance initSID. . Ora inside the processes of the value of the total. .
And (get rid of most Processes parameters) + oldest Processes× 2 + 10 x the number of Oracle instance.
Examples: Set semsys: seminfo_semmns = 200. .
semmsl:。.
Meaning: a set maximum number of semaphore. .
Settings: setting the 10 + all Oracle instance .ora InitSID. maximum value of the Processes.
Examples: Set semsys: seminfo_semmsl =- 200. .
72. How to see which user owns the SYSDBA, SYSOPER Privileges?.
SQL> conn sys / change_on_install. .
SQL>select * from V_$PWFILE_USERS;。.
73. . How to back up one or more separate tables? . .
Exp = user/password tables (table 1, ..., table 2).
74. . How to back up a single or multiple users? . .
Exp system/manager owner = (user 1, user 2, ..., n) file = exported file.
75. . How to retrieve the full text CLOB field? . .
SELECT * FROM A WHERE dbms_lob。.instr(a。.a,'K',1,1)>0;。.
76. . How to display the currently connected user?. .
SHOW USER。.
77. . How to view data files placed in the path?. .
col file_name format a50。.
SQL> select tablespace_name, file_id, bytes/1024/1024, file_name from dba_data_files order by. .
file_id;。.
78. . How do I view the current rollback of the state?. .
SQL> col segment format a30。.
SQL> SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID, STATUS FROM DBA_ROLLBACK_SEGS. .
79. How to change a field in the initial definition of the scope of Check?.
SQL> alter table xxx drop constraint constraint_name;. .
After you create a new constraint:.
SQL> alter table xxx add constraint constraint_name check ();. .
80. Oracle common system file?.
By the following view shows the file information: v $ database, v $ datafile, v $ logfile v $ controlfile v $ parameter;. .
81. Internal links INNER JOIN?.
Select a. .* From bsempms a, bsdptms b where a. . Dpt_no = b. . Dpt_no;. .
82. How external links?.
Select a. .* From bsempms a, bsdptms b where a. . Dpt_no = b. . Dpt_no (+);。 .
Select a。.* from bsempms a,bsdptms b wherea。.dpt_no(+)=b。.dpt_no;。.
83. . How to implement the SQL script file?. .
SQL>@$PATH/filename。.sql;。.
84. . How to quickly empty a large table?. .
SQL>truncate table table_name;。.
85. . How to check the number of database instances?. .
SQL>SELECT * FROM V$INSTANCE;。.
86. . How to check the number of database tables?. .
SQL>select * from all_tables;。.
87. . How to test SQL statement execution time spent?. .
SQL>set timing on ;。.
SQL> select * from tablename;. .
88. CHR () 's anti-counted?.
ASCII (). .
SELECT CHAR(65) FROM DUAL;。.
SELECT ASCII ('A') FROM DUAL;. .
89. A string of links.
SELECT CONCAT (COL1, COL2) FROM TABLE;. .
SELECT COL1||COL2 FROM TABLE ;。.
90. . How to select out the results lead to a text file? . .
SQL>SPOOL C:\ABCD。.TXT;。.
SQL> select * from table;. .
SQL >spool off;。.
91. . How to estimate SQL execution I / O numbers?. .
SQL>SET AUTOTRACE ON ;。.
SQL> SELECT * FROM TABLE;. .
OR。.
SQL> SELECT * FROM v $ filestat;. .
You can view the number of IO.
92. . How to change the field size in sqlplus?. .
alter table table_name modify (field_name varchar2(100));。.
Changed lines, Gaixiao not work (unless all empty). .
93. How to query the data for the day?.
select * from table_name where trunc (date field) = to_date ('2003-05-02 ',' yyyy-mm-dd ');. .
94. How to insert SQL statements throughout the day?.
create table BSYEAR (d date);. .
insert into BSYEAR。.
select to_date ('20030101 ',' yyyymmdd ') + rownum-1. .
from all_objects。.
where rownum <= to_char (to_date ('20031231 ',' yyyymmdd '),' ddd ');. .
95. If you modify the table name.
alter table old_table_name rename to new_table_name;. .
96. How to obtain an order for return status values?.
sqlcode = 0. .
97. How do I know if a user has permissions?.
SELECT * FROM dba_sys_privs;. .
98. Download Oracle9i and market sold on what is the difference between the standard version?.
From the function that there is no difference, but the company has express provision oracle; downloaded from the site shall not be used for commercial use oracle products. .
Pedestrians, or infringement.
99. . How to determine the database is running in archive mode or running in non archive mode? . .
Enter the course dbastudio,-----> database > archive view.
100. . Sql> startup pfile and ifile, spfiled What is the difference? . .
Pfile is Oracle initialization parameter files, traditional, text format.
ifile is similar to c in languages include, for the introduction of another file. .
Spfile is 9i added and is the default argument file, binary format.
should only be connected after startup pfile. .
101. How to search out the first n records?.
SELECT * FROM empLOYEE WHERE ROWNUM
ORDER BY empno;。.
102. . How do I know how many machines on the Oracle support for concurrent users?. .
SQL>conn internal ;。.
SQL> show parameter processes;. .
103. Db_block_size can modify do?.
Generally can not, is not recommended to do so. .
104. How to count the two tables of the total number of records?.
select (select count (id) from aa) + (select count (id) from bb) the total from dual;. .
105. How to use SQL statements to implement find a column in the Nth largest value?.
select * from. .
(select t。.*,dense_rank() over (order by sal) rank from employee)。.
where rank = N;. .
106. How to give existing date plus (2 years?.
select add_months (sysdate, 24) from dual;. .
107. USED_UBLK negative mean?.
It is "harmless". .
108. Connect string mean?.
Should be tnsnames. . Ora in the service name behind the content. .
109. How to enlarge the size of the REDO LOG?.
The establishment of a temporary redolog group, then switch logs, delete the previous log, create a new log. .
110. Tablespace is cannot be greater than 4G?.
There is no limit. .
111. Returns the greater than or equal to the minimum N the whole digital value?.
SELECT CEIL (N) FROM DUAL;. .
112. Returns the first negative integer less than the minimum is equal to N the whole digital value?.
SELECT FLOOR (N) FROM DUAL;. .
113. Returns the current on the last day of the month?.
SELECT LAST_DAY (SYSDATE) FROM DUAL;. .
114. How to separate user data into a closet?.. 導
IMP SYSTEM / MANAGER FILE = AA. . DMP FROMUSER = USER_OLD TOUSER = USER_NEW ROWS = Y INDEXES = Y;. .
115. How to find database table's primary key field name?.
SQL> SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE = 'P' and table_name = 'TABLE_NAME';. .
116. Two EGM set of cross-Canada counted?.
SQL>SELECT * FROM BSEMPMS_OLD UNION SELECT * FROM BSEMPMS_NEW;。.
SQL> SELECT * FROM BSEMPMS_OLD UNION ALL SELECT * FROM BSEMPMS_NEW;. .
117. Two sets of results counted of mutual reducing?.
SQL> SELECT * FROM BSEMPMS_OLD MINUS SELECT * FROM BSEMPMS_NEW;. .
118. How to configure the Sequence line.
Construction sequence seq_custid. .
create sequence seq_custid start 1 incrememt by 1;。.
Building tables:. .
create table cust。.
(Cust_id smallint not null,. .
}。.
insert time:. .
insert into table cust。.
values (seq_cust.. nextval,..). .
Date of the written law are commonly used.
119>. . Take time to point the wording of the year:. .
SELECT TO_CHAR(SYSDATE,'YYYY') FROM DUAL;。.
120>. . Get the wording of the month time:. .
SELECT TO_CHAR(SYSDATE,'MM') FROM DUAL;。.
121>. . Get the wording of days time:. .
SELECT TO_CHAR(SYSDATE,'DD') FROM DUAL;。.
122>. . Get the wording when the time points:. .
SELECT TO_CHAR(SYSDATE,'HH24') FROM DUAL;。.
123>. . Get the wording of the sub-time:. .
SELECT TO_CHAR(SYSDATE,'MI') FROM DUAL;。.
124>. . Take the second time the wording:. .
SELECT TO_CHAR(SYSDATE,'SS') FROM DUAL;。.
125>. . Get the wording of the date time:. .
SELECT TRUNC(SYSDATE) FROM DUAL;。.
126>. . Take the time time the wording:. .
SELECT TO_CHAR(SYSDATE,'HH24:MI:SS') FROM DUAL;。.
127>. . The date, time, shape into a character form. .
SELECT TO_CHAR(SYSDATE) FROM DUAL;。.
128>. . To convert a string into a date or time pattern:. .
SELECT TO_DATE('2003/08/01') FROM DUAL;。.
129>. . Back to the wording of the week parameter:. .
SELECT TO_CHAR(SYSDATE,'D') FROM DUAL;。.
130>. . Back to the first days of the year parameter wording:. .
SELECT TO_CHAR(SYSDATE,'DDD') FROM DUAL;。.
131>. . Back to midnight and the parameters specified number of seconds between the time value of the wording:. .
SELECT TO_CHAR(SYSDATE,'SSSSS') FROM DUAL;。.
132>. . Back to the first weeks of the year parameter in the wording:. .
SELECT TO_CHAR(SYSDATE,'WW') FROM DUAL;。.
Virtual field. .
133. CURRVAL and nextval.
To create the sequence table. .
CREATE SEQUENCE EMPSEQ 。. ;。.
SELECT empseq. . Currval FROM DUAL;. .
Automatically insert a sequence of numeric values.
INSERT INTO emp. .
VALUES (empseq。.nextval, 'LEWIS', 'CLERK', 7902, SYSDATE, 1200, NULL, 20) ;。.
134. . ROWNUM. .
By setting the sort sequence of rows.
SELECT * FROM emp WHERE ROWNUM <10;. .
135. ROWID。.
Back row of the physical address. .
SELECT ROWID, ename FROM emp WHERE deptno = 20 ;。.
136. . To N seconds, minutes and seconds format conversion too? . .
set serverout on。.
declare. .
N number := 1000000;。.
ret varchar2 (100);. .
begin。.
ret: = trunc (n/3600) | | 'hour' | | to_char (to_date (mod (n, 3600), 'sssss'), 'fmmi "points" ss "seconds"');. .
dbms_output。.put_line(ret);。.
end;. .
137. How to query do larger sorting process?.
SELECT b. . Tablespace, b. . Segfile #, b. . Segblk #, b. . Blocks, a. . Sid, a. . Serial #,. .
a。.username, a。.osuser, a。.status。.
FROM v $ session a, v $ sort_usage b. .
WHERE a。.saddr = b。.session_addr。.
ORDER BY b. . Tablespace, b. . Segfile #, b. . Segblk #, b. . Blocks;. .
138. How to query do larger sort of SQL statements that process?.
select / * + ORDERED * / sql_text from v $ sqltext a. .
where a。.hash_value = (。.
select sql_hash_value from v $ session b. .
order by piece asc;. .
139. How to find duplicate records?.
SELECT * FROM TABLE_NAME. .
WHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME D。.
WHERE TABLE_NAME. . COL1 = D. . COL1 AND TABLE_NAME. . COL2 = D. . COL2);. .
140. How to delete duplicate records?.
DELETE FROM TABLE_NAME. .
WHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME D。.
WHERE TABLE_NAME. . COL1 = D. . COL1 AND TABLE_NAME. . COL2 = D. . COL2);. .
141. How to quickly compile all view?.
SQL> SPOOL VIEW1. . SQL. .
SQL >SELECT ‘ALTER VIEW ‘||TNAME||’。.
COMPILE; 'FROM TAB;. .
SQL >SPOOL OFF。.
Then do VIEW1. . SQL can. .
SQL >@VIEW1。.SQL;。.
142. . ORA-01555 SNAPSHOT TOO OLD solutions. .
Increase the value, increase MINEXTENTS it sets a high value of OPTIMAL.
143. . Matters not required rollback segment space, performance space for the table with a full (ORA-01560 error), rollback segments reached expansion parameters. .
MAXEXTENTS values (ORA-01628) solutions.
Add files to the tablespace or rollback segments so that the documents have been larger; increase the MAXEXTENTS value. .
144. How to encrypt stored procedures for ORACLE?.
The following stored procedure content on AA. . SQL file. .
create or replace procedure testCCB(i in number) as。.
begin. .
Dbms_output. .put_line (' input parameter is ' || to_char (I));.
end;. .
SQL>wrap iname=a。.sql;。.
PL / SQL Wrapper: Release 8. .1. .7. .0. .0 - Production on Tue Nov 27 22:26:48 2001. .
Copyright (c) Oracle Corporation 1993, 2000。. All Rights Reserved。.
Processing AA. . Sql to AA. . Plb. .
Run .plb. AA.
SQL> @ AA. . Plb;. .
145. How to monitor case wait?.
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;。.
146. . How to rollback contention situation? . .
select name, waits, gets, waits/gets "Ratio"。.
from v $ rollstat C, v $ rollname D. .
where C。.usn = D。.usn;。.
147. . How to monitor the table space I / O ratio? . .
select B。.tablespace_name name,B。.file_name "file",A。.phyrds pyr,。.
A. . Phyblkrd pbr, A. . Phywrts pyw, A. . Phyblkwrt pbw. .
from v$filestat A, dba_data_files B。.
where A. . File # = B. . File_id. .
order by B。.tablespace_name;。.
148. . How to monitor file system I / O ratio? . .
select substr(C。.file#,1,2) "#", substr(C。.name,1,30) "Name",。.
C. . Status, C. . Bytes, D. . Phyrds, D. . Phywrts. .
from v$datafile C, v$filestat D。.
where C. . File # = D. . File #;. .
149. How to find a user with all the indexes.
select user_indexes. . Table_name, user_indexes. . Index_name, uniqueness, column_name. .
from user_ind_columns, user_indexes。.
where user_ind_columns. . Index_name = user_indexes. . Index_name. .
and user_ind_columns。.table_name = user_indexes。.table_name。.
order by user_indexes. . Table_type, user_indexes. . Table_name,. .
user_indexes。.index_name, column_position;。.
150. . How to monitor the SGA's hit rate? . .
select a。.value + b。.value "logical_reads", c。.value "phys_reads",。.
round (100 * ((a.. value + b.. value)-c.. value) / (a.. value + b.. value)) "BUFFER HIT RATIO". .
from v$sysstat a, v$sysstat b, v$sysstat c。.
where a. . Statistic # = 38 and b. . Statistic # = 39. .
and c。.statistic# = 40;。.
151. . How to monitor the SGA in the dictionary buffer hit ratio? . .
select parameter, gets,Getmisses , getmisses/(gets+getmisses)*100 "miss ratio",。.
(1 - (sum (getmisses) / (sum (gets) + sum (getmisses ))))* 100 "Hit ratio". .
from v$rowcache。.
where gets + getmisses <> 0. .
group by parameter, gets, getmisses;。.
152. . How to monitor the SGA in shared buffer hit ratio should be less than 1%? . .
select sum(pins) "Total Pins", sum(reloads) "Total Reloads",。.
sum (reloads) / sum (pins) * 100 libcache. .
from v$librarycache;。.
select sum (pinhits-reloads) / sum (pins) "hit radio", sum (reloads) / sum (pins) "reload percent". .
from v$librarycache;。.
153. . How to display all the database objects of the type and size? . .
select count(name) num_instances ,type ,sum(source_size) source_size ,。.
sum (parsed_size) parsed_size, sum (code_size) code_size, sum (error_size) error_size,. .
sum(source_size) +sum(parsed_size) +sum(code_size) +sum(error_size) size_required。.
from dba_object_size. .
group by type order by 2;。.
154. . Monitoring SGA in the redo log buffer hit ratio should be less than 1%. .
SELECT name, gets, misses, immediate_gets, immediate_misses,。.
Decode (gets, 0,0, misses / gets * 100) ratio1,. .
Decode(immediate_gets+immediate_misses,0,0,。.
immediate_misses / (immediate_gets + immediate_misses) * 100) ratio2. .
FROM v$latch WHERE name IN ('redo allocation', 'redo copy');。.
155. . Monitoring memory and hard disk sort ratio, it is less than the best. .10, An increase sort_area_size. .
SELECT name, value FROM v$sysstat WHERE name IN ('sorts (memory)', 'sorts (disk)');。.
156. . How to monitor who is running what the current database SQL statement? . .
SELECT osuser, username, sql_text from v$session a, v$sqltext b。.
where a. . Sql_address = b. . Address order by address, piece;. .
157. How to monitor a dictionary buffer?.
SELECT (SUM (PINS - RELOADS)) / SUM (PINS) "LIB CACHE" FROM V $ LIBRARYCACHE;. .
SELECT (SUM(GETS - GETMISSES - USAGE - FIXED)) / SUM(GETS) "ROW CACHE" FROM V$ROWCACHE;。.
SELECT SUM (PINS) "EXECUTIONS", SUM (RELOADS) "CACHE MISSES WHILE EXECUTING" FROM V $ LIBRARYCACHE;. .
The latter by the former, this ratio is less than 1%, close to 0% as well.
SELECT SUM (GETS) "DICTIONARY GETS", SUM (GETMISSES) "DICTIONARY CACHE GET MISSES". .
FROM V$ROWCACHE。.
158. . Monitoring MTS. .
select busy/(busy+idle) "shared servers busy" from v$dispatcher;。.
This value is greater than 0. .5, The parameters need to increase. .
select sum(wait)/sum(totalq) "dispatcher waits" from v$queue where type='dispatcher';。.
select count (*) from v $ dispatcher;. .
select servers_highwater from v$mts;。.
servers_highwater close mts_max_servers, the parameters need to increase. .
159. How do I know if the current user's ID number?.
SQL> SHOW USER;. .
OR。.
SQL> select user from dual;. .
160. How to view the pieces with a high degree of table?.
SELECT segment_name table_name, COUNT (*) extents. .
FROM dba_segments WHERE owner NOT IN ('SYS', 'SYSTEM') GROUP BY segment_name。.
HAVING COUNT (*) = (SELECT MAX (COUNT (*)) FROM dba_segments GROUP BY segment_name);. .
162. How do I know if a table is stored in a table space?.
select segment_name, sum (bytes), count (*) ext_quan from dba_extents where. .
tablespace_name='&tablespace_name' and segment_type='TABLE' group by。.
tablespace_name, segment_name;. .
163. How do I know if the index is stored in a table space?.
select segment_name, count (*) from dba_extents where segment_type = 'INDEX' and owner = '& owner'. .
group by segment_name;。.
164, how many users that use the CPU session?. .
11 is the cpu used by this session.
select a. . Sid, spid, status, substr (a.. Program, 1,40) prog, a. . Terminal, osuser, value/60/100 value. .
from v$session a,v$process b,v$sesstat c。.
where c. . Statistic # = 11 and c. . Sid = a. . Sid and a. . Paddr = b. . Addr order by value desc;. .
165. How do I know if the listener log file?.
To 8I example. .
$ORACLE_HOME/NETWORK/LOG/LISTENER。.LOG。.
166. . How do I know the listener parameter file?. .
A case study in 8I.
$ ORACLE_HOME / NETWORK / ADMIN / LISTENER. . ORA. .
167. How do I know if TNS connect file?.
To 8I example. .
$ORACLE_HOME/NETWORK/ADMIN/TNSNAMES。.ORA。.
168. . How do I know Sql * Net environment file?. .
A case study in 8I.
$ ORACLE_HOME / NETWORK / ADMIN / SQLNET. . ORA. .
169. How do I know if the warning log file?.
To 8I example. .
$ORACLE_HOME/ADMIN/SID/BDUMP/SIDALRT。.LOG。.
170. . How do I know the basic structure?. .
A case study in 8I.
$ ORACLE_HOME / RDBMS / ADMIN / STANDARD. . SQL. .
171. How do you know that set up a data dictionary view?.
To 8I example. .
$ORACLE_HOME/RDBMS/ADMIN/CATALOG。.SQL。.
172. . How can I set up the audit with the data dictionary view?. .
A case study in 8I.
$ ORACLE_HOME / RDBMS / ADMIN / CATAUDIT. . SQL. .
173. How do I know if the establishment of a snapshot of data dictionary view?.
To 8I example. .
$ORACLE_HOME/RDBMS/ADMIN/CATSNAP。.SQL。.
The talk mainly about the SQL statement optimization! Mainly based on ORACLE9I of. .
174. /*+ALL_ROWS*/。.
Show that the choice of the block cost-based optimization method, and the best throughput, minimize consumption of resources. . For example:. .
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='CCBZZP';。.
175. . / * + FIRST_ROWS * /. .
Indicates the statement block select cost-based optimization methods, and get the best response time, the resource consumption is minimized. for example:.
SELECT / * + FIRST_ROWS * / EMP_NO, EMP_NAM, DAT_IN FROM BSEMPMS WHERE EMP_NO = 'CCBZZP';. .
176. /*+CHOOSE*/。.
That if the data dictionary tables have access to statistical information, cost-based optimization method, and get the best throughput; that if the data dictionary. .
There is no access to the table of statistics, the cost will be based on the rule of optimization methods; for example:.
SELECT / * + CHOOSE * / EMP_NO, EMP_NAM, DAT_IN FROM BSEMPMS WHERE EMP_NO = 'CCBZZP';. .
177. /*+RULE*/。.
Show that the choice of the block rule-based optimization method. . For example:. .
SELECT /*+ RULE */ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='CCBZZP';。.
178. . / * + FULL (TABLE) * /. .
Indicates that the table select global scan.. for example:.
SELECT / * + FULL (A) * / EMP_NO, EMP_NAM FROM BSEMPMS A WHERE EMP_NO = 'CCBZZP';. .
179. /*+ROWID(TABLE)*/。.
Suggest a clear demonstration of the specified table is based on ROWID visit. . For example:. .
SELECT /*+ROWID(BSEMPMS)*/ * FROM BSEMPMS WHERE ROWID>='AAAAAAAAAAAAAA'。.
AND EMP_NO = 'CCBZZP';. .
180. /*+CLUSTER(TABLE)*/。.
. .
Tip clearly indicate on the specified table select cluster scan access method, it is only valid for the cluster objects. for example:.
SELECT / * + CLUSTER * / BSEMPMS. . EMP_NO, DPT_NO FROM BSEMPMS, BSDPTMS. .
WHERE DPT_NO='TEC304' AND BSEMPMS。.DPT_NO=BSDPTMS。.DPT_NO;。.
181. . / * + INDEX (TABLE INDEX_NAME) * /. .
Select the index on a table scan. for example:.
SELECT / * + INDEX (BSEMPMS SEX_INDEX) USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS * / FROM. .
BSEMPMS WHERE SEX='M';。.
182. . / * + INDEX_ASC (TABLE INDEX_NAME) * /. .
Select the index on a table by scanning method in ascending order.. for example:.
SELECT / * + INDEX_ASC (BSEMPMS PK_BSEMPMS) * / FROM BSEMPMS WHERE DPT_NO = 'CCBZZP';. .
183. /*+INDEX_COMBINE*/。.
Select the bitmap for the specified table access pass, if INDEX_COMBINE does not provide the index as a parameter, will select a Boolean combination of bitmap indexes. .
.. For example:.
SELECT / * + INDEX_COMBINE (BSEMPMS SAL_BMI HIREDATE_BMI) * / * FROM BSEMPMS. .
WHERE SAL <5000000 and hiredate。. and="">
184. . / * + INDEX_JOIN (TABLE INDEX_NAME) * /. .
Tip specific command the optimizer to use the index as access path.. for example:.
SELECT / * + INDEX_JOIN (BSEMPMS SAL_HMI HIREDATE_BMI) * / SAL, HIREDATE. .
FROM BSEMPMS WHERE SAL <60000;。.>
185. . / * + INDEX_DESC (TABLE INDEX_NAME) * /. .
Select the index on a table by scanning method in descending order.. for example:.
SELECT / * + INDEX_DESC (BSEMPMS PK_BSEMPMS) * / FROM BSEMPMS WHERE DPT_NO = 'CCBZZP';. .
186. /*+INDEX_FFS(TABLE INDEX_NAME)*/。.
The implementation of the specified table index fast full scan, rather than a full table scan approach. . For example:. .
SELECT /*+INDEX_FFS(BSEMPMS IN_EMPNAM)*/ * FROM BSEMPMS WHERE DPT_NO='TEC305';。.
187. . / * + ADD_EQUAL TABLE INDEX_NAM1, INDEX_NAM2,. .* /. .
Prompt explicitly implementation planning choices, several single-column index scan.. for example:.
SELECT / * + INDEX_FFS (BSEMPMS IN_DPTNO, IN_EMPNO, IN_SEX) * / * FROM BSEMPMS WHERE EMP_NO = 'CCBZZP' AND. .
DPT_NO='TDC306';。.
188. . / * + USE_CONCAT * /. .
On the query's WHERE conditions OR later converted to combine ALL of the UNION. for example: query.
SELECT / * + USE_CONCAT * / * FROM BSEMPMS WHERE DPT_NO = 'TDC506' AND SEX = 'M';. .
189. /*+NO_EXPAND*/。.
For behind the OR WHERE IN-LIST or query statement, NO_EXPAND to prevent the optimizer be extended based. . For example:. .
SELECT /*+NO_EXPAND*/ * FROM BSEMPMS WHERE DPT_NO='TDC506' AND SEX='M';。.
190. . / * + NOWRITE * /. .
Prohibition on query block query rewriting.
191. . / * + REWRITE * /. .
You can view as a parameter.
192. . / * + MERGE (TABLE) * /. .
To view individual queries to the appropriate merge. for example:.
SELECT / * + MERGE (V) * / A. . EMP_NO, A. . EMP_NAM, B. . DPT_NO FROM BSEMPMS A (SELET DPT_NO..
,AVG(SAL) AS AVG_SAL FROM BSEMPMS B GROUP BY DPT_NO) V WHERE A。.DPT_NO=V。.DPT_NO。.
AND A. . SAL> V. . AVG_SAL;. .
193. /*+NO_MERGE(TABLE)*/。.
For no longer can merge the view of the merger. . For example:. .
SELECT /*+NO_MERGE(V) */ A。.EMP_NO,A。.EMP_NAM,B。.DPT_NO FROM BSEMPMS A (SELET DPT_NO。.
, AVG (SAL) AS AVG_SAL FROM BSEMPMS B GROUP BY DPT_NO) V WHERE A. . DPT_NO = V. . DPT_NO. .
AND A。.SAL>V。.AVG_SAL;。.
194. . / * + ORDERED * /. .
According to the table to appear in the order in the FROM, ORDERED according to the order of the ORACLE on it.. for example:.
SELECT / * + ORDERED * / A. . COL1, B. . COL2, C. . COL3 FROM TABLE1 A, TABLE2 B, TABLE3 C. .
WHERE A。.COL1=B。.COL1 AND B。.COL1=C。.COL1;。.
195. . / * + USE_NL (TABLE) * /. .
Adds the specified table and the nested row source of a connection to connect to the specified table as internal tables. for example:.
SELECT / * + ORDERED USE_NL (BSEMPMS) * / BSDPTMS. . DPT_NO, BSEMPMS. . EMP_NO, BSEMPMS. . EMP_NAM FROM. .
BSEMPMS,BSDPTMS WHERE BSEMPMS。.DPT_NO=BSDPTMS。.DPT_NO;。.
196. . / * + USE_MERGE (TABLE) * /. .
Adds the specified table and other line sources connected through merge sort.. for example:.
SELECT / * + USE_MERGE (BSEMPMS, BSDPTMS) * / * FROM BSEMPMS, BSDPTMS WHERE. .
BSEMPMS。.DPT_NO=BSDPTMS。.DPT_NO;。.
197. . / * + USE_HASH (TABLE) * /. .
Adds the specified source table and the other line connection via hash.. for example:.
SELECT / * + USE_HASH (BSEMPMS, BSDPTMS) * / * FROM BSEMPMS, BSDPTMS WHERE. .
BSEMPMS。.DPT_NO=BSDPTMS。.DPT_NO;。.
198. . / * + DRIVING_SITE (TABLE) * /. .
Forces with Oracle in the selected location different tables for query execution. as:.
SELECT / * + DRIVING_SITE (DEPT) * / * FROM BSEMPMS, DEPT @ BSDPTMS WHERE BSEMPMS. . DPT_NO = DEPT. . DPT_NO;. .
199. /*+LEADING(TABLE)*/。.
Connect the specified table as the first order in the table. .
200. /*+CACHE(TABLE)*/。.
When the full-table scan, CACHE prompted able to retrieve the table block placed in the buffer cache LRU list in least recently used end of the most recent example:. .
SELECT/* + FULL (BSEMPMS) CAHE (BSEMPMS) */EMP_NAM FROM BSEMPMS; World Cup 2006 was perhaps the fertilizer's last World Cup, Zidane when compared to Real Madrid team-mates nearly perfect curtain farewell, this Cup is perhaps the greatest of his life. Fertilizer nickname is given the most fans acrid gifts, like with the Hall with the scalpel cut his beautiful coat layers, cut his deep self-respect, then inserts his heart until the soul. Memories of his fans is always smiling, never heard of provocation to the fans. . .
It seems to me that this fist is not what others, playing himself, raging behind for the State has fallen after the frustration and even despair. Sad eyes show such a scene, a scarred Wolf, aggressive in the cold wind still watching the night sky, cool Moonlight in it, the snow is dragged out of a long shadow.
He is early 30s, the cheer, many people are saying. No one can accept the age of 17 who gained world renown of the young killer, in Eindhoven, Barcelona, Inter Milan and Real Madrid marched in elegant dance pierced again and again the goal of the alien opponents in the thirty year old into a Ronaldo. No one can accept that trademark in Barcelona when Ronaldo scored a swan song. .
But people forget, even the machine also has a day in the life of the aging, defensive technology with a violent, brutal and vicious foul, the game's strength and speed of the transition, I do not know than Pele and Diego Maradona era exceeds the number of times. His early fame than Zidane almost 10 years, affected by the extent to which competitors attention seems to be no respect of Zidane can be compared, frequent transmission speed itself more vulnerable to injury of muscle and tendon key, wounds is estimated to be an old Red Army. Previously saw him, at least four or five people to grab.
98 when the World Cup only 21 year old youth has become the patron saint of Brazil, the defending champion, shoulder almost all the pressure of supporting the defending champion. Although the final mental collapse of the match for host France lost the trophy, but I think a 21-year-old has never been an official in the World Cup finals appearance in the small youth mental load in case of high achieve such results, no reason and all position to blame him. .
After a serious injury in 2002 World Cup historic created eight goals and lead Brazil Gets world champion, has been pretty amazing. Puladini when time said he has from one full of creativity affects the entire match race completely reduced to an opportunistic killers. This is true, however puladini was never takes into account each other's body have been harmed by far not the most players. Besides economic pressure on the players need to better protect themselves, and opportunism is a means of protecting himself.
In fact, all people have the opportunity to see from 17 to 30 and the drop path, Platini to see, but people are unwilling to accept the total generation of world number one will leave the truth. Maradona's farewell as did a lot of people are suffering, our people still are eager to see the miracle of the resurrection of Jesus. .
In the 1970s, peers, keep in mind that Ronaldo, he accompanied us to grow together, have brought us new unlimited football enjoyed Visual impact.
Ronaldo, all the best. House-breaking in the software park to go to work fast for 2 years, and downstairs is the site of Guangzhou NetEase. Working hours can often see the small red and purple boss, who often found alone, in the public security chief called "a national security one of the best cities" of Guangzhou, so bold and not afraid of being kidnapped actually really admire it . But also very curious about how China's rich sense of safety so bad. Mr. Mo Feiding is a martial arts master? . .
Have seen park outside a group dressed in camouflage uniforms of your'e (look for vertical look like military police) in the check in and out of the Park's ID card or temporary residence permit, a 2-bit colleague because without going through the temporary residence permit, and they grabbed. Do not know whether Mr. Ding is this group of people to do a temporary residence permit will be able to view it? prtconf into memory as well as other information about your system configuration.
pmstat can see the number and the CPU load. 21st Century Chinese mouth, in addition to "fuck" and pig bones, the source is probably spit up "globalization, internationalization," the shit was. .
From Legend to Lenovo, the CEO, from China a share to NASDAQ, the famous Lenovo seems to be completed with a shotgun to Yang gun completely like evolution. Revolution is a success, although corporate profits have been reduced, the Abbot of the Temple of the rich and poor treatment goes far beyond the General internationalization.
Do not know since when the unit price of our city quietly from RMB into U.S. dollar, of course, the people there are eager for medical expenses, children's school fees. To the process of globalization of our salary Quedui unparalleled contempt, for many years has been immense patriotism, the banner of Mao Yeye has been strong, enjoy the glorious honor of the taxpayers (even if only one confused the shit officials carried away gift) to suffering into joy, support the social insurance. .
The above argument too dark, we can see many domestic firms bold and went in a globalized market achieved his ambition. Domestic no lack of Huawei, ZTE and Haier so successful enterprise.
But always feel like the rich or the power of globalization is the game, is the strong crush the weak for the trick. But I still believe that China is born with the temperament of the large and powerful, and will be in this game are huge gains. .
I also believe that the whole earth community, including the person's social, social or even pigs forest society (materialist who thinks fixing, plant no spirituality does not exist in society, can I trust the Buddha said every sand which has one of the world), is generally consistent with the law of conservation of energy, I am talking about energy, both the mechanical energy of electromagnetic energy and nuclear energy, and so on classic quantum of energy (I call this energy for hard), but also includes money gold these allow the energy to push a ghost (I called this soft energy).
According to this logic, the United States strong, Europe and the world powers of the total energy must be deprived of a considerable part. Similarly, a strong Japan, and China is suffering the (former military invasion, and now may not be called the economic invasion, along with China's powerful lower this relationship for the mutual advantage). .
No matter what, it was certainly intensified globalization luck, I do not believe that it is the Chinese people, not necessarily what Chinese luck, perhaps the other species on our planet luck, then is the earth itself is bad, and the last is all exceedingly. At that time really world communism, but is not a Marxist communism is the deterioration of the living environment, let the cow b called human being degraded to a primitive society of species.
This is not alarmist, but the staple of crap, just laugh. One day on-line journey of the spirit, the endless of N-dimensional space viewing the lake, Hong Jin-Jin Luo. Collection unexpectedly startled glance of a sunflower, "want to practice divine, we must first..", Non-pain of ear, is a guard against complaints. .
This axiom is 1 + 1 equals 2, who, so not out of the mouth and not through the mouth. Complained of Mo than opium importers, sweet, sweet success difficult to abandon their habits, and even beyond them.
Where to complain of the power, line the road of doing things, though not as powerless power, or can make out alive, although the defeat, or may have been a little way, in order to Dongshan to play a. .
Remember remember. This is a small example of the work, its network google out stuff and put it into my notebook blog above, should not be in breach of work discipline?.
High-tech stuff has nothing to say, are common gadgets. .
The use of solaris email service to send mail, the this blog in other articles, interested can look at.
CREATE OR REPLACE PROCEDURE P_ALERT_BYMAIL (..
StatDate IN DATE。.
). .
AS。.
V_RPT_ID CF_RPT_NAME. . CN_NAME% TYPE;. .
V_EXCEPTION_FEAT CF_FEAT_NAME。.CN_NAME%TYPE;。.
V_MAX_VAL CF_PORTAL_CFG. . MAX_VAL% TYPE;. .
V_MIN_VAL CF_PORTAL_CFG。.MIN_VAL%TYPE;。.
V_MAIL_LIST CF_PORTAL_CFG. . MAIL_LIST% TYPE;. .
V_RECEIVER_AREAID CF_PORTAL_CFG。.RECEIVER_AREAID%TYPE;。.
V_TIME_TYPE CF_EXCEPTION_MAP_RPT. . TIME_TYPE% TYPE;. .
V_MAIN_SQL CF_FACT_DIM。.MAIN_SQL%TYPE; 。.
V_WHERE_TIME_NAME CF_FACT_DIM. . WHERE_TIME_NAME% TYPE;. .
V_WHERE_AREA_NAME CF_FACT_DIM。.WHERE_AREA_NAME%TYPE; 。.
V_WHERE_OTHERS CF_FACT_DIM. . WHERE_OTHERS% TYPE;. .
V_GROUP_BY_SQL CF_FACT_DIM。.GROUP_BY_SQL%TYPE; 。.
V_HAS_TIME_TYPE CF_FACT_DIM. . HAS_TIME_TYPE% TYPE;. .
V_GET_DIM_STR CF_FACT_DIM。.GET_DIM_STR%TYPE; 。.
V_DIM_NAME_STR CF_FACT_DIM. . DIM_NAME_STR% TYPE;. .
v_sqlstmt varchar2(2000);。.
v_result number;. .
v_resultmsg varchar2(2500);。.
v_msgheader varchar2 (512);. .
v_command varchar2(3000);。.
v_count number;. .
v_dim_result varchar2(1024);。.
cursor V_cur is. .
SELECT d。.CN_NAME,。.
e. . CN_NAME,. .
a。.MAX_VAL,。.
a. . MIN_VAL,. .
a。.MAIL_LIST,。.
a. . RECEIVER_AREAID,. .
b。.TIME_TYPE, 。.
c. . MAIN_SQL,. .
c。.WHERE_TIME_NAME ,。.
c. . WHERE_AREA_NAME,. .
c。.WHERE_OTHERS , 。.
c. . GROUP_BY_SQL,. .
c。.HAS_TIME_TYPE,。.
c. . GET_DIM_STR,. .
c。.DIM_NAME_STR。.
FROM CF_PORTAL_CFG a, CF_EXCEPTION_MAP_RPT b, CF_FACT_DIM c, CF_RPT_NAME d, CF_FEAT_NAME e. .
where a。.RPT_ID=b。.RPT_ID and a。.EXCEPTION_FEAT=b。.EXCEPTION_FEAT 。.
and a. . EXCEPTION_FEAT = b. . EXCEPTION_FEAT. .
and a。.RPT_ID=d。.ID and a。.EXCEPTION_FEAT=e。.ID。.
and a. . EXCEPTION_FEAT = c. . EXCEPTION_FEAT;. .
v_curid NUMBER;。.
d NUMBER;. .
v_error_code NUMBER;。.
v_error_message VARCHAR2 (255);. .
v_format_stat_time VARCHAR2(20);。.
L_NAME VARCHAR2 (128): = DBMS_SCHEDULER. . GENERATE_JOB_NAME;. .
L_FILE UTL_FILE。.FILE_TYPE;。.
L_PATH_NO_SLASH VARCHAR2 (512);. .
BEGIN。.
- To enable this procedure, need to grant below authority to crg. .
--grant execute on dbms_lock to crg。.
- Grant create job to crg. .
--grant create external job to crg。.
- Grant select on DBA_DIRECTORIES to crg. .
--CREATE OR REPLACE DIRECTORY my_docs AS '/export/home/oracle',it can be any folder that oracle user can access。.
- Create an empty file named send_mail. . Sh with mode 777. .
OPEN V_cur;。.
LOOP. .
BEGIN。.
FETCH V_cur INTO V_RPT_ID, V_EXCEPTION_FEAT, V_MAX_VAL, V_MIN_VAL, V_MAIL_LIST, V_RECEIVER_AREAID, V_TIME_TYPE,. .
V_MAIN_SQL,V_WHERE_TIME_NAME,V_WHERE_AREA_NAME,V_WHERE_OTHERS,V_GROUP_BY_SQL,V_HAS_TIME_TYPE,。.
V_GET_DIM_STR, V_DIM_NAME_STR;. .
EXIT WHEN V_cur%NOTFOUND;。.
if V_MAX_VAL is not null or V_MIN_VAL is not null then. .
if V_GET_DIM_STR is not null then。.
v_sqlstmt: = 'select' | | V_GET_DIM_STR | | ',';. .
else。.
v_sqlstmt: = 'select';. .
end if;。.
v_sqlstmt: = v_sqlstmt | | V_MAIN_SQL | | 'where';. .
if V_HAS_TIME_TYPE = 0 then。.
if V_TIME_TYPE = 0 then. .
v_sqlstmt := v_sqlstmt||'substr('||V_WHERE_TIME_NAME||',1,4)='''||to_char(StatDate,'yyyy')||'''';。.
v_format_stat_time: = to_char (StatDate, 'yyyy')||' years';. .
elsif V_TIME_TYPE = 1 then。.
v_sqlstmt: = v_sqlstmt | | 'substr (' | | V_WHERE_TIME_NAME | | ', 1,6 )='''|| to_char (StatDate,' yyyymm')||'''';。 .
V_format_stat_time: = to_char (StatDate, ' yyyy ') || ' ' || to_char (StatDate, ' mm ') || ' month ';.
elsif V_TIME_TYPE = 2 then. .
v_sqlstmt := v_sqlstmt||'substr('||V_WHERE_TIME_NAME||',1,8)='''||to_char(StatDate,'yyyymmdd')||'''';。.
v_format_stat_time: = to_char (StatDate, 'yyyymm');. .
V_format_stat_time: = to_char (StatDate, ' yyyy ') || ' ' || to_char (StatDate, ' mm ') || '-' || to_char (StatDate, ' mm ') || ' day ';.
end if;. .
if V_RECEIVER_AREAID is not null then。.
v_sqlstmt: = v_sqlstmt | | 'and' | | V_WHERE_AREA_NAME ||'='''|| V_RECEIVER_AREAID ||'''';。 .
end if;。.
if V_WHERE_OTHERS is not null then. .
v_sqlstmt := v_sqlstmt||' and '||V_WHERE_OTHERS;。.
end if;. .
if V_GROUP_BY_SQL is not null then。.
v_sqlstmt: = v_sqlstmt | | 'group by' | | V_GROUP_BY_SQL;. .
end if;。.
else. .
if V_TIME_TYPE = 0 then。.
v_sqlstmt: = v_sqlstmt | | V_WHERE_TIME_NAME ||'='''|| to_char (StatDate, 'yyyy')||'''';。 .
V_format_stat_time: = to_char (StatDate, ' yyyy ') || ' years ';.
elsif V_TIME_TYPE = 1 then. .
v_sqlstmt := v_sqlstmt||V_WHERE_TIME_NAME||'='''||to_char(StatDate,'yyyymm')||'''';。.
v_format_stat_time: = to_char (StatDate, 'yyyy')||' years' | | to_char (StatDate, 'mm')||' months';. .
elsif V_TIME_TYPE = 2 then。.
v_sqlstmt: = v_sqlstmt | | V_WHERE_TIME_NAME ||'='''|| to_char (StatDate, 'yyyymmdd')||'''';。 .
V_format_stat_time: = to_char (StatDate, ' yyyy ') || ' ' || to_char (StatDate, ' mm ') || '-' || to_char (StatDate, ' mm ') || ' day ';.
end if;. .
if V_RECEIVER_AREAID is not null then。.
v_sqlstmt: = v_sqlstmt | | 'and' | | V_WHERE_AREA_NAME ||'='''|| V_RECEIVER_AREAID ||'''';。 .
end if;。.
if V_WHERE_OTHERS is not null then. .
v_sqlstmt := v_sqlstmt||' and '||V_WHERE_OTHERS;。.
end if;. .
if V_GROUP_BY_SQL is not null then。.
v_sqlstmt: = v_sqlstmt | | 'group by' | | V_GROUP_BY_SQL;. .
end if;。.
end if;. .
v_resultmsg := '';。.
if V_MAX_VAL is not null then. .
v_sqlstmt := 'select dim,result from ('||v_sqlstmt||') where result>'||V_MAX_VAL;。.
end if;. .
if V_MIN_VAL is not null then。.
v_sqlstmt: = v_sqlstmt | | 'or result <' | | V_MIN_VAL;. .
end if;。.
v_curid: = dbms_sql. . Open_cursor;. .
dbms_sql。.parse(v_curid,v_sqlstmt,dbms_sql。.v7);。.
dbms_sql. . Define_column (v_curid, 1, v_dim_result, 1024);. .
dbms_sql。.define_column(v_curid,2,v_result);。.
d: = dbms_sql. . Execute (v_curid);. .
v_count :=0;。.
LOOP. .
if dbms_sql。.fetch_rows(v_curid) = 0 then。.
exit; - No, exit the loop. .
end if;。.
dbms_sql. . Column_value (v_curid, 1, v_dim_result);. .
dbms_sql。.column_value(v_curid,2,v_result);。.
if v_count> 5 then. .
exit;。.
end if;. .
v_resultmsg := v_resultmsg||v_dim_result||' '||v_result||'\n';。.
v_count: = v_count + 1;. .
END LOOP; 。.
dbms_sql. . Close_cursor (v_curid);. .
v_msgheader := '';。.
if length (v_resultmsg)> 0 then. .
V_msgheader: = V_RPT_ID || ' \n ' || ' ' || report time v_format_stat_time || ' \n ' || ': ' || V_EXCEPTION_FEAT || ' \n ';.
if V_MAX_VAL is not null then. .
V_msgheader: = v_msgheader || ': ' | ceiling | power trim (to_char (V_MAX_VAL, ' 999999999 ')) || ' \n ';.
end if;. .
if V_MIN_VAL is not null then。.
v_msgheader: = v_msgheader | | 'minimum patriarch:' | | trim (to_char (V_MIN_VAL, '999999999'))||' \ n ';. .
end if;。.
v_sqlstmt: = 'select' | | V_DIM_NAME_STR | | 'from dual';. .
execute immediate v_sqlstmt into V_DIM_NAME_STR;。.
v_resultmsg: = V_DIM_NAME_STR | | '\ n' | | v_resultmsg;. .
v_resultmsg := v_msgheader || v_resultmsg; 。.
V_MAIL_LIST: = replace (V_MAIL_LIST ,';',',');。 .
SELECT DECODE(SUBSTR(D。.DIRECTORY_PATH, LENGTH(D。.DIRECTORY_PATH)),。.
'/',。 .
substr(D。.DIRECTORY_PATH,1,LENGTH(D。.DIRECTORY_PATH)-1),。.
D. . DIRECTORY_PATH). .
INTO L_PATH_NO_SLASH。.
FROM DBA_DIRECTORIES D. .
WHERE D。.DIRECTORY_NAME = 'MY_DOCS';。.
L_FILE: = UTL_FILE. . FOPEN ('MY_DOCS', 'send_mail.. Sh', 'w', 32767);. .
UTL_FILE。.PUT_LINE(L_FILE, '#!/bin/sh');。.
- V_command: = 'echo "hialex" | mailx-s "it is alex"' | | V_MAIL_LIST;. .
V_command: = ' echo "' || v_resultmsg || '" | mailx-s "report warning" ' || V_MAIL_LIST;.
UTL_FILE. . PUT_LINE (L_FILE, v_command);. .
UTL_FILE。.FFLUSH(L_FILE);。.
UTL_FILE. . FCLOSE (L_FILE);. .
DBMS_SCHEDULER。.CREATE_JOB(。.
JOB_NAME => L_NAME,. .
JOB_ACTION => L_PATH_NO_SLASH || '/send_mail。.sh',。.
JOB_TYPE => 'EXECUTABLE',. .
ENABLED => TRUE,。.
AUTO_DROP => TRUE. .
);。.
- DBMS_SCHEDULER. . RUN_JOB (L_NAME, FALSE);. .
select count(*) into v_count from ALL_SCHEDULER_JOBS where job_name = L_NAME;。.
if v_count> 0 then. .
while v_count > 0 loop。.
dbms_lock. . Sleep (1);. .
select count(*) into v_count 。.
from ALL_SCHEDULER_RUNNING_JOBS. .
where job_name = L_NAME;。.
end loop;. .
dbms_scheduler。.drop_job(L_NAME, TRUE);。.
end if;. .
insert into dt_alert_log(msg_date,alert_msg,is_ok) values(sysdate,substr(v_command,1,1000),1);。.
commit;. .
end if;。.
end if;. .
END;。.
END LOOP;. .
CLOSE V_cur; 。.
COMMIT;. .
EXCEPTION。.
WHEN OTHERS THEN. .
rollback;。.
IF dbms_sql. . Is_open (v_curid) THEN. .
dbms_sql。.close_cursor(v_curid);。.
END IF;. .
v_error_code := SQLCODE ;。.
v_error_message: = SQLERRM;. .
dbms_output。.put_line('SQLCODE='||v_error_code);。.
dbms_output. . Put_line ('SQLERRM =' | | v_error_message);. .
select count(*) into v_count from ALL_SCHEDULER_JOBS where job_name = L_NAME;。.
if v_count> 0 then. .
dbms_scheduler。.drop_job(L_NAME, TRUE);。.
end if;. .
insert into dt_alert_log(msg_date,alert_msg,is_ok) values(sysdate,substr(v_command,1,1000),0);。.
commit;. .
END P_ALERT_BYMAIL;。.
/. .
Is this a broken things, I had one and a half days, hematemesis. However thanks to function correctly.
To / etc / mail directory editor sendmail. . Cf file. .
Find # Dj $ .Foo .COM w.., followed by add Dj $ cn. .ao. .ericsson. .se.
Find DSmailhost $? M. . $ M $. ., Comment, add DSse-smtp. . Ericsson. . Se. .
Modifications, and then restart the mail service.
/ Etc / init. .d / sendmail restart. .
Any user can execute the following commands similar to outgoing mail.
mailx-s "test mail" alex. . Lam @ siemens. . Com <`echo / etc / hosts` 1). .
SQL> select username,count(*) from v$session group by username;。.
USERNAME COUNT (*). .
------------------------------ ----------。.
SYSTEM 2. .
14.
CBD 30. .
CRG 1。.
SKPORTAL 20. .
SQL> select sid,serial# from v$session where username='CRG';。.
SID SERIAL #. .
---------- ----------。.
293 704. .
SQL> alter system kill session '293,704';。.
2). .
select object_id,session_id,locked_mode from v$locked_object;。.
select t2. . Username, t2. . Sid, t2. . Serial #, t2. . Logon_time. .
from v$locked_object t1,v$session t2。.
where t1. . Session_id = t2. . Sid. .
order by t2。.logon_time;。.
select t1. . Object_name, t2. . Session_id, t2. . Locked_mode. .
from dba_objects t1,v$locked_object t2。.
where t1. . Object_id = t2. . Object_id;. .
select t3。.object_name,T3。.object_type,t2。.username,t2。.sid,t2。.serial#,。.
t2. . Logon_time. .
from dba_objects t3,v$locked_object t1,v$session t2 。.
where t1. . Session_id = t2. . Sid. .
and t3。.object_id=t1。.object_id order by t2。.logon_time;。.
Confirmed, then it can be. .
alter system kill session (sid,serial#);。.
To kill the session. .
SQL> set serverout on 。.
Inside the stored procedure to add dbms_output. . Put_line statements, we can do as printf to print the information. .
dbms_output。.put_line('alex lin'); 。.
"7 Sharp-point player, passed the 9 players, 9 players, also called Sharp, they may be brothers. A lot of brothers are active in football, such as the Netherlands, De Boer brothers, Ireland, Keane brothers. Good ball, the ball 10 travels very well. Hey, how No. 10, also known as Sharp. may be so, the foreign players is printed on the shirt on the family name, family name of these Sharp players, like South Korea, many players have the surname Park. beautiful, even had two crew on the 10th, scoring, 11, came forward to congratulate, on the 11th is - Sharp? (Big pause will) I'm sorry, dear viewers, Sharp are printed on the shirt sponsorship business name..
"Ownership" is the u.s. Government's official target, such as the 1998 living quality and work obligations Act clearly pointed out: "the State should promote the following objectives: … for all citizens to provide decent, affordable housing. "The essence here is" affordable. " The u.s. Government believes that: If a household, housing expenditures exceed 30 per cent of the revenue, it belongs to the excessive burden of the "shelter". At present, according to statistics, the proportion of households in the United States has been reduced to an average of 23%. In other words, the United States basically implements the "affordable housing".
This is how to do it? I summed up the U.S. government's housing policy has three pillars, the first of which is to make people easier access to mortgages. Common sense tells us that if a person money to buy a commodity, the best emergency measures, is to borrow money to him. If not convenient to lend him our own, should at least encourage others - such as banks - borrow money to him. And so, when people generally can not afford a house, the government should encourage banks lending to people, to lower the down payment and interest loans, not turn to tighten credit. .
Historically, the United States first housing policies in the 1930s great depression, without exception, is to try to increase the supply of housing loans. The first is in 1932 by the Federal Home Loan Bank Act, the country has established 12 "Federal Home Loan Bank." This 12 banks can be described as the "Bank", a membership system, where housing loans by a bank or other financial institutions can become a member become shareholders. Its operational mode: 12 Federal home loan bank bonds issued by the Ministry of finance, specifically to low-cost financing, these low-interest loans to members of the Bank for payment of housing loan. . Today, a total of more than 8,000 U.S. financial institutions are members of the system, accounting for 80% of financial institutions. They each received from the Federal Home Loan Bank of billions of dollars in low-interest financing. .
Some people might ask: why do countries established this 12 banks are not issued directly to the residents of the original mortgage?, Americans are aware of the State-owned enterprises of birth defects. 12 Federal home loan banks to adopt national and civic hybrid management system with strong State-owned enterprise property. If you let them directly to millions of households at the end of the payment of low-interest loans, in all likelihood be spamming, God knows what will come up for bad debts? first, to a private bank, let them go and deal with the final household, more solid guarantees.
Although the system can reduce the mortgage interest, but not solve another problem: the down payment! Most commercial banks require 30% down payment. A new person to work for many years to live frugally to save Qi down payment, during which he must have been spent in vain many rental and rent. For this problem, in 1934 the "Federal Housing Act," has created the Federal Housing Authority (now under the Department of Housing and Urban Development), its primary function is to come out by the state for low income housing loans mortgage insurance.。 This policy has significantly increased the middle-income residents, especially those new to participate in the work of a young person's ability to purchase.
When the home loans cheaper, lower down payment, residents can make more loans to buy a house, the remaining question is: longer duration of most loans, the banks loaned out money to dozens or even decades to recover, will not be able to continue to grant more housing loans. To this end, in 1938 also set up another state-owned non-profit enterprises (and later the privatization of state regulation, but still), "Fannie Mae" (FannieMae). Fannie Mae has not yet recovered from the bank to buy mortgage loans packaged into bonds after the sale to recover the funds quickly. This means that finance is what we often say "securitization."。.
In short the policy is to relax the supply of housing loans. The United States to implement this policy based on their national circumstances, of course: it's commercial banking system is extremely powerful and basic private. In China, banks are mostly state-owned, lack of restraint mechanism, if the practice of blindly copying the United States to expand the supply of housing loans, may indeed have negative consequences. Nevertheless, U.S. practice is worth learning from.。 The more this way "Suppression rate", on the contrary, the more suffering residents. This is like using inflation raise just a fuss. A Japanese shock but been forgotten battle-1944 Battle of Guilin.
It is generally filed in Guangxi, Guilin best in the world would think of, brought in Guilin, you think of the beautiful Lijiang River, Elephant Trunk Hill, Seven Star Crags and so beautiful. However, in Guilin City, the outbreak was a shock that the Japanese people but was forgotten battle ---- Battle of Guilin in 1944. .
If you asked people in the war of which the most brutal battle the most intense, some might say songhu, campaign, third battle, changde, Changsha, battle, battlefield, etc. over Hengyang, but if you ask the person who participated in the war of aggression against China, many Japanese veteran, you will find many of these veterans agree that 1944 Battle of Guilin in China is on the battlefield they encountered the most brutal battle.
. In the Japanese history of war in defense of that Guilin is a "war" in the two that China's military (rough estimate only refers to the Kuomintang army, right?) Bravery much more than one of his campaign (another one for the Battle of Kunlun Pass Japanese 5th Division 5th Army Central Army was defeated). .
First let's take a look at the situation before the battle of Guilin, the Japanese launched in 1944, was Yu-Xiang of China referred to as the "battle" of large-scale GUI warfare, krenke Henan, Hunan Hengyang City, Hunan province, in addition to being the Central army tenth army's stubborn resistance, all the way to victory, the KMT forces most fierce battle, the Japanese army near seven divisions, 15 000 troops, tanks, 300 30 to a large number of heavy artillery in Guilin, ready to attack the Guilin.
. Guangxi militia is composed of thousands of death squads, and their task is to tie him hand grenades or explosives, then blew up his body Japanese tanks and landing craft. .
. .
"From now on you can see the Japanese Army casualties and morale is low, 7 November, the great Japanese see storm victims, using a large number of these bombs attacks throughout the defenders of Guilin, the majority of positions in the media have not seen a poisonous gas, don't know what to avoid, so a lot of poisoning deaths and injuries, including 800 GUI soldiers (most wounded), row number, resistance the Japanese army, lost nearly a thousand people to the area within the poison in the area of a large number of GUI soldiers at this time Japanese poisoning, rushed into many GUI soldiers rest a little bit of trouble shooting with the Japanese Imperial Army and hand-to-hand combat, but the end result of poisoning after exhaustive and the bottom of the barrel and all the sacrifices.
November 10, 1944 fall of the city of Guilin, the defenders of 10,009 thousand, 10,002 thousand people died (half of them were poisoned by gas), 7,000 people became unconscious because of poisoning was captured by the Japanese. The Japanese casualties, according to the Japanese headquarters of a battlefield report was submitted, said: "Imperial Army in the Battle of Guilin and killed 10 003 1000 9 hundred people, injured 10 009 1000 a hundred people, more than 300 people missing, of which 9 died Colonel-level commander of names, 31 in the junior-level commander, squadron leader and nearly 100 small-captain, Li River water against me, the Chek bloody armed forces of a game which I experienced in my life to the worst campaign, is not to scale, but rather the enemy of the brave. ".
After the battle of Guilin, Guangxi, listening to a lot of elderly people, in the beautiful Li River, on the whole there are nearly 5 km on the River is in the body of the two armies, the battle demonstrated the cruel.
As does not meet its "commitment to three months", the National Government had no thought as to keep Guilin, Guangxi as Chiang Kai-shek and conflicts, and even may be due to the expense of Guilin, the military garrison in exchange for counter-time, and so questions . This shocking campaign to make the Japanese people do not know for many, the only awards the National Government is to Guilin garrison commander has been killed, 131 division of the Kan-dimensional Yong upgrade will, nothing more. .
Battle of severity, qixing district, Guilin were Japanese before the battle over Hengyang, Guilin, the defenders of equipment than over Hengyang defenders of equipment much less, and many local armed and, more importantly, Guijun never a soldier's "sober," State of surrender (captured the defenders all gassed up unconscious), even in the bottom of the barrel, injuries of resistance to the dead, and many Japanese people's memoirs, in the war of Guangxi militia groups, many still haired old man, but how do you say over Hengyang defenders are also better equipped central army, say the last over Hengyang defenders also surrendered.
. Like music you like to hear. .
Buddha be required. Called bodhisattva who should be such as Saad is subduing its heart. All sentient beings. If the egg-laying if viviparous if wet if metaplasia. If colored to colorless. If you want to without thought. Would like to think of non-free. I make without acknowledging and off-balance. If it is off of infinite myriads of boundless beings. There is no sentient being is off of. Why is it. Required. If there is a phase I trial with ecologies Shou ' phase. That is, non-bodhisattva.
Recovery time Subhuti. Buddha in the law should Wusuo Zhu line at Busch. The so-called not live color Busch. Not live sound smell touch Dharma. Subhuti. Bodhisattva should thus giving not live in the phase. Why so. If the Buddha not live with Busch. The Ford can not consider. Subhuti. In Italy Yunhe. Oriental void can not consider. Is not the Blessed One. Subhuti. Southwest up and down the North dimensional void to consider not. Is not the Blessed One. Subhuti. No live with Bushifude Buddha. So too are not ponder. Subhuti. Buddha taught as it should be lived. .
Required. @ Yi-yun HO. Can the body does not meet the Tathagata. Not too strong. You can not see such as phase. Why is it. Buddha said that non-body body. Buddha be required. Where all phases are virtual. If it is found that non-phase-see the Tathagata.
Therefore should not be process. Not be illegal. To be justified. Buddha say thou shalt monk. I know that if the raft metaphor. Law should, he became illegal.
Subhuti. In Italy Yunhe. A hoe as more and more Romanian San Miao San Bodhi yeah. Tathagata be saying yeah. Subhuti made. If I solution Fosuo Yue Yi. A hoe without a titration were three more than Romania despise his mind. Nor have titration Tathagata can. Why so. Ru Laisuo claims are not that desirable.非法 Africa, Africa and France. So are any. All Xiansheng tailor inaction law differ. Subhuti. In Italy Yunhe. If people over three thousand worlds. Metals and to use the donation. Is a multi-person income Fu Dening not. Subhuti made. Many Blessed One. Why so. Is that non-Crawford of Crawford. Therefore in more than Crawford, such as speaking. Ruofu been through in this. Si Juji and so on for others and even accept and uphold that. The Fu-Sheng He. Why so. Subhuti.。 Required. The so-called non-Buddhist Dharma is. ..
Why is it. There is no name of a method. Sage. If an arhat is read. I have an arhat. That is, to me who all tho. Sage. The Buddha said: I have no such person the most works first. First off to an arhat. I don't read as is. I'm off to an arhat. Sage. If I say I have made is an arhat. Sage is said to be the Bodhi was Alan the walkers. To be made è no rows. Which shall be the Bodhi was Alan line.
Shall be made è. A lot of great length. But there is more on the Ganges. He became their sand. Required. I should say, thou. If there is a good man, the good woman. To seven treasures the Ganges River sand-filled with a few thousand. To give much blessed. Shall be made è. A lot of great length. Buddha be required. If the good men, good women. In this Sutra and honors four sentences "philosophy, etc. As someone else said. But before this blessing Desheng..
Recovery time Subhuti. As said by even the Si Juji and so on. Dang Zhici Department all worldly heaven Asura. All should support such as a pagoda temple. Moreover, it was possible to accept and uphold the classics aloud. Subhuti. Known to be the most success when people have the law on the first Greek. If the classic lies. If the respect was a disciple of the Buddha. .
-Having regard to the lime white Buddha. Sage. When the name of this place. I wait for the clouds from Ho. Buddha be required. Is known as the Gold just transcendent. To be the name when bong. So, how. Required. Transcendent Buddha said. The non-transcendent. Is the name of transcendent. Required. @ Yi-yun HO. Such an argument is not. Shall be made è white Buddha. Sage. Buddha said no. Required. @ Yi-yun HO. 3 all dust is everywhere as many do not have to worry. A lot of great length. Required. Called for non-dust fallout as. Is the name of fine dust. As for the world-world. Is the name of the world. Required. @ Yi-yun HO. You can meet the Tathagata is 32. Not too strong. . Why so. If it is non-phase 32-phase. Is the name of 32-phase. Subhuti. If Shannan Zi good woman. Give life to life-sized Henghe Sha. Ruofu was this even after the so accept and uphold the Si Juji. Said that many of its blessing to others. .
. Buddha told Subhuti. It was to hear the case so Ruofu is through. Do not panic terror fear not. When people know that there is very Greek. Why so. Subhuti. As for the first non-first jackfruit jackfruit. Is the name of the first jackfruit. Subhuti. As for the non-shame shame jackfruit jackfruit. Is the name of insults and jackfruit. Why so. Subhuti. As I Xi Li Wang cut cut for the song body. No I am with my Ershi with no faces and no one person with no life. Why so. Steadily in the past when I have dismemberment. If my life with great masses of people were corresponding with the hatred of Health. Subhuti. Also read in the past on the Wu Baishi for Renruxianren. Er no I in the world with no sentient beings with no one person with no life phase. Therefore in Subhuti.。 Students should not be live color. Live sound and scent should not conflict with the law students. Should no living soul. If you live in your heart to non-residents. Is it the Buddha said that Buddha heart should not give live color. Required. Buddha for the benefit of all sentient beings. You should be giving. If everything is right and wrong aspects. Also said that all beings are non-sentient beings. Required. Is a real language. Real language. Such as language. Not kuangyu. The phrase does not. [citation needed] Required. This method derived from the law, such as no there is no virtual. Required. If Buddha heart live in France and Almsgiving. If there is no man in the dark. If Buddha heart and give live method. If people have a variety of purposes, bright Windows. Required. When you are in for a good man who if good woman. Be able to take this stand dusong. . Noted see is people. Obtains success limitless merit. .
. Is this man by not listening to explanations by studying this topic. Subhuti. If this everywhere in the economic. All the world should support Asura Heaven. Dang Zhici Department was of the tower. All should be respectful to all Chinese around for Li Hong and scattered his office. .
. .
. Subhuti. If the law is no more A hoe over Romania San Miao San enlightenment. Subhuti. A hoe if methods such as more and more persons Romania San Miao San enlightenment. Natural light by the Buddha is not with me in mind. Greatness is made, when the Buddhist afterlife. No. Sakyamuni. There is no law to get more than A hoe Romania San Miao San enlightenment. Therefore in Buddhism and my natural light is made by the denoted. Greatness must be chanted when Sakyamuni afterlife. Why so. Tathagata who is Dharmas such as Meaning. If so, to hide, as more and more Arab Nou Lo San Miao San enlightenment. Subhuti. The law is no more than Nou Lo Verde A three despise his mind. Subhuti. Ru Laisuo have A Nou doro San Miao San enlightenment. So the real nor unreal. Therefore in such law for all law Jie Shifo. Subhuti. All those who said Law. The non-all method.。 Required. For example, personal growth. Shall be made è. Sage. As for personal growth are not large. Is the name big body. Required. Bodhisattva. To make a statement. I am off of non-sentient beings is called bodhisattva. Why is it. Required. There is no law known as bodhisattvas. It is therefore all the Buddha said that without me unmanned by non-sentient beings no Shou. Required. If Buddha is. I'm a stately Buddha. Is not a bodhisattva. Why is it. As for solemn Buddha. That is, non-solemn is a solemn. Required. If not I method of Bodhisattva mastery. If the name is for the Buddha.
Subhuti. In Italy Yunhe. Tathagata with the naked eye does not. So the Blessed One. Tathagata with the naked eye. Subhuti. In Italy Yunhe. If they visit a day or eyes. So the Blessed One. Tathagata eye one day. Subhuti. In Italy Yunhe. Tathagata with eye does not. So the Blessed One. Tathagata with eye. Subhuti. In Italy Yunhe. Tathagata has no discernment. So the Blessed One. Tathagata have discernment. Subhuti. In Italy Yunhe. Tathagata has Foyan not. So the Blessed One. Tathagata has Foyan. Subhuti. In Italy Yunhe. Buddha said that all the sand the Ganges is not sand. So the Blessed One. If it is sand. Subhuti. In Italy Yunhe. If a Ganges is so all the sand like the Ganges. The number of all the sand is all the Ganges River in the world. Ning is not so much. Many Blessed One.。 -The country in all beings several heart Buddha understands. Why is it. If the heart is called a non-heart is known as the heart. So, how. Required. Past heart. The heart is not so now. The heart is not so in the future.
Subhuti. In Italy Yunhe. If anyone filled three thousand worlds metals and to use the donation. Is not more people be blessed yes fate. So the Blessed One. Yes cause the person blessed many. Subhuti. If Ford has really. Tathagata does not speak more than Crawford. To Crawford for no reason. If it was Ford and more. .
Required. @ Yi-yun HO. Buddha can have colors not being seen. Not too strong. The Tathagata should not have color being seen. Why is it. If the color is a foot. That is, non-color with foot. Is the name of the color with the foot. Required. @ Yi-yun HO. The Tathagata can have called upon to do. Not too strong. The Tathagata should not have called upon each other. Why is it. If the term aspects have that. Is the name called phase. Required. Yu-not that Buddha is read. I should say. MO is read. Why is it. If people have been saying that for such slander on Buddhism. I have said so. Required. That's not to say. Is the name argument. When wisdom shall lime white Buddha. Sage. Have people in the future. . Foyan. Subhuti. Bifei non-sentient beings are not sentient beings. Why so. Subhuti. Beings are sentient beings. As for the non-sentient beings. Is the name of all beings. .
Shall be made è white Buddha. Sage. Verde Anou Tatara three Miao three Bodhi. For nothing. Buddha said, if it is. Required. I was three Miao Anou Tatara. three Bodhi Even without a few methods available are the names cadoro three anou Miao three Buddha.
Recovery time Subhuti. There is no law compete with equality. A hoe is the name of more than Romania San Miao San enlightenment. I have no no no-no longevity living beings. A good rule was revised Nou all over Romania San Miao San enlightenment. Subhuti. Righteous person has said. If it is the name of non-effective ways to good ways. .
Required. If 3 Panorama all called xumeshan King. If Yes, get somebody seven treasures may give. If the person as a transcendent philosophy by and even four sentences, etc. Honors dusong for others. In the former Ford and a percent. Tsumoru minutes and even the word analogy..
Subhuti. In Italy Yunhe. Rudeng Do not say that Tathagata Zuoshi Nian. I When the self. Subhuti. Mo Zuo Shinian. Why so. There is no degree of sentient beings who, if they visit. If living beings who Tathagata degrees. Tathagata have my life who were living beings. Subhuti. If there are those who are non-speaking with my. The ordinary person of the people think that with my. Subhuti. Ordinary person as it is non-ordinary person who is the name of ordinary person. .
Required. @ Yi-yun HO. You can view the Tathagata is 32 phase. Shall be made è. As is the case. To view 32-phase. " Buddha's words. Required. If a 32-view of Buddha. Runner King St. is the Tathagata. Shall be made è white Buddha. Sage. As I said for the Buddha. Should not be based on the concept of the Tathagata, 32 phase. When Sage and said in verse.
In terms of sound and color to see me to ask me. .
Is the evil cannot see the Tathagata.
Is it that is not supported by Ford.
Subhuti. If so, to hide, if they visit if if if to Ruozuo lying. I said that people understand justice. Why so. Tathagata who has never been nor have nothing to go hence the name Tathagata. .
Required. If the good men, good women. To 3 000 pieces for dust everywhere. @ Yi-yun HO. Is all the better for a lot of dust. Have a lot of lime, Sage. Why is it. If there is dust and all. Buddha did not say that it is dust. So, how. Buddha said that all the non-Dust Speck. Is the name of fine dust. Sage. Buddha said the world over all the world. Is the name of the world. Why is it. If there are people in the world is an in-phase. If it is not a closed phase-phase. Is the name of an in-phase. Required. One-phase is not said. But the journey of man, and his story.
Subhuti. If the hide, I see people see the Buddha said beings who see life see. Subhuti. In Italy Yunhe. I said one solution is not justice. Blessed. Is that people understand Rulai Suo Yi. Why so. Blessed that I see people who see all living beings see the life that is not my view to see people see those who see all living beings see life. Is the name I see people who see all living beings see life see. Subhuti. A hoe made over Romania San Miao San Bodhicitta. To all law. Known to be the case no solution so students see the letter so wears. Subhuti. Wears those words. If it is illegal phase. Is the name wears. .
Required. If someone has a full non-monk of the seven treasures in the world only holders of giving. If there is a good man, a woman made è heart good. Holding to this or even four sentences "philosophy, etc. Honors for its human speech dusong Fusheng Peter. Cloud heweiren speech. Do not take in phase as such. Why is it.
All promising method as Menghuanpaoying. .
Where there is a concept electric should.
Buddha said that already. Elder Subhuti Ji Zhu monks nuns. Upasaka laywomen. All the world Heaven Asura. News Fosuo Shui happy. Trust and practice. .
Lemuel.
Postscript to God that Mo PO Qie La bowl more than a bad drag Om Baltic MI Erie Room Lee lost the end of the Iraqi pack Vaisali Ye Lu She Yesha PO blame adjoining view Bodhisattva, long line of deep Prajna Paramita, according to Perceiving total defeat, degree All Kue. Relic! Color does not differ from air, air no different color, sex is zero, Kongjishise. By the intending consciousness, so too are. Relic! All Dharmas are empty. Health is not eternal, does not scale without a net, not to rise. Therefore, in emptiness, no subject line to know. Eyes 耳鼻舌身意. Colorless sound flavor breaking the law. No vision, and even unconscious world. No field, no field to do. Even without old age, nor do die of old age. No Kuji off Road. No wisdom nor too. With no income so.。 Sever is not a terrorist, escaping, Nirvana. III Buddhas, transcendent, have three Miao Anou Tatara. three Bodhi Prajna paramita is who is the mantra that the mantra is mantra. Be subject to all the bitter truth. They say that the curse transcendent. That is, that spell Viet Thanh: mortgage mortgage truths, Baltic logistic mortgage truths, Baltic monk mortgage truths, he SA Po. During the reign of the Guangdong wuchuan County has called for the instrument, the tip of the dog and the nickname "father of six, as is famous for its humorous to the country.
Day, to the riverside grazing geese. Four squires met, suddenly Chujing students "poetry." One of them proposed to goose the title of poems, his first poems: "The middle of the river tour to a group of geese.". .
Another country gentleman lyrics: "Mother Goose males sing songs and geese. ”。.
The remaining two to a half-day can not go together. Cut dog 6 Davis, said: "gentlemen, let me complete the poem poems it.". .
Four country gentleman looking at Goose man irony: "go go go, b: well your goose arse!".
Cut six father ignored the dog, stretched voice asks to himself: middle of the river tour to a group of geese, E Gong goose mother goose song to sing. Defecate the feces of two squires, two feces did not defecate! We learned a lot of things have been deeply embedded in our minds, but eventually discovered that our brains are crammed into too much garbage, we have accepted too much false information that the foreigners cited said a few words, these words appear to outsiders that the objective is also in disguise before being accepted, the most famous three words. .
1. China is a sleeping lion, once he woke up, the whole world would be shaking. Everybody knows this is Napoleon said a Word, we accept it, is a great foreigners have such high evaluation, we are deeply as a Chinese person proud, and we are convinced that this Lion Colbie, has brought the world to feel it, because of the trembling of the Chinese people have stood up, the world already, but we for a long time did not know that there is a long tail: "thank God, he is still sleeping".
2. . Genius is one percent inspiration and 99 percent perspiration. This is probably the most encouraging us to make progress remark because, according to this logic, each of us is a genius, everyone is Edison, Edison reason we did not make that kind of performance, but we just did not work hard, because each stupid person then there are always the talented one percent inspiration for it, but Edison's also added the sentence: "This is just 1% of inspiration is vital." .
3. We are at the wrong time, wrong place, wrong opponent a wrong war. We used to know about the US imperialist aggression against Korea, and China people's volunteers is the one to beat us armed to the teeth, and achieved a great victory, we were the first Americans in the absence of the victory of the Armistice, the American arrogance, large long people power and prestige, and even the Americans also says, this is the proof. . .
