Re: Strange Behaviour (with Test Case)

From: Patrick Jolliffe <jolliffe_at_gmail.com>
Date: Wed, 5 Aug 2015 20:29:26 +0800
Message-ID: <CABx0cSXEX05Uwh26Pdbm2Ujr3K7NSv=JXrLE7tTOSYWu5vpY8g_at_mail.gmail.com>

Raw trace means what - will try to generate tommorrow? Here is explain plan for now, sorry about the formatting:

20:27:25 SQL> select * from
table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT

---

---

SQL_ID 67bm5czzp2hs0, child number
0

---

SELECT SUM( CASE WHEN (CHRTYPE = 'R03' OR CHRTYPE =
'LDU') THEN RATE /10 END ) FROM TEST_FACT Plan hash value:
1326015606

---

| Id  | Operation                  | Name      | Rows  | Bytes | Cost
(%CPU)| Time     |


----------------------------------------------------------------------------------------


|   0 | SELECT STATEMENT           |           |       |       |     3
(100)|          |
|   1 |  SORT AGGREGATE            |           |     1 |    16 |
|          |
|   2 |   TABLE ACCESS STORAGE FULL| TEST_FACT |     3 |    48 |     3

(0)| 00:00:01 |

---

Note

---

• dynamic statistics used: dynamic sampling (level=2)

19 rows
selected.

Elapsed: 00:00:00.20

On 5 August 2015 at 19:37, Sayan Sergeevich Malakshinov < malakshinovss_at_psbank.ru> wrote:

> Could you show the execution plan or raw trace?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 05 2015 - 14:29:26 CEST