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

Tuesday, June 2, 2020

SYSAUX links to analyze contents

http://facedba.blogspot.com/2014/09/manage-sysaux-tablespace-in-oracle-11gr2.html
https://community.oracle.com/thread/4329725
https://topic.alibabacloud.com/a/lower-sqlset-related-table-wri_sqlset_plan_lines-high-watermark-free-sysaux-tablespace_8_8_20003853.html
https://jhdba.wordpress.com/2009/05/19/purging-statistics-from-the-sysaux-tablespace/
https://blog.toadworld.com/2017/11/15/sysaux-and-purging-big-objects-segments-manually
How to Purge WRH$_SQL_PLAN Table in AWR Repository, Occupying Large Space in SYSAUX Tablespace. (Doc ID 1478615.1)
High Storage Consumption for LOBs in SYSAUX Tablespace (Doc ID 396502.1)


Posted by Mehman Jafarov at 11:42 AM
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.