In the Oracle RAC previous version we have worked with the option “misscount” of crsctl, which applies for all the servers because there was only one kind of servers, but in the new version of Oracle (12c) we have a new kind of RAC configuration, the “Flex Cluster”. With Flex Cluster we have two kinds of servers “Hub nodes” and “Leaf Nodes”, the Hub Nodes have the same concept of the normal nodes in the previous versions, however (more...)
Just wanted to share some pieces of information from the recent DOAG annual conference that you may find interesting.
From Mike Dietrich’s presentation about Database Upgrade:
Database Replay is extremely useful to predict after-upgrade performance on a test system,
especially we can record the production load on 10g even.
From Carsten Czarski’s talk about XML DB:
With 12c, XML DB is mandatory and it provides an easy way to upload BLOBs via ftp into the (more...)
While creating a POC of a SQL rewrite recently I received a little surprise as I switched my query from serial execution to parallel execution and saw the optimizer’s estimated cost increase dramatically. I’ll explain why in a moment, but it made me think it might be worth setting up a very simple demonstration of the anomaly. I created a table t1 by copying view all_source – which happened to give me a table with about 100,000 rows and 1117 (more...)
I know some people share my opinion on this and others totally disagree – but I fail to appreciate why people I have never met, spoken with or care about want to Social Media with me. If we have not met but there is a high probability we share unusual interests then OK, perhaps – but the fact that we both can spell Oracle or know what a gene is does not count as unusual (more...)
APPEND hint in oracle is very useful, there are many benefits
Fragmented data loading – data will clustered above the HWM so that similar data will be together. Otherwise Oracle will place the records in blocks using PCT_FREE rule
- No undo will be generated – in large direct path insert will free up large amount of data blocks
- Less CBC latches (because of no UNDO blocks), less CPU usage
- Readers need not undo the records, (more...)
My day 2 at the conference started with my analytic functions session. I’m always a bit worried I oversimplify things, but people seem to appreciate it, so perhaps I’m just being paranoid. I’m sure the feedback will let me know.
Next I went to Chris Muir‘s session of Developing Web and Mobile Dashboards with Oracle ADF. I had already seen this at the AUSOUG WA event in Perth, but I liked it, so I (more...)
I got a bunch of emails this morning telling me by blogs had upgraded to WordPress 4.0.1. It’s a critical security release, so if you’ve not done an auto-update, you really need to get this sorted.
WordPress 4.0.1 Released was first posted on November 20, 2014 at 11:32 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is (more...)
Just a quick blog post on things you might see after upgrading to 18.104.22.168. We recently upgraded database from 22.214.171.124 to 126.96.36.199 and query on some data dictionary views ran too slow.
1. Performace of query on dba_free_space degraded
2. Performance of query involving dba_segments is slow
DEV01> select ceil(sum(b.bytes)/1024/1024) b from sys.dba_free_space b; Elapsed: 01:31:45.78
Searching MOS pointed to these Doc Ids (more...)
An interesting experience I have had this year is being more involved in helping organise the annual UKOUG Oracle Technical Conference – Tech14 this year. I fully intended to blog about things as we progressed, but it never happened. But I thought it would be interesting to do a couple of blogs about it, for anyone interested,
If you have never helped organise a conference or user group meeting then you probably think there is (more...)
That’s data that isn’t there until you look for it, sort of, from the optimizer’s perspective.
Here’s some code to create a sample data set:
create table t1 as with generator as ( select --+ materialize rownum id from dual connect by level <= 1e4 ) select rownum id, mod(rownum-1,200) mod_200, mod(rownum-1,10000) mod_10000, lpad(rownum,50) padding from generator v1, generator v2 where rownum <= 1e6 ; begin dbms_stats.gather_table_stats( ownname => user, tabname =>'T1', method_opt => (more...)
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 188.8.131.52 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...)
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...)
“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...)
With Step 1 - Oracle (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’;
For all those who attended my session today in Oracle Virtual Technology Summit on InMemory, thank you very much. Some questions were cut off towards the end since it was an automated session. I will be happy to answer, if your question was in that category.
Since this was an on-demand show, you can watch the replay anytime by visiting this site. Remember, this requires a connection to watch; it's not a download. You can (more...)