Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

March 2016

GNW01: In-Memory Processing for Databases

Submitted by tanelpoder on Mon, 2016-03-28 05:39

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:

I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

GNW01: In-Memory Processing for Databases

Submitted by tanelpoder on Mon, 2016-03-28 05:39

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:
RAM is the new disk – Introduction RAM is the new disk – tools for measuring CPU efficiency and RAM access RAM is the new disk – Columnar vs Row-oriented data access test results I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

GNW01: In-Memory Processing for Databases

Submitted by tanelpoder on Mon, 2016-03-28 05:39

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:
RAM is the new disk – Introduction RAM is the new disk – tools for measuring CPU efficiency and RAM access RAM is the new disk – Columnar vs Row-oriented data access test results I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

GNW01: In-Memory Processing for Databases

Submitted by tanelpoder on Mon, 2016-03-28 05:39

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:
RAM is the new disk – Introduction RAM is the new disk – tools for measuring CPU efficiency and RAM access RAM is the new disk – Columnar vs Row-oriented data access test results I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

GNW01: In-Memory Processing for Databases

Submitted by tanelpoder on Mon, 2016-03-28 05:39

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:
RAM is the new disk – Introduction RAM is the new disk – tools for measuring CPU efficiency and RAM access RAM is the new disk – Columnar vs Row-oriented data access test results I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

#Oracle University Expert Summit Berlin 2016

Submitted by Uwe Hesse on Sun, 2016-03-27 11:20

Join us in Berlin, 18th – 20th April. The event will take place at the Adlon Hotel with Jonathan Lewis, Pete Finnigan, Christian Antognini, Javier de la Torre Medina and myself as speakers. We have over 70 enrollments already, so take action to secure your seat in time!

Expert Summit Berlin 2016

WebLogic Stuff

Submitted by oraclebase on Sat, 2016-03-26 09:11

glasses-272399_1280-smallI’ve written a bunch of stuff about WebLogic over the last few years, but it’s kind-of scattered throughout the site. When I was gearing up for my session at the Middleware SIG recently I figured it was about time I collected it all together, so I added a new WebLogic page to the site. It’s on the menu and the quick links.

Much the same as the SQL and PL/SQL pages, it really is just a bunch of links to other stuff. I tend to put my articles in version-specific locations, because it suits me, but I realise it’s not ideal for everyone. I think this gives me the best of both worlds.

Are your SQL Plus scripts going to ‘ell ?

Submitted by connor_mc_d on Sat, 2016-03-26 08:58

Excuse the hideous pun in the title.  All will become clear shortly.

Often we use SQL Plus to run scripts on a scheduled basis in our database.  The “problem” is, they need to connect to that database.

Here’s a simple script I want to run:

image

and here’s my very sophisticated Smile batch file (which could just as easily be a Unix shell script) to run it:

Push the oracle alert.log and listener.log into Elasticsearch and analyze/visualize their content with Kibana

Submitted by Bertrand Drouvot on Sat, 2016-03-26 08:09

Introduction

The oracle alert.log and listener.log contain useful information to provide answer to questions like:

  • When did the Instance start?
  • When has the Instance been shutdown?
  • When did ORA- occur? With which code?
  • Which IP client did connect to the Instance? With which user?
  • How did it connect? Through a service? Through the SID?
  • Which program has been used to connect?
  • A connection storm occurred, what is the source of it?

What about having all this information centralized? What about having the possibility to gather, format, search, analyze and visualize this information in real time?

To achieve this, let’s use the ELK stack:

Up to date text indexes

Submitted by connor_mc_d on Sat, 2016-03-26 08:06

If you really need your text indexes to be “super dooper” up to date, that is, always in sync with your data, you can set the SYNC level to be ON COMMIT.  For example,