Forum Stats

  • 3,759,437 Users
  • 2,251,543 Discussions
  • 7,870,640 Comments

Discussions

Difference in execution plan (12.1.0.1 vs 12.2.0.1)

vpolasa
vpolasa Member Posts: 392 Blue Ribbon
edited Jul 23, 2020 5:40AM in SQL & PL/SQL

Please find below sample test script.

Below query shows different execution plan in 12.1.0.1 and 12.2.0.1

select * from test_folder_vw where fldr_key = -41;

Please help me understand why the plans are different? How can a better plan be achieved in 12.2.0.1.

The test data I have provided has 1580 records. Our table in production db has 15,000 records. This is causing severe performance issues in 12.2.0.1 database. We're not seeing any performance issues in 12.1.0.1 databases with the same or higher amount of data.

12.1.0.1

-----------------------------------------------------------------------------------------| Id  | Operation                                 | Name        | Rows  | Bytes | Cost  |-----------------------------------------------------------------------------------------|   0 | SELECT STATEMENT                          |             |   801 | 10413 |    21 ||   1 |  VIEW                                     |             |   801 | 10413 |    21 ||   2 |   UNION ALL (RECURSIVE WITH) BREADTH FIRST|             |       |       |       ||   3 |    TABLE ACCESS FULL                      | TEST_FOLDER |   161 |  4186 |     7 ||   4 |    HASH JOIN                              |             |   640 | 24960 |    14 ||   5 |     RECURSIVE WITH PUMP                   |             |       |       |       ||   6 |     TABLE ACCESS FULL                     | TEST_FOLDER |  1419 | 36894 |     7 |-----------------------------------------------------------------------------------------

12.2.0.1

---------------------------------------------------------------------------------------------------------| Id  | Operation                                 | Name        | Rows  | Bytes | Cost (%CPU)| Time     |---------------------------------------------------------------------------------------------------------|   0 | SELECT STATEMENT                          |             |   357K|  4541K|    17  (12)| 00:00:01 ||*  1 |  VIEW                                     |             |   357K|  4541K|    17  (12)| 00:00:01 ||   2 |   UNION ALL (RECURSIVE WITH) BREADTH FIRST|             |       |       |            |          ||*  3 |    TABLE ACCESS FULL                      | TEST_FOLDER |   161 |  4186 |     7   (0)| 00:00:01 ||*  4 |    HASH JOIN                              |             |   357K|    17M|    10  (20)| 00:00:01 ||   5 |     BUFFER SORT (REUSE)                   |             |       |       |            |          ||*  6 |      TABLE ACCESS FULL                    | TEST_FOLDER |  1419 | 36894 |     7   (0)| 00:00:01 ||   7 |     RECURSIVE WITH PUMP                   |             |       |       |            |          |---------------------------------------------------------------------------------------------------------

Using Windows 10

SQL Developer 19.2

12.1.0.1 version:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

PL/SQL Release 12.1.0.1.0 - Production

"CORE 12.1.0.1.0 Production"

TNS for 64-bit Windows: Version 12.1.0.1.0 - Production

NLSRTL Version 12.1.0.1.0 - Production

12.2.0.1 version:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

"CORE 12.2.0.1.0 Production"

TNS for 64-bit Windows: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

