Skip navigation.

Grumpy old DBA

Syndicate content
Updated: 2 days 18 hours ago

Join Alex Carlos Mauro Scott and speak at the Great Lakes Oracle Conference 2014

Sat, 2014-01-11 08:34
The Great Lakes Oracle Conference is May 12-14 2014 in Cleveland at CSU.  Beautiful campus environment and state of the art student center main ballroom.  Plus well of course the chance to speak at the city where the river caught on fire right ( long story ask me over a beer ). We have 1/2 day workshops on Monday ( Alex Gorbachev / ( Carlos Sierra and Mauro Pagano ) / Scott Spendolini ) and then main conference starts Tuesday with keynotes by Steven Feuerstein and Tom Kyte. Call for Abstracts is open now here: https://www.neooug.org/gloc/presentations.aspx  Please consider joining us at a rapidly growing regional conference that Carol Dacko considers "One of the best choices for any Oracle Professional to attend".   
Categories: DBA Blogs

Four tough choices for workshops at GLOC 2014

Thu, 2014-01-09 12:18
This year at the Great Lakes Oracle Conference ( May 12-14 2014 at CSU ) we are doing 1/2 day workshops monday afternoon.  Then the conference kicks into full speed with keynotes tuesday morning and session tracks after that.

We have an incredible set of people doing workshops for our attendees.  We are working on finalizing a fourth workshop in the Essbase area but not quite ready to announce that on.

We are going to go live this weekend with the ability to register for our latest addition to the workshops.

Alex Gorbachev:
From Relational to Hadoop - Migrating your data pipelineI am very excited to announce this addition!

Will update this post with links when this workshop is online for registration. 
Categories: DBA Blogs

schema validation scripts and alter session set current_schema ... make me not so grumpy

Tue, 2014-01-07 07:14
Believe it or not many DBAs/Developers are unaware of ( well or have forgotten ) how to "switch into" a different schema.

PLSQL has had the option for a long time

alter session set current_schema = SOME_SCHEMA_NAME;

This does not give you full schema owner capabilities ( well depends on what your login session capabilities have ) but can be very useful.  For instance in some kind of script to validate that all the expected objects exist and are at the corrrect version you could use it like this.

set echo off
set feedback on
set heading off
set linesize 168
set serveroutput on size unlimited
set term on

alter session set current_schema = FIRST_SCHEMA_BEING_CHECKED;

BEGIN
  validate_objects.bv_show_valid_messages := TRUE;
  validate_objects.bv_stop_on_error := FALSE;

  dbms_output.put_line(chr(13));
  dbms_output.put_line('===============================================================================');
  dbms_output.put_line(chr(13));
 
  -- a bunch of calls against a validation package ... check that tables exists / views exists / foreign keys exists / indexes exist / packages procedures functions exists / data exists

 
  -- at the end check that all objects are valid in the schema ...  
 
END;
/
Categories: DBA Blogs

12c buffer cache flushing in a CDB / PDB environment

Wed, 2014-01-01 20:42
Here is an interesting post from Thomas Saviors blog aka ( My Oracle Life ).  It shows some complicated things going on flushing the database buffer cache from various CON_IDs within a CDB.

12c buffer cache flushing

Obviously only the people doing design work at Oracle for 12c ( 12.1 and 12.2 heck maybe 13 ) know what the overall plan is for next set of features/changes for a container database.  To me it seems very dangerous to know have a way of isolating one PDBs impact on other PDBs for the memory areas in the SGA ( shared pool / buffer cache etc ).  Maybe this will be changing soon?

There are some interesting CDB presentations going to occur at Hotsos 2014 ( best practices etc ) that I will be attending that may give me a better idea of what other people are worrying about and planning on using in this new CDB/PDB universe.

Thanks to Thomas for pointing out his post!

Categories: DBA Blogs