42 lines
841 B
SQL
42 lines
841 B
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display all SQL Ids with degraded execution plan flips
|
|
* Parameters : 1 - Number of days
|
|
*
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 11-Oct-12 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
UNDEFINE DAYS
|
|
DEFINE DAYS="&&1"
|
|
|
|
COLUMN _DAYS NEW_VALUE DAYS NOPRINT
|
|
|
|
set term off
|
|
SELECT DECODE('&&DAYS','','7','&&DAYS') "_DAYS"
|
|
FROM DUAL;
|
|
set term on
|
|
|
|
|
|
|
|
/************************************
|
|
* CONFIGURATION PARAMETERS
|
|
************************************/
|
|
DEFINE elapsed_time_threshold=
|
|
|
|
|
|
|
|
|
|
@@footer |