APEX Printer Friendliness using CSS Media Queries

In the projects I've been involved with I've rarely seen it used, but there is a ninth argument in the f?p= syntax that toggles Printer Friendly mode.

Side note - being the space geek I am this reminded me of the hubhub over Pluto being the ninth planet.

The APEX documentation on Printer Friendly mode states
When referenced, the Application Express engine does not display tabs or navigation bars, and all items are displayed (more...)

How to find out session info about session that comes from remote database through dblink

It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example.

First of all we need to start script on local database:

SQL>                                                                                                                                                                   
SQL> @transactions/global.sql
Enter filters(empty for any)...
Sid           :
Globalid mask :
Remote_db mask:

 INST_ID  SID    SERIAL# USERNAME REMOTE_DB REMOTE_DBID TRANS_ID         DIRECTION   GLOBALID                                           EVENT                      
-------- ----  (more...)

Standalone sqlplus script for plans comparing

I have a couple scripts for plans comparing:

1. https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql
2. http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active.sql

But they have dependencies on other scripts, so I decided to create a standalone script for more convenient use without the need to download other scripts and to set up the sql*plus environment.
I’ve tested it already with firefox, so you can try it now: http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active_standalone.sql

Some screenshots:
diff_plans.sql:
diff_plans

plans_active.sql:
plans_active

Usage:
1. plans_active:

SQL> @plans_active  (more...)

PostgreSQL Database

How time flies, last March I explained how to install and configure PostgreSQL on Windows. It was my intent to start posting more content on PostgreSQL but I was distracted by another writing commitment on Oracle Database 12c PL/SQL Advanced Programming Techniques, which should be available in November. It tempted me away from PostgreSQL because I got to write about how to use Java inside Oracle Database 12c, which was fun. Having (more...)

EMCTL Blackout Scripts

The uptime metrics for my group are based on the times OEM has recorded for each target.  Timely blackouts, of course, are essential to keeping the numbers up and (more importantly) preventing Target Down notifications from being sent out.

Initially I’d develpoed EM CLI scripts to create and remove the blackouts.  That solution was crisp, well-characterized, and scalable with one huge problem:  for convenience the blackout script should execute from host containing the target and not (more...)

AWR Warehouse, Status

So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience.  I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to the ODTUG members on this feature that everyone is so anxious to get their hands on.

Let’s start with some of the top questions:

1. Can I (more...)

Bug with xmltable, xmlnamespaces and xquery_string specified using bind variable

Today I was asked about strange problem: xmltable does not return data, if xquery specified by bind variable and xml data has xmlnamespaces:

SQL> var x_path varchar2(100);
SQL> var x_xml  varchar2(4000);
SQL> col x format a100;
SQL> begin
  2      :x_path:='/table/tr/td';
  3      :x_xml :=q'[
  4                  <table xmlns="http://www.w3.org/tr/html4/">
  5                    <tr>
  6                      <td>apples</td>
  7                      <td>bananas</td>
  8                    </tr>
  9                  </table>
 10                  ]';
 11  end;
 12  /

PL/SQL procedure successfully completed.

SQL> select
  2        i, x
  3   from  (more...)

SYNC 2014 !

Vanuit Proact organiseren wij het kennisplatform SYNC 2014 op 17 september in de Rotterdam Cruise Terminal. Alle hedendaagse IT-infrastructuurontwikkelingen in 1 dag: • Een interactief programma o.l.v. dagvoorzitter Lars Sørensen o.a. bekend van BNR • Een keynote van Marco Gianotten van Giarte, de Nederlandse “Gartner” op het gebied van Outsoucing/Managed Services • Huisman Equipment over de

A Smart Holster for Law Enforcement

So, back in January, Noel (@noelportugal) took a team of developers to the AT&T Developer Summit Hackathon in Las Vegas.

Although they didn’t win, the built some very cool stuff, combining Google Glass, Philips Hue, Internet of Things, and possibly a kitchen sink in there somewhere, into what can only be described as a smart holster. You know, for guns.

You read that right. This project was way out of our usual wheelhouse, which (more...)

Unlimited Session Timeout

There are a lot of security admins out there that are going to hate me for this post. There are a lot of system administrators, developers, and users, however, that will LOVE me for this post. The code I'm about to share with you will keep the logged in PeopleSoft user's session active as long as the user has a browser window open that points to a PeopleSoft instance. Why would you do this? I (more...)

Excel connect to Oracle – 64bit and 32bit issues

Wow, thanks to

Process Monitor   http://technet.microsoft.com/en-us/sysinternals/bb896645

I was able track down why I couldn’t connect to Oracle from Excel.

I had wanted to try some of the examples Charles Hooper has posted on connecting to and monitoring Oracle, for example

http://hoopercharles.wordpress.com/2010/01/20/excel-scrolling-oracle-performance-charts/

I kept getting the error “Provider not found”
Now what kind of trace info is there for an error like this in Excel? None AFAIK. Time to start guessing.
(more...)

Oracle Priority Service Infogram for 24-JUL-2014


RDBMS




Another great issue of the Log Bugger: Log Buffer #380, A Carnival of the Vanities for DBAs, from Pythian.

SQL Developer

Korrektur der Join Cardinality

Laut Randolf Geist ist es "one of the most obvious weak spots of the optimizer: A filter on a table that is joined to another table that has a skewed value distribution in the FK column(s)." Der Satz ist die Antwort auf eine Frage im OTN-Forum, die ein recht kompaktes Beispiel enthielt, bei dem der Optimizer sich hinsichtlich der Cardinality eines Joins massiv verschätzt. Hier eine vereinfachte Version des einfachen Beispiels:

-- 11.2. (more...)

Tokenizing a String

Over the past while I've been working a lot with text strings. Some of these have been short in length like tweets from Twitter, or longer pieces of text like product reviews. Plus others of various lengths.

In all these scenarios I have to break up the data into individual works or Tokens.

The examples given below illustrate how you can take a string and break it into its individual tokens. In addition to tokenising (more...)

Oracle Database 12.1.0.2 – Turning on the In-Memory Database option

It is indeed that sample as switching a knob to turn it on. To enable it you will have to set a reasonable among of...

Read More

Oracle Database 12.1.0.2.0 – Native JSON Support (1)

Oracle Database 12.1.0.2 has now native support build-in for handling JSON (Javascript Object Notation) data. Oracle Database supports JSON natively with relational database features, including...

Read More

Modern Sales Enabled through Siebel and Oracle Sales Cloud Integration

Modern Sales will enable your reps to Sell More, Know More and Grow More. To compete and win, Modern Sales teams need new skills to sell to today's customers. They must be mobile, productive and agile. You can now leverage existing Siebel investments to take advantage of Oracle Sales Cloud capabilities. Learn about Siebel and Sales Cloud integration touch points and the planned roadmap for the coming year and view a demo of what's available (more...)

Oracle CX Cloud Integrations Update With a Spotlight on Oracle Sales Cloud Integrations Webinar

Learn about the Oracle CX Cloud Integrations that are available today as well as additional integrations that are on the roadmap.

Leading customer experiences need to bring together the best in sales, marketing, service, social, and commerce technologies. The Oracle CX solution portfolio contains all the pieces you need to deliver optimized experiences across the customer lifecycle at a lower cost. This session provides an overview of how the Oracle CX Cloud Portfolio provides a (more...)

Oracle Sales Cloud and Marketing Cloud Integration webinar for partners

Oracle's pre-integrated solution connects sales and marketing activities and increases the velocity of leads to opportunities. Learn how our CX portfolio aligns processes and provides deeper customer insight.

This webcast describes in-depth the existing integrations, customer vignettes, and planned roadmap. Join Leslie Buhrer, Sr. Director of Oracle Sales Cloud and Caryn Reddick, Sr. Director of Oracle Marketing Cloud along with our product management experts to get your integrated portfolio questions answered.

Take webinar replay here!

Oracle Sales Cloud Financial Services Demo Environment Now Available!

Product Management and GSE (Global Sales Engineering) are pleased to announce the general availability of the new Financial Services CX Demonstration Environment.

This environment is single instance supporting five distinct Financial Services sub-industry demonstrations including Retail Banking, Commercial Banking, Wholesaling Life and Annuities, Wealth Management, and Mutual Fund Wholesaling. All five demonstrations are rooted in Sales Cloud Release 8, and some include other CX solutions such as OSN and Eloqua. This demo is based on (more...)