Preview

oracle

Satisfactory Essays
Open Document
Open Document
3885 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
oracle
ORACLE 10g ASM
May 17th, 2006

Inderpal S. Johal
Principal Consultant

Agenda
What is ASM
Benefits of ASM
ASM Architecture
ASM Components
DB Instance parameters to support ASM
ASM Instance Monitoring using EM
ASM Views
Migrating from File system to ASM
Miscellaneous Tips
Q&A

Data Softech Inc.

Oracle 10g ASM

2

What is ASM
ASM stands for Automatic Storage Management
It is Oracle Cluster File System and Volume Manager
Designed for Oracle Database Related Files
Provide Storage management capabilities like striping as well as mirroring
Data files
Log files
Archived files
Control Files

Not Certified for
Trace Files
ORACLE_HOME
Voting Disk
OCR Files
Alert Log
Password File
Binary File (BFILE)

Temp File
SPfile
DG file
Flashback Logs
Datapump File

DataGuard
Change Tracking File

Data Softech Inc.

Oracle 10g ASM

3

Benefits of Automatic Storage Management
Provide efficient management of storage
No need for buggy OCFS or expensive 3rd party CFS
Provide integrated Cluster File system and Volume management capabilities
Traditional Volume Mgmt.

ASM

Tables

Tables

Tablespaces

Tablespaces

Files
File systems

Automatic
Storage
Management

Disk Groups

Logical
Volumes
Physical
Volumes

Physical
Volumes
Data Softech Inc.

Oracle 10g ASM

4

Benefits of Automatic Storage Management
Provide efficient management of storage
Provide integrated Cluster File system and Volume management capabilities
No need for buggy OCFS or expensive 3rd Party CFS
Provide Software Mirroring on top of vendor supplied SAN
[2 or 3 Mirrors]

Triple Mirroring

Data Softech Inc.

Double Mirroring

Oracle 10g ASM

No Mirroring

5

