Everything went smoothly at Auckland airport. Boarding an A380 takes quite a bit of time and I was near the front of the plane, so I was in the last group to board. Fortunately there was loads of room for hand luggage and the seat was pretty good. The people too my right were a couple, so they were leaning together, which gave me more elbow room. The extra room and a plug socket meant (more...)
I will start this post off stating that I know there are better and more efficient methods of doing this but this is the best method I could come up with.
I had a csv file with a number of columns, one of which was data in a timestamp with timezone format.
A few rows looked like this – note I have stripped the other columns out for ease of display.
7941 11/9/2014 (more...)
Just got home to find VirtualBox 4.3.20 has been released. I’ve just installed it on MaC (Yosemite), Fedora 20 and Windows 7 with no dramas so far.
VirtualBox 4.3.20 was first posted on November 22, 2014 at 4:11 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading (more...)
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...)
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...)
Check it out! Available for free from http://tinyurl.com/UXstrategy
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...)
On Thursday, December 4th from 1 PM-2 PM CST, Fishbowl Solutions will hold a webinar in conjunction with Oracle about our new solution for enterprise project management. This solution transforms how project-based tools, like Oracle Primavera, and project assets, such as documents and diagrams, are accessed and shared.
With this solution:
- Project teams will have access to the most accurate and up to date project assets based on their role within a specific project
- Through (more...)
Just a quick blog post on things you might see after upgrading to 220.127.116.11. We recently upgraded database from 18.104.22.168 to 22.214.171.124 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...)
On Friday, December 19, AMIS organises a special XMas-terclass on SOA Suite 12.
SOA Suite 12c (June 2014) was a major release for Oracle’s flagship integration product. This release introduces new functionality, higher developer productivity, more robust run-time scalability and performance. 12c brings together development and administration of Service Bus and SOA composite applications, it ships new technology adapters as well as a SDK to develop custom adapters and provides across the stack support for REST-style (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 126.96.36.199 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...)
“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...)
I left the Bangkok event straight after my session, went back to my hotel to get my luggage, then got a taxi to the airport. I was a little worried as people said the traffic would be horrific. Luckily I beat the worst of the traffic and my hotel was very close to the highway. I got to the airport with about 3 hours spare, which sounds like a lot, but for Bangkok airport I (more...)
Images are heavily used in Mobile apps. For instance a list that contains employees usually shows the images of these employees. This works well when you have a WIFI connection, but what if you are using slower connections ? If you look at a mobile twitter app you will see that, depending on connectivity, images are loaded instantaneously or delayed. In this post I explain how you can load the images of a List in a (more...)
The last 2 weeks we are lucky enough to have the Big Data Appliance (BDA) from Oracle in our lab/demo environment at VX Company and iRent. In this blog post i am trying to share my first experiences and some general observations. I am coming from an Oracle (Exadata) RDBMS background so i will probably reflect some of that experience on the BDA. The BDA we got here at is a starters rack which consists (more...)