Tagged: system statistics

I’ve been working on a few test cases and I’m in search of some real-world data. If your production Oracle database uses system statistics, either Workload Statistics or Noworkload Statistics, and you are willing to share them, please post a comment with the output from the following two queries:

select version from v$instance;
select pname, pval1 from sys.aux_stats$ where sname = 'SYSSTATS_MAIN';

Disclaimer

The views or opinions expressed on this blog are my own and do not necessarily reflect the views or opinions of current or past employers. The views or opinions expressed by visitors on this blog are theirs solely and may not reflect mine.