Home » RDBMS Server » Performance Tuning » need assist to delete histograms (oracle 10.2.0.3 solaris 10)
need assist to delete histograms [message #339046] Wed, 06 August 2008 11:49 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm
Re: need assist to delete histograms [message #339054 is a reply to message #339046] Wed, 06 August 2008 12:09 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Mon Dec 05 21:04:30 CST 2016

Total time taken to generate the page: 0.11009 seconds