Posts Categorized: Technical Blog

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if you want to see how the performance changes over time. I’ve been using three really…

MSDB – Cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 Gigs is not considered big for a database. Correct, but for MSDB, it is. So, the…

Step-by-Step Installation of an EBS 12.2 Vision Instance

It’s here! It’s here! It’s finally here! (what, you don’t get excited when you get new toys?) Now that version 12.2 of Oracle Applications has been released, it’s time for eager Apps DBAs and non-DBA EBS geeks to get their hands dirty with new features! This post will walk through the steps required to install…

Getting ready to install EBS 12.2 Vision: Quickstart notes

Getting ready for the next big thing In the wake of last week’s announcement of the general availability of Oracle E-Business Suite Release 12.2, I’ve started spinning up a 12.2 Vision instance, so I can start getting familiar with the product. Learning about the changes has been pretty fun so far, and you’ll be seeing…

Breaking News: Oracle E-Business Suite Release 12.2.2

Oracle E-Business Suite Release 12.2.2 is out! Big times ahead of us folks! My team is planning to blog about it a lot. Stay tuned. This is my prediction: Online patching a game-changer in Oracle E-Business Suite 12.2 Oracle Press Release Steven Chan’s blog You can get it from e-delivery site. Yury PS: If any of you…

Database 12c: What’s New with Data Pump? Lots.

Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.

Database Validation in Data Guard 12c

Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.

Oracle Database 12c: Network Recovery in RMAN

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner’s Guide for Oracle Database 12c. Many of the new 12c features have fascinated me and my peers. I have thirsted in particular for the following handful of rman enhancements that are bundled with Database 12c…

Page 12 of 61« First...1011121314...203040...Last »