SQL> exec plato.SystemState('HTM');
TRUDBA Database report (Systemstate)
The PLATO Package, version 45, build 1046
Report generated on 29-Sep-05 22:32:42
Geert De Paep, http://www.dba-village.com


General Files Storage Rbs/Undo Bckp/reco Problems Tables Jobs/AQ Memory Security Networking Various DBFeatures

Session information top

Session information
Sid Serial Username Machine Program Status Type Server LogonTime ClientInfo Module Action OsUser Terminal Spid
1 1 trudba.iconos.be oracle@trudba.iconos.be (PMON) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:33 oracle UNKNOWN 322773
2 1 trudba.iconos.be oracle@trudba.iconos.be (DBW0) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:33 oracle UNKNOWN 323089
3 1 trudba.iconos.be oracle@trudba.iconos.be (LGWR) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:33 oracle UNKNOWN 323393
4 1 trudba.iconos.be oracle@trudba.iconos.be (CKPT) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:33 oracle UNKNOWN 321973
5 1 trudba.iconos.be oracle@trudba.iconos.be (SMON) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:33 oracle UNKNOWN 322128
6 1 trudba.iconos.be oracle@trudba.iconos.be (RECO) ACTIVE BACKGROUND DEDICATED 12-sep 17:41:34 oracle UNKNOWN 322521
7 1 trudba.iconos.be oracle@trudba.iconos.be (CJQ0) ACTIVE USER DEDICATED 12-sep 17:41:34 oracle UNKNOWN 323008
8 1 trudba.iconos.be oracle@trudba.iconos.be (QMN0) ACTIVE USER DEDICATED 12-sep 17:41:34 oracle UNKNOWN 322649
9 1 trudba.iconos.be oracle@trudba.iconos.be (QMN1) ACTIVE USER DEDICATED 12-sep 17:41:34 oracle UNKNOWN 322629
68 10700 ACTIVE USER DEDICATED 29-sep 19:42:24 501355
192 15116 ACTIVE USER DEDICATED 29-sep 22:32:38 330230
186 15340 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 21:42:06 ? @fenris.dba-village.com (TNS V1-V3) oracle 263436
164 1805 ACTIVE USER DEDICATED 29-sep 22:32:30 331741
105 15398 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 21:25:27 ? @fenris.dba-village.com (TNS V1-V3) oracle 262943
99 35579 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:13:29 ? @fenris.dba-village.com (TNS V1-V3) oracle 262507
284 53888 ACTIVE USER DEDICATED 29-sep 22:32:29 328445
122 29798 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:10:48 ? @fenris.dba-village.com (TNS V1-V3) oracle 264188
196 1428 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:22:30 ? @fenris.dba-village.com (TNS V1-V3) oracle 263949
120 28278 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:13:41 ? @fenris.dba-village.com (TNS V1-V3) oracle 263585
214 29087 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:11:13 ? @fenris.dba-village.com (TNS V1-V3) oracle 259806
253 14193 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:18:25 ? @fenris.dba-village.com (TNS V1-V3) oracle 263840
22 14064 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:25:29 ? @fenris.dba-village.com (TNS V1-V3) oracle 263497
101 29553 ACTIVE USER DEDICATED 29-sep 18:10:53 258969
215 32659 ACTIVE USER DEDICATED 29-sep 22:29:09 404423
17 5435 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:19:09 ? @fenris.dba-village.com (TNS V1-V3) oracle 262537
11 49804 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:29:18 ? @fenris.dba-village.com (TNS V1-V3) oracle 262768
150 25492 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:10:49 ? @fenris.dba-village.com (TNS V1-V3) oracle 264009
182 15701 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:14:07 ? @fenris.dba-village.com (TNS V1-V3) oracle 263739
258 24537 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 21:51:12 ? @fenris.dba-village.com (TNS V1-V3) oracle 260301
250 25874 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:11:13 ? @fenris.dba-village.com (TNS V1-V3) oracle 263733
195 22241 SYS WERKGROEP\INDONESIA sqlplus.exe ACTIVE USER DEDICATED 29-sep 21:54:40 PLATO Sessio
n
inform
ation 		Bazeke INDONESIA 259499
146 29162 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 21:16:39 ? @fenris.dba-village.com (TNS V1-V3) oracle 261655
274 41582 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:29:51 ? @fenris.dba-village.com (TNS V1-V3) oracle 264052
54 28732 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:30:10 ? @fenris.dba-village.com (TNS V1-V3) oracle 263762
246 9334 ACTIVE USER DEDICATED 29-sep 20:56:56 255800
198 19643 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 22:14:43 ? @fenris.dba-village.com (TNS V1-V3) oracle 260128
283 24185 ZAIN fenris.dba-village.com ? @fenris.dba-village.com (TNS V1-V3) INACTIVE USER DEDICATED 29-sep 21:12:16 ? @fenris.dba-village.com (TNS V1-V3) oracle 258205
65 23349 SYSMAN fdx.gsx.iconos.be OMS INACTIVE USER DEDICATED 29-sep 21:27:53 OMS oracle unknown 263291
213 31136 SYSMAN fdx.gsx.iconos.be OMS INACTIVE USER DEDICATED 29-sep 21:27:57 Mgmt_srv OEM.SystemPool oracle unknown 262601

