Improve company productivity with a Business Account.Sign Up

x
?
Solved

clear shared pol

Posted on 2014-04-01
6
Medium Priority
?
293 Views
Last Modified: 2014-04-06
If we are inserting and it slow...
how can we clear the shared pool
0
Comment
Question by:tonydba
6 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 2000 total points
ID: 39970453
basically insert must be slow because of other reasons(check out indexes, and tablespace fragmentation etc,)

if you intend to do so..

use the below command

alter system flush shared_pool;

but be sure as you may lose transaction data at that particular instant

read this for more information
http://www.dba-oracle.com/tp_Oracle_shared_pool_routine_flush.htm
0
 
LVL 23

Expert Comment

by:David
ID: 39970458
A very typical reason for slow performance during insert is lock contention.  Is that likely?
0
 
LVL 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39970622
I agree that flushing the shared pool will not help with performance.

>>but be sure as you may lose transaction data at that particular instant

I have to disagree with this statement.  If you have supporting documentation I would like to read it.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39970827
Please check event in v$session to see if session is waiting on which wait event or generate ASH report for that session. This will help you to narrow down the root cause.
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39971234
Agreed Steve.. Shared pool will not cause a transaction loss, however you will definitely loose the cached sql plans of sql statements..
0
 

Author Closing Comment

by:tonydba
ID: 39981697
yes got it
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question