Hi there,

No bind vars are being used (not applicable for these queries). These are the 3 sql statements:

> SELECT min_page_req_time,avg_page_req_time,max_page_req_time
> FROM page_requests_summary
> WHERE timestamp>=TO_DATE('00-00-0000 00:00','dd-mm-yyyy hh24:mi:ss')
> AND timestamp<=TO_DATE('00-00-0000 23:59','dd-mm-yyyy hh24:mi:ss')
> AND page_req_hour=24
> AND store_id IS NULL
>
> SELECT session_hour,session_count
> FROM sessions_summary
> WHERE TO_CHAR(session_date,'dd-mm-yyyy hh24:mi:ss')='01-01-1001 01:01:01'
> ORDER BY session_hour
>
> SELECT to_char(orderdate,'HH24'), count(*)
> FROM STORE_ORDER
> WHERE orderdate >= to_date('09-11-2004 00:00:00','DD-MM-YYYY HH24:MI:SS')
> AND orderdate <= to_date('10-11-2004 00:00:00','DD-MM-YYYY HH24:MI:SS')
> GROUP BY to_char(orderdate,'HH24')

I imagine these are parsed/executed from the shared pool?

Thanks,
Chucks