schema stats [message #635171] |
Mon, 23 March 2015 10:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Experts,
Stats on some of the Tables in one of the production schema is gathered on dec 12 and four of the tables are never gathered stats.
There are fair of amount of tables with schema stats up to date.
We don't have any major performance issues except on some queries that involvles those four tables whose stats have never been gathered.
I was going to gather stats on those tables after testing in UAT.
But i needed your suggestion on this:-
Since overall performance is good but still Is it a good idea to run schema stats as many of the tables are not up to date stats?
Thanks,
Varun
|
|
|
|
|
|
|
|
|
Re: schema stats [message #635192 is a reply to message #635171] |
Tue, 24 March 2015 04:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:We don't have any major performance issues except on some queries that involvles those four tables whose stats have never been gathered. Gather stats on those tables, with histograms. If you don't like the results, delete them. Furthermore, ask your DBA why he disabled the automatic stats gathering job. And ask when he last gathered system stats.
--update: to be precise, I should have said "gather stats auto task" rather than "automatic stats gathering job".
[Updated on: Tue, 24 March 2015 04:25] Report message to a moderator
|
|
|
Re: schema stats [message #635204 is a reply to message #635192] |
Tue, 24 March 2015 12:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Thanks John,
I imported the database 3 months ago from another server.
I will enable the job gather stats auto task now.
Thanks,
Varun
|
|
|
|
Re: schema stats [message #635224 is a reply to message #635205] |
Tue, 24 March 2015 17:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hey Dear Michel,
Please don't say that. Some how either I did not see your reply or I just could not perceive it somehow.
You have been such a great help to me since I started working on and off Oracle DBA job.
I consider you as my teacher and I honor you always.
Thanks so much for your help for all those years.
-Varun
|
|
|
|
|