I received an email from a team member yesterday
Have you seen this? https://docs.oracle.com/database/121/TDPPT/tdppt_awr_warehouse.htm
Interesting idea – ever thought of implementing it?
Well of course I have implemented a AWR data repository and I thought I would catch-up on where I am with it and how it is being used.
The database started out on HPUX on 184.108.40.206 about 2 years ago and is now on Linux on 11. (more...)
So it was really day 2 of the conference, but it was day 1 for me, so that’s the way I’m naming it… There were seven tracks available, but I’ll be speaking about what I saw…
First up was the keynote by Tim Ebbeck called 10 Rules of Transformational Leadership. I’m not the biggest fan of keynotes, but this one was pretty cool. To summarise:
- Nothing beats being as good as you can be. Get (more...)
Recently i came cross a use case where i need to add a new column into a table which being already used in production and we need to support this new changes on both version of table schema.
However gradually we will get ride of old version of table. but for now we need to support both schema.
In my case it's only related to fetch operation ,so here i am going to (more...)
Jobs To Be Done. Or #JTBD. We’ve been road testing this framework lately. I like it. Could it be a good fit for the busy cloud developer who wants to build a usable solution that solves a real problem and doesn’t want to deal with the generalizations of personas or overhead of user profiles (a debate in itself)?
Seems like a good fit for the agile world too. Pictured is Julian Orr (left) (more...)
With the Oracle BPM Suite your process data consists of project or process variables. Whenever the variable is based on a component, that component is either defined by some external composite (like a service), or is defined by the BPM composite itself, in which case it will be a Business Object. That Business (more...)
Table TXK_TCC_RESULTS needs to be installed by running the EBS Technology Codelevel Checker (available as patch 17537119).
[EVENT] [START 2014/11/19 09:18:39] Performing database sanity checks
[ERROR] Table TXK_TCC_RESULTS needs to be installed by running the EBS Technology Codelevel Checker (available as patch 17537119).
The first day of the Auckland conference was made up of hands-on labs and workshops. I wasn’t presenting, so I arranged to meet up with some friends and have a play day.
On my way out of the hotel I saw Osama Mustafa, who is still looking buff like a Teenage Mutant Ninja Turtle. On the way to the station I met Anton Els, which was a pleasant surprise. We chatted for a (more...)
It's not the traditional blog post I generally write. But it's something I consider near and (more...)
This article describes how to standardize your JDeveloper Installation as requested in Planning & Getting Started – Team, Skills and Development Environments. It is part of the ADF Architecture Practice lessons and describes the installation with examples for windows.
There is a tool ojwebupdate to handle this. It is fully supported but it’s not documented at the moment, documentation is planned for 12.1.4. But you can get a lot (more...)
“You can’t compare apples with oranges.”
Oh, yes you can! The answer is 72,731,533,037,581,000,000,000,000,000,000,000.
SQL> SQL> create table fruit(v1 varchar2(30)); SQL> SQL> insert into fruit values('apples'); SQL> insert into fruit values('oranges'); SQL> commit; SQL> SQL> SQL> begin 2 dbms_stats.gather_table_stats( 3 ownname => user, 4 tabname =>'FRUIT', 5 method_opt => 'for all columns size 2' 6 ); 7 end; 8 / SQL> SQL> select 2 endpoint_number, 3 endpoint_value, 4 to_char(endpoint_value,'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') hex_value 5 from 6 (more...)
Continuing our blog series on Oracle 12 Unified Auditing is a discussion of Pure Mode. Mixed mode is intended by Oracle to introduce Unified Auditing and provide a transition from the traditional Oracle database auditing. Migrating to PURE Unified Auditing requires the database be stopped, the Oracle binary linked to
uniaud_on, and then restarted. This operation can be reversed if auditing needs to be changed back to Mixed Mode.
When changing (more...)
A SQL plan directive is additional information and instructions that the optimizer can use to generate a more optimal plan. For example, a SQL plan directive can instruct the optimizer to (more...)
With Step 1 - Oracle (more...)
There is API method available - authenticateOnBehalf(context, userName), you must have a valid connection context created and with authenticateOnBehalf (more...)
The values of initialization parameters in another session can be changed using procedures SET_BOOL_PARAM_IN_SESSION and SET_INT_PARAM_IN_SESSION provided in DBMS_SYSTEM package.
SQL>conn / as sysdba
SYS> grant dba to hr;
– Currently parameter HASH_AREA_SIZE is set to 131073 in HR session
HR>> sho parameter hash_area_size
NAME TYPE VALUE
———————————— ———– ——————————
hash_area_size integer 131073
– Find out SID, SERIAL# for HR session
SYS> select sid, serial#, username from v$session where username=’HR’;