Active sessions
Sid Serial Username Type SQL
1 1 BACK
2 1 BACK
3 1 BACK
4 1 BACK
5 1 BACK update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd,
deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags,
flags + :flag)), timestamp = :time where obj# = :objn
6 1 BACK select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id,
state, status, heuristic_dflt, session_vector, reco_vector,
3600*24*(sysdate-reco_time),
3600*24*(sysdate-nvl(heuristic_time,fail_time)), global_commit#, type# from
pending_trans$ where session_vector != '00000000'
7 1 USER
8 1 USER select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid,
chain_no, local_order_no, enq_time, enq_tid, step_no, priority,
exception_qschema, exception_queue, retry_count, corrid, time_manager_info,
sender_name, sender_address, sender_protocol from SYSMAN.MGMT_NOTIFY_QTABLE
where msgid = :1
9 1 USER select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid,
chain_no, local_order_no, enq_time, enq_tid, step_no, priority,
exception_qschema, exception_queue, retry_count, corrid, time_manager_info,
sender_name, sender_address, sender_protocol from SYSMAN.MGMT_NOTIFY_QTABLE
where msgid = :1
68 10700 USER SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
101 29553 USER
164 1805 USER
192 15116 USER select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay,
tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue,
tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info,
tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address,
tab.sender_protocol, tab.dequeue_msgid from DL3_BORNEM.DDT_TRACKING_QT tab
where msgid = :1
195 22241 SYS USER select * from v$session where status = 'ACTIVE'
215 32659 USER SELECT c.target_guid, c.metric_guid, c.store_metric, c.schedule,
c.coll_name, m.metric_name, m.eval_func FROM MGMT_METRIC_COLLECTIONS_REP r,
MGMT_METRIC_COLLECTIONS c, MGMT_METRICS m WHERE c.suspended = 0 AND
c.is_repository = 1 AND (c.last_collected_timestamp IS NULL
OR c.last_collected_timestamp + c.schedule / 1440 < SYSDATE) AND
c.metric_guid = m.metric_guid AND r.target_guid = c.target_guid AND
r.metric_guid = c.metric_guid AND r.coll_name = c.coll_name
246 9334 USER SELECT c.target_guid, c.metric_guid, c.store_metric, c.schedule,
c.coll_name, m.metric_name, m.eval_func FROM MGMT_METRIC_COLLECTIONS_REP r,
MGMT_METRIC_COLLECTIONS c, MGMT_METRICS m WHERE c.suspended = 0 AND
c.is_repository = 1 AND (c.last_collected_timestamp IS NULL
OR c.last_collected_timestamp + c.schedule / 1440 < SYSDATE) AND
c.metric_guid = m.metric_guid AND r.target_guid = c.target_guid AND
r.metric_guid = c.metric_guid AND r.coll_name = c.coll_name
284 53888 USER SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

SGA Distribution
Pool Size Pct
Total SGA
241.4M 100%
Shared pool
192.0M 79.5%
Buffer cache
32.0M 13.3%
Large pool
16.0M 6.6%
Log buffer
770.0K .3%
Fixed SGA
716.6K .3%


Locking information top

Locking information
Username Sid ObjOwner ObjName Type Held Rqst Tx Start time
SYS 195 SYS PLATO_TEMP_UPTIME_GDP TM RX 09/29/05 21:57:51
SYS 195 TX X 09/29/05 21:57:51
SYS 195 SYS PLATO_TEMP_UPTIME_GDP TO RX 09/29/05 21:57:51


Top SQL Area top

