Database Development

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

Part 1, Part 2. A wise man* once said: So no-one told you life was gonna be this way. Your job’s a joke, you’re broke, your love life’s DOA. It’s like you’re always stuck in second gear. And when it hasn’t been your day, you week, your month, or even your year. [*That wise man wasn’t me; but stick with… Continue Reading →

All Things Oracle Full Articles, Database Development

Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we looked at the result cache for PL/SQL Code We can also use this same technique when our function depends on tables (or views). Let’s create a simple table, add some data and a simple, slow function: CREATE OR REPLACE FUNCTION… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things faster. Sure you can use more CPU power or more memory in the database server, but there’s a limit to that approach. Be it the amount of money being spent, the limits of the [current] CPU power or other limits…. Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

A wise man* once said, no one’s ever learned how to cook just by reading recipes. And so, since we painted in the background in Part 1, we are now going to roll up our sleeves and dive in. By the end of this article you will be reading and writing SQL, the lingua franca of databases. [* that wise… Continue Reading →

All Things Oracle Full Articles, Database Development

A wise man* once said, an expert is someone who uses big words and acronyms where simple phrases would do just as nicely. So stand back and listen to this: Database, Relational Database, DBMS, RDBMS, SQL, Sub-queries, normalisation. [* that wise man was me.] So now that I’ve established my credentials by bamboozling you with arcane words and capital letters,… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database

Error Handling

Jan Leers on 06 December 2013 with 3 comments

Most programmers don’t like exceptions, but you should consider them as your closest friends. They are the ones that honestly say what is wrong with your program. We cannot foresee all possible problematic events, and even the best programmers write bugs. Exceptions There are three kinds of exceptions Internally defined: A system error, defined by Oracle, that occurs. Predefined: The… Continue Reading →

All Things Oracle Full Articles, Database Development, PL/SQL, Troubleshooting

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