OraFAQ Forum: Performance Tuning » need assist to delete histograms

Home » RDBMS Server » Performance Tuning » need assist to delete histograms (oracle 10.2.0.3 solaris 10)

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

need assist to delete histograms [message #339046]

Wed, 06 August 2008 11:49

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Experts,

i have a question. one of my database is suffering with bind pecking. for this i got instruction from my teammates to delete histograms.

can any one provide some information about histograms and how to remove histograms.

Regards,

Jyothy..

[Updated on: Wed, 06 August 2008 11:49]

Report message to a moderator

Re: need assist to delete histograms [message #339047 is a reply to message #339046]

Wed, 06 August 2008 11:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

Report message to a moderator

Re: need assist to delete histograms [message #339054 is a reply to message #339046]

Wed, 06 August 2008 12:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>information about histograms
Way too much to be explained in a forum.
Oracle docs carry all the information you want.
>> how to remove histograms
Depends on how you collect statistics and usage of METHOD_OPT.
If you are absolutely sure you may want to check try that in test environment and only for that specific table.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#i42219
I would try with 'FOR ALL COLUMNS SIZE 1'

[Updated on: Wed, 06 August 2008 12:10]

Report message to a moderator

Previous Topic:	Help me tune the query
Next Topic:	How to estimate query response time and number of rows without executing query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:56:48 CST 2024