2009/04
######### To create a database ---- look $ ORACLE_HOME / rdbms / admin / buildall.sql ############# create database db01 maxlogfiles 10 maxdatafiles 1024 maxinstances 2 logfile GROUP 1 ( '/ u01/oradata/db01/log_01_db01.rdo') SIZE 15M, GROUP 2 ...
rn I would like to ask That all the information on db_block_size to be configured to block the entire operating system several times to improve the processing speed, But do not indicate the reason for that? The boss explains why ah? : em14: rn rn ivh ...
Original Address: http://www.bokee.net/bloggermodule/blog_viewblog.do?id=465310 Oracle's import utility (Import utility) allows to extract data from the database and the data written into the operating system files. imp to use the basic format: i ...
I often get asked when the index need to rebuild, read a article today, recording a bit. The INDEX_STATS view is useful for seeing how efficiently an index is using its space. Large indexes have a tendency to become unbalanced over time if many delet ...
Partition table Learning through this section, you can learn the following questions 1, to understand the concept of partition table 2, clearly the use of the partition table 3, to understand the classification of the partition table 4, to understand ...
rn Oracle backup rn Include: rn Advanced Replication (Advanced Replication) rn Stream replication (Streams Replication) rn Preparation of the Treasury (Dataguard) rn A dataguard: rn dataguard in high availability and disaster recovery in general is a ...
# Index-organized tables can be range or hash partition list. Oracle Database 10g Also provides three types of zoning Index: # Local index Local index is the way of its geographical location and its regional approach based on the same table index. Lo ...
Oracle is willing to buy 7.4 billion U.S. dollars from Sun Oracle has announced that would be willing to 74 million in cash and debt acquisition of Sun Microsystems, Inc., or the stock price of 9.5 U.S. dollars per share. According to foreign media r ...
Oracle database today to study the Cluster, DataGuard, the logic of the physical backup, flash back, as well as technical Rman. On learning experiences: rn Cluster: 10g or later to use cluster operating crs; the use of VIP, ASM, OCR technology; rn Backup
Partition table Learning through this section, you can learn the following questions 1, to understand the concept of partition table 2, clearly the use of the partition table 3, to understand the classification of the partition table 4, to understand ...
Create table PCTUSED parameters PCTFREE and what does this mean? pctfree: Used to specify the necessary reservations BLOCK in the smallest proportion of space. pctused: as a percentage of value, when BLOCK space has been reduced to the following valu ...
Role: DBMS_STATS.GATHER_TABLE_STATS tables, columns, indexes of statistical information. DBMS_STATS.GATHER_TABLE_STATS syntax is as follows: DBMS_STATS.GATHER_TABLE_STATS (ownname VARCHAR2, tabname VARCHAR2, partname VARCHAR2, estimate_percent NUMBER ...
DBA experience often is such a headache: I do not know who created an Oracle user, to create did not give the user-specified default tablespace, so the user will be using the default table space - system table space. Lead to system tables user data s ...
SQL> exec dbms_scheduler.disable ( 'SYS.GATHER_STATS_JOB'); PL / SQL procedure successfully completed. # exec dbms_scheduler.enable ( 'SYS.GATHER_STATS_JOB');
DBA experience often is such a headache: I do not know who created an Oracle user, to create did not give the user-specified default tablespace, so the user will be using the default table space - system table space. Lead to system tables user data s ...
1. Installation oracle10, I installed the Release 10.1.0.2.0, in the installation database, it can be installed through dbca to create a simple database 2. Companion CD-ROM to install the third, oracle database 10g companion products 10.2.0.1.0, and ...
Recently changed computers, used to be installed directly suse11 system 32. The entertainment in order to install a virtual machine, installed in the virtual machine suse10 system, but is 64-bit. After installation, it still felt pretty good by compa ...
We have to discuss four areas: 1: the server character set 2: character set client can find the registry miscellaneous NS_LANG 3: sqlplus Character Set D: \ oracle \ product \ 10.2.0 \ client_1 \ sysman \ config \ dbappscfg.properties Inside SQLPLUS_ ...
ORACLE more points the more knowledge, a look at the forgotten front of the back, not enough of a head, ah, ah
The use of character set AL32UTF8 problems Client character set is also set to AL32UTF8, when the implementation of the problem statement: SQL> update t_port_permission set permission_name = 'delete inbound' where permission_name ='123 ...
To the Oracle database backup and restore a clear understanding of, first of all, it is necessary to run several databases have a full understanding of the state. Running Oracle database is divided into three kinds, they were as follows: l Nomount (non-in
Putty to operate through the database, in the SQL> prompt through the up and down arrow keys to show the history of the command, you can adopt the following solution: 1. Rlwrap to download a tool called http://utopia.knoware.nl/% 7Ehlub/uck/rlwrap ...
Format: alter system | session set events' [eventnumber | immediate] trace name eventname [forever] [, level levelnumber]: ... .... ' By: symbols, you can set up a number of consecutive events, but also can be used for alter session set event ...
To the Oracle database backup and restore a clear understanding of, first of all, it is necessary to run several databases have a full understanding of state. Running Oracle database is divided into three kinds, they were as follows: l Nomount (non-instal
On the Oracle sequence (Sequence) to use Sequence is a database object, use it to generate only integers. Sequence generally used to generate primary key automatically. Of our programmers, the energy limited time, we only learn the most useful knowle ...
From the Internet into some of the posts of: Dba_tablespaces can check this table to see a table space is a dictionary management or local management, the corresponding field for extent_management, if the value is compared with the dictionary DICTIONARY m
1, in the library in good condition when the first backup controlfile about the rainy day SQL> alter database backup controlfile to trace; SQL> exit; $ Cd $ ORACLE_BASE / admin / $ ORACLE_SID / udump $ Ls-ltrh | tail -1 -rw-r ----- 1 oracle oin ...
In front of us a brief introduction about the scope of the district: We continue on the following HASH partition, LIST Zoning HASH Zoning: Create: Insert the five data; we query: Next on: LIST Zoning Insert the write data: And then proceed to query: ...
ORACLE District (a) Oracle would like to know the district has long been finally determined to get a get As the name suggests is to partition the data into a range of one to keep, the attention of the district and databases where the logic that the & ...
Putty to operate through the database, in the SQL> prompt through the up and down arrow keys to show the history of the command, you can adopt the following solution: 1. Rlwrap to download a tool called http://utopia.knoware.nl/% 7Ehlub/uck/rlwrap ...
Backup server has a bad day, did not note that the archive file to disk filled, alert in error as follows: Tue Apr 7 08:31:53 2009 Errors in file / oracle/admin/gis/bdump/gis_arc0_430402.trc: ORA-19502: Message 19502 not found; No message file for pr ...
From the Internet into some of the posts of: Dba_tablespaces can check this table to see a table space is a dictionary management or local management, the corresponding field for extent_management, if the value is compared with the dictionary DICTIONARY m
From 7-8, from 8-9, it is now 10, and appears to have been replaced, statspack really do not want to use, awr and addm very powerful, especially addm. http://www.hellodba.com/Doc/oracle10g_addm (1). htm
Access to remote DBLINK custom type, between different examples of custom types of mutual visits must use the same OID. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14289/dciobjtypes.htm # sthref184 Assigning an Object Identifier to an Ob ...
DECLARE CURSOR C1 IS SELECT FILE_NAME FROM DBA_DATA_FILES; CURSOR C2 IS SELECT A. GROUP # GRP, A. MEMBER MEM, B. BYTES / 1024 / 1024 BYT FROM V $ LOGFILE A, V $ LOG B WHERE A. GROUP # = B. GROUP # ORDER BY A. GROUP #; CURSOR C3 IS SELECT TABLESPACE_N ...
Relational database languages are classified into three types, which are (Data Description Language DDL), (data manipulation language DML) and (Data Control Language DCL), while SQL is the (set DDL, DML, DCL as a whole) of the standard relational dat ...
We know that in the Oracle database, you can kill session approach to the termination of a process, and its basic grammatical structure as follows: alter system kill session 'sid, serial #'; Was kill off the session, the state will be marked ...
1, start the database: oracle @ suse92: ~> sqlplus / nolog SQL * Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected to an idle i ...
First, create a PLSQL table: create table HWQY.TEST ( CARNO VARCHAR2 (30), CARINFOID NUMBER ) Second, create a PLSQL stored procedure: create or replace procedure pro_test AS carinfo_id number; BEGIN select s_CarInfoID.nextval into carinfo_id from du ...
Keywords: oracle, table space, partition table, index Database the first time last week to test a number of problems encountered hereby summarized: Table space: Oracle's UNDOTBS01.DBF solution file is too large 1,. The prohibition of automatic un ...
$ Sqlplus - help SQL * Plus: Release 10.2.0.1.0 - Production Copyright (c) 1982, 2005, Oracle. All rights reserved. Usage 1: sqlplus-H |-V -H Displays the SQL * Plus version and the usage help. -V Displays the SQL * Plus version. Usage 2: sqlplus [[& ...
Relational database languages are classified into three types, which are (Data Description Language DDL), (data manipulation language DML) and (Data Control Language DCL), while SQL is the (set DDL, DML, DCL as a whole) of the standard relational dat ...
First, create a PLSQL table: create table HWQY.TEST ( CARNO VARCHAR2 (30), CARINFOID NUMBER ) Second, create a PLSQL stored procedure: create or replace procedure pro_test AS carinfo_id number; BEGIN select s_CarInfoID.nextval into carinfo_id from du ...
Oracle data in the application process, the database when the machine is believed to be encountered by everyone, and how to restore the backup so that is the minimum loss of each dba should be most concerned about, no matter what the circumstances are imp
Linux environment in sqlplus, in the back to delete (backspace) tend to occur when a string of gibberish. Garbled due to the oracle's sqlplus does not use gnu caused readline library. There are two solutions: 1. To use the Back button to delete ( ...
The use of geographical advantages: Enhanced availability: If a partition table failure, table of data in other divisions are still available; Easy maintenance: If a partition table failure, the need to repair the data, only to repair the partition; ...
Oracle data in the application process, the database when the machine is believed to be encountered by everyone, and how to restore the backup so that is the minimum loss of each dba should be most concerned about, no matter what the circumstances are imp
Do test in Japan, the use of Japan's environment, each should be sqlplus configuration oracle environment variables (ORACLE_SID, ORACLE_HOME, PATH), due to lack of experience, there have been two very hard to understand the error. This in the she ...
In this paper, carried over the Internet, I would like to thank the author! the difference between sys and system users 1) The most important difference between the importance of data stored in different Sys] [all oracle data dictionary base tables a ...
1: The table lists several ways to connect hash join / merge join / nest loop (cluster join) / index join 2: do not use third-party tools and how to view sql of the implementation plan set autot on explain plan set statement_id = & item_id for &a ...
