What? Dress Code 2.0: Wearable Tech Meetup at the OTN Lounge at Oracle OpenWorld 2014
When? Tuesday, 30-September-2014, 4-6 PM
Developers! Partners! Customers! Lend me your (wearable tech) ears!
Get your best wearables technology gear on and come hang out with the Oracle Applications User Experience team and friends at the OTN Lounge Wearables Technology Meetup at Oracle OpenWorld 2014.
- See live demos of Oracle ideation and proof of concept wearable technology—smart watches, (more...)
Hi there, Last week, I spoke at AIOUG Tech Day at Hyderabad. All India Oracle Users Group (AIOUG) in association with TechMahindra organized one full day of techtalk event. Believe me, the Danube auditorium was a state-of-art facility with 500 capacity. Fabulous venue and huge crowd with similar interest. I thought of sharing my experience … Continue reading
In my last week's post, I had shared key not-to-miss sessions for all things AppAdvantage at Oracle OpenWorld. This year we do have a great lineup of customer sessions, product roadmap, implementation and strategy sessions, executive keynotes, hands-on-labs, product demos, birds-of-a-feather sessions and lots more going on.
It is official! Executive Vice President of Oracle, Thomas Kurian will kick things off with the Oracle Fusion Middleware keynote on Monday at 1:15 pm. And Group (more...)
Oracle’s 22.214.171.124 was released a few weeks ago (You can download it from OTN here: Oracle 126.96.36.199 Download). While technically a minor point release, it contains a couple of major features that would normally be rolled out in a more substantial version change like 12cR2 or perhaps V13. Of course the most highly anticipated feature is a new option (Oracle In-Memory Option) that provides a column (more...)
A TNS error at night…
Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had to restart this job during daytime.
It turned out it was not the only occurrence of this TNS error. A couple of days later he (more...)
A Pandas DataFrame has a nice to_sql(table_name, sqlalchemy_engine) method that saves itself to a database.
The only trouble is that coming up with the SQLAlchemy Engine object is a little bit of a pain, and if you're using the IPython %sql magic, your %sql session already has an SQLAlchemy engine anyway. So I created a bogus
PERSIST pseudo-SQL command that simply calls
to_sql with the open database connection:
%sql PERSIST mydataframe
The result is (more...)
Over the last two weeks I’ve been working on a heartbeat monitoring solution for a client. This is not the normal heartbeat solution provided by Oracle as described in note 1299679.1; yet very similar. The approach that I configured is similar to a traditional heartbeat setup but uses the same extract and replicats already being used by the database/application. For simplicity reasons, I like to call this approach an Integrated Application Heartbeat.
In order (more...)
If you’re building a “finance-ey” application you probably have plenty of fields that should show and accept monetary amounts – and quite possibly these items may be implemented in a variety of ways – ordinary apex number items, edit fields in tabular reports, or even dynamically generated items using APEX_ITEM.text.
In my case I had all three, scattered throughout the application. Our users routinely deal with multi-million dollar amounts and they had trouble checking the amounts visually, (more...)
The title of this piece is the name given to a new feature in 188.8.131.52, and since I’ve recently blogged about a limitation of the in-memory option I thought I’d pick this feature as the next obvious thing to blog about. This is a bit of a non sequitur, though, as the feature seems to have nothing whatsoever to do with the in-memory option; instead it’s a cunning mechanism combining aspects of the star-transformation (but without the bitmap indexes), (more...)
I recently read a blog post by Kyle Hailey regarding some lack of randomness he detected in the Orion I/O generator tool. Feel free to read Kyle’s post but in short he used dtrace to detect Orion was obliterating a very dense subset of the 96GB file Orion was accessing.
I’ve used Orion for many years and, in fact, wrote my first Orion related blog entry about 8 years ago. I find Orion to be (more...)
First-rate announcement from Oracle through Steven Chan Blog for Mobile Apps strategy on Oracle eBusiness Suite. With the rapid advent of social media and our behavior to see everything on smart phones. We as users of Oracle eBusiness suite started feeling old fashioned with the release of Oracle Fusion Applications where everything was coming for [...]
The post Mobile Apps for Oracle E-Business Suite appeared first on ORAERP.COM - Blogs.
Here is how big it was in 2013. Compare it to its size in 2012. It is safe to assume that it will be bigger in 2014!
I will attend this year’s event by invitation from the Oracle ACE Program. Prior to the start of the conference, I will be attending a two day product briefing with product teams at Oracle HQ. It’s like a mini OpenWorld but only for Oracle ACE Directors.
During the (more...)
A comparison of sucking data into a table over a db link using DBMS_PARALLEL_EXECUTE.
This particular example is based on something I needed to do in the real world, copying data from one database into another over a db link. Datapump is not available to me. Tables in question happen to be partitioned by a date-like number (boo!) hence some of the specific actions in the detail.
I think it’s a good example of (more...)
Fresh off the heels of my earlier composite partitioning post, I just ran into this confusing issue:SQL> alter table p_objects 2 add partition p201410 3 values less than (to_date('2014/11/01','yyyy/mm/dd')) 4 ( 5 subpartition p201410_spdts values ('DTS') 6 (more...)
As part of a project for work I wanted to create a script that would create a new range partition but also pre-create all the list subpartitions. By default the subpartitions would be created based on the subpartition template. However for various reasons which I won't get into we don't update or use the subpartition template. I wanted to define the subpartition list as part of the ALTER TABLE ... ADD PARTITION statement. I assumed it (more...)
Here’s a script to create a table, with index, and collect stats on it. Once I’ve collected stats I’ve checked the execution plan to discover that a hint has been ignored (for a well-known reason):
create table t2
rownum <= 3000
create index t2_i1 on t2(n1);
method_opt => 'for all columns size 1'
explain plan for
My friend and colleague, ACE Director Brendan Tierney, has recently published the reference book Predictive Analytics Using Oracle Data Miner. It is the first comprehensive book on the subject matter. The book is primarily aimed at the Oracle Data Scientist/Data Miner. The other target audience are Oracle developers who implement the data mining models created by the Data Scientists in their applications, e.g. OBIEE. Some of the areas covered are also relevant for Oracle (more...)