As your data volumes increase, particularly as you evolve into the big data world, you will be start to see that your Oracle Data Mining scoring functions will start to take longer and longer. To apply an Oracle Data Mining model to new data is a very quick process. The models are, what Oracle calls, first class objects in the database. This basically means that they run Very quickly with very little overhead.
Shared appltop setup in Oracle E-Business Suite (EBS) is very common nowadays, for obvious reasons. It cuts down the patching downtime enormously on large multi middle tier environments, as we just have apply the patches on only one node instead of all nodes. Any apps patch or apps techstack patch need to be applied only once, Thus Downtime window for production multi middle tier setups with shared Appl_top is significantly less.
Thus in 18.104.22.168 :
SQL> create table test_null_default (id_column number, data_column varchar2(10) default 'SPACE');
SQL> insert into test_null_default values (1,NULL);
1 row created.
Often I want to configure an APEX page based on how many rows have been returned in a (typically classic) report region. There are a number of methods for determining this row count, and some have advantages over others.
Back in September we announced some cool new ways to connect your WordPress.com site to your Google+ account. One major improvement was the ability to bring your WordPress.com and Google+ profiles closer together by sharing your content via Publicize.
For creating a pluggable database you have to consider how to create the pluggable database, and what are you current CDB settings. In this post i have played with and without OMF and difference file structures inside ONE CDB database. Mostly pluggable database will be created from the seed database. What is needed when you want the oracle files of the pluggable database on an other file structure storage. What will you use, and when should you use what.
UKOUG Tech13 was great! Not only because of the amount of interesting presentations to choose from, but also because of the surrounding events. I felt this conference was quite different from previous UKOUG Oracle Technology & E-Business Suite events in Birmingham (I’ve attended six previous events so you can trust me when I say that.) I decided to take a few notes about my experience at the conference to reveal what made it such a great event to attend.
How not to write subqueries:
AND sal.ticket_airline || sal.ticket_number NOT IN ( SELECT sub.dsd_airline || sub.dsd_ticket_number FROM ... )
If there had been any opportunity for the optimizer to do something clever with the NOT IN, you’ve just made sure it can’t happen. On top of that you may find that you don’t get the right results – consider the following cut-n-paste: