Explore >> Select a destination
|
You are here 
|
dbamarco.wordpress.com | ||
| | | | |
mikedietrichde.com
|
|
| | | | | If you still use DBMS_JOB in Oracle Database 19c, you will need this important one-off patch to avoid hang situations. This applies till 19.7 | |
| | | | |
alwayssql.wordpress.com
|
|
| | | | | Many times it happens that your backup (or restore) activity has been started by another Database Administrator or by a job, and you cannot use the GUI anything else to check the progress of that Backup / Restore. By combining multiple commands, I have generated below script which can give us a summary of current... | |
| | | | |
alexzeng.wordpress.com
|
|
| | | | | I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will... | |
| | | | |
tanelpoder.com
|
|
| | | Training overview This training session is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior. Instead of looking into increasing system utilization (by using more buffer cache or more parallelism) as a first "tuning" choice, this class is mostly about decreasing resource usage of SQL execution plans by improving their shape and available access paths. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. | ||
