473,405 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

flush shared pool

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........
Apr 7 '08 #1
2 10586
Dave44
153 100+
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.
Apr 16 '08 #2
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.....
Apr 27 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: lezah | last post by:
what is the meaning "latch" in the shared pool and library cache?
11
by: Michael Schuler | last post by:
The use of STL in shared memory poses a real problem since (non-smart) pointers are not allowed there. Is there any solution for containers in shared memory using smart pointers? Where can I...
14
by: phil_gg04 | last post by:
Dear C++ Experts, Over the last couple of months I have been writing my first program using shared memory. It has been something of an "in-at-the-deep-end" experience, to say the least. At...
12
by: Jeremy | last post by:
Hi all, I'm getting very confused about how DB2 uses shared memory and I wonder if someone could clarify matters for me, please ? We are running 32bit DB2 V7.2 FP9 under AIX 4.3.3 on a machine...
0
by: Peter | last post by:
When I issue call sqlj.install_jar('file:///f:/jars/mail.jar','MAIL'); I get the messages SQL4301N Java or .NET interpreter startup or communication failed, reason
2
by: Osvaldo Bisignano | last post by:
Program1.exe and Program2.exe reference Library.dll, which only contains a class with static methods and properties. Modifying a value of Library.dll from Program1.exe, will change when I read...
0
by: Abhishek Srivastava | last post by:
Hello All, I am reading about the worker process based architecture of ASP.NET. What I am wondering is how do they use the shared resources like the connection pool to the database. DB...
10
by: Oriane | last post by:
Hello, I have to share a object in RAM between several processes. I intend to design a special process to load this objet (an Autocad plan) in memory, and to take care of the read/write...
5
by: Sune | last post by:
Hi all, I want to make data stored in-memory (not disk) available to several processes. My concern is that poorly written C applications with dangling pointers may(will) damage the data in this...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.