Oracle Database 10g provides a fairly easy upgrade path for users of older Oracle Database versions. The following versions can directly be upgraded to Oracle Database 10g:
- Oracle Database 8.0.6
- Oracle Database 8.1.7
- Oracle Database 9.0.1
- Oracle Database 9.2
- Use exp/imp to copy the data in your database to a new Oracle Database 10g database.
- New tablespace called SYSAUX.
- SYSAUX is a secondary tablespace for storage of a number of database components that were previously stored in the SYSTEM tablespace.
- Default tablespace for Management of Data Base features such as RMAN recovery catalog, Ultra Search,
Data Mining , XDP, and OLAP.- The SYSAUX tablespace consolidates these tablespaces into one location.
- Database statement with the sysaux datafile clause in it:
CREATE DATABASE my_db
DATAFILE 'c:\oracle\oradata\my_db\my_db_system_01.dbf' SIZE 300m
SYSAUX DATAFILE 'c:\oracle\my_db\my_db_sysaux_01.dbf' SIZE 100m
DEFAULT TEMPORARY TABLESPACE dtemp_tbs tempfile
'c:\oracle\my_db\my_db_temp_01.dbf' SIZE 100m
UNDO TABLESPACE undo_tbs_one DATAFILE
'c:\oracle\my_db\my_db_undo_tbs_one_01.dbf' SIZE 100m;
- Each set of application tables within the SYSAUX tablespace is known as an occupant.
- a new view, V$SYSAUX_OCCUPANTS
- SELECT occupant_name, space_usage_kbytes FROM v$sysaux_occupants;
- To create tablespace statement that you would use to perform this operation:
CREATE TABLESPACE sysaux
DATAFILE 'c:\oracle\oradata\my_db\my_db_sysaux_01.dbf' SIZE 300m
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;Automatic storage management (ASM) : 10 g Feature:
- a service that provides management of
disk drives .- Setting Up ASM Disks:
- set up disk groups.
- a disk group is a logical collection of a number of physical disk devices.
- Create diskgroup disk_group_001
FAILGROUP fail_group_01 DISK
'/dev/disk1', '/dev/disk2', '/dev/disk3',
FAILGROUP fail_group_02 DISK
'/dev/disk5', '/dev/disk6', '/dev/disk7';
- Oracle will mirror the two groups.
- ASM and Data Dictionary Views:
- V$ASM_ALIAS : displays a single row for every alias present in every disk group mounted by the ASM instance.
- V$ASM_CLIENT: displays a single row for every database instance using a disk group managed by the ASM instance.
- V$ASM_DISK: displays a single row for every disk discovered by the ASM instance.
- V$ASM_DISKGROUP: displays a single row for every ASM file in every disk group mounted by the ASM instance.
- V$ASM_FILE: displays a single row for every ASM file in every disk group mounted by the ASM instance.
- V$ASM_OPERATION: displays a single row for every active ASM long-running operation executing in the ASM instance.
- V$ASM_TEMPLATE: displays a single row for every template present in every disk group mounted by the ASM instance.
Real Application Clusters ( RAC):
- Portable Clusterware:
- services for the Oracle Database 10g RAC configuration
- Cluster Ready Services:
- node membership, group services, global resource management, and high availability.
- to manage the workload of the various
machines of the cluster.- dbms_services PL/SQL stored procedure.
- Automatic Workload Repository (AWR).
- AWR provides the ability to monitor any specific performance thresholds.
- DBA notification alerts based on these thresholds.
Grids (G):
- The Grid is all about the synergies that can be achieved by aligning the Oracle technologies with the capabilities of existing and future hardware.
- Grid Computing Infrastructure.
- Dynamic allocation of resources for Processing and Storage.
The gcs_server_processes Parameter:
- defines the initial number of server processes in Global Cache Service that are started to serve inter-instance traffic.
- The default value for this parameter is 2, and the value can range from 1 to 20.
- This parameter can also be set differently for each instance in the cluster.
Administration:
Oracle System Global Area (SGA):
| Click to go to Home Page |