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 06: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.

#Oracle University Expert Summit Berlin 2016

Submitted by Uwe Hesse on Sun, 2016-03-27 12: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 10: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 09: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 09: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 09: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,

Interview with PeopleSoft Administrator Podcast

Submitted by davidkurtz on Fri, 2016-03-25 20:00

I recently recorded an interview with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast. It has been spread over three episodes. There is lots of other good stuff on the website and other episodes that are well worth listening to.

(25 March 2016) #21 - Temporary Tables

OTNYathra2016

Submitted by rshamsud on Thu, 2016-03-24 20:25

Over the last many years, some of you have invited me to attend conferences in India, and talk about Oracle RAC and performance. I have not had an opportunity to make it to conferences in India, until now </p /> </p></div> <div class=

India bound !

Submitted by connor_mc_d on Thu, 2016-03-24 07:20

As part of the activities organised by the Oracle Ace Program and the All India Oracle User Group, the OTN Yathra tour is coming up in a few weeks.

OTNYathra2016

I’ll be speaking on 12c developer features and advanced SQL techniques at the following locations:

AWR Warehouse Fails on Upload- No New Snapshots

Submitted by dbakevlar on Wed, 2016-03-23 17:28

This issue can be seen in either EM12c or EM13c AWR Warehouse environments.  It occurs when there is a outage on the AWR Warehouse and/or the source database that is to upload to it.