Oracle
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Oracle as PDF for free.
More details
- Words: 529
- Pages: 2
1 • •
•
•
•
• • • • • •
•
Version: 10.1.0.2 in spring 2004 Three new three primary thrusts -ease of management -enhanced scalability -improved performance management The ease of management features include the automatic management of disk storage allocated to the database, proactive monitoring and self-tuning of the database’s memory structures, preconfigured database alerts, and enhanced, webbased tools for monitoring and managing the entire oracle architecture. Scalability and performance improvements are largely based on oracle’s grid computing model. Grid computing is intended to allow businesses to move away from the idea of many individual servers, each of which is dedicated to a small number of applications. There are five editions of oracle 10g - Enterprise: include all available oracle 10g features either bundled or as extra-cast options. - Standard Edition: includes full clustering features and all oracle 10g easeof-management features for servers running as many as four processors. - Standard Edition One: Include oracle 10g ease-of-management features for servers running as many as two processors. - Personal: includes all available oracle 10g features either bundled or as extra-cost options, but for an individual user database. - Lite: Include all oracle 10g features needed to build and deploy mobile database application. Data Definition Language (DDL): CREATE, ALTER, DROP Data Control Language (DCL): GRANT, REVOKE Data Manipulation Language (DML): INSERT, UPDATE, DELETE. Oracle 10g can accommodate tables that have as many as 1000 columns and billions of rows. An oracle 10g database contains two types of metadata views - data dictionary views - dynamic performance views Data dictionary views: Depending on which are installed are configured, an oracle 10g database can contain more than 1300 data dictionary views. Data dictionary views have manes that begin with DBA_, ALL_ and USER_. - DBA_TABLES views: shows information all tables in the database. - ALL_TABLES views: shows only the tables that a particular database user owns or has access to. - USER_TABLES view shows only those objects owned by a user. Data Dictionary Views: - DBA_Table: shows the name and physical storage information about all the tables in the database. - DBA_users: shows information about all the users in the database. - DBA_views: shows information about all the views in the database.
2 -
•
• •
• •
Dba_tab_columns: shows all the names and datatypes of the table columns in the database. Dynamic Performance views: - V$DATABASE: Contain information about the database itself, such as the database name and when the database is created. - V$VERSION: shows which software version the database is using. - V$OPTION: Display which optional component are installed in the database. - V$SQL: Display information about the sql statements that database users have been issuing. Constraint: A constraint allows the database designer to enforce business rules about the data stored in the database’s tables and the relationships between tables. Five types of constraints: - Not mull: a value must be supplied for this column, but values do not have to be unique. - Unique key: every value in this column must be unique, but null values are allowed. - Primary key: every value in the column must be unique and cannot be null. -
•
•
•
• • • • • •
•
Version: 10.1.0.2 in spring 2004 Three new three primary thrusts -ease of management -enhanced scalability -improved performance management The ease of management features include the automatic management of disk storage allocated to the database, proactive monitoring and self-tuning of the database’s memory structures, preconfigured database alerts, and enhanced, webbased tools for monitoring and managing the entire oracle architecture. Scalability and performance improvements are largely based on oracle’s grid computing model. Grid computing is intended to allow businesses to move away from the idea of many individual servers, each of which is dedicated to a small number of applications. There are five editions of oracle 10g - Enterprise: include all available oracle 10g features either bundled or as extra-cast options. - Standard Edition: includes full clustering features and all oracle 10g easeof-management features for servers running as many as four processors. - Standard Edition One: Include oracle 10g ease-of-management features for servers running as many as two processors. - Personal: includes all available oracle 10g features either bundled or as extra-cost options, but for an individual user database. - Lite: Include all oracle 10g features needed to build and deploy mobile database application. Data Definition Language (DDL): CREATE, ALTER, DROP Data Control Language (DCL): GRANT, REVOKE Data Manipulation Language (DML): INSERT, UPDATE, DELETE. Oracle 10g can accommodate tables that have as many as 1000 columns and billions of rows. An oracle 10g database contains two types of metadata views - data dictionary views - dynamic performance views Data dictionary views: Depending on which are installed are configured, an oracle 10g database can contain more than 1300 data dictionary views. Data dictionary views have manes that begin with DBA_, ALL_ and USER_. - DBA_TABLES views: shows information all tables in the database. - ALL_TABLES views: shows only the tables that a particular database user owns or has access to. - USER_TABLES view shows only those objects owned by a user. Data Dictionary Views: - DBA_Table: shows the name and physical storage information about all the tables in the database. - DBA_users: shows information about all the users in the database. - DBA_views: shows information about all the views in the database.
2 -
•
• •
• •
Dba_tab_columns: shows all the names and datatypes of the table columns in the database. Dynamic Performance views: - V$DATABASE: Contain information about the database itself, such as the database name and when the database is created. - V$VERSION: shows which software version the database is using. - V$OPTION: Display which optional component are installed in the database. - V$SQL: Display information about the sql statements that database users have been issuing. Constraint: A constraint allows the database designer to enforce business rules about the data stored in the database’s tables and the relationships between tables. Five types of constraints: - Not mull: a value must be supplied for this column, but values do not have to be unique. - Unique key: every value in this column must be unique, but null values are allowed. - Primary key: every value in the column must be unique and cannot be null. -