Test data:

 CREATE TABLE TEST_FOLDER    ( FLDR_KEY NUMBER(16,0) NOT NULL ENABLE, FLDR_ID VARCHAR2(255 BYTE) NOT NULL ENABLE, FLDR_DESC_TX VARCHAR2(255 BYTE), PAR_FLDR_KEY NUMBER(16,0), SEUS_KEY NUMBER(16,0) NOT NULL ENABLE, FLDR_PRIVATE_FLG VARCHAR2(1 BYTE) NOT NULL ENABLE, LAST_UPDT_DT DATE NOT NULL ENABLE, LAST_UPBY_SEUS_KEY NUMBER(16,0) NOT NULL ENABLE, LOCK_SEQ_NBR NUMBER(9,0) DEFAULT 0 NOT NULL ENABLE, CONTENT_GUID RAW(16),CONSTRAINT TEST_FOLDER_PK PRIMARY KEY (FLDR_KEY)   ) ;Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2924673,'test119','test119-desc',2914835,8100,'N',to_date('20-FEB-14','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2924674,'test120','test120-desc',2924673,8100,'N',to_date('20-FEB-14','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2924687,'test191','test191-desc',2924673,8100,'N',to_date('20-FEB-14','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2924690,'test36','test36-desc',2924673,8100,'N',to_date('20-FEB-14','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711031,'test64','test64-desc',2098447,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'327608DAE798B2755C488C532A341985');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711032,'test120','test120-desc',2711031,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'9DF741EA3DF664A36B4EDF0858DA2538');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711033,'test1','test1-desc',2711032,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'29950D6B76055F9B356EB8BCEA14F959');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711062,'test64','test64-desc',-4,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711063,'test120','test120-desc',2711062,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2711064,'test1','test1-desc',2711063,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2715832,'test121','test121-desc',2123845,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'80D63DF9A8CB9F6358E49D959CB0FCFB');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2715861,'test121','test121-desc',2123848,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730411,'test36','test36-desc',2283395,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'44695C8E6424CF3DA79DE79906D50CDD');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730440,'test36','test36-desc',2283398,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730483,'test36','test36-desc',2319422,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'2475858BFA4FB4744AFE2B8647D23235');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730512,'test36','test36-desc',2319425,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730555,'test36','test36-desc',2700707,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'B061A69683E6731AAB04E056719110E4');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730584,'test36','test36-desc',2700738,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730627,'test36','test36-desc',2711031,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'1E6ACCA7219D3933770C4E7B08E3F568');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2730656,'test36','test36-desc',2711062,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2736639,'test191','test191-desc',2123845,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,'48C0224699342CD0B23480D4DE5F9F4D');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2736672,'test191','test191-desc',2123848,8100,'N',to_date('30-AUG-13','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2899098,'test192','test192-desc',-30,8100,'N',to_date('20-FEB-14','DD-MON-RR'),8100,0,'9B7ED300B2866DDFD0BD9458BF5D71BA');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2899099,'test2','test2-desc',2899098,8100,'N',to_date('19-FEB-14','DD-MON-RR'),8100,0,'4E39FCC39E887C4DAF1E4A627E83D714');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440223,'test157','test157-desc',2314449,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'0A47AF6A53CDB3469E24D69FF41F092B');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440224,'test157','test157-desc',2314450,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440225,'test158','test158-desc',2098447,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'68AAF21B002EA0C691608FE2AC1F4333');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440226,'test120','test120-desc',2440225,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'92707A08B29228E6FD0FFCE8AE00DDCF');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440227,'test1','test1-desc',2440226,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'A29F2075B2345D55CEF6400BAEB0D510');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440228,'test158','test158-desc',-4,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440229,'test120','test120-desc',2440228,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440230,'test1','test1-desc',2440229,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440231,'test36','test36-desc',2440225,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'376DD7B1DB7BA123D94456EB611E638A');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440232,'test36','test36-desc',2440228,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440233,'test120','test120-desc',2098486,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'D0A194F9C3539D285BCDECE69E42A559');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2440234,'test120','test120-desc',-15,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437339,'test65','test65-desc',2079714,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,'780EC090BB0DA71BF8B56BB68A01CF7B');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437714,'test159','test159-desc',2319614,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,'97B1BE6566DC6526F4B51B4C11BE9D0C');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437716,'test159','test159-desc',2319616,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437726,'test37','test37-desc',2098486,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,'0CB8EEF561AFB524F65A778B0652E983');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437728,'test37','test37-desc',-15,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398866,'test160','test160-desc',2098447,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'7A96351604A77BCCE9F37C8708EFD0AE');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398867,'test160','test160-desc',-4,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398868,'test122','test122-desc',2398866,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'3DFDBCD404E79EBC09C4A31ADD07F360');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398869,'test122','test122-desc',2398867,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398870,'test120','test120-desc',2398868,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'3B5BE387727531764B01A2FFF78BB507');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2398871,'test120','test120-desc',2398869,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319487,'test193','test193-desc',2319425,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319488,'test120','test120-desc',2319487,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319492,'test218','test218-desc',2319484,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'5CB4BE7C2F93BDDF740D0A6D1D095CA3');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319494,'test218','test218-desc',2319487,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319498,'test218','test218-desc',2319444,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'728D58F53B792BE07EF54D76AF9A4FF7');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319499,'test38','test38-desc',2319498,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'29E2FC8373DCC56D130EF97CE0D394A7');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319501,'test218','test218-desc',2319447,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319502,'test38','test38-desc',2319501,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319524,'test191','test191-desc',2319404,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'1B474F211E51A675802F448BEA1BE39A');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319525,'test123','test123-desc',2319524,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'F78ABA62BE1EE90DFB0650EA3F2D0FAA');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319527,'test191','test191-desc',2319407,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319528,'test123','test123-desc',2319527,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319538,'test219','test219-desc',2319422,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'97F8319ED74AD1B9EE4C3DD82E8E2578');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2319539,'test120','test120-desc',2319538,8100,'N',to_date('11-NOV-09','DD-MON-RR'),8100,0,'9415F4260B12BFF0B708E95418DE4E15');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377544,'test39','test39-desc',2314454,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377556,'test191','test191-desc',2377400,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'D971EA361E145AAE16D299DCE3843DE8');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377558,'test191','test191-desc',2377403,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377560,'test123','test123-desc',2377556,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'2EA94381504648E856AFCCD0DF9D7BD0');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377562,'test123','test123-desc',2377558,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377568,'test191','test191-desc',2188809,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'D1C798ABA1206A27EF9882A74A1F934B');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377570,'test191','test191-desc',2188812,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377582,'test191','test191-desc',2377502,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'3AFA57C74ED387209FD3E39E92ED49E9');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377584,'test191','test191-desc',2377505,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377586,'test37','test37-desc',2098455,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'92C105EFA5D695DF8CFCF254154A5C56');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377588,'test37','test37-desc',2078350,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377596,'test37','test37-desc',2098478,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'A6F55969EE36C8D94E690A1E013B3D5A');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377598,'test37','test37-desc',-13,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377606,'test37','test37-desc',2152215,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,'C4D4C798979844688B5AC8A5F57AC3CE');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2377608,'test37','test37-desc',2152216,8100,'N',to_date('29-MAR-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2402598,'test220','test220-desc',-4,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2402595,'test220','test220-desc',2098447,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'7EC2C1ECF1EEFE21ADCE0F6842B2A18B');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2402596,'test120','test120-desc',2402595,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'F433DFFE32C2F5FC7C2A3A84872121E5');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2400340,'test66','test66-desc',-29,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'5AA5D09125356B4F19E9E196C369FE8C');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2400345,'test122','test122-desc',2400340,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,'B644C784FAF7662D9677983F826A11E2');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2402599,'test120','test120-desc',2402598,8100,'N',to_date('17-NOV-10','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2415418,'test3','test3-desc',2254576,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,'CE0601C081B32FBB042D95DA7AC64CA1');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2415419,'test3','test3-desc',2254577,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2437106,'test40','test40-desc',2188187,8100,'N',to_date('21-DEC-11','DD-MON-RR'),8100,0,'5B4EA92A6B346DA971619F2468CBC70D');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479266,'test120','test120-desc',2300076,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'79819B905B1B740F3435F7C6F1380DBB');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479268,'test120','test120-desc',2300078,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479270,'test1','test1-desc',2479266,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'A5C8DCBF5DFED75362FE410094896295');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479272,'test1','test1-desc',2479268,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479324,'test221','test221-desc',2098447,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'AC5A2C9411CF68C178F6B5E802E6CA4A');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479325,'test120','test120-desc',2479324,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'7F16CA75CE14E533748A4749F1B19370');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479327,'test221','test221-desc',-4,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479328,'test120','test120-desc',2479327,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479330,'test124','test124-desc',2314467,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'5C0373324A965C09FFB26FE807AA2B9C');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479332,'test124','test124-desc',2314468,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479492,'test36','test36-desc',2300076,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'7B3277E889E9A12E748C69E879FA1DB0');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479494,'test36','test36-desc',2300078,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478370,'test4','test4-desc',2400340,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'FA0979C915FB5EB4C047D3F8C606A8CA');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478422,'test5','test5-desc',-29,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'B91C3F7EA91AD1BCA055F967463C7C26');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479252,'test125','test125-desc',2098448,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'050D6DF6C3622CC72690435B96493DDA');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478465,'test6','test6-desc',2083019,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'9B164A9800E6747068A9769528AAF766');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478490,'test126','test126-desc',2123992,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'39476B645D258B9B66D464ED42528077');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478652,'test222','test222-desc',2079714,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'FC6BB2750CCB2E347BE509F649BE9BC2');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478691,'test67','test67-desc',2081743,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'91469B7E9B1C4A9EB006C59D488FF588');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2478757,'test194','test194-desc',2083314,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'20FFD3FDC69A60DD2AC4B64799F7E498');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479258,'test41','test41-desc',2098448,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'C0C0CE7CC70BE3164C6B5E84C92DE053');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479360,'test4','test4-desc',2398866,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'688582F6D833E6A213B09A646BCFD9E0');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479361,'test120','test120-desc',2479360,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'B1CEBB3857899B38FE3AAA57BC6ECBA5');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479363,'test4','test4-desc',2398867,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479364,'test120','test120-desc',2479363,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479372,'test223','test223-desc',2440226,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'B0E45AC210DDA60C022674BE3001DE93');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950160,'test161','test161-desc',2950159,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479374,'test223','test223-desc',2440229,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2479392,'test1','test1-desc',2479325,8100,'N',to_date('16-AUG-12','DD-MON-RR'),8100,0,'62FD70AEE85B9BA247308F9001CEE6FA');Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950061,'test218','test218-desc',2950059,2950058,'Y',to_date('22-MAY-14','DD-MON-RR'),2950058,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950062,'test120','test120-desc',2950059,2950058,'Y',to_date('22-MAY-14','DD-MON-RR'),2950058,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950064,'test127','test127-desc',2950059,2950058,'Y',to_date('22-MAY-14','DD-MON-RR'),2950058,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950069,'test42','test42-desc',null,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950070,'test161','test161-desc',2950069,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950071,'test218','test218-desc',2950069,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950072,'test120','test120-desc',2950069,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950073,'test191','test191-desc',2950069,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950074,'test127','test127-desc',2950069,2950068,'Y',to_date('22-MAY-14','DD-MON-RR'),2950068,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950079,'test42','test42-desc',null,2950078,'Y',to_date('22-MAY-14','DD-MON-RR'),2950078,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950080,'test161','test161-desc',2950079,2950078,'Y',to_date('22-MAY-14','DD-MON-RR'),2950078,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950082,'test120','test120-desc',2950079,2950078,'Y',to_date('22-MAY-14','DD-MON-RR'),2950078,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950083,'test191','test191-desc',2950079,2950078,'Y',to_date('22-MAY-14','DD-MON-RR'),2950078,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950084,'test127','test127-desc',2950079,2950078,'Y',to_date('22-MAY-14','DD-MON-RR'),2950078,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950089,'test42','test42-desc',null,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950090,'test161','test161-desc',2950089,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950091,'test218','test218-desc',2950089,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950092,'test120','test120-desc',2950089,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950093,'test191','test191-desc',2950089,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950094,'test127','test127-desc',2950089,2950088,'Y',to_date('22-MAY-14','DD-MON-RR'),2950088,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950099,'test42','test42-desc',null,2950098,'Y',to_date('22-MAY-14','DD-MON-RR'),2950098,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950100,'test161','test161-desc',2950099,2950098,'Y',to_date('22-MAY-14','DD-MON-RR'),2950098,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950101,'test218','test218-desc',2950099,2950098,'Y',to_date('22-MAY-14','DD-MON-RR'),2950098,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950102,'test120','test120-desc',2950099,2950098,'Y',to_date('22-MAY-14','DD-MON-RR'),2950098,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950104,'test127','test127-desc',2950099,2950098,'Y',to_date('22-MAY-14','DD-MON-RR'),2950098,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950109,'test42','test42-desc',null,2950108,'Y',to_date('22-MAY-14','DD-MON-RR'),2950108,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950110,'test161','test161-desc',2950109,2950108,'Y',to_date('22-MAY-14','DD-MON-RR'),2950108,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950112,'test120','test120-desc',2950109,2950108,'Y',to_date('22-MAY-14','DD-MON-RR'),2950108,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950113,'test191','test191-desc',2950109,2950108,'Y',to_date('22-MAY-14','DD-MON-RR'),2950108,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950114,'test127','test127-desc',2950109,2950108,'Y',to_date('22-MAY-14','DD-MON-RR'),2950108,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950119,'test42','test42-desc',null,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950120,'test161','test161-desc',2950119,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950121,'test218','test218-desc',2950119,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950122,'test120','test120-desc',2950119,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950123,'test191','test191-desc',2950119,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950124,'test127','test127-desc',2950119,2950118,'Y',to_date('22-MAY-14','DD-MON-RR'),2950118,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950129,'test42','test42-desc',null,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950130,'test161','test161-desc',2950129,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950131,'test218','test218-desc',2950129,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950132,'test120','test120-desc',2950129,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950133,'test191','test191-desc',2950129,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950134,'test127','test127-desc',2950129,2950128,'Y',to_date('22-MAY-14','DD-MON-RR'),2950128,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950139,'test42','test42-desc',null,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950140,'test161','test161-desc',2950139,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950141,'test218','test218-desc',2950139,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950142,'test120','test120-desc',2950139,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950143,'test191','test191-desc',2950139,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950144,'test127','test127-desc',2950139,2950138,'Y',to_date('22-MAY-14','DD-MON-RR'),2950138,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950149,'test42','test42-desc',null,2950148,'Y',to_date('22-MAY-14','DD-MON-RR'),2950148,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950150,'test161','test161-desc',2950149,2950148,'Y',to_date('22-MAY-14','DD-MON-RR'),2950148,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950152,'test120','test120-desc',2950149,2950148,'Y',to_date('22-MAY-14','DD-MON-RR'),2950148,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950154,'test127','test127-desc',2950149,2950148,'Y',to_date('22-MAY-14','DD-MON-RR'),2950148,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950159,'test42','test42-desc',null,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950161,'test218','test218-desc',2950159,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950162,'test120','test120-desc',2950159,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950163,'test191','test191-desc',2950159,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950164,'test127','test127-desc',2950159,2950158,'Y',to_date('22-MAY-14','DD-MON-RR'),2950158,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950169,'test42','test42-desc',null,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950170,'test161','test161-desc',2950169,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950171,'test218','test218-desc',2950169,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950172,'test120','test120-desc',2950169,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950173,'test191','test191-desc',2950169,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950174,'test127','test127-desc',2950169,2950168,'Y',to_date('22-MAY-14','DD-MON-RR'),2950168,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950179,'test42','test42-desc',null,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950180,'test161','test161-desc',2950179,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950181,'test218','test218-desc',2950179,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950182,'test120','test120-desc',2950179,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950183,'test191','test191-desc',2950179,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950184,'test127','test127-desc',2950179,2950178,'Y',to_date('22-MAY-14','DD-MON-RR'),2950178,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950189,'test42','test42-desc',null,2950188,'Y',to_date('22-MAY-14','DD-MON-RR'),2950188,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950190,'test161','test161-desc',2950189,2950188,'Y',to_date('22-MAY-14','DD-MON-RR'),2950188,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950192,'test120','test120-desc',2950189,2950188,'Y',to_date('22-MAY-14','DD-MON-RR'),2950188,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950194,'test127','test127-desc',2950189,2950188,'Y',to_date('22-MAY-14','DD-MON-RR'),2950188,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950199,'test42','test42-desc',null,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950200,'test161','test161-desc',2950199,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950201,'test218','test218-desc',2950199,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950202,'test120','test120-desc',2950199,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950203,'test191','test191-desc',2950199,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950204,'test127','test127-desc',2950199,2950198,'Y',to_date('22-MAY-14','DD-MON-RR'),2950198,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950209,'test42','test42-desc',null,2950208,'Y',to_date('22-MAY-14','DD-MON-RR'),2950208,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950211,'test218','test218-desc',2950209,2950208,'Y',to_date('22-MAY-14','DD-MON-RR'),2950208,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950212,'test120','test120-desc',2950209,2950208,'Y',to_date('22-MAY-14','DD-MON-RR'),2950208,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950213,'test191','test191-desc',2950209,2950208,'Y',to_date('22-MAY-14','DD-MON-RR'),2950208,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950214,'test127','test127-desc',2950209,2950208,'Y',to_date('22-MAY-14','DD-MON-RR'),2950208,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950219,'test42','test42-desc',null,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950220,'test161','test161-desc',2950219,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950221,'test218','test218-desc',2950219,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950222,'test120','test120-desc',2950219,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950223,'test191','test191-desc',2950219,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950224,'test127','test127-desc',2950219,2950218,'Y',to_date('22-MAY-14','DD-MON-RR'),2950218,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950229,'test42','test42-desc',null,2950228,'Y',to_date('22-MAY-14','DD-MON-RR'),2950228,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950230,'test161','test161-desc',2950229,2950228,'Y',to_date('22-MAY-14','DD-MON-RR'),2950228,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950232,'test120','test120-desc',2950229,2950228,'Y',to_date('22-MAY-14','DD-MON-RR'),2950228,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950234,'test127','test127-desc',2950229,2950228,'Y',to_date('22-MAY-14','DD-MON-RR'),2950228,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950239,'test42','test42-desc',null,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950240,'test161','test161-desc',2950239,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950241,'test218','test218-desc',2950239,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950242,'test120','test120-desc',2950239,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950243,'test191','test191-desc',2950239,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950244,'test127','test127-desc',2950239,2950238,'Y',to_date('22-MAY-14','DD-MON-RR'),2950238,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950249,'test42','test42-desc',null,2950248,'Y',to_date('22-MAY-14','DD-MON-RR'),2950248,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950250,'test161','test161-desc',2950249,2950248,'Y',to_date('22-MAY-14','DD-MON-RR'),2950248,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,LAST_UPDT_DT,LAST_UPBY_SEUS_KEY,LOCK_SEQ_NBR,CONTENT_GUID) values (2950251,'test218','test218-desc',2950249,2950248,'Y',to_date('22-MAY-14','DD-MON-RR'),2950248,0,null);Insert into TEST_FOLDER (FLDR_KEY,FLDR_ID,FLDR_DESC_TX,PAR_FLDR_KEY,SEUS_KEY,FLDR_PRIVATE_FLG,L
William Robertson_jum

Best Answer

Answers

  • jaramill
    jaramill Member Posts: 4,299 Gold Trophy
    edited Jul 9, 2020 3:06PM

    Appreciate you following the guidelines (Oracle DB version, DDL and DML statements, and formatted).  But it's a bit TOO much data (i.e. insert statements).  If you show just a smaller sample that will help in the future.

  • Paulzip
    Paulzip Member Posts: 8,457 Blue Diamond
    edited Jul 9, 2020 3:40PM

    Index your foreign keys!!!!

    CREATE INDEX IX_TEST_FOLDER on TEST_FOLDER(PAR_FLDR_KEY)

    /

    Use a connect by....

    CREATE OR REPLACE FORCE EDITIONABLE VIEW TEST_FOLDER_VW2 (FLDR_KEY) AS

    select FLDR_KEY

    from TEST_FOLDER

    start with PAR_FLDR_KEY is null

    connect by PAR_FLDR_KEY = prior FLDR_KEY;

  • Jonathan Lewis
    Jonathan Lewis Member Posts: 9,756 Gold Crown
    edited Jul 9, 2020 4:11PM

    Ideally we need to see the execution plans (from SQL*Plus) after you've executed:

    alter session set statistics_level = all;

    set serveroutput off

    set linesize 180

    set pagesize 60

    set trimspool on

    ... run your query here

    select * from table(dbms_xplan.display_cursor(null,null,'allstats last outline projection'));

    One simple test - can you add the hint /*+ optimizer_features_enable('12.1.0.1') */ to the query running under 12.2.0.1 to see if the plan reverts to the 12.1.0.1 plan.  At first sight it looks as if the optimizer has a problem dealing with an estimate of the number of rows that the "recursive with pump" might return and swaps the hash join - which in your case might increase the CPU usage dramatically.  It might be a bug, and it might take an examination of the 10053 trace file to see what's actually happening.  Setting the OFE might just reverse the behaviour (as a short term measure).

    Regards

    Jonathan Lewis

    William Robertsonvpolasa
  • Jonathan Lewis
    Jonathan Lewis Member Posts: 9,756 Gold Crown
    edited Jul 9, 2020 5:26PM

    I got curious so I had a little poke around in the 10053 (CBO) trace.

    The change is deliberate - the optimizer does a recursive calculation - emulating a descent of the recursive WITH subquery.

    This is controlled by the hidden parameter: "_recursive_with_branch_iterations" which defaults to 7 in 12.2.0.1

    Set this to 1 with an "alter session" call, or add the hint  /*+ OPT_PARAM('_recursive_with_branch_iterations' 1) */ to the query and the behaviour will fall back to the 12.1.0.x calculation.

    Regards

    Jonathan Lewis

    William Robertsonvpolasa
  • Solomon Yakobson
    Solomon Yakobson Member Posts: 18,745 Red Diamond
    edited Jul 9, 2020 6:50PM

    Test case you provided has roots where PAR_FLDR_KEY IS NULL therefore ANY row in TEST_FOLDER table can be reached traversing starting from PAR_FLDR_KEY IS NULL and query:

    select * from test_folder_vw where fldr_key = -41;

    which builds all hirerchies from root (PAR_FLDR_KEY IS NULL) to leaf and only then picking rows where fldr_key = -41 is grossly inefficient since logically result is nothing but plain select from test_folder table:

    select * from test_folder where fldr_key = -41;

    But even if real data is such that there are roots besides PAR_FLDR_KEY IS NULL (in other word not all rows can be accessed traversing from PAR_FLDR_KEY IS NULL) view is quite inefficient.

    Efficient query would start with fldr_key = -41 and travese upstream until PAR_FLDR_KEY IS NULL is reached :

    SELECT  -41 FLDR_KEY

      FROM  TEST_FOLDER

      WHERE CONNECT_BY_ISLEAF = 1

        AND PAR_FLDR_KEY IS NULL

      START WITH FLDR_KEY = -41

      CONNECT BY FLDR_KEY = PRIOR PAR_FLDR_KEY

    /

    SY.

    William Robertsonvpolasa
  • Jonathan Lewis
    Jonathan Lewis Member Posts: 9,756 Gold Crown
    edited Jul 10, 2020 11:33AM Accepted Answer

    I've done a little write-up of this change on my blog: https://jonathanlewis.wordpress.com/2020/07/10/recursive-with-upgrade/

    Regards

    Jonathan Lewis

    _jum
  • vpolasa
    vpolasa Member Posts: 392 Blue Ribbon
    edited Jul 22, 2020 4:06PM

    Thank you very much Jonathan. The article is very helpful.

    I altered the parameter to 1 and flushed the shared pool. When I checked, the query was using the good execution plan.

    If the default value is 7, in which scenarios this value would be helpful?

  • Jonathan Lewis
    Jonathan Lewis Member Posts: 9,756 Gold Crown
    edited Jul 23, 2020 5:40AM
    vpolasa wrote:Thank you very much Jonathan. The article is very helpful.I altered the parameter to 1 and flushed the shared pool. When I checked, the query was using the good execution plan.If the default value is 7, in which scenarios this value would be helpful? 

    Thanks for letting us know that the suggestion worked for you.

    I think the appearance of a new default value is probably the optimizer group trying to add a "better guess" to what happens when recursive subqueries are used. The previous cost calculation were basically adequate for simple "one-step" recursion - the old "employee / manager" connect by example - but for real-world "bill of matierials" reports it's much more likely that there were be several steps down the tree and it does make more sense for large data sets to try to generate a cost that reflects the increasing volume of data as the descent takes place.  If the idea had occurred to me I might have been a little more cautious and used a value like 3 or 4, but the optimizer group picked 7.

    It will be interesting to see how many people have systems that response badly to the change, and whether Oracle publishes a note about this and (perhaps) changes the default or supplies a public mechanism for setting the value.

    Regards

    Jonathan Lewis

    P.S.  My last comment prompted me to check MOS for the articles on the hidden parameter. THere's a note dated Sept 2018 which describes the problem, gives the two workarounds, and suggests patch 24566985 as the permanent workaround.

    Document id 2443466.1 Oracle 12.2.0.1 CBO calculating high cost/CPU for queries with recursive sub-query (Doc ID 2443466.1)

    Regards

    Jonathan Lewis