Oracle Database General Examples, Tutorials and Articles

AWR basaelines have been available since Oracle 10g; Oracle 11g enhances those baselines with new ways to generate them and new tricks in OEM to use adaptive thresholds to monitor the performance of the database. Starting off let's look at the way generating baselines has changed. The original 10g ...

An interesting question was posed on the Oracle-L list a few weeks back; a member was having difficulty getting a constraint created using an existing non-unique index as Oracle would consistently consume all of the TEMP space and cause the process to terminate for lack of resources. The conventional ...

One of my friend send this article to me time ago, i think that its very helpful for a new user to understand what actually ORACLE database is so i have attached that word file to this post, for beginners believe me it’s very comprehensive and interesting ...

What is Oracle? - An Introduction for beginners

When you discuss Oracle, you have to consider this from two aspects. There is Oracle the company and Oracle Technology.

We will first look at Oracle the company. Oracle the company have come a long way since their appearance ...

It is common question for most of us specially with the newbie is which version I am using. This may be sometime ambiguous about what you mean. Do you indicate oracle version or Sql*plus version or imp version or rman version or etc like that. Here is some way to determine your several version you use ...

Oracle revamps Metalink with Flash

Going about some routine problem today, when I accessed metalink, I was surprised by a pop-up which kept asking me to install Adobe Flash. Seems like Oracle has revamped Metalink with customised Dashboards and lots of eye-candy.

...

Difference between Data Mart and Data warehousing

What is the difference between Data Mart and Data warehousing?

Firstly, Data mart represents the programs, data, software and hardware of a specific department. For example, there is separate data mart for finance, production, ...

OCA, OCP & OCM Exams and Certification

Are you looking for Oracle certification courses?

If you want to excel in IT, career then you needs to get yourself certified so that you can get better job options. Most of the IT companies look for individuals with OCM, OCP ...

Understanding Oracle Database on mobile devices and mobile environments


With the increasing use of mobiles and PDA and applications residing in the mobile systems, database systems on mobile devices are fast becoming a norm. There are applications on these mobile devices which ...