When using "Alter database calibrate" is the calibration dependent on the database file size?
asked 17 Dec '10, 08:22
Martin 9.0k●130●166●257 accept rate: 14%
Yes. Calibration involves sampling I/O retrieval times for each dbspace, and the larger the dbspace the more sampling is performed, up to a maximum of 3200 pages with the 12.0.0 release.
answered 17 Dec '10, 15:23
Glenn Paulley 10.8k●5●76●106 accept rate: 43%
Once you sign in you will be able to subscribe for any updates here
Answers
Answers and Comments
Markdown Basics
learn more about Markdown
Question tags:
performance ×274 calibration ×6
question asked: 17 Dec '10, 08:22
question was seen: 1,500 times
last updated: 17 Dec '10, 15:23
CALIBRATE DATABASE issue
SSD performance
What is the quickest statement?
Will heavy disk fragmentation slow down my queries?
Having table in ML publication kills update performance
How do I save the plan in Application Profiling?
How much does the size of a database page affect its performance ?
SA-9 Using Hash Table; Degrading Performance
Internal warning: Request task 62 dispatch took 13 seconds
Why does a 6000-row INTEGER index take 1.1G of disk space?
First time here? Check out the FAQ!