Database Administration

Category

Securing enterprise business-critical data is as important for DBAs as database tuning and data protection. Oracle provides comprehensive and powerful security controls/solutions to ensure data privacy and data security which will help with meeting regulatory compliance. Oracle supports the following security controls: Data Masking Advance Security (TDE, Data Redaction) Label security Virtual Private Database (VPD) Fine Grained Auditing (FGA) Data… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development

A wise man* once said, all software programming is about hoops and loops. You take some variables, give them hoops to jump through and, depending on their success or failure, you give them some actions to loop through a number of times. Might sound basic, but that’s what all software code – from Angry Birds to the space shuttle –… Continue Reading →

All Things Oracle Full Articles, Database Administration, PL/SQL

In part 1 of this series we saw two basic ways of creating, or acquiring, execution plans. The first method gave us the optimizer’s prediction of what it would (possibly) do if you ran the query: explain plan for {sql statement} select * from table(dbms_xplan.display); The second method told us what the optimizer had done after we ran the query…. Continue Reading →

All Things Oracle Full Articles, Database Administration

If you have to tackle performance problems in an Oracle database one of the most important skills you need to acquire is the ability to interpret execution plans, and in this series of articles I’ll be telling you how to do just that. We’ll start with a couple of articles that look at some of the ways we can access… Continue Reading →

All Things Oracle Full Articles, Database Administration, PL/SQL

When Oracle initially introduced the standby database concepts, the solo intention was to deliver the solutions to protect enterprise critical business data from any sort of natural and unnatural disasters. Since its innovation, Oracle has incorporated huge amount of new functionality/features and made several enhancements to ensure the standby database deliver and meet various user demands. This article is not… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration

Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements. At the beginning of architecting a new high available Oracle database system it’s important to understand the need to make design and infrastructure decisions in the context of meeting Service Level Agreements (SLA). The SLA targets can be usually achieved… Continue Reading →

Database Administration, Oracle Database

By now, many of us have downloaded, installed and either played with or implemented the latest release of the Oracle Database.  If you haven’t downloaded the latest release, I would recommend that you do so and see what it has in store for not only your organization but also the industry as a whole.  Oracle Database 12c is going to… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

In part 2 we looked at the way that Oracle collects and uses height –balanced histograms, and raised the problem of how sensitive they could be to small changes in the sampling, or in the data. We ended the article with a suggestion on how you could generate data for an “approximate” frequency histogram  that could be “good enough” to… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, Performance Tuning, Troubleshooting

In part 1 of this series we discussed the reasons why we might want to create some histograms to help the optimizer deal with skewed data distribution. We used an example of a simple status column in an orders table to demonstrate principles, talked about frequency histograms in particular, and highlighted a couple of problems associated with histograms. In part… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, Performance Tuning, Troubleshooting

Join Kyle Hailey (Oracle ACE, OakTable) from Delphix and James Murtagh from Red Gate on Monday Sept. 22nd for a DevOps round table discussion. The session will revolve around: setting up and maintaining development environments; replicating production conditions; and the challenges of managing, sharing, and deploying changes. Further talking points will include: spinning up virtual databases quickly and cheaply; and managing team… Continue Reading →

Application Development, Database Administration, Database Development