Politechnika Śląska - strona 114

Managing the Online Redo Log - wykład

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

Managing the Online Redo Log The online redo log files are a critical component in database recovery. Every transaction in the database updates the redo logs, regardless of whether archiving is enabled. During crash, instance, or media recovery, the database properly applies redo log files in as...

Media Recovery - wykład

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

Media Recovery If you restore the archived redo log files and data files, then you must perform media recovery before you can open the database. Any database transactions in the archived redo log files not reflected in the data files are applied to the data files, bringing them to a transaction-...

Modifying a Role - wykład

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

Modifying a Role Suppose your applications make use of Oracle Streams Advanced Queuing, and you determine that developers must be granted the roles AQ_ADMINISTRATOR_ROLE and AQ_ USER_ROLE to develop and test their applications. You must edit the APPDEV role to grant it these two Advanced Queuing...

Monitoring General Database State and Workload - wykład

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

Monitoring General Database State and Workload The Database Home page enables you to monitor the state and workload of your database. It provides a central place for general database state information and is updated periodically. To monitor the general database state and workload: 1. Go to the ...

Monitoring Performance Using the Performance Hub - wykład

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

Monitoring Performance Using the Performance Hub The Performance Hub allows you to view all the performance data available for a specified time period. Once a time period is selected, the performance information is collected and presented ba...

Multiplexing the Online Redo Log - wykład

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

Multiplexing the Online Redo Log Oracle recommends that you multiplex the online redo log. Multiplexing provides better protection for data if an instance or media failure occurs. To multiplex your online redo log, you must add members to each online redo log group. It is not required that onlin...

Naming Schema Objects - wykład

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

Naming Schema Objects Every object in the database belongs to one schema and has a unique name within that schema. Multiple database objects can share the same name, if they are in different schemas. You can use the schema name to unambiguously refer to objects. For example, hr.employees refers ...

New Features - wykład

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

New Features ■ Oracle Enterprise Manager Database Express (EM Express) is the next-generation management tool for administration and management of individual databases that comes with Oracle Database 12c Release 1 (12.1). In previous Or...

Nonpartitioned and Partitioned - wykład

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

Nonpartitioned and Partitioned As with tables, you can partition an index. In most situations, it is useful to partition an index when the associated table is partitioned, and to partition the index using the same partitioning scheme as the table...