• 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
0
tonydba
Asked:
tonydba
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
http://www.dba-oracle.com/tp_Oracle_shared_pool_routine_flush.htm
0
 
DavidSenior Oracle Database AdministratorCommented:
A very typical reason for slow performance during insert is lock contention.  Is that likely?
0
 
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.
0
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.
0
 
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..
0
 
tonydbaAuthor Commented:
yes got it
0

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