Oracle Tuning
Useful Queries
Useful Queries
Maximum Concurrent Users
Maximum Concurrent Users
SELECT dbid,
version,
highwater
FROM DBA_HIGH_WATER_MARK_STATISTICS
WHERE name = 'SESSIONS';
Maximum IOPS
http://otipstricks.blogspot.com/2012/03/iops-requirements.html Maximum IOPS
Bibliography
Bibliography
Troubleshooting Query Performance Degradation - Recommended Actions (Doc ID 742112.1)Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions (Doc ID 745216.1)
https://centroid.com/db-time-average-active-sessions-and-some-scripts/
http://otipstricks.blogspot.com/2012/03/iops-requirements.html
https://blogs.oracle.com/sql/learn-sql-performance-tuning-in-this-free-online-coursehttps://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-performance.html
https://www.slideshare.net/CarlosSierra29/presentations
https://centroid.com/db-time-average-active-sessions-and-some-scripts/
http://otipstricks.blogspot.com/2012/03/iops-requirements.html
https://blogs.oracle.com/sql/learn-sql-performance-tuning-in-this-free-online-coursehttps://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-performance.html
https://www.slideshare.net/CarlosSierra29/presentations