2009/05
9i increased from the beginning insert all, the data can be inserted into multiple tables at the same time, this can greatly reduce the disk IO, as well as the length of the code. rn ADMIN @ orcl> create table inser_test_all (a varchar2 (20), b nu ...
5. Rights Management (DCL) statements 1.GRANT giving permission Commonly used in the collection system has the following three rights: CONNECT (basic connection), RESOURCE (Programming), DBA (database management) Commonly used data objects have the follow
5. Rights Management (DCL) statements 1.GRANT giving permission Commonly used in the collection system has the following three rights: CONNECT (basic connection), RESOURCE (Programming), DBA (database management) Commonly used data objects have the follow
A foreword As there will always be unfair to the community, people will always make mistakes, the program will always be the same BUG, the database is not a problem Could have been avoided, a good backup is the key to the success of the project appli ...
Unix environment explain fully optimized for Oracle database Today, the optimization has been to optimize the wait (waits) in transition, and the actual performance optimization in the emergence of the most fundamental points are concentrated in the ...
1.windows command line to start sqlplus: sqlplus-> user & pwd (to connect to orcal: user: system pwd: 000000) 2. See the current date: select sysdate from dual; 3. To create a user: - method 1: create user "username" identified by &q ...
ORACLE common command A, ORACLE startup and shut down 1, in the stand-alone environment To start or shut down ORACLE system must first switch to the ORACLE user, as su - oracle a, start the ORACLE system oracle> svrmgrl SVRMGR> connect internal ...
solaris10 oracle10G EM config su - oracle emctl status dbconsole (see conditions) su - oracle emctl start dbconsole (Open Service) su - oracle emctl stop dbconsole su - oracle emca-config dbcontrol db-repos recreate (re-configuration management oracl ...
solaris 10 oracle10g install This is my install process: First of all, first download the ORACLE 10G Download address http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201sol64soft.html Extract oracle 10g <br /> Ins ...
oracle under unix command A, ORACLE startup and shut down 1, in a single environment in order to activate or deactivate the ORACLE system must first switch to the ORACLE user, as su - oracle a, start the ORACLE system oracle> svrmgrl SVRMGR> connect
Each DBA path of growth is different, because no one is born with the DBA, each DBA are in their own career path through the inflection point to an accidental DBA and not through their own career planning. Now, a growing number of young technical sta ...
Oracle Exp-00003 on the solution to the problem The day before yesterday in the lead when the data have taken place in the Exp-00003 error, before encountered such a problem, the solution is to the database server on the local guide, problem solving, ...
Direct access to a number of view will not return any results. There are two reasons for this situation would lead to the occurrence of: view the use of ou shielding, the client query, it is necessary to simulate the operation of the application of u ...
Oracle Exp-00003 on the solution to the problem The day before yesterday in the lead when the data have taken place in the Exp-00003 error, before encountered such a problem, the solution is to the database server on the local guide, problem solving, ...
Prototype: fnd_global.apps_initialize (user_ID, Responsibility_id, Responsibility_application_id); Role: the conversation in the database set up global variables, and user-summary information. Parameters was: Parameters of a User ID select user_id fr ...
6, Appendix ◎ installation procedures are shown in "box □" This is because the installation procedure for Oracle to support the poor Chinese, we use in English can be installed, before running the installation # su - oracle $ export LANGUAG ...
Oracle network configuration used in the sqlnet.ora, tnsnames.ora, listener.ora file Note: The article and related content from the network from finishing the book, so only the sharing of knowledge, to help. listener.ora, tnsnames.ora and sqlnet.ora ...
The production database hang, try to get the systemstat ++++++++++++++++++ % oracle_home% \ bin \ sqlplus-prelim / as sysdba oradebug setmypid oradebug unlimit; oradebug dump systemstate 266 oradebug dump systemstate 266 ++++++++++++++++++ Then, it g ...
Have been used in the previous DBCA to create database using DBCA, however bare in the use of equipment always pass, so want to pass the database manually to the database of the way built on the bare device. Through the manual to understand database ...
"In-depth Analysis of Oracle" Book The first time to buy books related DBA point of view! Reading down the breath, there are still many views. In general, the more successful this book. Particularly in the author's actual experience. If ...
SQL statement in the optimization process, we often use hint, is to sum up the process in the SQL optimization Oracle HINT common usage: 1. / * + ALL_ROWS * / Show that the choice to block the optimization method based on cost and get the best throug ...
- sql structured query language - DML - Data Manipulation Language - Data Manipulation Language query information (SELECT), add new rows (INSERT), modify existing rows (UPDATE), delete existing rows (DELETE), perform a conditional update or insert op ...
A, sql statement the implementation of these steps: 1) Syntax analysis syntax statement with the norms, measured statement of the meaning of the expression. 2) semantic analysis, to check all statements relating to the existence of database objects, ...
1). Set the current session whether to modify the data automatically submitted SQL> SET AUTO [COMMIT] (ON | OFF | IMM [EDIATE] | n) 2). Start command with the implementation of a sql script, whether the script is running the SQL statement SQL> ...
Oracle network configuration used in the sqlnet.ora, tnsnames.ora, listener.ora file Note: The article and related content from the network from finishing the book, so only the sharing of knowledge, to help. listener.ora, tnsnames.ora and sqlnet.ora ...
Have been used in the previous DBCA to create database using DBCA, however bare in the use of equipment always pass, so want to pass the database manually to the database of the way built on the bare device. Through the manual to understand database ...
1. Oracle database data types commonly used varchar2 (length) variable length string char (length) fixed length number () that the integer or floating point number (8) number (8,2) clog character large object blog binary large object 2. Database Quer ...
Preface: a brief introduction of relational database 1970.Dr.EFcodded created a relational database model (similar to the now commonly used two-dimensional form) Relational database composed of a number of data objects, the relationship between the operat
1, switch archiving mode server, if the archive is already skip this step-by-step mode: % sqlplus / nolog (start sqlplus) SQL> conn / as sysdba (connect to DBA database) SQL> shutdown immediate; (immediately shut down the database) SQL> star ...
RMAN learning notes This article is reproduced, thanks to the author! The list command RMAN 1 provides a counterpart RMAN> list incarnation; 2 shows the back-up 2.1 an overview of the available backup RMAN> list backup summary; B said backup F ...
See PDF document! Document: How to control the PO can not be billed to do Return.pdf Size: 2023KB Download: Download
On SPOOL (SPOOL is SQLPLUS command, not the things inside the SQL syntax.) SPOOL data for SQL, the best definition to its own format, to facilitate the direct import procedures, SQL statements such as: select taskindex ||'|'|| commonindex ||& ...
A step in the implementation of sql statement 1) Syntax analysis syntax statement with the norms, measured statement of the meaning of the expression. 2) semantic analysis, to check all statements relating to the existence of database objects, and us ...
In the creation of the database control file will specify a time when a copy of at least two and preferably a copy of these on a different hard drive, causes the hardware to prevent the loss of all of the control file copy Empty control file data includes
oracle trigger line and the difference between the trigger statement: 1, the trigger clause for each row there. Statement does not trigger clause for each row. 2, the flip-flop, there are restrictions on when a trigger, you can use the new / old. Statemen
When people in the use of SQL in a misunderstanding sometimes, that is too much focus on the result SQL is correct, the neglect of the realization of the different methods that may exist between the differences in performance, in particular the state ...
SQL statement in the optimization process, we often use hint, is to sum up the process in the SQL optimization Oracle HINT common usage: 1. / * + ALL_ROWS * / Show that the choice to block the optimization method based on cost and get the best throug ...
Oracle network configuration used in the sqlnet.ora, tnsnames.ora, listener.ora file Note: The article and related content from the network from finishing the book, so only the sharing of knowledge, to help. listener.ora, tnsnames.ora and sqlnet.ora ...
SGA in the granule size changes we all know the various components in the distribution of SGA is to granule distribution as a unit, rather than a distribution of such units 1M or 1K. granule size of the SGA size is set by the system, the time when th ...
ORACLE Off Script rn See online many friends still ask this question, then write it (all in root user implementation):, 1, the first change / etc / oratab, format ORACLE_SID: ORACLE_HOME: Y 2, the script is as follows # Chkconfig: 2345 # Description: orac
10G RAC experiment in a virtual machine environment: Host: windows xp, vmware server. rn 1, planned each node's host name, stored, SID, DB name rn 2, the installation of two RHAS 4 virtual machine, the OS installation process, the better to syste ...
Although there spauto.sql can, but I still like to use this script to collect information, more intuitive rn rn #! / Bin / bash rn rn ORACLE_HOME = / u01/app/oracle/11.2 if [$ @-gt 1] then echo "bad usage" eliff [$ @-eq 1] then case "$ ...
statspack to collect performance data rn In the daily maintenance, I still prefer to use statspack to gather performance data. Such as the automatic collection of prior snapshot with my script, can facilitate the collection of performance information ...
How to determine whether the oracle instance is running rn ORACLE instance starts, you must define ORACLE_SID. TOM on oracle ORACLE_SID explained that under the SID of the hash to uniquely determine the address of an instance. When we open sqlplus / ...
statspack to collect performance data rn In the daily maintenance, I still prefer to use statspack to gather performance data. Such as the automatic collection of prior snapshot with my script, can facilitate the collection of performance information ...
Reprinted: log file sync rn log file sync is too often presented as services, IO could not keep pace, and thus give rise to this wait. rn 1, raising the priority of LGWR alter system set "_high_priority_processes" = 'LMS * | LGWR | PMON ...
Log group operations rn 1, add a group rn alter database add logfile group 4 'd: \ redo04.log' size 10m; rn 2, add a member rn alter database add logfile member 'd: \ redo14.log' to group 4; rn 3, to delete a member, (the group not to ...
How to index the block to dump rn Require frequent analysis of the index block, dump the process is as follows: rn 1, create a table test, rn SQL> create table test as select spid from v $ process; Table has been created. rn 2, create a new table ...
Diagnostic event oracle rn rn ORACEL attending the event is a very important number of tools and instruments, compiled some of this knowledge, we want to help, as follows: rn 1, ORACLE events can be divided into diagnostic events and wait for the eve ...
knowledge of lock and latch latch and lock are used in concurrent environment, like the protection of shared resources, a mechanism has been damaged. In effect, the two are the same, but the way in achieving, and differences between the two 1, range: ...
