OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » schema stats (11.2.0.4)

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

schema stats [message #635171]

Mon, 23 March 2015 10:34

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

Report message to a moderator

[Message index]

		schema stats By: varunvir on Mon, 23 March 2015 10:34
		Re: schema stats By: Michel Cadot on Mon, 23 March 2015 11:15
		Re: schema stats By: BlackSwan on Mon, 23 March 2015 11:22
		Re: schema stats By: varunvir on Mon, 23 March 2015 11:58
		Re: schema stats By: BlackSwan on Mon, 23 March 2015 12:23
		Re: schema stats By: varunvir on Mon, 23 March 2015 12:58
		Re: schema stats By: Michel Cadot on Mon, 23 March 2015 13:31
		Re: schema stats By: John Watson on Tue, 24 March 2015 04:23
		Re: schema stats By: varunvir on Tue, 24 March 2015 12:29
		Re: schema stats By: Michel Cadot on Tue, 24 March 2015 12:45
		Re: schema stats By: varunvir on Tue, 24 March 2015 17:47
		Re: schema stats By: Michel Cadot on Wed, 25 March 2015 01:45
		Re: schema stats By: varunvir on Thu, 26 March 2015 14:13

Previous Topic:	regarding deleting 80 million records
Next Topic:	Setting environmental variable for SID failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:18:54 CDT 2024