OraFAQ Forum: Performance Tuning » defragment in oracle

Home » RDBMS Server » Performance Tuning » defragment in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

defragment in oracle [message #141308]

Sat, 08 October 2005 06:54

manu_jariwala
Messages: 20
Registered: August 2005
Location: Surat

Junior Member

Hi,

I have some doubts. So pls. clear it.

Is it possible to indexing / defragmentation in oracle to clean cache.

If yes, so how it possible?

I heared about this in sql server.

So pls. guide me to improve my performance

Bye.

Regards,

Manish

Report message to a moderator

Re: defragment in oracle [message #141318 is a reply to message #141308]

Sat, 08 October 2005 12:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So pls. guide me to improve my performance
Enable SQL_TRACE & run the results through TKPROF.
Produce EXPLAIN_PLAN for slow running SQL.
Post here the SQL that is slow running along with table description
It sounds like you are using the
READY, FIRE, AIM
approach to tuning.
What evidence do you have that poor performance is due to fragmentation?

Report message to a moderator

Re: defragment in oracle [message #141457 is a reply to message #141318]

Mon, 10 October 2005 06:21

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

>>Is it possible to indexing / defragmentation in oracle to clean cache.

Can you please elaborate what cache you are talking about?

--Girish

Report message to a moderator

Previous Topic:	AUM IN ORACLE
Next Topic:	How can I see the optimized SQL by CBO

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 18:48:18 CDT 2024