Thanks for the question, oracle.
Asked: September 23, 2017 - 10:20 am UTC
Last updated: September 24, 2017 - 2:03 pm UTC
Version: 12.1.0
Viewed 1000+ times
You Asked
Hi team,
I have One question -
1. Suppose i have 1TB DB Size so What our recommendation in term of
-sizing of database memory.
-Temporary tablespace
-Undo tablespace
Thanks
and Connor said...
About this big
|---------------------------------------|
:-)
Seriously though - it is a constraint of what your database does.
I dont want to get ora-1555 (snapshot too old), I dont want to get ora-01237 (cannot extend datafile), and I want to get the best performance I can for all users. That *might* mean lots of memory ... but it might not. I've seen queries that run *better* via direct path read (and thus a smaller buffer cache) than queries that come from memory (ie, larger buffer cache).
But conversely, if I have an im-memory license, I'd probably buy as much memory as possible and take advantage of that feature.
Is this answer out of date? If it is, please let us know via a Comment