Re: v$sql - how to clear/truncate

From: Bryan Michael Lenihan <bryanle_at_lenisoft.com>
Date: Sat, 6 Jun 1998 02:18:54 -0400
Message-ID: <6lan0t$c3d$1@news1.infoave.net>

Have you tried flushing your SGA:

ALTER SYSTEM FLUSH SGA I have not tested this out yet. Another way would be to bounce your instance to clear the SGA out.

Thanks,
Bryan

Jim Stott wrote in message <6la6uc$qvq$1_at_news.innet.com>...
>Is there any way to truncate the data output from the view v$sql ??
>
>I would like to start over and track the number of executions for
particular
>sql statements on my db, but I can's seem to find what underlying table the
>v$sql comes from ?
>
>Thanks for any help.
>
>Jim.
>
>
Received on Sat Jun 06 1998 - 01:18:54 CDT