Oracle ® Database Installation Guide 10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX, hp Tru64 UNIX, Linux, and Solaris Operating System http://download-east.oracle.com/docs/html/B10811_05/toc.htm
Oracle9i initialization parameters that English Blank_trimming: Description: If the value is TRUE, even if the length of the source than the target length (SQL92 compatible) longer, but also allows data distribution. Range: TRUE | FALSE Default value: FAL
Umpdp into use: Backup file. Dmp on d: \ sd directory First of all system users visit create directory dump_dir as' d: \ sd '; Exit The implementation of impdp system / password dumpfile =. dump directory = dump_dir
(1) REMOTE_LOGIN_PASSWORDFILE = none and SQLNET.AUTHENTICATION_SERVICES = none: oracle user to install a local sqlplus "/ as sysdba" can not log in Non-oracle user to install a local sqlplus "sys / change_on_install as sysdba" can ...
admin => Record number of summary information alertgnd-rac01.log => Change Record node status crs some time to outline the information in detail to look at css log client => Record crs initialization, ocr application including: CLSCFG, CSS, ...
ERROR at line 1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found SQL> delete ZJDA.ZJ_T_YJFP where rowid not in (select min (rowid) from ZJDA.ZJ_T_YJFP group by C_JGBH, C_SJLX, N_SJHM, N_GS); 214789 rows deleted SQL> SQL> create U ...
Can type in the operating system to obtain tkprof all available options and output options to sort a list of note has Sort Option Description call analysis prscnt execnt fchcnt the implementation of the number of extraction Analysis of the implementa ...
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
Differential backup and incremental backup, the backup only the data changes. However, the former backup is "the cumulative (cumulative)" - and a file since the last full backup as long as after, and was updated, then the next to do a diffe ...
Transfer from: http://space.zdnet.com.cn/html/80/289380-1442131.html A lot of time in our study required further dump (dump) Oracle data block in order to study its contents, Oracle provided a good way, we adopt the following simple example to explai ...
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
SQL> ANALYZE INDEX acct_no_idx VALIDATE STRUCTURE; Index analyzed. SQL> SELECT (DEL_LF_ROWS_LEN / LF_ROWS_LEN) * 100 2 AS index_usage 3 FROM index_stats; INDEX_USAGE ----------- 24 SQL> ALTER INDEX acct_no_idx REBUILD; Index altered. Index s ...
10,12 Month 1 day downtime oracle restart the accident happened, alert file reports the following error: Fri Jan 12 04:07:49 2007 Thread 1 cannot allocate new log, sequence 187398 Checkpoint not complete This error is repeated in recent reports, as s ...
• 1, outlines the problem January 22, 2009 inspection of dg_vassms system and database performance analysis, we found problems as follows: l Problem: 1) buffer hit rate is very low, 54.5%; SQL> select round ((1 - (phy.value / (cur.value + con.valu ...
Can use the SQL * Plus script to eliminate the transfer line has been / * Get the name of the table with migrated rows * / accept table_name prompt 'Enter the name of the table with migrated rows:' / * Clean up from last execution * / set ech ...
es5.3 Release Notes: I use the oracle enterprise linux 5.3 version, you can also use redhat enterprise 5.3 Or centos enterprise 5.3 version, the basic is the same. Preparation work: first www.oracle.com Download linux_x86_11gR1_database.zip (x86 arch ...
Single SQL Record function 1.ASCII Return with a specified number of characters corresponding to the metric system; SQL> select ascii ( 'A') A, ascii ( 'a') a, ascii ('0 ') zero, ascii (' ') space from dual; AA ZERO ...
SQL> SELECT name, value FROM v $ sysstat 2 WHERE name LIKE '% table scans%'; NAME VALUE -------------------------------------------------- ------- ----- table scans (short tables) 125 table scans (long tables) 30 table scans (rowid ranges) ...
When a lot of us may have to go through the server CPU consumption 100% of performance problems. Rule out the possibility of abnormal system, such problems usually exist because the system performance even exist Lower wrong SQL statement, a large amo ...
Problem Description: This is a company assist the diagnosis of the case. Application is a background press release system. Symptoms are, through the connection to access news pages are extremely slow ten seconds are usually required to return. This p ...
Society is a very useful database D ~ ~ Record a number of commonly used entry sql statement ... there is there is see improve has never seen the ... ... well the whole collection of ... In fact, the average is used to query, insert, delete and so on ...
