2006/04

Installing Oracle 10g on RHEL AS 3 Step-by-Step

Installing Oracle 10g on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) V 0.21 Not long ago, Oracle (Oracle) headquarters in California in the United States announced, Oracle 10g Database and Oracle RAC on TPC-H benchmark created a new world rec ...

How to update or delete millions of records

If I had to update millions of records I would probably opt to NOT update. rn -------------------------------------------------- ------------ rn create a new table, then drop the original table and rename the new table to original table instead of up ...

How to recompile invalid database objects

In sql / plus to perform the following two on it. rn -------------------------------------------------- ------------ connect sys / change_on_install @ Database @% ORACLE_HOME% \ rdbms \ admin \ utlrp.sql rn rn Additional annotations section utlrp.sql ...

How to feed the table. Riega comment?

Specific methods: rn rn SQL> comment on table the table is 'table comment'; Note has been created. SQL> comment on column table. Column is 'column comment'; Note has been created. SQL> select * from user_tab_comments where co ...

oracle SGA adjustment (Reprinted)

SGA Adjustment rn -------------------------------------------------- ------------------------------ SGA Adjustment rn An environment: A platform: IBM AX360, 4G memory rn windows 2k advServer sp3 + oracle 816 Exclusive Mode rn 2 memory allocation para ...

howto clean up a failed crs install

rn rn

Oracle Database routine maintenance manuals

rn During the Oracle database is running, DBA should run the database log and table space is being used to monitor the early detection of problems in the database. rn 1, Oracle alert log file monitoring rn Oracle during operation and will be warned t ...

Control access to oracle of the ip

By oracle parameter file settings, you can control access to the computer's ip address. Sqlnet.ora in the configuration file to add: # Turn on ip address checking tcp.validnode_checking = yes # Allow access to the ip tcp.invited_nodes = (ip1, ip2 ...

ORACLE Backup Strategy

rn Understand what is a backup rn Understand the importance of backup rn Understanding of the database two kinds of operation mode rn Understand the different backup methods and their differences rn Learn the correct backup strategy and its benefits rn Ch

How to effectively use the data dictionary oracle

ORACLE data dictionary is an important part of the database, which produce the products with the database, rn Of Health, with the database and change, reflected in sys user at some of the tables and views. Data dictionary name is great rn Written in ...

Common Monitoring SQL

1. Monitoring examples of waiting: select event, sum (decode (wait_time, 0,0,1)) prev, sum (decode (wait_time, 0,1,0)) curr, count (*) from v $ session_wait group by event order by 4; 2. Rollback contention situation: select name, waits, gets, waits ...

Table connection and use of occasions

Original: http://spaces.msn.com/roujiaweize/blog/cns!9745F14B4AEB3B72!410.entry NESTED LOOP The data for the connected subset of relatively small, nested loop connection is a better choice. nested loop is scanning a table, each reading a record, on w ...

linux install oracle9i Chinese garbled Solutions

rnrnrnrnrnrnrnrnrnrn linux install oracle9i Chinese garbled Solutions rnrnrnrn rn rn rn Oracle on Linux, installed when the characters are the "mouth" shape garbled the first time is rather tense in English can only be installed and after r ...

ORACLE8.1.7 FOR LINUX7.2 INSTALL

rn First, the software to prepare glibc-2.1.3-stubs.tar.gz env_ctx.mk binutils_2.10.91.0.2-3 jdk1.18_v3 Download the software in / home / oracle under 2, the installation environment to prepare 1, run: rpm-qa | grep copmat command to view the followi ...

Briefly join, outer-join, semi-join, anti-join the distinction between

Briefly join, outer-join, semi-join, anti-join the distinction between Tags: oracle Original: http://blog.itpub.net/post/901/12680 Posted by: dbaoracle | Published Date: January 4, 2005, 14:14 Table join methods, such as join, semi-join, outer-join, ...

Simple steps to use LogMiner

Simple steps to use LogMiner Tags: logminer oracle 1. Create DBMS_LOGMNR package SQL> @ $ ORACLE_HOME / rdbms / admin / dbmslm.sql 2. To create the data dictionary SQL> @ $ ORACLE_HOME / rdbms / admin / dbmslmd.sql 3. Modify the initialization ...

Oracle 2 Download classic books

Oracle 2 Download classic books Recently, there are a lot of friends to write to me and wanted to look at "Oracle of outstanding books recommended" and two classic books of the electronic version of Oracle. Too lazy to 1 1 responded to dire ...

itpub on the ORACLE Common FAQ V1.0 of the

The first part, SQL & PL / SQL [Q] how kind of inquiries, special characters, such as wildcards% and _ [A] select * from table where name like 'A_%' escape'' [Q] How to insert a single quote into a database table [A] can be handled wit

decode function in oracle tips

rn DECODE function is ORACLE PL / S QL is a powerful function, one of ORACLE Corporation is currently only SQL provides this function, the other SQL database vendors have not yet achieved this feature. rn DECODE what purposes? First construct an exam ...

oracle time in accordance with the classification statistics

rn rn rn Statistics on a weekly basis: rn select to_char (col_date, 'yyyy ww'), sum (colname) from tbname group by to_char (col_date, 'yyyy ww'); rn rn According to ten days to statistics: rn select to_char (col_date, 'yyyy mm' ...

How to oracle in the volume all the tables in a user license to a user?

Description of the problem and implement the following: rn The stat of all users authorized to mid table users; sqlplus stat / stat select 'grant select, insert, update, delete on stat.' | | table_name | | 'to mid;' from user_tables; ...

sql loader using the Example

sql loader using the Example a) SQLLoader to Excel data export to Oracle 1. Create a SQL * Loader input data required documents are saved to C: \, use Notepad to edit: Control file: input.ctl, reads as follows: load data - 1, control file identifies ...

9I-ocp review information (007/032/033)

rnrnrnrnrn rnrnrnrnrnrnrnrnrnrnrn File: TestKing Oracle 1z0-033 V23.pdf Size: 882KB Download: Download rnrnrnrnrn rnrnrnrnrnrnrnrnrnrnrn File: TestKing Oracle 1z0-032 V11.1.pdf Size: 903KB Download: Download rnrnrnrnrn rnrnrnrnrnrnrnrnrnrnrn File: Ac ...

Backup and Recovery Experiment (archive mode, the user management, full recovery)

os: winxp oracle: 9.2.0.1.0 sid: xianhe rn 1: preparatory work Change the database archiving mode SQL> startup mount ORACLE instance started. Total System Global Area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database B ...

Understanding of backup and recovery

rnrnrnrnrn rnrnrnrnrnrnrnrnrnrnrn File: oracle backup & recovery cases. rar Size: 30KB Download: Download rn Chap. Overview of database recovery rn When we use a database, always want the contents of the database is reliable and correct, but because o

Oracle database import and export

Using the oracle of the import and export The following frequently used in the course of to the. (After tuning the parameters together with instructions, SGA area, shared pool, PGA, etc. inside spfile parameters) 1.Export tool is an export program &l ...

RAC database archiving mode change

1 Use alter system set CLUSTER_DATABASE = FALSE SCOPE = SPFILE will cluster_database initialization parameter is set to false 2 If it is converted by non-archive mode archive mode, need to pay attention LOG_ARCHIVE_DEST_n, LOG_ARCHIVE_FORMAT paramete ...

statspack report analysis (2)

Author unknown statspack report analysis (2) Tags: statspack Parse CPU to Parse Elapsd%: parsing the actual operation incident / (parse the actual running time + resources to resolve the waiting time) The higher the better % Non-Parse CPU: check the ...

Recommendation 2 Ben Wang grid in introductory textbooks

Recommendation 2 Ben Wang grid in introductory textbooks Recently busy, we recommend to the grid in two introductory textbooks Ben Wang, the former is the first Ben Wang grid materials, many universities are now teaching courses in the grid; the latt ...

Oracle in JSP How to handle CLOB type of field

1. CLOB field insertion clob types of data directly insert characters long and may be due to an error, so use the object form of insertion. Example: First, create a table with CLOB field: create table test (id INTEGER, content clob); Then insert a nu ...

statspack report analysis (-)

statspack report analysis (-) Author unknown Tags: statspack 1, statspack output must be 10 to view the content of 1, the load between the file (Load profile) 2, examples of the efficiency of click-through rate (Instance efficiency hit ratios) 3, the ...

How to use sys as sysdba permissions to connect the database EXP / IMP

Using sys as sysdba privileges to EXP / IMP is slightly different with other users, the details are as follows (from metalink) Applies to: Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 10.2.0.0 Oracle Server - Personal Edition - Version: 8 ...

