Politechnika Śląska - strona 113

Getting Started with Database Administration - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 392

Getting Started with Database Administration This chapter provides a brief roadmap for administering your database. It introduces you to Oracle Enterprise Manager Database Express (EM Express), the Web-based interface for managing an Oracle database. This chapter contains the following sections:...

Granting Access to EM Express for Nonadministrative Users - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 294

Granting Access to EM Express for Nonadministrative Users As a database administrator, you can log in to EM Express with the SYS or SYSTEM user account to perform administrative and other tasks. Nonadministrative users may also want to log in to EM Express. For example, application developers may...

How to Use This Guide with Related Material - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 336

How to Use This Guide with Related Material This guide is part of a comprehensive set of learning material for administering Oracle Database, which includes a 2 Day DBA Oracle By Example (OBE) series, available on the Web. Every chapter in

Image Copies and Backup Sets - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 483

Image Copies and Backup Sets Database backups created by RMAN are stored as image copies or backup sets. Image copies are exact byte-for-byte copies of files. You can create an image copy by copying a file at the operating system level. Unlike copying files at the operating system level, however...

Indexes and Performance - opracowanie

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 441

Indexes and Performance Indexes generally improve the performance of queries and DML statements that operate on a single, existing row or a small number of existing rows. However, too many indexes can increase the processing overhead for sta...

Common Oracle DBA Tasks - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 406

Common Oracle DBA Tasks As an Oracle DBA, you can expect to be involved in the following tasks: ■ Installing Oracle software ■ Creating Oracle databases ■ Performing upgrades of the database and software to new release levels ■ Starting and shutting down the database instance ■ Managing the st...

Installing Oracle Database Software - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 371

Installing Oracle Database Software This section briefly describes the steps for a desktop-class installation. Most steps are common to all platforms and involve running the Oracle Universal Installer. Platform-specific steps are noted. ...

Loading Data into a Table - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 917

Loading Data into a Table You can use SQL Developer to load data into a table. You can load data from an .xls file or a .csv file into the table. In this example, you load data into the PURCHASE_ORDERS table that you created in "Example: C...

Managing Templates with DBCA - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 406

Managing Templates with DBCA DBCA templates are XML files that contain information required to create a database. Templates are used in DBCA to create new databases and duplicate existing databases. The information in templates includes database options, initialization parameters, and storage at...