System stats
From: Cee Pee <carlospena999_at_gmail.com>
Date: Sun, 24 Mar 2019 23:56:13 -0500
Message-ID: <CAPTPB13EVpRba3DnEsHAGtNkrjtnnOTr-wq6n1KyCrNNG99QDQ_at_mail.gmail.com>
List,
Date: Sun, 24 Mar 2019 23:56:13 -0500
Message-ID: <CAPTPB13EVpRba3DnEsHAGtNkrjtnnOTr-wq6n1KyCrNNG99QDQ_at_mail.gmail.com>
List,
I was reading up on system stats and came across this link:
https://blogs.oracle.com/optimizer/should-you-gather-system-statistics
Here are some of the things the author says:
Doesnt setting systems help a lot these days esp with faster IO devices. Do
the listers collect system stats in your environments, test. prod, etc?
2. "there is at least *some *management or procedural overhead required to
maintain them"
'Maintaining' stats? I thought once we set the system stats we leave it out
there forever without touching it?
Thanks all,
CP
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 25 2019 - 05:56:13 CET