• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

clear shared pol

If we are inserting and it slow...
how can we clear the shared pool
1 Solution
Wasim Akram ShaikCommented:
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
DavidSenior Oracle Database AdministratorCommented:
A very typical reason for slow performance during insert is lock contention.  Is that likely?
slightwv (䄆 Netminder) Commented:
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.
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Devinder Singh VirdiLead Oracle DBA TeamCommented:
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.
Wasim Akram ShaikCommented:
Agreed Steve.. Shared pool will not cause a transaction loss, however you will definitely loose the cached sql plans of sql statements..
tonydbaAuthor Commented:
yes got it

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now