Playing with Oracle Cloud – Creating a Hybrid DR Deployment

On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high

Oracle to Postgres — Index Skip Scan

I have been working on Oracle to Postgres migration and it has been a fun ride.

One of the recent encounters during migration was performance issue in Postgres for a query, actually quite a simple query.

SELECT count(*) AS num_incidents FROM audit_cs acs INNER JOIN audit_changes ac ON acs.audit_change_id = ac.audit_change_set WHERE acs.object_id=$1 AND ac.path = 'Flag' AND ac.new_value = 'sign' 

Let’s look at the execution plan in Postgres

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 (more...)

Oracle and More…

It has been over a year I wrote my last blog post. I would admit I was being lazy to write, but the good part is not anymore !!

I plan to take out some time and write at least 2 blogs every month and share my learning with the community and to learn from the community.

With the current pace of change in technology, it very important to keep up with it, though sometimes it (more...)

Speaking At DOAG 2018 Exa & Middleware Days In Frankfurt

I will be speaking at the DOAG 2018 Exa & Middleware Days in Frankfurt on June 18th and 19th. My talk will be "Exadata & InMemory Real World Performance" where I discuss the different performance improvements you can expect from the super fast scans delivered by those technologies depending on the actual work profile of the SQL and data used.

Hope to see you there!

ORDS, SQL Developer and SQLcl Version 18.1 Released : Plus Some ORDS Documentation Comments

If you’re active in the Twitter-verse you will have seen a bunch of tweets yesterday about the release of the 18.1.x versions of Oracle REST Data Services (ORDS), SQL Developer (and Data Modeler) and SQLcl.

The first thing I did was edit my ORDS Docker build to use the latest versions of ORDS, SQLcl, Tomcat9 and Java9. If you are interested in playing with that you can find the build on (more...)

SQL Monitor

I’ve mentioned the SQL Monitor report from time to time as a very useful way of reviewing execution plans – the feature is automatically enabled by parallel execution and by queries that are expected to take more than a few seconds to complete, and the inherent overheads of monitoring are less than the impact of enabling the rowsource execution statistics that allow you to use the ‘allstats’ format of dbms_xplan.display_cursor() to get detailed execution (more...)

Oracle Code : India – Hyderabad to Bengaluru

I mentioned in the previous post I ducked out of the evening dinner as I needed to get some sleep. I had very little up to this point, and having to get up at 03:00 to get a flight suddenly seemed like a very bad idea. ????

I got some really nice food from the hotel and went to bed. In typical Tim style I was so nervous about not waking up in time for the (more...)

Oracle Code : Hyderabad – 2018

Today was Oracle Code : Hyderabad.

I woke up in a bit of a daze, so rather than jumping straight into the fray I worked through my demos again just to settle my nerves. ????

I headed down for my session to find there was no lectern and they wanted to run my presentation from the audio desk. I said that wasn’t going to work as I had live demos, so they guys went off to (more...)

Question: Anything Wrong With Query Performance? (Straight To You)

I have a query that runs pretty darn efficiently, here’s the setup: So the query basically returns 100 rows based on the CODE column and it does so using an index on CODE. The CBO has got the costings for this just about spot on. For 100 rows returned, it does so with just 105 […]

Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup

The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database

Lady Coders Conference, Denver 2017

This weekend I’m not going to have to say, “No, this is not my husband’s code” for a change.

This weekend will be about supporting everyone in technology and how technology will benefit by making everyone part of tech.

This event is the brain child of my peer, Elaine Marino, owner of Equili.  Equili’s mission is to “To build a stronger, more diverse tech community that levels the playing field for all underrepresented and underutilized (more...)

Whitepaper Announcement: Migrating Oracle Database Workloads to Oracle Linux on AWS

This is just a quick blog entry to share a good paper on migrating Oracle Database workloads to Amazon Web Services EC2 instances running Oracle Linux.

Please click the following link for a copy of the paper:  Click Here.

 

Adventures in AWS land

I admit it…I’m a BTOARCFODBA. I learned computers on BASIC, COBOL, and  a wee bit of Pascal. Add in a smattering of DCL (Digital Control Language) and SQL.

Along the way (c. 1996), I entered the world of Oracle (7.0 to be exact) and became an Oracle DBA. Eventually specializing in diagnosis and optimization. While I have a accomplished a great deal in my career, I feel somewhat stagnated…time to explore new technology.

Amazon (more...)

Playing with Oracle Database Cloud Backup Service

This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances

A look into oracle redo, part 9: commit

The previous blogpost talked about a simple insert, this blogpost investigates what happens when the DML is committed. Of course this is done with regular commit settings, which means means they are not touched, which means commit_logging is set to immediate and commit_wait is set to wait as far as I know. The documentation says there is no default value, and the settings are empty in all parameter views. In my humble opinion, if you (more...)

Oracle Code : India – The Journey Begins

If you’ve been following my tweets recently you will know I’ve had a bit of a nightmare lead up to these events. Problems with my laptop and problems with my seat on one of the planes.

About 15 minutes before the taxi was due to pick me up I finally got most of the laptop things sorted. It was a bad morning…

I got to the airport in plenty of time and went to the (more...)

Cross workspace reporting in log analytics



We had some consultants in last week talking about many different Azure topics - one of the things i mentioned was that it was really annoying that there seemed to be no way to report across multiple log analytics workspaces from a single point - take the example that i have some data in one workspace that also has some related data in a dashboard i want to built in a completely different workspace - (more...)

DOAG conference 2018 Call for Paper is open

Call for Paper is open. (Take a look on the timetable.)

For Engineered Systems please use the „Infrastructure“ Stream.

We had a wide range of topics :-)

https://2018.doag.org/en/speakers/

 

TO_DOG_YEAR

Some members of the Oracle community got well and truly into the April Fools Day spirit this year.

There were plenty of very earnest looking blog posts about a new 18c function – “TO_DOG_YEAR”.  You can read their posts here

http://www.oralytics.com/2018/04/predicting-ibs-in-dogs-using-oracle-18c.html 
https://blog.dbi-services.com/after-iot-iop-makes-its-way-to-the-database/
http://berxblog.blogspot.ie/2018/04/more-fun-with-ages.html
http://vanpupi.stepi.net/2018/04/01/exploring-18c-exadata-functions/

They even enlisted the help of the team here at AskTOM where they posed a question looking for more (more...)

Oracle Tidbits – March 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in March 2018. You will also see these tidbits on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has …