Oracle Database

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

After providing a baseline for Parallel Execution working as expected in the introduction of this series, in this part I’ll demonstrate how things can go wrong with the work distribution. A Simple Example Of Parallel Execution Skew One common source of Parallel Execution Skew is a skewed foreign key, which means that the value distribution of the foreign key column… Continue Reading →

10g, 11g, 12c, All Things Oracle Full Articles, Oracle Database, Performance Tuning, Troubleshooting

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

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, 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

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

OakTable World

All Things Oracle on 05 September 2013 with 0 comments

The secret conference-within-a-conference formerly known as Oracle ClosedWorld, which used to be held at the same time as Oracle OpenWorld has outgrown its roots and is now an open conference rebranded as OakTable World. This is your exclusive invitation to mind-meld with the illustrious members of the OakTable Network while enjoying the free-flowing hospitality of the generous sponsors. You don’t… Continue Reading →

Database Administration, Database Development, Oracle Database

Admit that your own private Mount Everest exists. That is half the battle. – Hugh Macleod Other options In the example we used pretty much the minimum number of parameters to make it work. There are more parameters and options available. For example UPDATE_CHECK. This does pretty much the same as WITH UPDATE CHECK in views. If you insert or… Continue Reading →

10g, 11g, 12c, 8i, 9i, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL