Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


561: I installed RH9 experience Oracle8.1.7
My environment: Machine C1200M, 128M Software RedHat Linux release 9, Kernel 2.4.20-8. glibc-2.1.3-stubs.tar.gz / / oracle patch for linux j2sdk-1_4_2_06-linux-i586-rpm.bin / / Sun's JDK linux81701.tar / / ORACLE installation disk The inst...

562: Oracle memory structure: SGA's Regional Information
SGA's Regional Information ...

563: Oracle database in how to deal with the bad block problem
This article describes how to deal with in the Oracle database appears the problem of bad blocks, bad blocks generated for the object in different, ways to deal with will be different, this article will do more or less on the introduction of these m...

564: How to View Oracle process memory consumption
Some people say that the output of Top inaccurate, this view is not accurate. Top output actually shows memory usage of Oracle processes, including part of the SGA. This is the significance of SGA. SGA can be shared, all processes can be visited, i...

565: Oracle Database 10g: delete table
The use of Oracle Database 10g features flashback table, you can easily restore accidentally deleted a table ------------------------ ------- ---------- RECYCLETEST TABLE ------------------------------ ------- ---------- BIN $ 04LhcpndanfgMAAAAA...

566: Oracle Database 10g: Flashback version query
Settings do not need to immediately identify all the changes on the line SQL> desc rates Name Null? Type ----------------- -------- ------------ CURRENCY VARCHAR2 (4) RATE NUMBER (15,10) insert into rates values ( 'EURO', 1.1012); ...

567: Oracle Database 10g: rollback surveillance
To provide users with the operation of the rollback of time to accurately assess the SELECT USED_UREC FROM V $ TRANSACTION; select time_remaining from v $ session_longops where sid = <sid of the session doing the rollback>; SQL> set s...

568: Oracle Database 10g: The table space to improve the management of
Table space management has been significant improvement, which can be attributed to a sparser SYSTEM, for a default user-defined table space support, the new SYSAUX, and even rename FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_PERMA...

569: Oracle Database 10g: Automatic Shared Memory Management
Is it difficult to accurately allocated to the allocation of places most in need to become Different number of required memory pool? Were able to automatically. Enjoy automatic memory management features will make the memory sub - Whether you'...

570: ROWID in ORACLE
We may use oracle's rowid is no stranger, but if a closer look and found that their knowledge or some point. 1, rowid is a pseudo-column is used to ensure that the only form of Bank of China, it is not indicative of the physical location of tra...

571: Oracle memory structure: Shared Pool details
The Shared Pool in SGA is a part of a larger SIZE. There are many DBA did not engage in Shared Pool is used to understand what to do, and do not know how to set the Shared Pool suitable SIZE. On the arbitrary will make it very SIZE Great. sometimes ...

572: Oracle diagnosed cases to stop the implementation of task-Job
System environment: SunOS DB 5.8 Generic_108528-21 sun4u sparc SUNW, Ultra-4 Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production $ Sqlplus "/ as sysdba" SQL * Plus: Release 9.2.0.3.0 - Production on Wed Nov 17 20:23:53 2004 Copyr...

573: oracle script to build table with default values which
In the creation of database tables, you can specify a DEFAULT value (that is, the default value). The database fields use the default value will contribute to the issue of database design and application of code isolation. Can be at a later time by...

574: Oracle's in and not in - the performance of practice
In many software systems, the performance of the system is playing extent the performance of the decision database. Have done before many times on the performance of various tests, especially on the oracle, and I think part of it should be recorded ...

575: RedHat9.0 install Oracle8i
First download jdk1.41, glibc2.1, oracle8i for linux ...

576: [Oracle 10g] large table space
Briefly Large files (Bigfile) table space. On VLDB management capabilities. Automatic space management segment only of the LMT (Locally Managed Tablespaces) support BIGFILE tablespace. Table space for large files can contain only one document, but...

577: Sql text a useful (ORACLE)
Yesterday trying to get a field, it was found that the existing data, not the value of the field, and the procedures required to elect a number of years, that is to say, the sql text in any case have to be selected data to a. , following a statement...

578: Oracle 904 Instal On RedHat AS3
--------------------------- MAKE RAID DISK STORAGE ------------------- --- STEP 1: FOLLOW AS THE HINT, PRESS CTRL-M, START TO CONFIG RAID STEP 2: MAKE 3 RAIDS: 1 DISK, 1 DISK, 4 DISKS. in installing we choose chinese simplified language package...

579: For more information Process Memory (b)
The CGA: The overall situation with the other different, Call Global Area is a transient existence. It is only during the existence of data in the call, the general case in the lowest level of the call when the need to CGA, as follows: Analysis of...

580: For more information Process Memory (a)
The Process Memory: Apart from the SGA (System Global Area) in addition, Oracle also uses the process of the overall situation of the following three areas: The Process Global Area (PGA) The User Global Area (UGA) The Call Global Area (CGA) Man...


Page 29 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]