Skip navigation.


Oracle Rules Manager by example

shouvikb's picture

Simple introduction to Oracle Database 11g Rules Manager using good old EMP table.

This Article introduces Oracle Rules Manager in a series of simple examples with imaginary cases on the EMP table. This article is an overview of the possibilities of Oracle Rule Manager for a traditional Oracle Architect who has never thought of a Rule based approach. It will also be informative to communities working actively with other Rule Engines, who never considered the Oracle Rule Manager.

Blue Core Research's "NO BULL" buyers guide to Database Auditing products - Part 14: Oracle and MS SQL Server

Most companies have more than one database vendor. Oracle, SQL Server, DB2, MySQL and Sybase are all common depending on the company, and some use less common databases such as TeraData. There are, however, some important questions to ask before you dive into your cross platform heterogeneous requirements:

* Which databases do you actually need to audit? Is all your SOX, PCI, HIPAA or other sensitive data scattered across all these databases, or is your SQL Server just used for small home-grown apps that do not have any auditing requirements?

* Do you have the same DBA or team managing all these databases, or are they different teams that will end up managing auditing solutions independently? In the later case you are better off choosing the best solution for each database rather than mandating a single solution no one is too happy with.

Oracle Licensing: Part 1 License Metric

Information about Oracle licensing is not abundantly available. Most of us might not be familiar with Oracle licensing. This article provides information about Oracle Licensing Rules and Definitions. This is Part 1 – License Metric (Oracle Technology). Please look at the disclaimer and agree before reading.

You can choose between a license based on a ‘User’ or based on server-specifications which is ’Processor’. A user-based license is called Named User Plus. So, two common license metrics are Named User Plus and Processor. I will explain a little more about the definitions.

BlueCoreResearch gives a DAM

Database Activity Monitoring (DAM) is a new emerging and challenging market bordering both databases and security. The biggest problem in this market is the lack of tools able to provide what is so obviously needed. Blue Core Research aims to fill this gap and provide the products and technologies that can adequately audit your databases.

Compliance is about mitigating risks. Some of the risks you are likely to have in your organization are:

* DBAs – DBAs have unlimited access to the database and as a result they can see and change anything.

Exploring BI Publisher 11g : A simple report with DataModel Editor

If you have installed OBIEE 11g successfully, lets try to explore some of the new features and tools available with BI Publisher 11g.

Unlike 10g, where Report is a single entity and data sets are the part of Report definition, in 11g, Data Sets (which termed as Data Model in 11g) and Report definition are two separate entities.

Data Model, which drive/extract the xml data for report is the advance version of Data Template, So there is no Data Template in 11g, its all Data Model with a very nice Data Model editor to design simple to complex Data model. This support some new data source like, BC4J View Objects and EXCEL, which were not supported in earlier releases as data source.

Report definition includes the Data Model reference, Layout template and other report specific metadata required to render or generate the Report output.

For these many years, we are using RTF templates as main Layout Template, now there is new format available with 11g, it is xpt format, which looks like Oracle’s proprietary format. As claimed, it generates almost pixel perfect output and could be a good substitute for PDF Forms. A nice Report Designer is available to design these xpt reports.

As I mentioned earlier, the complete report consist of two main objects, Data Model and Report definition. Data Model should exist, before we start Report definition.

Before design the data model, make sure the required jdbc connection is setup through BI Publisher Administration UI. To access JDBC data source UI, click the Administration from the Top bar and select the Manage BI Publisher Administration from the Common Administration Page.
Read more..

Tuning Goldilocks SQL

Tuning Goldilocks SQL

... then Goldilocks went into the bears' Data Centre and there were 3 Oracle databases. The first was a Data Warehouse. Goldilocks checked the AWR, but all the SQLs were to-o-o-o-o-o-o-o big; they all used full scans, hash joins, bitmap-index combining, partition pruning and parallelism and couldn't be tuned any more. So Goldilocks went to the second Oracle database. It was an OLTP system with hundreds of concurrent users. Goldilocks fired up SQL Tuning Advisor, but all the SQLs were to-o-o-o-o-o-o-o small; they used unique index scans and cluster-joins and couldn't be tuned any more. So Goldilocks went to the third Oracle database. It was an Operational Data Store with a rolling 3 month retention. Goldilocks found SQLs that were joining a million rows with Nested Loops joins, buffer cache hit ratios of 50%, and under-utilised disk. She smiled, opened up Tom Kyte's Expert Oracle eBook on her second monitor and got to work. This database was ju-u-u-u-u-u-u-u-st right ...

It is seen that Windowsx64 Edition Operating System has following two directories:-

It is seen that Windowsx64 Edition Operating System has following two directories:-
1. Program Files
2. Program Files(x86)
Windows XP Professional x64 Edition redirects the \Program Files directory for all programs that are 32-bit during the installation to the \Program Files(x86) directory. Programs that are 64-bit compatible are installed into the \Program Files directory.
The \Windows\SysWOW64 directory is where 32-bit system files are installed.

Word-Based Password Generator

During my experiences with different environments, I have been tasked with maintaining passwords for different information systems. This includes operating system accounts (root, oracle, administrator) and Database accounts (sys, system, dbsnmp).

It can be sometimes difficult to remember many different passwords. I have seen some people overcome this by documenting the passwords, sometimes just in a plaintext file, sometimes encrypted, sometimes just on a ‘Post-It’ Note under the keyboard.

I try and retain the passwords in memory.

Hints on OCA/OCP exam technique

Part of my job is teaching for Oracle University, and I'm often asked about OCP exam technique. Here are a few hints. The OCM exam is very different, and the confidentiality rules forbid me from discussing it, so please don't ask.

Using Regular Expressions in Oracle

Everyday most of us deal with multiple string functions in Sql. May it be for truncating a string, searching for a substring or locating the presence of special characters.

The regexp functions available in Oracle 10g can help us achieve the above tasks in a simpler and faster way.