2009/03
Create a new instance Better prepare the directory structure E: oracleproduct 10.1.0 admintestbdump E: oracleproduct 10.1.0 admintestcdump E: oracleproduct 10.1.0 admintestcreate E: oracleproduct 10.1.0 admintestpfile E: oracleproduct 10.1.0 admintes ...
Solution1: source: windows2003 32bit, oracle10g 10.2.0.2 target: IBM aix 64bit, oracle10g 10.2.0.3, RAC, ASM Solution2: source: HP UX 64bit, oracle10g 10.2.0.3, RAC, ASM target: IBM aix 64bit, oracle10g 10.2.0.3, RAC, ASM Solution1: source: windows20 ...
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
checkpoint is a database of case, it would have modified the data from the disk cache to refresh and update the control files and data files. rn We know that the checkpoint will be set dirty data, but when will it happen checkpoint? The following sit ...
bash_profile ORACLE_BASE = / opt / oracle; export ORACLE_BASE ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME ORACLE_SID = oracle; export ORACLE_SID NLS_LANG = AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG PATH = / usr / sbin: $ PATH ...
1. Rn rn begin rn sys.dbms_job.submit (job =>: job, rn what => 'job_stat_cooperate;', rn next_date => to_date ('01-07-2008 05:00:00 ',' dd-mm-yyyy hh24: mi: ss'), rn interval => 'TRUNC (SYSDATE +30) +5 / 24' ...
ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...
Merge to select from a table update or insert some data to another table. And finally is used to update or insert depends on the conditions of the statement. rn Here's our easy to cite an example: rn rn SQL> create table merge_test1 (a number, ...
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
Point encountered an error today, marking what: ************************************************** ********************** ARC0: Failed to archive thread 1 sequence 1 (19809) Wed Feb 25 13:53:32 2009 Errors in file / oradata/oracle/admin/ebaby/bdump/e ...
A lot of time because of unusual or procedural errors leading to a particular process will use up a lot of system resources, the need to end these processes can usually be Kill the process using the following command: However, this command is extreme ...
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
1. SQL predicate in between ... and ... yes, including the border, the following is a small test: SQL> select * 2 from (select rownum rn from dba_objects where rownum <6) 3 where rn between 2 and 4; RN ---------- 2 3 4 2. Unix search under the ...
Monitor in the standby host to create the necessary directory structure and parameter files. Hot COPY after the main library to the standby, and on standby to restore. +++++++++++++++++++++++++++++ Standby ++++++++++++++++++++++++++++++++++++++++++++ ...
1.1 basic commands 1. Getting Help $ Exp help = y $ Imp help = y 2. Three work (1) interactive mode $ Exp / / then prompted to enter the required parameters (2) command-line mode $ Exp user / pwd @ dbname file = / oracle / test.dmp full = y / / command li
can be estimated dbms_stats good statistical data (especially for the larger partition table), and to obtain better results, faster and finally work out the SQL implementation plan. exec dbms_stats.gather_schema_stats ( ownname => 'SCOTT', opti
ORACLE11G test environment installed today, and checking network configuration requirements encountered Detect does not pass, the machine configuration is a static IP too, remember the PASS manual directly. Resolve this question is actually very simp ...
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
Oracle Data Import Export imp / exp on oracle is equivalent to restore and backup data. exp command to put the data from a remote database server to the local exported dmp file, imp command dmp files can be put into the distance from the local database se
500) this.width = 500; "border =" 0 "> Now the production base of CPU, compared the terror, SQL tuning to have to point, and alas, some things to do, but. . . . . Like this BLOG, to write, but had no time to write .... Now the DBA, ...
Examples are as follows: (Over)
500) this.width = 500; "border =" 0 "> Now the production base of CPU, compared the terror, SQL tuning to have to point, and alas, some things to do, but. . . . . Like this BLOG, to write, but had no time to write .... Now the DBA, ...
WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ------- ---- --- ------------ NRMS 3111045189 XXXX 1 10.2.0.4.0 NO XXXX Snap Id Snap Time Sessions Curs / Sess --------- -- ...
http://blog.csdn.net/jat_chipmore/archive/2008/11/27/3391402.aspx In theory, the direct insert for undo (rowid) is no longer necessary because the HWM in the mobile, these should not block are used by other process, then, means that as long as the re ...
Oracle9i start from, Oracle allows the use of duplicate manner Dataguard standby database creation, very simple. First of all, the main course required a RMAN backup database, and then need to send backup to the standby database and the main library ...
1 exp / imp role Used to transfer data between databases. exp export data from the database to the dump file, imp from the dump file to put data into the database. in general we use for data backup and recovery. exp export file formats are binary, no ...
Monitor in the standby host to create the necessary directory structure and parameter files. Hot COPY after the main library to the standby, and on standby to restore. +++++++++++++++++++++++++++++ Standby ++++++++++++++++++++++++++++++++++++++++++++ ...
Test the following three commonly used connection between the table: Sort - merge connected (sort-merge join, SMJ) Nested loops (nested loop, NL) Hash connection (hash join, HASH) 1. To create the test table SQL> select * from v $ version; BANNER ...
First, the purpose of testing SunnyXu in accordance with the "SQL Performance adjust - summarized," commonly used to test the following four categories of hints: 1. The method of instruction optimizer hints with the aim ALL_ROWS: Based on t ...
Under normal circumstances, nested loop drive line source should be chosen small table, or a few lines of the line source, but sometimes, not necessarily. We look at a large table to do the examples of the source line drive. 1. To create a test envir ...
One of my colleagues ask so little demand for a field stored in a lot of Chinese characters, one of each line has a total figure of Chinese characters are, such as: one, two, three, ... ... like. How to sort according to these figures? With a case ex ...
Test the following four types of index: Unique Index Scan (INDEX UNIQUE SCAN) Index range scan (INDEX RANGE SCAN) Scan the whole index (INDEX FULL SCAN) Express-wide scan index (INDEX FAST FULL SCAN) 1. To create the test table and the only composite ...
Test Objective: To test CBO and RBO, as well as full table scan than index the situation quickly. 1. To create a test environment SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- Oracle Datab ...
Data in the index have been scheduled well in advance of the order. So when SQL specified in accordance with the index to sort out when, in the implementation of the plan do not need to sort of. 1. To create a test environment SQL> create table te ...
Blocking mechanism is set up in order to control the concurrent operation of the block interference, to ensure data consistency and accuracy. Oracle database blockade There are three ways: sharing blockade blockade exclusive, shared update blockade [ ...
Encountered a problem today: select * from v $ pwfile_user: The result is there is no record was found And the mandate of manually grant sysdba to scott; Error: password file is not open or do not have a password file Finally view the password file: ...
The customer is always asked for two days to a number of temporary table to import text data, sql * loader is also not very familiar with the FREE today to sum up. General to set up two files: Control files and data files, if the data can also be les ...
select inception_date, to_date (to_char (sysdate-1, 'yyyymmdd'), 'yyyymmdd') yesd, case when to_date (to_char (sysdate-1, 'yyyymmdd'), 'yyyymmdd')> planned_end_date then trunc (planned_end_date - inception_date) els ...
Pub at around the time that someone ask this question, metalink, then this indicated that the original user account is locked, and the general characters are encrypted, but if the account is locked, it shows as INVALID Posts the following address: ht ...
Demand should be for sale to customers at the scene (music base) to help analyze why the operation clearly update our records are submitted, but every day dozens of W there are dozens of records shown by records such as not submitted. March 24, 2009 ...
The customer is always asked for two days to a number of temporary table to import text data, sql * loader is also not very familiar with the FREE today to sum up. General to set up two files: Control files and data files, if the data can also be les ...
On Linux x86 is installed in Oracle Database 10 g Author: John Smiley Study in RHEL 2.1, RHEL 3 or SLES 8 installation from scratch on Oracle Database 10 g of basic knowledge (for assessment) Contents Overview Part 1: Installing Linux RHEL 2.1 RHEL 3 SLES
NVL To determine whether the air: NVL (exp1, exp2) is empty if exp1 then return back exp1 or exp2 NVL2 (exp1, exp2, exp3) is empty if exp1 then return exp2, otherwise return exp3 NULLIF (exp1, exp2) if exp1 = exp2 return null otherwise return exp1 de ...
DB_BLOCK_LRU_LATCHES = 6 BUFFER_POOL_KEEP = (BUFFERS: 14000, LRU_LATCHES: 1) BUFFER_POOL_RECYCLE = (BUFFERS: 2000, LRU_LATCHES: 3) ... Note: buffer_pool_buffers = 2000 * 3 +14000 * 1 = 20000 keep the district will once again be used to retain the use ...
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
Can be used: Table space, rollback segment, table, index, partition, snapshot, snapshot log PCTINCREASE parameters of the proposed set to 0, can minimize debris, so that each of the same Extent (NEXT equal value) Once an object, its parameters INITIA ...
Steps: running the original version of the installation process, select deinstall to remove the old oracle, the operation of the new version of the installation process, choose not to create a database instance. Database after the installation is com ...
ASM formatted partition, we must choose P, # fdisk-l Disk / dev / sda: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors / track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System / dev/sda1 * 1 910 ...
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
loadrunner questions and solutions: 1.error-82801: Abnormal termination, caused by mdrv process termination. Methods: The opening of the ip-spoofing 2.error-27791: Action.c (816): Error -27791: Server "128.2.3.124" has shut down the connect ...
