Re: tuning tool/scripts

From: Sigmar Wiesmayr <wis_at_ecolog.at>
Date: Mon, 17 Apr 2000 20:10:18 +0200
Message-ID: <38FB538A.A3ED7F89_at_ecolog.at>

Try this. Perhaps you wanted that.

select vs.sql_text, vs.sharable_mem, vs.persistent_mem, vs.runtime_mem, vs.sorts, vs.executions, vs.parse_calls, vs.buffer_gets, vs.disk_reads, vs.version_count, vs.users_opening, vs.loads, to_char(to_date(vs.first_load_time,'YYYY-MM-DD/HH24:MI:SS'),'MM/DD HH24:MI:SS') first_load_time,
rawtohex(vs.address) address, vs.hash_value hash_value

, rows_processed
, vs.command_type
, OPTIMIZER_MODE

 from v$sqlarea vs
where (parsing_user_id != 0)
order by
 buffer_gets/executions desc

WieSi

Tom wrote:

> I want to create a daily list off the most 'expensive' sql statements used
> during the day. Is there anybody wo can tell me how to produce such a list.
> Do i need to buy a tool, or is it possible to use just sql scripts ??
> Thanks, just mail me or mail to this group.
>
> Tom Breed
> tbreed_at_hacom.nl
Received on Mon Apr 17 2000 - 20:10:18 CEST