1 / 11

Hannes Thiemann Oracle DBA hannes.thiemann@dkrz.de

Hannes Thiemann Oracle DBA hannes.thiemann@dkrz.de. The Internet. IXS 24nodes. Application Server. SX-6. SX-6. SX-6. SX-6. SX-6. SX-6. SX-6. SX-6. x 32. Postprocessing. Unitree. Oracle. Some facts. Oracle 9.2 single instance running on Sun E12k Database size 30 Tbyte

umay
Télécharger la présentation

Hannes Thiemann Oracle DBA hannes.thiemann@dkrz.de

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hannes Thiemann Oracle DBA hannes.thiemann@dkrz.de

  2. The Internet IXS24nodes Application Server SX-6 SX-6 SX-6 SX-6 SX-6 SX-6 SX-6 SX-6 x 32 Postprocessing Unitree Oracle

  3. Some facts • Oracle 9.2 single instance running on Sun E12k • Database size 30 Tbyte • Data accessible on the internet • 400 named users worldwide • Daily access 300 GB/Day (currently) • New data 120 GB/Day (currently)

  4. Use of dxdb Dxdb is used for • Ordinary Oracle datafiles • Redo logs • Backup

  5. Migin Migout dxdb TBS - RW TBS - RW TBS - RO All tablespaces are moved “at once” to dxdb Tbl Partition 1 Tbl Partition 2 Tbl Partition 1

  6. Migout / Migin • Migout takes place after files haven’t been modified for x minutes • Only one migout process per dxdb-filesystem • Migin takes place immediately after a file is requested. Only parts accessed are retrieved from the backend storage. • One migin process per requested file.

  7. dxdb HWM LWM Purging

  8. Criteria for purging • Size of datafiles doesn’t matter • Except: “small” datafiles can stay on disk • Time not modified (easy for read only tablespaces) • Time not touched • Oracle has the tendency to touch data files quite often • Oracle parameter read_only_open_delayed could be an option • Prerequisite: 2 copies on tape

  9. Pro • It works • It’s fast • Applications don’t have to wait until files are retrieved back completely. • Good support and good cooperation with developers

  10. It works Dxdb not supported by Oracle Only Oracle 8i officially supported by Legato (see legato.com) Backend requirements do not necessarily match requirements from other applications Contra - If the backend works

  11. Questions?

More Related