Oracle Database 11g R2 Administration Part 17

Global Name Resolution in Views, Synonyms, and Procedures A view, synonym, or PL/SQL program unit (for example, a procedure, function, or trigger) can reference a remote schema object by its global object name. If the global object name is complete, then the database stores the definition of the object without expanding the global object name. … Read moreOracle Database 11g R2 Administration Part 17

Oracle Database 11g R2 Administration Part 16

event_expiry_time This attribute enables you to set the time in seconds before a job state event generated by the Scheduler expires (is automatically purged from the Scheduler event queue). If NULL, job state events expire after 24 hours. log_history This attribute controls the number of days that log entries for both the job log and … Read moreOracle Database 11g R2 Administration Part 16

Oracle Database 11g R2 Administration Part 15

See Oracle Database PL/SQL Packages and Types Reference for detailed information about the SET_ATTRIBUTE procedure. Dropping Schedules You drop a schedule using the DROP_SCHEDULE procedure or Enterprise Manager. This procedure call will delete the schedule object from the database. See Oracle Database PL/SQL Packages and Types Reference for detailed information about the DROP_SCHEDULE procedure. Setting … Read moreOracle Database 11g R2 Administration Part 15

Oracle Database 11g R2 Administration Part 14

ETL_CRITICAL_PLAN Example plan for a data warehouse that prioritizes ETL operations over DSS queries. INTERNAL_PLAN INTERNAL_QUIESCE For disabling the resource manager. For internal use only. For quiescing the database. This plan cannot be activated directly. To activate, use the QUIESCE command. MIXED_WORKLOAD_PLAN Example plan for a mixed workload that prioritizes interactive operations over batch operations. … Read moreOracle Database 11g R2 Administration Part 14

Oracle Database 11g R2 Administration Part 13

If a session attribute is dynamically changed to a new value (which is only possible for run-time attributes), then the mapping rules are reevaluated, and the session might be switched to another consumer group. Predefined Consumer Group Mapping Rules Each Oracle database comes with a set of predefined consumer group mapping rules: As described in … Read moreOracle Database 11g R2 Administration Part 13

Oracle Database 11g R2 Administration Part 12

DBA_CLU_COLUMNS These views map table columns to cluster columns USER_CLU_COLUMNS See Also: Oracle Database Reference for complete descriptions of these views 23 Managing Hash Clusters In this chapter: About Hash Clusters When to Use Hash Clusters Creating Hash Clusters Altering Hash Clusters Dropping Hash Clusters Hash Clusters Data Dictionary Views About Hash Clusters Storing a … Read moreOracle Database 11g R2 Administration Part 12

Oracle Database 11g R2 Administration Part 11

timestamp range between which you want to view changes to row values. The query also can return associated metadata, such as the transaction responsible for the change. After you identify an erroneous transaction, you can use Oracle Flashback Transaction Query to identify other changes that were made by the transaction. You can then use Oracle … Read moreOracle Database 11g R2 Administration Part 11

Translate »