Managing unstructured data in a relational database system is one of the least know subjects. There is a large amount of unstructured data in the real world and a relational database designed to store data in a structured format but most database administrators and architectures do not have enough knowledge (more...)
This release also has an offline configuration Tool that will work with Virtualized and Non Virtualized ODA Configurations. This provides a lot of (more...)
As you know when we create Data Guard Configuration, we must copy password file. Because SYS user is default redo transport user on Data Guard configurations.
SYS password is changed on primary
When we change SYS password on primary database, redo transport service is stopping and we are (more...)
Here is a quick way of creating your own CA and issue server and client certificates via OpenSSL.
I will test the certificates via the Apache HTTP Server by configuring one and two-way SSL.
I use Oracle Linux 5.
You should of cause only use this for test scenarios.
Author, she is CTO and co-founder of Piction, an Oracle PL/SQL based app that allows for the delivery of Images on the internet. Marcelle (more...)
Live, Learn and Share is the signature from a friend that I used to work with – Chau Vu
Today, I learned something new because I was shared something by a colleague – Jing Han
If you know part of filename for what you are looking for but don’t know (more...)
My next Embarcadero sponsored webinar will be on May 14 and is entitled Using Optimizer Hints for Oracle Performance Tuning.
Hints are excellent database performance tuning tools that direct the Oracle optimizer to utilize specific operations in SQL execution plans. We often use hints because the Oracle optimizer (more...)
When there's a major change in the performance of your database the culprit can usually be found by looking at any changes made around the time that performance degraded, but what if nothing has changed? What do you do then? There are lots of options, but only one that will (more...)
A while ago I was doing some bandwith and latency testing of infiniband interfaces on different Exadata configurations and ran into something that might be interesting for Exadata V2 owners out there. You can do some performance test on your IB stack using a set of tools that start with (more...)
Before, I worked for organization that frowned upon database jobs and only uses cron job.
Now, it’s just the opposite and I get to learn about dbms_scheduler job.
Create job to run PLSQL_BLOCK every 5 minutes at: 21,22,23 (24 hour format)
SYSDATE ------------------- 2013-05-04 12:29:55 LAX:(MDINH@db01)> begin 2 (more...)
I’m about to make a serious move into online webinars, and as a warm-up exercise I’ll be doing a couple of one-hour free events on Friday 17th May.
I’ll be talking through a Powerpoint presentation called “Smarter Statistics in 11g” twice, once at 2:00 pm BST, and again at 6:00 (more...)
When an Oracle process starts executing a query and needs to do a full segment scan, it needs to make a decision if it’s going to use ‘blockmode’, which is the normal way of working on non-Exadata Oracle databases, where blocks are read from disk and processed by the Oracle (more...)
Blue Medora has created several Cloud Control extensions (plugins) and asked me to blog as a guest on their site. I've decided to challenge some (more...)