Tag: Database

Are you constantly wondering what is in your production environment? Do you have any doubts about what code is running? Chances are that your version control software isn't the problem. No matter what system you're using there is the ideal and there is the practice. This session is one that will help you get on…

Are you constantly wondering what is in your production environment? Do you have any doubts about what code is running? Chances are that your version control software isn't the problem. No matter what system you're using there is the ideal and there is the practice. This session is one that will help you get on…

Are you constantly wondering what is in your production environment? Do you have any doubts about what code is running? Chances are that your version control software isn't the problem. No matter what system you're using there is the ideal and there is the practice. This session is one that will help you get on…

Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…

Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…

Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

Oracle Database 12c introduced two new histograms – Top Frequency and Hybrid – that can dramatically improve the accuracy of cardinality estimates, construction of better execution plans, and speedier access to skewed data sources.  This presentation will offer real-world examples of how best to deploy these features, including actual metrics that illustrate the improvement in…