Benefits of Automatic Storage Management
Provide efficient management of storage
Provide integrated Cluster File system and Volume management capabilities
No need for buggy OCFS or expensive 3rd Party CFS
Provide Software Mirroring on top of
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Unit 7 Assignment 1: Designing an Exchange Server
    • 868 Words
    • 3 Pages

    Unit 7 Assignment 1: Designing an Exchange Server

    Good level of space utilization (e.g. you get to leverage more of the space on the disks in the array over that of RAID 1 or RAID 1+0)…

    • 868 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    PT2520 Unit 1 Research Assignment
    • 452 Words
    • 2 Pages

    PT2520 Unit 1 Research Assignment

    Oracle Express is Oracle’s express edition of their SQL database. This edition has many different features that can be used. Some of those features include; Interactive reports, Declarative BLOB support, Enhanced report printing, adding to the theme repository, Optional runtime-only installation, improved security, Application date format, and Application builder refinements. These features are used to create…

    • 452 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    ISDS 550 PS6
    • 438 Words
    • 2 Pages

    ISDS 550 PS6

    The advantages of consolidating data in central data center instead of distributing data storage arrangement are integrating the storage services more efficiently, having better availability for applications, providing better operating performance, and reducing administration and management of…

    • 438 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Nt1110
    • 335 Words
    • 2 Pages

    Nt1110

    3. Centralized Storage for backup - If a computer needs to be rebuilt or wiped, you can push files and backups and restore from the same location.…

    • 335 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    NT1110Module4 SA
    • 302 Words
    • 1 Page

    NT1110Module4 SA

    The New Technology File system also provides support for the larger hard drives and better security in the form of encryption and permissions that restrict access by unauthorized users. It allows administrators to set a guideline for people who can access certain files and folders. It also allows administrators to set up specific accounts with limits for each person to tighten the security.…

    • 302 Words
    • 1 Page
    Good Essays
    Read More
  • Good Essays

    Nvq Business and Administration
    • 501 Words
    • 3 Pages

    Nvq Business and Administration

    Electronic storage of an organisation’s information can take various forms depending upon the size and specific industry. The benefit of electronic information storage systems is the lack of physical space that they require. Information stored electronically is also very easily backed up by a central server.…

    • 501 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Sinosteel Strengthens Business Management with Oracle Apps
    • 1448 Words
    • 6 Pages

    Sinosteel Strengthens Business Management with Oracle Apps

    A business process is a collection of related, structured activities or tasks that produce a specific service or product for a particular customer(s). In FedEx case, the business process is the packages sorting in order to ship them to customers in many destinations inside and outside the U.S. As displayed in the video, first, a FedEx agent picks up a package and scans it, entering it into the system under a unique identification number. It is then transferred into a hub, or sorting center, via a truck containing other similar packages. Once it reaches the nearest sorting center, which are over two football fields long and have everywhere from five hundred to a thousand workers, the packages are stored via a system on conveyor belt. FedEx uses several types of technology to sort the packages it ships. A dimensional scanner gets the length, width, height and weight of packages to determine their size and eventual cost of shipping. Another multidimensional scanner reads the barcode from any location on the package except the bottom. Then, paddles nudge the packages onto different slides depending on the eventual destination. Some packages require manual sorting instead of this automated method. Once the packages have been sorted, they are placed into boxes together. The boxes are shaped in such a way that they will fit into a plane with maximum efficiency. A FedEx air control center coordinates the arrival of trucks and monitors airport and airplane conditions. Once the planes take off, travel and reach their destination, a FedEx courier delivers the package by hand, and scans again to signify the completion of the transaction.…

    • 1448 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Database
    • 330 Words
    • 2 Pages

    Database

    There are three problems. First is deletion problem, second is update problem, third is insertion problem.…

    • 330 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Aggregates and Flexible Volumes
    • 11355 Words
    • 46 Pages

    Aggregates and Flexible Volumes

    A traditional NetApp volume is made up of two layers – physical and logical. In Data ONTAP 7.0 (7g), we have separated the two layers. An aggregate is the physical layer. It is made up of a collection of disks organized in one or more raid groups and is used as a container to support one or more flexible volumes.…

    • 11355 Words
    • 46 Pages
    Powerful Essays
    Read More
  • Good Essays

    Oracle Mc Question
    • 6708 Words
    • 27 Pages

    Oracle Mc Question

    | B, C, and D. SQL, PL/SQL, and Java are implemented internally to the database. A is wrong because C is not available internally (though with OCI, it can of course be used for writing user processes). E is wrong because OCI is used for writing user processes that run externally to the database.…

    • 6708 Words
    • 27 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Oracle Configuration Manager
    • 895 Words
    • 10 Pages

    Oracle Configuration Manager

    | Incorrect. Refer to the Why Use The Configuration Manager In My Oracle Support training for more information.…

    • 895 Words
    • 10 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    DBMS
    • 1589 Words
    • 7 Pages

    DBMS

    *kapag may mali sa functionalities paki bago nln nandyan naman na ung mga links at paki ayos nalan to. Pasensya na tlga…. Nag rurush din ako, at ang openoffice ndi naman tlga siya parang mysql na pure data base…

    • 1589 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Good Essays

    Pl/Sql Programs
    • 1293 Words
    • 6 Pages

    Pl/Sql Programs

    16. Write a Pl/Sql program to raise the employee salary by 30%, who have completed their 40 years of service. declare cursor c3 is select * from emp where extract(year from sysdate)-extract(year from hiredate)>40 for update; e emp%rowtype; begin open c3; loop fetch c3 into e; exit when c3%notfound; update emp set sal=e.sal+(30/100)*e.sal where current of c3; end loop; close c3; end; / 17. Write a Pl/Sql program to check the given number is Armstrong ‘or’ not. declare n number(3); s number(3):=0; t number(3); begin n:=&n; t:=n; while t>0 loop s:=s+power((t mod 10),3); t:=trunc(t/10); end loop; if(s=n) then dbms_output.put_line('The given number ' || n || 'is an armstrong number'); else dbms_output.put_line('The given number ' || n || 'is not an armstrong number'); end if; end; / 18. Write a Pl/Sql program to display top 10 rows in emp table based on their job and salary. declare cursor c1 is select * from emp order by sal desc; e emp%rowtype; begin…

    • 1293 Words
    • 6 Pages
    Good Essays
    Read More
  • Powerful Essays

    dbms
    • 19259 Words
    • 78 Pages

    dbms

    The language that requires a user to specify the data to be retrieved without specifying…

    • 19259 Words
    • 78 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Oracle Database Backup and Recovery
    • 33097 Words
    • 133 Pages

    Oracle Database Backup and Recovery

    Oracle9i Backup and Recovery Concepts, Release 2 (9.2) Part No. A96519-01 Copyright © 2001, 2002 Oracle Corporation. All rights reserved. Primary Author: Lance Ashdown Graphic Designer: Valarie Moore…

    • 33097 Words
    • 133 Pages
    Powerful Essays
    Read More

Related Topics