All about Databases - Oracle, PostgeSQL, Mysql, Big Data .....

Monday, June 1, 2020

Links about Direct path reads and Smart Scan in Exadata

https://weidongzhou.wordpress.com/2016/04/06/direct-path-read-vs-buffer-cache-read/
http://afatkulin.blogspot.com/2012/07/serial-direct-path-reads-in-11gr2-and.html
https://avdeo.com/tag/_small_table_threshold/
https://www.centroid.com/direct-reads-and-smart-scan-exadata/
https://www.centroid.com/smart-scan-why-smalltablethreshold-important/
http://oracledoug.com/serendipity/index.php?/archives/1321-11g-and-direct-path-reads.html
https://fritshoogland.wordpress.com/2017/09/08/the-full-table-scan-direct-path-read-decision-for-version-12-2/
https://alexanderanokhin.com/2018/10/22/_serial_direct_read-is-not-a-criteria-for-cursor-non-sharing/
https://www.youtube.com/watch?v=bTuwFAUEgSw

Posted by Mehman Jafarov at 4:19 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Mehman Jafarov
Baku, Azerbaijan
I mainly started this blog with the intent to just keep a notes of what I am learning on my professional journey and thus providing a safe place to store my learning experience. I hope this will also help others to learn something new from my blog.
View my complete profile

Blog Archive

  • ►  2024 (1)
    • ►  July (1)
  • ►  2023 (17)
    • ►  October (14)
    • ►  August (1)
    • ►  July (1)
    • ►  April (1)
  • ►  2021 (25)
    • ►  November (1)
    • ►  October (2)
    • ►  September (1)
    • ►  July (4)
    • ►  June (9)
    • ►  April (1)
    • ►  February (3)
    • ►  January (4)
  • ▼  2020 (26)
    • ►  August (1)
    • ▼  June (5)
      • SYSAUX links to analyze contents
      • Direct Path Read vs Buffer Cache Read
      • Links about Direct path reads and Smart Scan in Ex...
      • Wait Events in Oracle Database
      • How To Force Direct Path Read for SQL Statements (...
    • ►  May (6)
    • ►  April (2)
    • ►  March (1)
    • ►  January (11)
  • ►  2019 (13)
    • ►  December (2)
    • ►  October (1)
    • ►  September (2)
    • ►  July (1)
    • ►  May (4)
    • ►  April (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (44)
    • ►  December (1)
    • ►  November (2)
    • ►  October (3)
    • ►  September (1)
    • ►  July (3)
    • ►  June (12)
    • ►  May (18)
    • ►  January (4)
  • ►  2017 (9)
    • ►  September (3)
    • ►  April (2)
    • ►  March (3)
    • ►  January (1)
  • ►  2016 (5)
    • ►  December (2)
    • ►  November (3)
by Mehman Jafarov. Picture Window theme. Theme images by Ollustrator. Powered by Blogger.