Top 7 SQL sorted by buffer gets per execution (since startup)
Statement Buf/exec Dsk/exec Exectns BufGets DiskRds
BEGIN :a := nmp_monitor.CheckStorage; END; 395906 35985 74 27.9M 2.5M
select s.tablespace_name, s.owner, s.segment_name, s.bytes, f.maxfree, s.next_one, s.next_two,
s.next_three, s.next_four, t.extent_management, t.allocation_type from (SELECT
s.tablespace_name, s.owner, s.segment_name, s.bytes, s.next_extent AS next_one,
s.next_extent*(1+s.pct_increase/100) AS next_two, s.next_extent*(1+s.pct_increase/100)
*(1+s.pct_increase/100) AS next_three, s.next_extent*(1+s.pct_increase/100)
*(1+s.pct_increase/100)
*(1+s.pct_increase/100) AS next_four FROM dba_segments s, dba_tablespaces t WHERE s.tablespace_name
= t.tablespace_name AND t.extent_management = 'DICTIONARY' UNION ALL SELECT s.tablespace_name,
s.owner, s.segment_name, s.bytes, t.next_extent, t.next_extent, t.next_extent, t.next_extent FROM
dba_segments s, dba_tablespaces t WHERE s.tablespace_name = t.tablespace_name AND
t.extent_management = 'LOCAL' AND allocation_type = 'UNIFORM' UNION ALL SELECT s.tablespace_name,
s.owner, s.segment_name, s.bytes, 0, 0, 0, 0 FROM dba_segments s, dba_tablespaces t WHERE
s.tablespace_name = t.tablespace_name AND t.extent_management = 'LOCAL' AND allocation_type = 'SYSTEM'
) s, (select tablespace_name, max(bytes) as maxfree from (select tablespace_name, bytes
from dba_free_space union all select tablespace_name, maxbytes - least(maxbytes,bytes) as bytes
-- Note: greatest, because current size can be > autoext maxsize from
dba_data_files where autoextensible = 'YES' ) group by tablespace_name ) f,
dba_tablespaces t, nmt_tablespace_usage tu2,
nmt_tablespace_usage tu3 where s.tablespace_name = f.tablespace_name AND s.tablespace_name =
t.tablespace_name and next_one+next_two+next_three+next_four > maxfree and
t.tablespace_name = tu2.tablespace_name(+) and tu3.tablespace_name='DEFAULT'
and nvl(tu2.check_cannotalloc,tu3.check_cannotalloc) = 'Y' 		142153 11332 74 10.0M 818.8K
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN
emd_maintenance.analyze_emd_schema('SYSMAN'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END
IF; END; 		118440 4599 5 578.3K 22.4K
select owner,segment_name,extents, max_extents, max_extents-extents nr_ext_gap from
dba_segments s where segment_type not in ('CACHE','CLUSTER') 		113965 13968 74 8.0M 1009.3K
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_articles.listsectoren', simple_list__, complex_list__, true)) then rc__ := 2;
else null; null; dvp_articles.listsectoren; if (wpg_docload.is_file_download) then rc__ := 1;
wpg_docload.get_download_file(:doc_info); null; null; null; commit; else rc__ := 0; null;
null; null; commit; owa.get_page(:data__,:ndata__); end if; end if; :rc__ := rc__; end; 		105875 1898 313 31.6M 579.8K
select owner,segment_name,segment_type,extents from dba_segments s, dba_tablespaces t
where s.tablespace_name = t.tablespace_name and t.extent_management <>
'LOCAL' order by extents desc 		72819 2357 74 5.1M 170.3K
BEGIN plato.help; END; 70512 9455 1 68.8K 9.2K

Top 7 SQL sorted by executions (since startup)
Statement Buf/exec Dsk/exec Exectns BufGets DiskRds
SELECT MAX(LOG_LEVEL) FROM SVT_GRAPHS WHERE ID = :b1 2 1 12513376 23.8M 188
SELECT * FROM SVT_AGLEVELS WHERE ID = :b1 2 1 2611332 4.9M 189
SELECT * FROM SVT_GRAPH_LEVELS WHERE GRAPH_ID = :b1 AND AGLVL_ID = :b2 3 1 2611332 4.9M 375
SELECT * FROM SVT_DATA WHERE GRAPH_ID = :b1 AND AGLVL_ID = :b2 AND FLOOR_X = :b3 5 1 2611332 11.1M 122.4K
SELECT VARRAY_POS FROM SVT_MEASURES WHERE GRAPH_ID = :b1 AND NAME = :b2 3 1 2187629 5.4M 1.3K
UPDATE SVT_DATA SET Y=:b1,NR_AGGREGATED=NR_AGGREGATED + 1 WHERE GRAPH_ID = :b2 AND AGLVL_ID = :b3 AND
FLOOR_X = :b4 		6 1 2068048 11.1M 2.1K
SELECT * from svt_dbmon where name = :b1 8 1 1931588 12.8M 22.4K

Top 7 SQL sorted by buffer gets (since startup)
Statement Buf/exec Dsk/exec Exectns BufGets DiskRds
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN
pandora_DBMON(60); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 		5262 19 24180 121.3M 439.1K
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_articles.listarticles', simple_list__, complex_list__, true)) then rc__ := 2;
else null; null; dvp_articles.listarticles(SubCatIdA=>:SubCatIdA); if (wpg_docload.is_file_download)
then rc__ := 1; wpg_docload.get_download_file(:doc_info); null; null; null; commit; else
rc__ := 0; null; null; null; commit; owa.get_page(:data__,:ndata__); end if; end if;
:rc__ := rc__; end; 		7523 291 11674 83.7M 3.2M
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_base.main', simple_list__, complex_list__, true)) then rc__ := 2; else
null; null; dvp_base.main; if (wpg_docload.is_file_download) then rc__ := 1;
wpg_docload.get_download_file(:doc_info); null; null; null; commit; else rc__ := 0; null;
null; null; commit; owa.get_page(:data__,:ndata__); end if; end if; :rc__ := rc__; end; 		5149 1855 14105 69.2M 24.9M
select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft,
system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 and q.table_objno
= t.objno and q.usage = 0 and bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name,
aft.table_objno skip locked 		722 359 93676 64.4M 32.0M
select id, publi_datum, title from( SELECT distinct(id) id,
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') publi_datum, title
FROM (SELECT * FROM dvt_articles, dvt_cat_art where status = 'P'
and id = artikel_id and cat_sub_id = :b1
ORDER BY to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') desc)
WHERE ROWNUM < (16 + :b2) minus
SELECT distinct(id) id, to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') publi_datum,
title FROM (SELECT * FROM dvt_articles, dvt_cat_art
where status = 'P' and id = artikel_id and
cat_sub_id = :b1 ORDER BY
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') desc)
WHERE ROWNUM < (1 + :b2)) order by publi_datum desc 		5210 182 12337 61.2M 2.1M
SELECT id, title, public_dag, public_maand from (select id, title, public_dag, public_maand from
dvt_articles where benelux_vlag = 'J' and status != 'H' and
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') <= trunc(sysdate) order by
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') desc, id desc) where rownum <= 5 		4118 1702 14166 55.6M 22.9M
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_articles.zinews', simple_list__, complex_list__, true)) then rc__ := 2; else
null; null; dvp_articles.zinews(SectorIdA=>:SectorIdA,ToonA=>:ToonA); if
(wpg_docload.is_file_download) then rc__ := 1; wpg_docload.get_download_file(:doc_info); null;
null; null; commit; else rc__ := 0; null; null; null; commit;
owa.get_page(:data__,:ndata__); end if; end if; :rc__ := rc__; end; 		5498 64 9234 48.4M 574.2K

Top 7 SQL sorted by disk reads (since startup)
Statement Buf/exec Dsk/exec Exectns BufGets DiskRds
select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft,
system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 and q.table_objno
= t.objno and q.usage = 0 and bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name,
aft.table_objno skip locked 		722 359 93676 64.4M 32.0M
select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time,
enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info,
sender_name, sender_address, sender_protocol from MAILER.MLT_MAIL_QT where time_manager_info <= :1 and
state != :2 for update skip locked 		475 362 92917 42.0M 32.0M
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_base.main', simple_list__, complex_list__, true)) then rc__ := 2; else
null; null; dvp_base.main; if (wpg_docload.is_file_download) then rc__ := 1;
wpg_docload.get_download_file(:doc_info); null; null; null; commit; else rc__ := 0; null;
null; null; commit; owa.get_page(:data__,:ndata__); end if; end if; :rc__ := rc__; end; 		5149 1855 14105 69.2M 24.9M
SELECT id, title, public_dag, public_maand from (select id, title, public_dag, public_maand from
dvt_articles where benelux_vlag = 'J' and status != 'H' and
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') <= trunc(sysdate) order by
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') desc, id desc) where rownum <= 5 		4118 1702 14166 55.6M 22.9M
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin
owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 84; null; null; simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if
(owa_match.match_pattern('dvp_articles.listbeneluxnews', simple_list__, complex_list__, true)) then rc__ :=
2; else null; null; dvp_articles.listbeneluxnews; if (wpg_docload.is_file_download) then rc__ :=
1; wpg_docload.get_download_file(:doc_info); null; null; null; commit; else rc__ := 0;
null; null; null; commit; owa.get_page(:data__,:ndata__); end if; end if; :rc__ := rc__;
end; 		8509 3803 4641 37.6M 16.8M
SELECT * from (select * from dvt_counter_articles where creatie_dt > (sysdate - 31) order by
aantal desc) where rownum < 11 		129 90 123739 15.1M 10.5M
SELECT * from dvt_articles where benelux_vlag = 'J' and status != 'H' order by
to_date(public_dag||'-'||public_maand||'-'||public_jaar, 'dd-mm-yy') desc, id desc 		4125 2055 5255 20.6M 10.2M


(c) Geert De Paep, Uptime Technologies, Belgium - http://www.dba-village.com

[This report took 96 seconds]
[Usage: SQL*Plus: "exec plato.help" after "set serveroutput on format wrapped"]

SQL> spool off