Skip to content

Hatem Mahmoud's blog

Just another blog : Databases, Linux and other stuffs

  • Home
  • About
Home2019February

Month: February 2019

Statement Quarantine : Another way

February 19, 2019 Mahmoud Hatem Uncategorized

Oracle 19c is finally out with some great features but sadly many of them are not available in Oracle Enterprise Edition

Capture 01

I started by looking at the SQL Quarantine feature in my last blog post and as stated it will not work if you are on Oracle EE. So what’s the next step ?

Continue reading →

Leave a comment

Oracle 19c : The QUARANTINE hint

February 15, 2019 Mahmoud Hatem Uncategorized

Here is some interesting stuffs that i discovered when playing around with one the new 19c feature known as SQL Quarantine.  Beside controlling  it the usual way such as using DBMS_SQLQ as explained in the documentation we can also use a special undocumented quarantine HINT.

Continue reading →

4 Comments

Oracle kernel function : Extracting info

February 12, 2019 Mahmoud Hatem troubleshoting

What this core oracle function is about ? Here is a little script that we can use to extract further information about a specific oracle kernel function which might help us in that process (Beside the usual way , another tool in your toolbox 🙂 ).

Continue reading →

Leave a comment

Public Talks

POUG17 : Memory-access-tracing
POUG18 : The power of linux advanced tracer
POUG19 : Oracle events hunting

That’s Me

View Mahmoud Hatem's profile on LinkedIn

Follow @Hatem__Mahmoud

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Disclaimer

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle Corporation.

Recent Posts

  • Auto-assignments of Jira issues using ML/Deep learning
  • Great books that helped me boost my knowledge and skills
  • KISS principle : SQL patches to the rescue
  • The story of optimizer_features_enable downgrade and high cursor version count
  • How setting cursor_sharing= force can break you application !

Archives

  • March 2022 (1)
  • October 2021 (7)
  • September 2021 (3)
  • August 2021 (2)
  • February 2021 (1)
  • December 2020 (2)
  • November 2020 (4)
  • October 2020 (5)
  • September 2020 (5)
  • June 2020 (1)
  • April 2020 (2)
  • February 2020 (1)
  • January 2020 (2)
  • December 2019 (2)
  • October 2019 (2)
  • September 2019 (1)
  • April 2019 (1)
  • March 2019 (5)
  • February 2019 (3)
  • November 2018 (3)
  • October 2018 (6)
  • September 2018 (1)
  • June 2018 (2)
  • March 2018 (2)
  • February 2018 (1)
  • January 2018 (1)
  • November 2017 (5)
  • October 2017 (3)
  • September 2017 (3)
  • May 2017 (1)
  • April 2017 (5)
  • March 2017 (5)
  • February 2017 (1)
  • December 2016 (3)
  • November 2016 (3)
  • October 2016 (5)
  • September 2016 (2)
  • August 2016 (3)
  • July 2016 (1)
  • June 2016 (1)
  • April 2016 (2)
  • March 2016 (2)
  • February 2016 (5)
  • January 2016 (4)
  • December 2015 (3)
  • November 2015 (5)
  • October 2015 (4)
  • September 2015 (2)
  • July 2015 (1)
  • June 2015 (1)
  • May 2015 (2)
  • April 2015 (5)
  • March 2015 (2)
  • February 2015 (2)
  • January 2015 (2)
  • December 2014 (3)
  • November 2014 (3)
  • October 2014 (1)
Blog at WordPress.com.
  • Follow Following
    • Hatem Mahmoud's blog
    • Join 122 other followers
    • Already have a WordPress.com account? Log in now.
    • Hatem Mahmoud's blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...