CLICK HERE TO DOWNLOAD PPT ON ORACLE 10G
ORACLE 10G Presentation Transcript
1.ORACLE10G
2.Introdution
3.Oracle Database 10g
Oracle Database 10g is the first database designed for grid computing.
Most flexible and cost-effective way to manage enterprise information.
It cut costs of management while providing the highest possible quality of service.
An Object Relational DataBase Management System (ORDBMS).
Oracle Database 10g is the first database designed for grid computing.
Most flexible and cost-effective way to manage enterprise information.
It cut costs of management while providing the highest possible quality of service.
An Object Relational DataBase Management System (ORDBMS).
4.Database Structures
Each running oracle database is associated with an instance (Mounting).
Uses memory structures and processes for managing and accessing DB.
Memory exists in the main memory of computer that constitute database server.
Processes are jobs that work in the memory of these computers.
Each running oracle database is associated with an instance (Mounting).
Uses memory structures and processes for managing and accessing DB.
Memory exists in the main memory of computer that constitute database server.
Processes are jobs that work in the memory of these computers.
5.Instance
6.Management Framework
The three components of the Oracle Database 10g management framework are:
Database instance
Listener
Management interface
Database Control
Management agent (when using Grid Control)
The three components of the Oracle Database 10g management framework are:
Database instance
Listener
Management interface
Database Control
Management agent (when using Grid Control)
7.Dynamic Performance Views
Dynamic performance views provide access to information about changing states and conditions in the database.
Can query V$FIXED_TABLE to see all the view names.
These views are often referred to as “v-dollar views.”
Dynamic performance views provide access to information about changing states and conditions in the database.
Can query V$FIXED_TABLE to see all the view names.
These views are often referred to as “v-dollar views.”
8.Storage
9.Storage Structures
Database is divided into tablespaces.
Each tablespace has logical data blocks.
Logical blocks forms extent.
A set of extent forms one segment.
Database is divided into tablespaces.
Each tablespace has logical data blocks.
Logical blocks forms extent.
A set of extent forms one segment.
10.Automatic Storage Management
Portable n high-performance cluster file system.
Manages Oracle database files.
Spreads data across disks to balance load.
Mirrors data.
Solves many storage management challenges.
Stripes files, but not logical volumes.
Portable n high-performance cluster file system.
Manages Oracle database files.
Spreads data across disks to balance load.
Mirrors data.
Solves many storage management challenges.
Stripes files, but not logical volumes.
11.Benefits
Provides online disk reconfiguration and dynamic rebalancing.
Allows for adjustable rebalancing speed.
Provides redundancy on a per-file basis.
Supports only Oracle database files.
Is cluster aware.
Is automatically installed.
Provides online disk reconfiguration and dynamic rebalancing.
Allows for adjustable rebalancing speed.
Provides redundancy on a per-file basis.
Supports only Oracle database files.
Is cluster aware.
Is automatically installed.
12.Users
13.Privileges
System: Enables user to perfrom particular action in DB.
Object: Enables user to access and manipulate a specific object.
System: Enables user to perfrom particular action in DB.
Object: Enables user to access and manipulate a specific object.
14.Roles
Easier privilege management.
Dynamic privilege management.
Selective availability of privileges.
Easier privilege management.
Dynamic privilege management.
Selective availability of privileges.
15.Assigning privileges to roles and roles to users
16.Security
17.Database Security
A secure system ensures the confidentiality of the data that it contains. There are several aspects of security:
Restricting access to data and services.
Authenticating users.
Monitoring for suspicious activity (Auditing).
A secure system ensures the confidentiality of the data that it contains. There are several aspects of security:
Restricting access to data and services.
Authenticating users.
Monitoring for suspicious activity (Auditing).
18.DB Auditing
19.Install only required software on machine.
Activate only required services.
Give DB access to only those users who require access.
Limit access to root account.
Activate only required services.
Give DB access to only those users who require access.
Limit access to root account.
20.Locks
After locking, no other data can modify the locked data.
Can lock individual, multiple row or the entire table.
Oracle supports both manual and automatic locking.
After locking, no other data can modify the locked data.
Can lock individual, multiple row or the entire table.
Oracle supports both manual and automatic locking.
21.Data And Concurrency
22.Manipulating data by SQL
There are five types of SQL statements namely:
Data Retrieval.
Data Manipulation Language(DML).
Data Definition Language(DDL).
Transaction Control.
Data Control Language(DCL).
There are five types of SQL statements namely:
Data Retrieval.
Data Manipulation Language(DML).
Data Definition Language(DDL).
Transaction Control.
Data Control Language(DCL).
23.Data Manipulation Language The data manipulation language statements are: DELETE INSERT MERGE SELECT UPDATE
24.Data Definition Language
Data definition language (DDL) statements let you to perform these tasks:
CREATE, ALTER, and DROP schema objects.
GRANT and REVOKE privileges and roles.
Analyze information on a table, index, or cluster
Establish auditing options.
Add comments to the data dictionary.
Data definition language (DDL) statements let you to perform these tasks:
CREATE, ALTER, and DROP schema objects.
GRANT and REVOKE privileges and roles.
Analyze information on a table, index, or cluster
Establish auditing options.
Add comments to the data dictionary.
25.Data Control Statements
Data control statements manage changes made by DML statements.
The transaction control statements are:
- COMMIT
- ROLLBACK
Data control statements manage changes made by DML statements.
The transaction control statements are:
- COMMIT
- ROLLBACK
26.Backup And Recovery
27.BackUp
Complete Backup solutions.
Provides media management.
Backs up data anywhere on the network.
Complete Backup solutions.
Provides media management.
Backs up data anywhere on the network.
28.Recovery Manager (RMAN)
Used for recovery.
RMAN:
Is a command-line client for advanced functions.
Has powerful control and scripting language.
Backs up data, control, archived log, and server parameter files.
Backs up files to the disk or tape.
Used for recovery.
RMAN:
Is a command-line client for advanced functions.
Has powerful control and scripting language.
Backs up data, control, archived log, and server parameter files.
Backs up files to the disk or tape.
29.Applications of Oracle 10g database
Banking
Airlines
Universities
Telecommunication
Online retailer
Human resources
Banking
Airlines
Universities
Telecommunication
Online retailer
Human resources
Posts
0 comments