Results for LAG


1 to 20 of 66 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

LAGLAST

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 56 of 177

LAGSyntax lag::= Text description of lag See Also: \"Analytic Functions\" for information on syntax … , semantics, and restrictions Purpose LAG is an analytic function. It provides access to more than one … and a position of the cursor, LAG provides access to a row at a given physical offset prior to that … value

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing the Online Redo Log

Controlling Archive Lagapplied by the standby database can lag the changes that are occurring on the primary database. This laglag, you set the ARCHIVE_LAG_TARGET initialization parameter. Setting this parameter allows you to … limit, measured in time, how long the lag can become. Setting the ARCHIVE_LAG_TARGET Initialization

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

LAG/LEAD FunctionsThe LAG and LEAD functions are useful for comparing values when the relative positions of rows can … without a self-join, they can enhance processing speed. The LAG function provides access to a row at a

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

LAG/LEAD SyntaxThese functions have the following syntax: {LAG | LEAD} ( value_expr [, offset] [, default] ) OVER … table or partition. Example 19-10 LAG/LEAD SELECT time_id, TO_CHAR(SUM(amount_sold),'9,999,999') AS … SALES, TO_CHAR(LAG(SUM(amount_sold),1) OVER (ORDER BY time_id),'9,999,999') AS LAG1, TO_CHAR(LEAD(SUM

Concepts and Administration, 9i Release 2 (9.2.0.2)

Data Guard Scenarios

10.2.1 Establishing a Time Lag on a Physical Standby DatabaseTo create a physical standby database with a time lag, modify the LOG_ARCHIVE_DEST_ n … description of using the DBMS_LOGSTDBY package to establish a time lag on a logical standby database.

Concepts and Administration, 9i Release 2 (9.2.0.2)

Data Guard Scenarios

10.2 Using a Physical Standby Database with a Time Lagbe applied immediately, because you want to create a time lag between the archiving of a redo log at … the primary site and the application of the log at the standby site. A time lag can protect against … . A primary database that has a standby database with a time lag could help you to recover. You could … fail over the standby

Concepts and Administration, 9i Release 2 (9.2.0.2)

Data Guard Scenarios

10.3 Switching Over to a Physical Standby Database That Has a Time Lagbypasses a time lag. For the purposes of this example, assume that the primary database is located in … to the original (time delayed) standby database bypassing the lag. Switchover will not begin until

Concepts and Administration, 9i Release 2 (9.2.0.2)

Data Guard Scenarios

10.2.2 Failing Over to a Physical Standby Database with a Time LagA standby database configured to delay application of redo logs can be used to recover from user errors or data corruptions on the primary database. In most cases, you can query the time-delayed standby database to retrieve the data needed to repair the primary database (for example, to recover the contents of a mistakenly dropped table). In cases where the damage to the primary database is unknown

OLAP User's Guide, 9i Release 2 (9.2.0.2)

DBMS_AW, 3 of 9

Example> EXECUTE DBMS_AW.EXECUTE('AW ATTACH xademo RW; DEFINE cost_pp FORMULA LAG(analytic_cube_f.costs, 1, time … ('DESCRIBE cost_pp'); DEFINE COST_PP FORMULA DECIMAL EQ lag(analytic_cube_f.costs, 1, time, levelrel time.levelrel) PL/SQL procedure successfully completed.

Concepts and Administration, 9i Release 2 (9.2.0.2)

Data Guard Scenarios

10 Data Guard ScenariosStandby Database for a Role Transition Section 10.2 Using a Physical Standby Database with a Time Lag … Section 10.3 Switching Over to a Physical Standby Database That Has a Time Lag Section 10.4

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing the Online Redo Log

Planning the Online Redo LogLog Members on Different Disks Setting the Size of Online Redo Log Members Choosing the Number of Online Redo Log Files Controlling Archive Lag

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Manipulating Multidimensional Data, 3 of 4

Time Series ManipulationThe time series functions perform operations such as lead, lag, and moving average. For example

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

19 SQL for Analysis in Data WarehousesFunctions Reporting Aggregate Functions LAG/LEAD Functions FIRST/LAST Functions Linear Regression Functions

Concepts and Administration, 9i Release 2 (9.2.0.2)

LOG_ARCHIVE_DEST_n Parameter Attributes

Purposeerroneous data from the primary site to the standby site, you might want to create a time lag between

Concepts and Administration, 9i Release 2 (9.2.0.2)

Managing a Logical Standby Database

9.1.9 Delaying the Application of Archived Redo Logslogical and physical standby databases (as described in Section 5.3.2.3, \"Specifying a Time Lag for the

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Models, 6 of 8

Using Data from Past and Future Time Periodsexample, the LAG function returns data from a specified previous time period, and the LEAD function … for the previous month. DIMENSION line month... revenue = LAG(revenue, 1, month) * 1.05 If the month

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Developing OLAP Applications, 4 of 5

WizardsBeans take advantage of all of the new OLAP functions in the database, including ranking, lag, lead … would be calculated using the lag method on data in the Sales measure. Because a DBA cannot

Concepts and Administration, 9i Release 2 (9.2.0.2)

LOG_ARCHIVE_DEST_n Parameter Attributes

Attributesspecify a time lag for the application of redo logs at the standby site. The DELAY attribute does not … therefore has no time lag. Standby database C is set up to protect against logical or physical

Concepts and Administration, 9i Release 2 (9.2.0.2)

Log Transport Services

5.3.2 Archived Redo LogsCONTROL_FILE_RECORD_KEEP_TIME initialization parameter 5.3.2.3 Specifying a Time Lag for the Application of Redo Logs … In some cases, you may want to create a time lag between the archiving of a redo log at the primary … site and the applying of the redo log at the standby site. A time lag can protect against the … = minutes


Was this page helpful?