1 / 10

Database internals and Federation

Astute utilization of tools for database administration, organization, maintenance, and naming conventions. Tools for federation management, tablespace configuration, stored procedures, network integrity, and more. Maximize efficiency and security in your database operations.

shiri
Télécharger la présentation

Database internals and Federation

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. Database internals and Federation Database administration

  2. Db & account management tools • Use dbca to create/drop a database and register it with the ASTRO-WISE LDAP server. • Use oemapp to • Create/drop/alter users • Create/drop/grant/revoke roles • Grant/revoke privileges

  3. Db & network management tools • netmgr – enterprise manager tool to administrate db network connections • Listener – makes the database visible to the network • lsnrctl – starts, stops and checks the status of the listener process • netca – tool to configure listeners

  4. Oracle Internet Directory • The internet directory provides a network lookup facility for resources, e.g. users, dbs, hardware, … • oidadmin tool • LDAP protocol • Centralized administration of users, databases, network, roles, etc.

  5. ASTRO-WISEDatabase Administration Organization and maintenance of the database federation

  6. Naming conventions • SID.machine.organization.awSID – database namemachine – hostname running SIDorganization – ESO, IAP, NOVA, OAC, USM, … • Users • .dbf files • Tablespaces • Tables, types and views

  7. Tools (1) • Adding partitions to tables • Changing the “CONTEXT” of data • Adding tablespaces • Create/drop/update indexes • Analyze • Check logs

  8. Tools (2) • Clean up garbage • Moving user and federation data while maintaining referential integrity • Checking network integrity • Checking (FITS)data integrity • ???

  9. Stored procedures • Stored procedures – groups of SQL, PL/SQL, and also Java statements – enable you to move code from your application to the database. • PL/SQL is a Pascal&ADA like language that is SQL-aware

  10. Recommended documentation • Always have the on-line documentation available that comes with the Oracle installation • Oracle9i SQL Reference • On-line SQL syntax & examples

More Related