Oracle Database Discussions

Hi,

Oracle 11.2.0.3 SE1

Windows 2008 R2

Used below command.

CREATE TABLE USER102815.FRAADS NOLOGGING AS SELECT * FROM FRADS@MAINEXP WHERE RAADAT >= TRUNC(ADD_MONTHS(SYSDATE,-25),'MONTH');

explain plan :-

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------
Plan hash value: 2888530699

------------------------------------------------------------------------------------------
| Id  | Operation | Name   | Rows  | Bytes | Cost (%CPU)| Time     | Inst   |
------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT REMOTE|        | 52M|  4612M|   847K  (1)| 04:23:51 |        |
|*  1 |  TABLE ACCESS FULL     | FRAADS |    52M|  4612M|   847K  (1)| 04:23:51 | MAINP~ |
------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 - filter("A1"."RAADAT">=TRUNC(ADD_MONTHS(SYSDATE@!,-25),'fmmonth'))

Note
-----
- fully remote statement

17 rows selected.

Something goes wrong with my schedule job that used  above CTAS query to copy data from production box to report box.

Usually it took 15-18 Min to finish but from last two day's it was took  (28th Oct 2015)  6:35:00 Hours and (29th Oct 2015) 2:55:00 Hours. -- (I have log file from where i am able to find this timing detail.)

Table statistics up to date by 28th Oct 2015.

I check and find that rows increase by 1 lack by day.   but do not think that make this much of different.

Thanks,

Nirav Joshi