flush shared pool

[premkumarsp1]

Hi
I am flushing the shared pool in oracle 9i database by using the command

>> alter system flush shared_pool ;

Now if i give

>> select sql_text from v$sql;

236 rows are selected. I am the only person accessing the database. No other jobs are running. Wat could be the reason for the records being fetched while i give the command select sql_text from v$sql
Can some one help me out with this problem...
thanks in advance........

[Dave44]

Hi
I am flushing the shared pool in oracle 9i database by using the command

>> alter system flush shared_pool ;

Now if i give

>> select sql_text from v$sql;

236 rows are selected. I am the only person accessing the database. No other jobs are running. Wat could be the reason for the records being fetched while i give the command select sql_text from v$sql
Can some one help me out with this problem...
thanks in advance........

flush shared pool only gets rid of what it can, that which is in use will remain. any pinned objects will remain. any sql with shared cursors will remain.

flush shared pool will NEVER empty out the v$sql view; there will always be some stuff in there.

[premkumarsp1]

flush shared pool only gets rid of what it can, that which is in use will remain. any pinned objects will remain. any sql with shared cursors will remain.

flush shared pool will NEVER empty out the v$sql view; there will always be some stuff in there.

thanks ....i have got it.....