Subscribe to Posts by Email

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

18c Database: Shadow Lost write protection

From 18c Onwards, we can enable Lost write protection for data blocks which occurs when an I/O subsystem acknowledges the completion of the block write even though the write did not occur or when a former image of the block overwrites the current image.

We can enable the Shadow Lost Write protection at Database, Tablespace, […]

12C – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup

Thanks to my Colleague Jaipal to introduce me to this Metalink Note: Doc ID 2005729.1

In a 12c and higher environment, to migrate data between systems that have different endian formats, with the least amount of application down time.

The first step is to copy a full back up from the source to the destination. […]

Oracle Autonomous Datawarehouse : Loading Data from Oracle Objects Stores or AWS S3

Oracle Autonomous Datawarehouse offers loading the data from object stores like Oracle Object Store and AWS S3 or Azure Blob Store.

For this, a new package has been introduced called DBMS_CLOUD and you can load/unload the data and also manage the files with the package. This facilitates easy management of objects in the objects store […]

OOW#18 – Kafka with Oracle Database

Yes, Oracle always strive to integrate latest trends in the industry to its Database. Now the new one is Kafka integration with Oracle Database through DBMS_KAFKA package. Where you can publish events and consume or load data into tables.

This feature has been discussed in CodeOne 2018 by Melli Annamalai, Senior Principal Product Manager at […]

OOW#18 – Updates – 19c Automatic Indexing

Really???. Straight from the OOW#18 updates in Twitter, LinkedIn, various posts.

Here is the snippet I got it from twitter from Franck Pachot & Maria Colgan posts.

This is how it may/will works :). Runs as background task at Fixed and Limited time. “Do not impact your application” ??? True, read below, Follow a predefined […]

AIOUG – Mumbai – Performance Tuning Tech Day -3-Nov-28 – Full Day Event

Hello All

Are you around Mumbai, India? I am delivering a Full Day Event is planned in Mumbai on 3rd November about Oracle Performance Tuning, Please join with me and session abstracts and registration details can be found in link below.

https://www.meraevents.com/event/aioug-mumbai-performance-tech-day-november-2018

See you there !!!

[…]

Building Datalake in Oracle Cloud

Hello All

My Latest presentation on Building Datalake in Oracle Cloud, covers at least 6 services in oracle cloud and 4 patterns of datalake editions in Oracle Cloud.

Download

Also uploaded videos to my youtube channel which are embedded in the pdf presentations.

[embedyt] https://www.youtube.com/embed?listType=playlist&list=PLR6rN4cTV4BTcDAeqZmFdXMijlBu65kxc&layout=gallery[/embedyt]

-Thanks

Suresh

Datalake in Oracle Cloud – AIOUG & APACOUC Events

Hello All

I am speaking about Datalake in Oracle Cloud in two events as below. I will be covering the fundamentals and building blocks of datalakes and how they differ from datawarehouse, I will also demo the new generation datalake in Oracle Cloud by using BigData, Event HubService & Object store.

Hyderabad – Tech Mahindra […]

APACOUC Webinar 2018 – Presenting SQL Plan Stability & Flexibility Features – Today

APACOUC Webinar 2018 – Wave 2 Sessions In next 2.5 hrs , @apacouc @fcomunoz @DataIntensity , I am presenting SQL Plan Stability & Flexibility Features

Register for free

https://events.genndi.com/register/818182175026319207/528ad96d7a

APACOUC.org – 2018 Webinar Tour – 18c New Features for DBA’s – 27th July

Hi

Join in to my free webinar for APACOUC.org webinar tour tomorrow i.e 27th July and I am presenting 18c New Features for DBA’s.

Timing: July 27th – 12.30PM (IST) , 17.00PM (AEST) Registration link : https://events.genndi.com/register/818182175026319207/2e96be318e

And also next wave of presentations announced, please check here.

http://www.apacouc.org/2017-webinar-tour.html

See you all there.

-Suresh

[…]