Only two things are really certain: network latency over long distances, and the fact that humanity will soon rapidly degenerate into undead brain-eaters.
When that day comes, when the dead are crowding at your door and the windows are busted out and ripped up rotted arms are clawing at the inside of your home, I know what you’ll be thinking: is my database protected?
Don’t worry, my friends. The Oracle Alchemist has you covered. We (more...)
VirtualBox 4.3.18 has been released. The downloads and changelog are in the usual places.
It’s a maintenance release, so mostly bug fixes and the odd little addition.
was first posted on October 12, 2014 at 2:00 pm.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then (more...)
The day before I left for OpenWorld 2014 I wrote a post called “Chaning my focus?” where talked about the possibility of dropping out of the forum scene and focusing more on writing. It’s now nearly 3 weeks later, so I thought I would follow it up to let people know what is going on…
Pretty soon after I left for OOW14 I locked the forums on my site. I had a touch of (more...)
So in a slight reversal of submit so many presentation abstracts get rejected so many times the Rocky Mountain training days 2015 will be featuring me! Wow pumped yikes this should be a ton of fun!
Ok to be totally honest Maria Colgan is keynoting not me ( shocking news still trying to get over it ).Rocky Mountain training days 2015
Looks like a top batch of speakers and topics ... I only have (more...)
As database gurus and fanatics of the world, as well as hotels and cabbies of San Francisco know, one of the largest enterprise software events, Oracle OpenWorld 2014 was held in San Francisco from September 28th, 2014 to October 2nd, 2014. The reason the later group know a tad bit about the event is because […]
The post Overview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.
What’s new ? Oracle 12c introduces a major update called Adaptive Query Optimization which is based on : Adaptive execution plans Adaptive Statistics These two functionnalities are used to improve execution plans by using dynamic statistics gathered during the first part of the SQL execution. This allow to create more efficient plans that those using [...]
The post OCP 12C – SQL Tuning appeared first on Oracle DBA Scripts and Articles (Montreal).
More and more people have been asking me how Delphix compares with Oracle EM 12c Cloud Control with Snap Clone.
Delphix compliments Oracle. Oracle and Delphix are partners. Delphix is an Oracle Gold ISV partner and we collaborated at Oracle Open World on hosting hands on Delphix labs.
Delphix ads value to Oracle by enabling Oracle customers to more efficiently and easily make copies of there databases. Databases are typically copied from a production (more...)
Last week I attended Oracle OpenWorld 2014, and it was an outstanding event filled with great people, awesome sessions, and a few outstanding notable experiences.
Personally I thought the messaging behind the conference itself wasn’t as amazing and upbeat as OpenWorld 2013, but that’s almost to be expected. Last year there was a ton of buzz around the introduction of Oracle 12c, Big Data was a buzzword that people were totally excited (more...)
Before I start, I wonder if anybody can help me. Some time ago, I saw several adverts on the Internet similar to the one below:
I am looking for an Oracle DBA (French speaking) - Hampshire (South Coast of England)
Languages: ENGLISH and FRENCH
We are recruiting for a major blue chip company based in the South of English (Hampshire area), where we seek a proven Oracle Database Administrator (HPUX, Linux, and AIX) who can (more...)
This is yet another one of these posts that hopefully help you as much as they are going to help me in the future. Recently I enjoyed troubleshooting a problem related to parallel execution. Since I have never really written down how to tackle such a problem I thought it might be nice to do that now.
This is 22.214.171.124.0 on Exadata, but the platform doesn’t really matter for the troubleshooting (more...)
Hadoop is an open-source software framework for storage and large-scale processing of data-sets on clusters of commodity hardware. How to deliver log to Hadoop HDFS. Apache Flume is open source to integrate with HDFS, HBASE and it's a good choice to implement for log data real-time collection from front end or log data system. Apache Flume
is a distributed, reliable, and available service for efficiently collecting, aggregating, and moving large amounts of log data.It uses (more...)
One of my blog readers asked me to write a sample EMCLI codes to create named credentials for Database. To be able to create a named credential, you need to know the target name (unless you create a global credential), target type and credential type associated with the target type. Let’s say I want to create a named credential for my database named “TESTDB”. First I need to login to our EM12c server, and list (more...)
Sometimes, a few pictures (or in this case index block dumps) is better than a whole bunch of words :) In my previous post, I introduced the new Advanced Index Compression feature, whereby Oracle automatically determines how to best compress an index. I showed a simple example of an indexed column that had sections of index entries that were […]
11 Ways To Get Your Conference Abstract Accepted
|This is what happens when your abstract is selected!|
Ready for some fun!? It's that time of year again and the competition will be intense. The "call for abstracts" for a number of Oracle Database conferences are about to close.The focus of this posting is how you can get a conference abstract accepted.
As a mentor, Track Manager and active conference speaker I've been helping DBAs (more...)
Two most popular causes for log file sync waits are redo filesystem I/O and CPU (or CPU scheduling). I’d like to share an example of a third scenario.
A few days ago, I noticed a weird spike in log file sync average duration on a production 11.2 database:
round(time_delta/1e3/nullif(waits_delta,0), 1) avg_wait_ms,
e.total_waits - lag(e.total_waits) over (partition by e.event_name (more...)
BBED (Block Browser Editor) is a tool for Oracle internal use, and it helps you to read and manipulate data at the Oracle Database block level. No need to say that it’s very powerful and also extremely dangerous because you can corrupt data/header blocks. There’s an unofficial but very comprehensive manual for BBED. It’s written by Graham Thornton. You can download it as PDF: http://orafaq.com/papers/dissassembling_the_data_block.pdf
Before Oracle 11g, BBED object code is shipped (more...)
You can always download latest version here: http://github.com/xtender/xt_scripts/blob/master/dynamic_sampling_used_for.sql
Current source code:
col owner for a30;
col tab_name for a30;
col top_sql_id for a13;
col temporary for a9;
col last_analyzed for a30;
col partitioned for a11;
col nested for a6;
col IOT_TYPE for a15;
with tabs as (
to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,1)) owner
,to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,2)) tab_name
,max(sql_id) keep(dense_rank first order by elapsed_time desc) top_sql_id
from v$sqlarea a
An interesting issue presented itself just recently with a logical standby database I manage. The database is used for generating reports and the client wanted to skip all DML activity for a given schema as it wasn’t necessary for reporting purposes. I had done this in version 10.2.0.x; it was a simple procedure on a low-traffic database:
alter database stop logical standby apply;
alter database start logical standby apply;