Xref: alice comp.databases.oracle.server:22258
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-peer.sprintlink.net!news-backup-east.sprintlink.net!news.sprintlink.net!165.166.15.6!news2.infoave.net!not-for-mail
From: "Bryan Michael Lenihan" <bryanle@lenisoft.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: v$sql - how to clear/truncate
Date: Sat, 6 Jun 1998 02:18:54 -0400
Organization: Info Avenue Internet Services
Lines: 26
Message-ID: <6lan0t$c3d$1@news1.infoave.net>
References: <6la6uc$qvq$1@news.innet.com>
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3

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@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.
>
>