PowerDesigner automatically generated under the NAME attribute table and column comments

PowerDesigner 11 menu: [Database] -> [Database Generation] tab: [Tables & Views] -> check table & column 's comment [Options] -> Generation name in empty comment

ORACLE9I FOR AIX 5L Mobile

ORACLE9I FOR AIX 5L Mobile Move database in the project implementation process, often occur, for the experienced DBA, the database is very easy to move. But for some only to understand the system, the database of persons who are not quite understand, ...

Spent the night with no end result!

File: HP 580G2 MSCS + failsafe to do two aircraft. Rar Size: 283KB Download: Download Last night in the windows platform, following the completion of oracle9i database clusters, spent the night, with no results, no results and eventually died. Platfo ...

ORACLE connectivity test fails Tips ORA-01033 issue summary

rn Fault: rn One day, the database just added a connection to the other data service name and change the service to manual, the database will not start up. NET MANAGER in the connectivity test in the Prompt: ORA-01033: ORACLE initialization or shutdo ...

oracle where commonly used commands

Chapter I: Log Management 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4] sql> ( '/ disk3/log4a.rdo ...

2 good ORACLE database of basic and primary management book ~ ~

File: 2.oracle8i_9i the primary database management. Rar Size: 1017KB Download: Download File: 1.Oracle8i_9i database infrastructure. Rar Size: 532KB Download: Download ORACLE database to learn a very good basis for two books! ! !

oracle backup and restore data file 2

Use rman backup database, the data document two situations: a non-system table space 2 is the system table space Under the rman online backup database, rman> backup database plus archivelog; 1, loss, non-system tablespace sql> shutdown immediate Rem

oralce backup and restore a control file

Prerequisite of a certain control file is damaged, but there are other image files: SQL> show parameter contro NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- control_file_record_keep_time integer 7 ...

Export / Import the use of techniques and common errors

Export / Import the use of techniques and common errors rn [b] Export / Import the use of techniques and common errors [/ b] rn Export and Import are a pair of reading and writing tool for Oracle data. Export the Oracle database data output to the op ...

Start Oracle Troubleshooting Common Problems

Start Oracle Troubleshooting Common Problems Instance and database startup and shutdown are the important duties of the DBA. Only open the database, other users of the data in the database in order to operate. Once the database is shut down, its oper ...

Interestingly, the string conversion

Interestingly, the string conversion rn Required to use pl / sql to write a function to achieve under the separator is divided into a number of the original string is the string function. Input: string (String) and Delimiter (Separator) Output: subst ...

Oracle 007 after reading the notes (some chaos)

Upper (au_fname) to switch to uppercase; Where conditions are case-sensitive; can be lower; upper; initcap be defined; This is the need to introduce the reasons for case conversion bar! ^ 0 ^ Chapter Digital Series number, pls_integer and binary_inte ...

Oracle Database Quick Copy (2)

Finally back. Today, fast-copy second chapter describes the database. 1: First, to prepare a server A, which is installed callcenter Database 2: Re-preparing for the second server B, which installed the aaa Database 3: end, it would A, callcenter dat ...

Understanding Joins (understanding link)

Since the work required to read "Oracle 9i Database Performance Tuning Guide and Reference" document, this section of Translation He will be out. Initially only for the purpose of deepening their own understanding and repeated scrutiny of t ...

Understanding Joins (understand the link)

Since the work required to read "Oracle 9i Database Performance Tuning Guide and Reference" document, this section of Translation He will be out. Initially only for the purpose of deepening their own understanding and repeated scrutiny of t ...

Oracle Installation (linux) Summary

oracle under linux install: Oracle's claim that the Linux install Oracle9i database, at least 512MB of memory and at least 1GB of memory, or twice the size of the swap space for the system memory is larger than 2GB of server space can range from ...

RAC to modify the oracle archive log mode

The more distant, and rely on the notes at that time, a simple summary of what, after all, not good to save paper ... ... oracle of all the default configuration is not good, or else the service is unable to sell the money After the database is insta ...

ORACLE commonly asked stupid questions 1000 (Part II)

ORACLE in the application when you may encounter a lot of looks? Lut y muddy the issue, particularly for novice? Bei f, today, I simply put it to sum up, release to you, hope all of us help! And everyone to explore make progress together! Right ORACL ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments