Corporate PPT Template - PowerPoint PPT Presentation

Loading...

PPT – Corporate PPT Template PowerPoint presentation | free to download - id: 5a9ab4-NDE2M



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Corporate PPT Template

Description:

Title: Corporate PPT Template Last modified by: carlos Created Date: 11/6/1996 7:19:12 PM Document presentation format: Presentaci n en pantalla Company – PowerPoint PPT presentation

Number of Views:1047
Avg rating:3.0/5.0
Slides: 54
Provided by: disUnalE5
Learn more at: http://dis.unal.edu.co
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Corporate PPT Template


1
Carlos Eduardo TrivinoOracle Certified
Associate Database Administrator
2
Where we come from
3
Introducing
4
Oracle Database 10gA Revolution in Database
Technology
5
Oracle 1 Database Vendor in 2004
Who is 1 in databases?
(Includes License Maintenance)
Source IDC, July 2004
6
Oracle Database 10g Goals
  • Half the Cost
  • Highest Quality of Service
  • Highest Availability, Reliability, Security
  • Highest Performance, Scalability
  • Easiest to Manage

7
Problem Islands of Computation
  • Limited scalability, no resource sharing
  • Must be configured for peak loads
  • Single point of failure
  • Slow to adjust to business needs

Sales
Files
HR
Procurement
Service
Supply Chain
Financials
8
Grid Computing Eliminates Islands of Computation
Coordinated use of many small servers acting as
one large computer.
IT Problem
Grid Solution
  • Separate servers
  • High h/w s/w costs
  • Configured for peak
  • Single point of failure
  • Hard to change
  • Difficult to manage
  • Shared servers
  • Low cost components
  • Capacity on demand
  • Fault tolerant
  • Flexible
  • Unified management

9
Introducing Oracle 10g
  • Complete, integrated grid infrastructure

10
Oracle Grid Computing
  • Low cost
  • Highest quality of service
  • Rapidly adjusts to meet business needs
  • Unified management

11
Grid Computing Defined
Coordinated use of many small servers acting as
one large computer.
12
Example In December
  • Order Entry maxes out processing orders
  • Financials is idling below capacity

Order Entry
Financials
13
Example In January
  • Order Entry drops off from season high
  • Financials maxes out on year end close

Order Entry
Financials
14
Grid Fault Tolerance
Database App. Server Total
Failover Detection Recovery Time
minutes
minutes
Oracle9i Oracle 10g
10 - 60 secs
lt 12 secs
lt 4 secs
lt 8 secs
  • Re-establish database connections faster with
    Oracle 10g infrastructure.

15
10g Performance Metrics
  • PLSQL up to 2x
  • Table Scans up to 2x
  • SQL Profile Tuning huge
  • Floating point math up to 10x
  • Bulk LOB Update up to 3x
  • Import up to 15x
  • Export up to 35
  • Incremental backup up 10x
  • Parallel media recovery 2-4x
  • Backup compression 17x
  • Infiniband interconnect ½ latency, 2x block
    transfer
  • TPC-C
  • Best absolute and best on 4-way Intel
  • 28 on same hardware

16
Business Challenge How to Scale DBAs to the
Grid ?
Installation 6
Others 15
DataLoading 6
Software Maintenance 6
Ongoing System Management 55
Source IOUG 2001 DBA Survey
17
10g initialization parameters
  • Basic parameters
  • CLUSTER_DATABASE
  • COMPATIBLE
  • CONTROL_FILES
  • DB_BLOCK_SIZE
  • DB_CREATE_FILE_DEST
  • DB_CREATE_ONLINE_LOG_DEST_n
  • DB_DOMAIN
  • DB_NAME
  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE
  • DB_UNIQUE_NAME
  • INSTANCE_NUMBER
  • JOB_QUEUE_PROCESSES
  • LOG_ARCHIVE_DEST_n
  • LOG_ARCHIVE_DEST_STATE_n
  • NLS_LANGUAGE, NLS_TERRITORY
  • OPEN_CURSORS
  • PGA_AGGREGATE_TARGET
  • PROCESSES
  • REMOTE_LISTENER
  • REMOTE_LOGIN_PASSWORDFILE
  • ROLLBACK_SEGMENTS
  • SESSIONS
  • SGA_TARGET
  • SHARED_SERVERS
  • STAR_TRANSFORMATION_ENABLED
  • UNDO_MANAGEMENT
  • UNDO_TABLESPACE

18
Flashback Versions Query
  • view the contents of a table as it existed at
    some point in the recent past(UNDO_RETENTION).
  • The feature allows the DBA to see the value of a
    column as of a specific time, as long as the
    before-image copy of the block is available in
    the undo segment

19
Rename Tablespace
  • Useful in Transportable Tablespace scenarios
  • ALTER TABLESPACE user RENAME to u1
  • Cant rename SYSTEM or SYSAUX
  • Tablespace and all datafiles must be online
  • Can also rename READ ONLY tablespaces

PROD
ARCHIVE
20
Tablespaces and Groups
  • Huge tablespaces could be separated for
    maintenance (backuprecovery) reasons
  • Users still have single point for storing data
  • CREATE TABLESPACE TS DATAFILE xx SIZE
    1MTABLESPACE GROUP G1
  • ALTER TABLESPACE NEWTS TABLESPACE GROUP G1
  • ALTER TABLESPACE NEWTS TABLESPACE GROUP
  • CREATE TABLE T() TABLESPACE G1

21
Bigfile Tablespaces
  • Support for sizes up to 8 Exabytes!
  • 8 000 000 Terabytes
  • Max 65535 files in database
  • SYSTEM SYSAUX cant be bigfile tablespaces
  • CREATE BIGFILE TABLESPACE bigtbsDATAFILE
    '/u02/oracle/data/bigtbs01.dbfSIZE 50G EXTENT
    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

8 000 000 000 000 000 000 bytes
22
Crossplatform Transportable TS
  • RMANgt CONVERT TABLESPACE sales_1,sales_2
  • 2gt TO PLATFORM Microsoft Windows NT
  • 3gt FORMAT /temp/U
  • ...
  • Transporting Tablespaces Between Databases
  • input datafile fno00004 name/u01/oracle/oradata/
    salesdb/sales_101.dbf
  • converted datafile/temp/data_D-10_I-3295731590_TS
    -EXAMPLE_FNO-4_06ek24vl
  • channel ORA_DISK_1 datafile conversion complete,
    elapsed time 000045

Crossplatform Transportable DB
Now you can transport an entire database across
platforms that share the same endianess (byte
ordering) in the release 2.
23
Data Pump
  • A server-managed data transportation tool
  • Direct load/extract capabilities
  • Very high performance/efficient with large data
    sets
  • Replacement for exp/imp
  • old exp/imp remain supported

DataPumpClient
DataPumpClient
PROD
DataWarehouse
Data Pump
Data Pump
24
Data Pump
  • Commands expdp/impdp
  • Can use files or direct network transfer
  • Dynamic configuration, resumable operations
  • Client can detach and reconnect
  • Can be parallelized using PARALLEL
  • Even loads to/from external text files
  • Monitored through DBA_DATAPUMP_JOBS

expdp hr/hr dumpfilechap7job_tabs.dmp
nologfiley contentmetadata_only
tablesjobs,job_history
25
Database Encryption(new feature release 2)
  • You can encrypt any or all the columns in a
    table.
  • Since the data is stored encrypted, all
    downstream
  • components, such as backup and archived logs,
  • also have the encrypted format

26
How Transparent Data Encryption works
ENCRYPTION_WALLET_LOCATION (SOURCE
(METHODfile) (METHOD_DATA
(DIRECTORY/orawall)))
alter system set encryption key authenticated by
"remnant"
alter system set encryption wallet open
authenticated by "remnant"
27
  • create table accounts (
  • acc_no number not null,
  • first_name varchar2(30) not null,
  • last_name varchar2(30) not null,
  • SSN varchar2(9) ENCRYPT USING 'AES128')
  • alter table accounts modify (ssn encrypt using
    'AES128')

28
Online Reorg of a Single Partition
  • partition by range (trans_date) (
  • partition y03q1 values less than
    (to_date('04/01/2003','mm/dd/yyyy')),
  • partition y03q2 values less than
    (to_date('07/01/2003','mm/dd/yyyy')), partition
    y03q3 values less than (to_date('10/01/2003','mm/d
    d/yyyy'))
  • )
  • Begin
  • dbms_redefinition.start_redef_table(
  • uname gt 'ARUP',
  • orig_table gt 'TRANS',
  • int_table gt 'TRANS_TEMP',
  • col_mapping gt NULL,
  • options_flag gt dbms_redefinition.cons_us
    e_rowid,
  • part_name gt 'Y03Q2')
  • end

29
Unlimited DBMS Output
  • ERROR at line 1
  • ORA-20000 ORU-10027 buffer overflow, limit of
    1000000 bytes ORA-06512 at "SYS.DBMS_OUTPUT",
    line 32
  • ORA-06512 at "SYS.DBMS_OUTPUT", line 97
  • ORA-06512 at "SYS.DBMS_OUTPUT", line 112
  • ORA-06512 at line 2
  • package dbms_output used to be 1 million
    bytes(release 1)
  • package dbms_output used to unlimited
    bytes(release 2)

30
WRAP Package
  • PL/SQL program units often contain very sensitive
    and confidential information about company
    procedures and trade secrets
  • begin
  • dbms_ddl.create_wrapped
  • ('create or replace procedure p2 as begin
    null end')
  • end

31
Autotrace
  • Autotrace is now using the DBMS_XPLAN package to
    display the explain plans. This gives us a much
    more detailed explain plan.
  • set autotrace traceonly explain

32
Conditional Compilation
  • Conditional compilation is the ability to make
    the compiler effectively ignore code (or not)

create or replace procedure p as begin
IF debug_code THEN
dbms_output.put_line( 'Our debug code' )
dbms_output.put_line( 'Would go here' )
END dbms_output.put_line( 'And our real
code here' ) end
alter procedure P compile 2 plsql_ccflags
'debug_codetrue' reuse settings
33
Automatic Storage Management (ASM)
  • Eliminates need for conventional file system and
    volume manager
  • Capacity on demand
  • Add/drop disks online
  • Automatic I/O load balancing
  • Stripes data across disks to balance load
  • Best I/O throughput
  • Automatic mirroring
  • Easy

Automatic Storage Management
34
ASM How it Works
  • No volumes just a pool of storage
  • Partitions total disk space into uniform sized
    megabyte units

Automatic Storage Management
35
ASM How it Works
  • No volumes just a pool of storage
  • Partitions total disk space into uniform sized
    megabyte units
  • Efficient, online add/remove of disk with
    automatic rebalancing

Automatic Storage Management
36
ASM How it Works
  • No volumes just a pool of storage
  • Partitions total disk space into uniform sized
    megabyte units
  • Efficient, online add/remove of disk with
    automatic load balancing

Automatic Storage Management
37
Automatic Storage Management Summary
  • Low Cost
  • Eliminates need for volume manager and file
    systems
  • Works well with inexpensive, modular storage
  • Better storage utilization
  • Easy up to 50 less DBA/Sys Admin work
  • Fault tolerant
  • Raw disk performance
  • Capacity on demand
  • Automatic I/O load balancing

38
Flashback Database
  • New strategy for point-in-time recovery
  • Flashback Log captures old versions of changed
    blocks
  • Think of it as a continuous backup
  • Replay log to restore DB to time
  • Restores just changed blocks
  • Its fast - recovers in minutes, not hours
  • Its easy - single command restore
  • SQLgt Flashback Database to 205 PM

Old Block Version
Disk Write
New Block Version
Flashback Log
Like a Rewind button for the Database
39
Storage Grid - Highest Data Protection for Lowest
Cost
40
Oracle10g High Availability Features
  • Backup and Recovery
  • Automated Disk-Based Backup and Recovery
  • Drop Database
  • RMAN Database Deregistration
  • Backup of Standby Control File
  • Automated TSPITR Instantiation
  • Simplified Recovery Manager Cataloging of Backup
    Files
  • Automated Channel Failover for Backup and Restore
  • Automated File Creation During Recovery
  • Simplified Backups to Disk
  • Proxy Copy Backup of Archivelogs
  • Backup and Recovery (Cont)
  • Incrementally Updated Backups
  • Simplified Recovery Through Resetlogs
  • Restore Tolerates Corrupt or Missing Backups
  • Full Database Begin Backup Command
  • Change-Aware Incremental Backups
  • Data Guard
  • Data Guard Broker Support for RAC
  • Automated LogMiner Configuration
  • Log Miner Support for Index-Organized Tables
  • Secured Redo Transmission
  • Data Guard (Cont)
  • Fine-Grained Supplemental Logging
  • Named Data Guard Configurations
  • Simplified Zero Data Loss for Data Guard SQL
    Apply
  • Zero Downtime Instantiation for SQL Apply
  • Real Time Apply
  • Redo Data and Archivelog Compression
  • Flashback
  • Flashback Database
  • Flashback Reinstantiation
  • Flashback Standby Database
  • Flashback Table
  • Flashback Row History
  • Flashback Drop
  • Flashback Transaction History
  • Online Operations
  • Enhanced Online Redefinition
  • Improved Handling of DDL Locks on Busy Tables
  • Signature-Based Dependency Tracking Using
    Synonyms
  • Rolling Upgrades with Data Guard SQL Apply

41
Database Server Grid Real Application Clusters
  • Runs Real Applications
  • Proven
  • Over 500 production sites
  • Certified with leading apps
  • Runs on standard,low cost servers
  • Fault tolerant
  • Capacity on demand
  • New integrated clusterware makes it easy
    everywhere

ERP
CRM
DW
42
Database Server Grid Workload Management
  • Push-button, online add/drop server to cluster
  • Automatic Load Balancing
  • Based on service concept
  • Automatic routing of service connection requests
    to appropriate server with lowest load
  • On server failure, automatic re-allocation of
    surviving servers to services
  • Dynamic load balancing when service levels not
    met (coming soon)

43
Oracle RAC 10g - Only Solution for Enterprise
Grids
  • Mission Critical Quality of Service on Industry
    Standard, Low Cost Servers
  • Integrated clusterware makes RAC easy for
    everyone
  • Fault tolerant, scales all applications
  • Capacity on demand
  • Automatic load balancing

44
Oracle 10g Grid ManagementOne-half to one-tenth
the cost
  • Self-Managing Database
  • OEM Grid Control
  • Grid-wide operations
  • Scale from one to hundreds of systems with little
    incremental cost

45
Oracle Database 10gSelf-managing Database
  • Built-in Intelligent Infrastructure
  • Code instrumentation
  • Data warehouse to analyze performance of customer
    workloads
  • Automatic Database Diagnostic Monitor
  • Automatic performance diagnostic engine in the
    database
  • Automatic Tuning Optimizer
  • SQL Profile to tune packaged applications
  • Automatic PGA and SGA Memory Management
  • Lots more

46
Oracle 10g OEM Grid Control
  • Manages the Oracle Grid environment
  • Scales to thousands of servers
  • Application Service Level Management
  • Configuration Management
  • Provisioning
  • Cloning
  • Patch Management

47
Business Intelligence on the Grid
  • Lower Cost
  • Leverage 10g hardware, software, labor savings
  • Manage millions of terabytes
  • Intelligence when you need it
  • Cross-platform transportable tablespaces
  • Asynchronous change data capture
  • More value from your data
  • Mature OLAP, Data Mining
  • Improved SQL Analytics SQL Model Clause

48
HTML DB Rapid Web Development Tool
  • Builds database-driven Web applications
  • For non-programmers
  • App developers and app users just need a web
    browser
  • Addresses MS Access proliferation problem
  • Supports hosted development and deployment
    environment

49
Easy Transition to the Grid
  • Oracle 10g preserves investment
  • Runs all existing apps on clusters
  • Moves data to new platforms as fast as FTP
  • Low risk - Start small and add capacity on demand

ERP
EMAIL
DW
50
Oracle 10g Grid Computing
  • Half the Cost
  • Low cost, modular storage and servers
  • Complete, integrated software infrastructure
  • Half the labor cost
  • Highest Quality of Service
  • Rapidly Adjust to Business Needs
  • Capacity on demand
  • Load balancing
  • Easy to Manage

51
Key Technology Innovations
  • Automatic Storage Management
  • Flashback Database/Table
  • Fast Disk-based Backup and Recovery
  • RAC Workload Management
  • Rolling Upgrade
  • Cross-platform Transportable Tablespaces
  • Exabytes of data
  • SQL Model Clause
  • Self-managing Database
  • Grid Control
  • HTML DB
  • Integrated software stack

52
Next Steps.
  • Tuesday, 2pm, Larry Ellison, Keynote on 10g
  • Wednesday, 945 Chuck Rozwat, Keynote on 10g
  • Wednesday, 230 Ken Jacobs, Keynote on Ease of
    Management

53
Key Technical Presentations
  • Self-managing DB, Monday, 1 pm, Rm 103
  • HTML DB, Monday, 1 pm, Rm 104
  • OEM Grid Control, Monday, 230 pm, Rm 103
  • RAC, Monday, 230 pm, Rm 104
  • SQL Model Clause, Monday, 4 pm, Rm 130
  • High Availability, Tuesday, 11 am, Rm 304
  • XML DB, Tuesday, 11 am, Rm 130
  • Grid, Tuesday, 330 pm, Rm 102
  • ASM, Wednesday, 11 am, Rm 103
  • Streams, Wednesday, 1 pm, Rm 103
  • OLAP, Thursday, 1 pm, Rm 131

54
(No Transcript)
55
Reminder please complete the OracleWorld
online session surveyThank you.
About PowerShow.com