Sitemap

Amicuk Programming Answers

Stats

-0001-11-30   Views:4

Advertisement

Hi Experts, For how many days once we have to gather statistics of a table. Let us say for example I have gathered the statistics of a table on 12-Dec-2010 after how many days(on what date) again I have to gather the statistics of a table. And also p

Hi Experts,
For how many days once we have to gather statistics of a table.
Let us say for example I have gathered the statistics of a table on 12-Dec-2010 after how many days(on what date) again I have to gather the statistics of a table.
And also please help me how gathering the statistics of a table will improve performance.Please explain me.
Thanks in advance

The replay answer
Advertisement
user9077483      
     Newbie
Handle:      user9077483
Status Level:      Newbie
Registered:      Jan 30, 2010
Total Posts:      142
Total Questions:      84 (84 unresolved)
And he is still requesting people who do read documentation to abstract the documentation as he can't be bothered to read it.
Sybrand Bakker
Senior Oracle DBA

Go to See the other 4 answers

Hot
I HAVE LOST MY ALL MY EVENTS, NOW I CAN ONLY SEE MY PHOTOS IN THE PHOTOS SECTION. CAN SOMEONE HELP ME PLEASE ?Never heard of that before. Events and Photos are exactly the same thing, just presented in a different way. What version of iPhoto? Can you [More]
Maybe this will help others, but I had an epiphany regarding iPhoto 08 and the organizational method (or lack there of) in regards to Events and albums, etc. Here it goes: iPhoto is now iTunes for pictures. I know it has been said before, but this ti [More]
Hello everyone, I used the following article(on o'reilly) as reference for file upload: http://www.onjava.com/pub/a/onjava/2001/04/05/upload.html?page=1 While it works fine for most files types, there are problems with image files.(I am using PrintSt [More]
All of my Mail using Apple Mail has double spaces in them how do I do I change to single-space? SebastianYes. That is the technique I traditionally use to drop an image into text. I even cut and pasted again as you suggested with the same result. Tru [More]
Like anyone else who uses TVTropes and/or Wikipedia, my web browsing experience can get to the point where I have a lot of tabs open. Like 30+. I have Tab Mix Plus set so that tabs condense themselves to fit the tab bar, but ever since Australis hit, [More]
Hi, Do you Know how to create a new message instance in iMS 5.1 on a single machine? iPlanet documentation talk about it but I don't find the instructions that explain how to do it. Thank for help. RegardsYou can create multiple domains in a single i [More]
My wife and I have the same apple ID and when I set up Icloud it insist on us recieving the same email and contacts even though hers is entered under her email???You can use the same iTunes.  The only minor issue is app updating.  Each purchased item [More]
When I try to install Forte (Sun ONE Studio 4)(I tries CE, CE bundled with J2SE1.4 and EE) on a WIndows XP system I get the following message: "Error in instructions. Invalid jvm file name specified in LAUNCH. Invalid variable specification. Line num [More]
Well, mine was down for more than 24 hours, suffering from the same issues so many others on here were experiencing (no Home Sharing, no Internet, did not recognize Apple ID, etc.).  However, at about 10pm tonight I was watching my Blu Ray player and [More]
when running either "imp" or "exp" on an 9.2.0.5 DB I am getting the error "PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared" I see this package on other instances but it is indeed missing on this instance. How d [More]