Skip navigation.

Feed aggregator

11 Tips To Get Your Conference Abstract Accepted

11 Ways To Get Your Conference Abstract Accepted
This is what happens when your abstract is selected!Ready for some fun!? It's that time of year again and the competition will be intense. The "call for abstracts" for a number of Oracle Database conferences are about to close.

The focus of this posting is how you can get a conference abstract accepted.

As a mentor, Track Manager and active conference speaker I've been helping DBAs get their abstracts accepted for many years. If you follow my 11 tips below, I'm willing to bet you will get a free pass to any conference you wish in any part of the world.

1. No Surprises! 
Track Manager After A SurpriseThe Track Manager wants no surprises, great content and a great presentation. Believe me when I say, they are looking for ways to reduce the risk of a botched presentation, a cancelation or a no show. Your abstract submissions is your first way to show you are serious and will help make the track incredibly awesome.

Tip: In all your conference communications, demonstrate a commitment to follow through.

2. Creative Title.
The first thing everyone sees is the title. I can personally tell you, if the title does not peak my curiosity without sounding stupid, then unless I know the speaker is popular I will not read the abstract. Why do I do this? Because as a Track Manager, I know conference attendees will do the same thing! And as a Track Manager, I want attendees to want to attend sessions in my track.

Tip: Find two people, read the title to them and ask what they think. If they say something like, "What are you going to talk about?" that's bad. Rework the title.

3. Tell A Story
The abstract must tell a compelling story. Oracle conferences are not academic conferences! There needs to be some problem along with a solution complete with drama woven into the story.

Tip: People forget bullet points, but they never forget a good story.

4. Easy To Read
The abstract must be easy to review. The abstract reviewers may have over a hundred abstracts to review. Make it a good quick read for the reviewers and your chances increase.

Tip: Have your computer read your abstract back to you. If you don't say, "Wow!" rework the abstract. 

5. Be A Grown-Up
You can increase the perception you will physically show up and put on a great show at the conference by NOT putting into your abstract emoji, bullet points, your name and title or pushing a product or service. NEVER copy/paste from a powerpoint outline into the abstract or outline. (I've seen people do this!)

Tip: Track Managers do not want to baby sit you. They want an adult who will help make their track great.

6. Submit Introductory Level Abstracts
I finally figured this out a couple years ago. Not everyone is ready for a detailed understanding of cache buffer chain architecture, diagnosis, and solution development. Think of it from a business perspective. Your market (audience) will be larger if your presentation is less technical. If this bothers you, read my next point.

Tip: Submit both an introductory level version and advanced level version of your topic.

7. Topics Must Be Filled
Not even the Track Manager knows what people will submit. And you do not know what the Track Manager is looking for. And you do not know what other people are submitting. Mash this together and it means you must submit more than one abstract. I know you really, really want to present on topic X. But would you rather not have an abstract accepted?

Tip: Submit abstracts on multiple topics. It increases your chances of being accepted.

8. Submit Abstract To Multiple Tracks
This is similar to submitting both an introductory version of your abstract. Here's an example: If there is a DBA Bootcamp track and a Performance & Internals Track, craft your abstract to Bootcamp version has a more foundational/core feel to it. And craft your Performance & Internals version to feel more technical and advanced.

Do not simply change the title and the abstract can not be the same.  If the conference managers or the Track Manager feels you are trying to game the conference, you present a risk to the conference and their track and your abstracts will be rejected. So be careful and thoughtful.

Tip: Look for ways to adjust your topic to fit into multiple tracks.

9. Great Outline Shows Commitment
If the reviewers have read your title and abstract, they are taking your abstract seriously. Now is the time to close the deal by demonstrating you will put on a great show. And this means you already have in mind an organized and well thought out delivery. You convey this with a fantastic outline. I know it is difficult to create an outline BUT the reviewers also know this AND having a solid outline demonstrates to them you are serious, you will show up, and put on a great show.

Tip: Develop your abstract and outline together. This strengthens both and develops a kind of package the reviewers like to see.

10. Learning Objectives Show Value
You show the obvious value of your topic through the learning objectives. Personally, I use these to help keep me focused on my listener, just not what I'm interested in at the moment. Because I love my work, I tend to think everyone also does... not so. I must force myself to answer the question, "Why would a DBA care about this topic?"

Tip: Develop your learning objectives by asking yourself, "When my presentation is over, what do I want the attendees to remember?"

11. Submit About Problems You Solved
Submit on the topics you have personally explored and found fascinating. Every year, every DBA has had to drill deep into at least one problem. This concentrated effort means you know the topic very well. And this means you are qualified to tell others about it! People love to hear from people who are fascinated about something. Spread the good news resulting from a "bad" experience.

Tip: Submit on topics you have explored and are fascinated with.

How Many Abstracts Should I Submit?
It depends on the conference, but for a big North America conference like ODTUG, RMOUG and IOUG I suggest at least four.

Based on what I wrote above, pick three topics, perhaps create both an introductory and advanced version and look to see if it makes sense to submit to multiple tracks. That means you'll probably submit at least four abstracts. It's not as bad as it sounds, because you will only have perhaps three core abstracts. All the others are modifications to fit a specific need. Believe when you receive the acceptance email, it will all be worth it!

See you at the conference!

Craig.

Categories: DBA Blogs

Data Visualization and Self Service Big Data Analytics

Nilesh Jethwa - Wed, 2014-10-08 15:59

The innovation engine in the field of Business Intelligence and Data visualization tools , is certainly cranked up. Qlikview, Tableau and Tibco Spotfire introduced new category of Data Visualization term in the field of Business Intelligence.

Now every vendor offers some form of Data Discovery. Oracle is also working on something similar adding to their confusing mix of OBIEE stack.

With the launch of new InfoCaptor, you can perform ad-hoc data visualizations and build dashboards all within the browser. Now that is refreshing. The browser is the key here. Once you deploy on the server, users can simply login, upload their datasets or point to existing database connection. Before you know users are already slicing and dicing their datasets and swimming in the world of beautiful visualizations. Yes, the visualizations are absolutely stunning and why shouldn’t they be. It is based on the excellent d3js.org library.

The key here is that the browser is your canvas and it is pretty huge, for e.g the detfault size for the visuals takes up my entire browser screen real estate. I like big visuals and if I am producing a Trellis chart then I can simply drag the corners and resize it. The visualization library is very comprehensive and offers around 30 visuals. It provides the bullet graph as well for KPI tracking.

Here are some screenshots from the website

d3 visualizations

 

InfoCaptor is also available on the cloud as a service and based on that there are few live analysis to try out without login or installing anything.

I would say with this release small business owners have truly found their Tableau or Qlikview alternative.

Go check out the new InfoCaptor Data Visualizer

ShareThis

How to keep databases up and running during the holidays [VIDEO]

Chris Foot - Wed, 2014-10-08 13:14

Transcript

Welcome to RDX. For our retail customers, the holiday season is a critical time of year for revenue generation. The increased activity can put additional stress on transactional databases.

Here are some best practice suggestions to ensure your databases are ready for the holiday season from RDX Director of Technical Sales, Katy Park:

Put in a High Availability solution if you do not have one.

Secondly, run a test of your DR plan to ensure you can meet your time to recovery objectives.

Ask your DBA for code tuning suggestions for queries that are run often and utilize a lot of resources.

You should also consider removing the reporting load from your transactional database if reports are currently running on the production server.

And finally, review object sizes and maximum server capacities.

Thanks for watching, and we'll see you next time!

The post How to keep databases up and running during the holidays [VIDEO] appeared first on Remote DBA Experts.

Is Oracle Application Express supported?

Joel Kallman - Wed, 2014-10-08 12:38

Time to clear up some confusion.

In the past 60 days, I have encountered the following:
  • Two different customers who said they were told by Oracle Support that "APEX isn't supported."
  • An industry analyst who asked "Is use of Oracle Application Express supported?  There is an argument internally that it cannot be used for production applications."
  • A customer who was told by an external non-Oracle consultant "Oracle Application Express is good for a development environment but we don't see it being used in production."  I'm not even sure what that means.
To address these concerns as a whole, let me offer the following:
  1. Oracle Application Express is considered a feature of the Oracle Database.  It isn't classified as "free", even though there is no separate licensing fee for it.  It is classified as an included feature of the Oracle Database, no differently than XML DB, Oracle Text, Oracle Multimedia, etc.
  2. If you are licensed and supported for your Oracle Database, you are licensed and supported (by Oracle Support) for Oracle Application Express in that database.  Many customers aren't even aware that they are licensed for it.
  3. If you download a later version of Oracle Application Express made available for download from the Oracle Technology Network and install it into your Oracle Database, as long as you are licensed and supported for that Oracle Database, you are licensed and supported (by Oracle Support) for Oracle Application Express in that database.
  4. Oracle Application Express is listed in the Lifetime Support Policy: Oracle Technology Products document.

As far as the customers who believed they were told directly by Oracle Support that Oracle Application Express isn't supported, there was a common misunderstanding.  In their Service Requests to Oracle Support, they were told that Oracle REST Data Services (formerly called Oracle Application Express Listener, the Web front-end to Oracle Application Express) running in stand-alone mode isn't supported.  This is expressed in the Oracle REST Data Services documentation.  However, this does not pertain to the supportability of Oracle Application Express.  Additionally, a customer can run Oracle REST Data Services in a supported fashion in specific versions of Oracle WebLogic Server, Glassfish Server, and Apache Tomcat.  To reiterate - running Oracle REST Data Services in standalone mode is the one method which is not supported in production deployments, as articulated in the documentation - however, you can run it supported in Oracle WebLogic Server, Glassfish Server and Apache Tomcat.

Oracle Application Express has been a supported feature of the Oracle Database since 2004, since it first shipped as Oracle HTML DB 1.5 in Oracle Database 10gR1.  Every subsequent version of Oracle Application Express has been supported by Oracle Support when run in a licensed and supported Oracle Database.  Anyone who says otherwise is...confused.

Bringing Clarity To The Avalanche - Part II

Floyd Teter - Wed, 2014-10-08 12:35
You had to be hiding under a rock (with no cell or internet service) to miss out on the fact that Oracle was trumpeting cloud messages throughout OpenWorld.  Far too much news for one person to track. So I'd like to approach discussing this in a very different way.

Today, I'm simply putting up a link to the best Oracle press release on recent cloud announcements.  The release touts the six new platform services for Oracle Cloud.  You can find it here.  This is the "sneak peek", made especially for those of you who think I'm too slow about writing things.  Heck, I'm much faster than George RR Martin, but anything to keep ya'all happy...

UPDATE:  So the highlights for me all have to do with PaaS (Platform-as-a-Service)...30,000 devices, 400 pedabytes of storage, 19 data centers around the globe...whew.

I had the opportunity to work hands-on with the Mobile Cloud, which puts development, deployment and administration onto one user interface (yup, it's the Oracle Alta UI).  Built a mobile app in about 30 minutes.  More on that in a subsequent post.

The Integration Cloud also looks exciting.  Yes, there are other integration service providers (Boomi comes immediately to mind), but working on integration of Oracle products on an Oracle platform offers some pretty unique possibilities.

The Process Cloud looks promising, especially if we will eventually be able to extend Oracle packaged applications with custom, cloud-based business processes.

Those are my big three highlights.  How about you?

Alfresco Summit 2014 - Conferences, Day 1 - Status & New version!

Yann Neuhaus - Wed, 2014-10-08 10:13


Today, I have the chance to be in London for the amazing Alfresco Summit 2014 (7-9 October 2014)! Two weeks ago, the Alfresco Summit took place in San Francisco but unfortunately I wasn't available at that time. This year, the Alfresco Summit in London is a three day event: the first day is, as often, a training day with a complete day course and the two other days are composed of conferences (General, Business, Technical or Solution sessions).

So yesterday, I attended the Alfresco University training course with Rich McKnight (Principal Consultant of Alfresco) about "Creating Custom Content Models in Alfresco". It was a really good training, very well presented. I'm sure that a lot of people with basic knowledge of Alfresco now have a better understanding of the general concepts of Content Models in Alfresco.

b2ap3_thumbnail_University_logo.jpg

The conferences have started today with a small status of Alfresco by Doug Dennerline (CEO of Alfresco) with quite a lot of interesting figures. After that, Thomas DeMeo (VP of Product Management at Alfresco) presented the Alfresco Product Keynote... And here we are, the brand new Alfresco Enterprise major version (Alfresco One 5.0) was presented with all its new features. Of course, I already had the opportunity to test almost everything in this version thanks to the Alfresco Community 5.0.a (there is often little differences between Community and Enterprise versions) but it's always good to view a presentation of what's new in an Alfresco Enterprise version especially a major version! Moreover, I can assure you that you will LOVE this new Alfresco version because of the following points:

  • Alfresco 5.0 now use Solr 4.9 instead of Solr 1.4 (for Alfresco 4.x) which involves a lot of improvements
  • Live Search feature: Start typing anything in the search field and alfresco will show you results as you type for documents, sites, people, wiki or blogs
  • Search suggestions and spell check feature: When typing, Alfresco present suggestions related to what you are writing and if you mistyped a word, then Alfresco is able to present you what the word should be (e.g. for 'Especialy', Alfresco will suggest you 'Especially')
  • Search by facets: A facet is a search filter based on a pre-defined metadata like document extension, creator, modifier, aso...
  • Default search operator switched from OR to AND: A consequence of that is that generally, there are less results to display (which means better performance) and these results are more relevant (better for user satisfaction)
  • New document previewer (faster, better browser support) with a search feature to directly search into the document preview. The new previewer let users crop videos or images directly from Alfresco to only keep important data on the repository
  • An improved WYSIWYG editor
  • A new page for administrators to manage all sites in the same place, finally!
  • Improuved Outlook integration: directly from the outlook interface, it's possible to create folders/docs, search documents, manage workflows, aso...
  • Improved Microsoft Office integration: document creation, modification and upload can be done directly from MS Office and moreover, you can specify the Type of the document directly from MS Office (even if it's a company specific Type. e.g. dbi_Meetings_Summary) and once done, you can view and edit all Type specific Properties on your document! All these elements will then be sent to Alfresco when the document is saved
  • Better integration between Alfresco & SharePoint: It's possible to use SharePoint as a UI (Client) and Alfresco as a Repository where documents are stored (Server). With this solution, all new features of Alfresco 5.0 are available directly through the SharePoint Sites (Live Search, Search with facets, Documents previewer, aso...)

 

This new major version of Alfresco brings its new features but some others will disappear:

  • The eclipse specific SDK: Now everything is built using Maven
  • Liferay portlets don't exist anymore. Well, they were not very useful, so...
  • The Alfresco Explorer client doesn't exist anymore! It's the turn of Alfresco Share to shine!

 

From what I've seen, there are a lot of other interesting things that will need your attention in the next few months like:

  • New version of Alfresco mobile apps (ATM iOS & Android) with some profiles to completly changes the way it looks like depending on your roles in Alfresco (Business, Sales, Technical, Management, aso...)
  • BI directly in Alfresco (using Dashlets)?
  • The new Alfresco Activiti Enterprise release (a new separate software with its own UI) who let business users write their own workflow logic and create the form they want for all steps of this workflow using a very simple graphical interface

 

So the first day was very interesting AND exciting! I hope that the Conferences Day 2 will be at least as cool! See you tomorrow for a new article with a lot of other interesting things (well if I have time for this Tongue out).

 

Next-Generation Accounts Payable Process Automation

WebCenter Team - Wed, 2014-10-08 08:47
Oracle Corporation Next-Generation Accounts Payable Process Automation The Next Generation of Accounts Payable Invoice Processing Is Here

Invoice processing is time-consuming and expensive work. This is especially true if invoicing involves inefficient paper-based processes, manually-conducted approvals and manual data-entry into the financial system. These inefficient methods affect the bottom line by increasing costs, creating liability & accrual blind-spots and causing other cash management, reconciliation & reporting challenges.

Change the game with the Next-Generation of A/P Process Automation
  • Automate up to 80% of invoice processing, eliminating paper, manual data entry and associated errors
  • Streamline operations with automated invoice creation, 2/3-way matching and by easily connecting to a variety of leading ERP business applications
  • Realize benefits faster, by leveraging new Cloud and on-premise deployment options & capabilities
Join this webcast to learn how Next-Gen A/P Process Automation can deliver significant results in terms of cost savings, processing time and resource efficiency to your existing Oracle and non-Oracle ERP applications.

Register now.
Red Button Top Register Now Red Button Bottom Live Webcast Calendar October 16, 2014
10 a.m. PT / 1 p.m. ET SPEAKERS Chris Preston Chris Preston
Sr. Director
Customer Strategies
Oracle Nilay Banker Nilay Banker
Founder & CEO
Inspyrus Hardware and Software Engineered to Work Together Copyright © 2014, Oracle Corporation and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices and Terms of Use | Privacy Statement

How do I type e acute (é) on Windows 8

Robert Baillie - Wed, 2014-10-08 08:32
I keep on forgetting how to type é on Windows 8 (I used to CTRL+ALT+e, but that's now often reserved for the Euro symbol) I then tend to run a search on Google, and end up being pointed towards 8 year old answers that point you to character map, options in old version of word, or the old way of typing the extended ASCII character code. They all suck. And then I remember - it's easy. You start by pressing a CTRL + a key that represent the accent, then type the letter you want accented. For example, CTRL + ' followed by e gives you é. Brilliant! The great thing about using this technique is that the characters you use (dead letters) are representative of the accents you want to type. This makes them much easier to remember than the seemingly random character codes Here are the ones I know about: KeystrokesAccent typeExamplesCTRL + 'acuteéCTRL + `graveèCTRL + SHIFT + 6 / CTRL + ^circumflexêCTRL + ,cedillaçCTRL + ~perispomeneõCTRL + SHIFT + 7 / CTRL + &Diphthongs / others a =...

How do I type e acute (é) on Windows 8

Rob Baillie - Wed, 2014-10-08 08:27

I keep on forgetting how to type é on Windows 8 (I used to CTRL+ALT+e, but that's now often reserved for the Euro symbol)

I then tend to run a search on Google, and end up being pointed towards 8 year old answers that point you to character map, options in old version of word, or the old way of typing the extended ASCII character code.

They all suck.

And then I remember - it's easy.

You start by pressing a CTRL + a key that represent the accent, then type the letter you want accented.

For example, CTRL + ' followed by e gives you é.

Brilliant!

The great thing about using this technique is that the characters you use (dead letters) are representative of the accents you want to type. This makes them much easier to remember than the seemingly random character codes

Here are the ones I know about:

KeystrokesAccent typeExamplesCTRL + 'acuteéCTRL + `graveèCTRL + SHIFT + 6 / CTRL + ^circumflexêCTRL + ,cedillaçCTRL + ~perispomeneõCTRL + SHIFT + 7 / CTRL + &Diphthongs / others a = æ, o = œ, s = ß It doesn't quite work with every app (Blogger on Chrome, for example), but it certainly covers Office 2013, including both Outlook and Word.

Deploying a Private Cloud at Home — Part 1

Pythian Group - Wed, 2014-10-08 08:17

Today’s blog post is part one of seven in a series dedicated to Deploying a Private Cloud at Home. In my day-to-day activities, I come across various scenarios where I’m required to do sandbox testing before proceeding further on the production environment—which is great because it allows me to sharpen and develop my skills.

My home network consists of an OpenFiler NAS which also serves DNS, DHCP, iSCSI, NFS and Samba in my network. My home PC is a Fedora 20 Workstation, where I do most of the personal activities.  KVM hypervisor is running on CentOS 6.2 x86_64 to run sandbox VMs for testing.

Recently I decided to move it to the cloud and create a private cloud at home. There are plenty of open source cloud solutions available, but I decided to use OpenStack for two reasons.

  1. I am already running Redhat compatible distros ( CentOS and Fedora ) so I just need to install OpenStack on top of it to get started.
  2. Most of the clients I support have RHEL compatible distros in the environment, so it makes sense having RHEL compatible distros to play around.

Ideally OpenStack cloud consists of minimum three nodes with at least 2 NICs on each node.

  • Controller: As the name suggests, this is the controller node which runs most of the control services.
  • Network: This is the network node which handles virtual networking.
  • Compute : This is the hypervisor node which runs your VMs.

However due to small size of my home network I decided to use legacy networking which only requires controller and compute nodes with single NIC

Stay tuned for the remainder of my series, Deploying a Private Cloud at Home. In part two of seven, I will be demonstrating configuration and setup.

Categories: DBA Blogs

First-timer tips for Oracle Open World

Rittman Mead Consulting - Wed, 2014-10-08 07:16

Last week I had the great pleasure to attend Oracle Open World (OOW) for the first time, presenting No Silver Bullets – OBIEE Performance in the Real World at one of the ODTUG user group sessions on the Sunday. It was a blast, as the saying goes, but the week before OOW I was more nervous about the event itself than my presentation. Despite having been to smaller conferences before, OOW is vast in its scale and I felt like the week before going to university for the first time, full of uncertainty about what lay ahead and worrying that everyone would know everyone else except you! So during the week I jotted down a few things that I’d have found useful to know ahead of going and hopefully will help others going to OOW take it all in their stride from the very beginning.

Coming and going

I arrived on the Friday at midday SF time, and it worked perfectly for me. I was jetlagged so walked around like a zombie for the remainder of the day. Saturday I had chance to walk around SF and get my bearings both geographically, culturally and climate. Sunday is “day zero” when all the user group sessions are held, along with the opening OOW keynote in the evening. I think if I’d arrived Saturday afternoon instead I’d have felt a bit thrust into it all straight away on the Sunday.

In terms of leaving, the last formal day is Thursday and it’s full day of sessions too. I left straight after breakfast on Thursday and I felt I was leaving too early. But, OOW is a long few days & nights so chances are by Thursday you’ll be beat anyway, so check the schedule and plan your escape around it.

Accomodation

Book in advance! Like, at least two months in advance. There are 60,000 people descending on San Francisco, all wanting some place to stay.

Get airbnb, a lot more for your money than a hotel. Wifi is generally going to be a lot better, and having a living space in which to exist is nicer than just a hotel room. Don’t fret about the “perfect” location – anywhere walkable to Moscone (where OOW is held) is good because it means you can drop your rucksack off at the end of the day etc, but other than that the events are spread around so you’ll end up walking further to at least some of them. Or, get an Uber like the locals do!

Sessions

Go to Oak Table World (OTW), it’s great, and free. Non-marketing presentations from some of the most respected speakers in the industry. Cuts through the BS. It’s also basically on the same site as the rest of OOW, so easy to switch back and forth between OOW/OTW sessions.

Go and say hi to the speakers. In general they’re going to want to know that you liked it. Ask questions — hopefully they like what they talk about so they’ll love to speak some more about it. You’ll get more out of a five minute chat than two hours of keynote. And on that subject, don’t fret about dropping sessions — people tweet them, the slides are usually available, and in fact you could be sat at your desk instead of OOW and have missed the whole lot so just be grateful for what you do see. Chance encounters and chats aren’t available for download afterwards; most presentations are. Be strict in your selection of “must see” sessions, lest you drop one you really really did want to see.

Use the schedule builder in advance, but download it to your calendar (watch out for line-breaks in the exported file that will break the import) and sync it to your mobile phone so you can see rapidly where you need to head next. Conference mobile apps are rarely that useful and frequently bloated and/or unstable.

Don’t feel you need to book every waking moment of every day to sessions. It’s not slacking if you go to half as many but are twice as effective from not being worn out!

Dress

Dress wise, jeans and polo is fine, company polo or a shirt for delivering presentations. Day wear is fine for evenings too, no need to dress up. Some people do wear shorts but they’re in the great minority. There are lots of suits around, given it is a customer/sales conference too.

Socialising

The sessions and random conversations with people during the day are only part of OOW — the geek chat over a beer (or soda) is a big part too. Look out for the Pythian blogger meetup, meetups from your country’s user groups, companies you work with, and so on.

Register for the evening events that you get invited to (ODTUG, Pythian, etc) because often if you haven’t pre-registered you can’t get in if you change your mind, whereas if you do register but then don’t go that’s fine as they’ll bank on no-shows. The evening events are great for getting to chat to people (dare I say, networking), as are the other events that are organised like the swim in the bay, run across the bridge, etc.

Sign up for stuff like swim in the bay,  it’s good fun – and I can’t even swim really. Run/Bike across the bridge are two other events also organised. Hang around on twitter for details, people like Yury Velikanov and Jeff Smith are usually in the know if not doing the actual organising.

General

When the busy days and long evenings start to take their toll don’t be afraid to duck out and go and decompress. Grab a shower, get a coffee, do some sight seeing. Don’t forget to drink water as well as the copious quantities of coffee and soda.

Get a data package for your mobile phone in advance of going eg £5 per day unlimited data. Conference wifi is just about OK at best, often flaky. Trying to organise short-notice meetups with other people by IM/twitter/email gets frustrating if you only get online half an hour after the time they suggested to meet!

Don’t pack extra clothes ‘just in case’. Pack minimally because (1) you are just around the corner from Market Street with Gap, Old Navy etc so can pick up more clothes cheaply if you need to and (2) you’ll get t-shirts from exhibitors, events (eg swim in the bay) and you’ll need the suitcase space to bring them all home. Bring a suitcase with space in or that expands, don’t arrive with a suitcase that’s already at capacity.

Food

So much good food and beer. Watch out for some of the American beers; they seem to start at about 5% ABV and go upwards, compared to around 3.6% ABV here in the UK. Knocking back this at the same rate as this will get messy.

In terms of food you really are spoilt, some of my favourites were:

  • Lori’s diner (map) : As a brit, I loved this American Diner, and great food - yum yum. 5-10 minutes walk from Moscone.
  • Mel’s drive-in (map) : Just round the corner from Moscone, very busy but lots of seats. Great american breakfast experience! yum
  • Grove (map) : Good place for breakfast if you want somewhere a bit less greasy than a diner (WAT!)

 

Categories: BI & Warehousing

select pdf from sqlplus

Laurent Schneider - Wed, 2014-10-08 06:48

sqlplus 10gR2 and later allows you to select from a BLOB. If you use linux, you could convert the hex output to binary with xxd


sqlplus -s scott/tiger <<EOF |xxd -p -r >doc.pdf
set pages 0 lin 17000 long 1000000000 longc 16384
select document from emp where ename=user;
EOF

Obviously, it could also be a sound, a video or an image !

Spring XD Pivotal Gemfire Sink Demo

Pas Apicella - Wed, 2014-10-08 03:39
Spring XD is a unified, distributed, and extensible system for data ingestion, real time analytics, batch processing, and data export. The project's goal is to simplify the development of big data applications.

There are 2 implementation of the gemfire sink: gemfire-server and gemfire-json-server. They are identical except the latter converts JSON string payloads to a JSON document format proprietary to GemFire and provides JSON field access and query capabilities. If you are not using JSON, the gemfire-server module will write the payload using java serialization to the configured region.

In this example below we show how we connect to an existing GemFire 7.0.2 cluster using a locator to add some JSON trade symbols to an existing region in the cluster.

1. Start a GemFire cluster with with an existing region as shown below. The following cache.xml is for "server1" of the cluster and "server2" of the cluster. They are identical configs , just using different ports

server1 cache.xml
  
<?xml version="1.0"?>
<!DOCTYPE cache PUBLIC
"-//GemStone Systems, Inc.//GemFire Declarative Caching 7.0//EN"
"http://www.gemstone.com/dtd/cache7_0.dtd">

<cache>
<cache-server bind-address="localhost" port="40404" hostname-for-clients="localhost"/>

<region name="springxd-region">
<region-attributes data-policy="partition">
<partition-attributes redundant-copies="1" total-num-buckets="113"/>
<eviction-attributes>
<lru-heap-percentage action="overflow-to-disk"/>
</eviction-attributes>
</region-attributes>
</region>

<resource-manager critical-heap-percentage="75" eviction-heap-percentage="65"/>

</cache>

server2 cache.xml
  
<?xml version="1.0"?>
<!DOCTYPE cache PUBLIC
"-//GemStone Systems, Inc.//GemFire Declarative Caching 7.0//EN"
"http://www.gemstone.com/dtd/cache7_0.dtd">

<cache>
<cache-server bind-address="localhost" port="40405" hostname-for-clients="localhost"/>

<region name="springxd-region">
<region-attributes data-policy="partition">
<partition-attributes redundant-copies="1" total-num-buckets="113"/>
<eviction-attributes>
<lru-heap-percentage action="overflow-to-disk"/>
</eviction-attributes>
</region-attributes>
</region>

<resource-manager critical-heap-percentage="75" eviction-heap-percentage="65"/>

</cache>

2. Verify using GFSH you have 2 members , a locator and a region as follows
  
$ gfsh
_________________________ __
/ _____/ ______/ ______/ /____/ /
/ / __/ /___ /_____ / _____ /
/ /__/ / ____/ _____/ / / / /
/______/_/ /______/_/ /_/ v7.0.2.10

Monitor and Manage GemFire
gfsh>connect --locator=localhost[10334];
Connecting to Locator at [host=localhost, port=10334] ..
Connecting to Manager at [host=10.98.94.88, port=1099] ..
Successfully connected to: [host=10.98.94.88, port=1099]

gfsh>list members;
Name | Id
-------- | ---------------------------------------
server1 | 10.98.94.88(server1:10161)<v1>:15610
server2 | 10.98.94.88(server2:10164)<v2>:39300
locator1 | localhost(locator1:10159:locator):42885

gfsh>list regions;
List of regions
---------------
springxd-region

3. Start single node SpringXD server
  
[Wed Oct 08 14:51:06 papicella@:~/vmware/software/spring/spring-xd/spring-xd-1.0.1.RELEASE ] $ xd-singlenode

_____ __ _______
/ ___| (-) \ \ / / _ \
\ `--. _ __ _ __ _ _ __ __ _ \ V /| | | |
`--. \ '_ \| '__| | '_ \ / _` | / ^ \| | | |
/\__/ / |_) | | | | | | | (_| | / / \ \ |/ /
\____/| .__/|_| |_|_| |_|\__, | \/ \/___/
| | __/ |
|_| |___/
1.0.1.RELEASE eXtreme Data


Started : SingleNodeApplication
Documentation: https://github.com/spring-projects/spring-xd/wiki

....

4. Start SpringXD shell
  
$ xd-shell
_____ __ _______
/ ___| (-) \ \ / / _ \
\ `--. _ __ _ __ _ _ __ __ _ \ V /| | |
`--. \ '_ \| '__| | '_ \ / _` | / ^ \| | | |
/\__/ / |_) | | | | | | | (_| | / / \ \ |/ /
\____/| .__/|_| |_|_| |_|\__, | \/ \/___/
| | __/ |
|_| |___/
eXtreme Data
1.0.1.RELEASE | Admin Server Target: http://localhost:9393
Welcome to the Spring XD shell. For assistance hit TAB or type "help".
xd:>

5. Create a stream as follows
  
xd:>stream create --name gemfiredemo --definition "http --port=9090 | gemfire-json-server --host=localhost --port=10334 --useLocator=true --regionName=springxd-region --keyExpression=payload.getField('symbol')" --deploy
Created and deployed new stream 'gemfiredemo'

6. Post some entries via HTTP which will be inserted into the GemFire Region
  
xd:>http post --target http://localhost:9090 --data {"symbol":"ORCL","price":38}
> POST (text/plain;Charset=UTF-8) http://localhost:9090 {"symbol":"ORCL","price":38}
> 200 OK

xd:>http post --target http://localhost:9090 --data {"symbol":"VMW","price":94}
> POST (text/plain;Charset=UTF-8) http://localhost:9090 {"symbol":"VMW","price":94}
> 200 OK

7. Verify via GFSH that data has been inserted into the GemFire region. JSON data stored in GemFire regions is done using PDX.
  
gfsh>query --query="select * from /springxd-region";

Result : true
startCount : 0
endCount : 20
Rows : 2

symbol | price
------ | -----
ORCL | 38
VMW | 94

NEXT_STEP_NAME : END

More Information

SpringXD
http://projects.spring.io/spring-xd/

GemFire Sinks
http://docs.spring.io/spring-xd/docs/1.0.1.RELEASE/reference/html/#gemfire-serverhttp://feeds.feedburner.com/TheBlasFromPas
Categories: Fusion Middleware

OOW : Présentations 2014

Jean-Philippe Pinte - Wed, 2014-10-08 03:12
Les présentations d'OOW 2014 sont téléchargeables en pdf sur le site https://www.oracle.com/openworld/index.html (onglet Sessions / Content Catalog)


OOW 2014: Day 2

Doug Burns - Wed, 2014-10-08 03:02
Having been awake for so many hours, I was along at Oak Table World bright and early because :-
1) I wanted to make damn sure I got one of the T-shirts. The courier had let down poor Kyle Hailey so they weren't there at first, but I accosted him to remind him that I was one of the first group of people there ;-) (Oh, and it worked later when they turned up.)
2) Because Mogens Norgaard was on first with a 30 minute opening talk. Mmmm, at 08:30? Who came up with *that* moment of scheduling genius?! LOL ... Sure enough, Kyle had to implement a last-minute schedule change and Riyaj Shamsudeen helped out by stepping up to deliver his 9:00 slot 30 minutes early. 
Which was a shame for those who showed up at 09:00 and missed the first half of his In-memory Internals presentation, which I loved. Riyaj always works at a deep level but in those areas that are practically important, rather than just showing off his smarts!

I picked up a few extremely useful things from this presentation but I think the most important one was the journaling area used when rows in the standard row-orientated buffer cache have been updated. Which, for starters, means that only 80% of the allocated memory will be available for your original data. Not a problem, but worth knowing.

What really jumped out at me though was when he discussed how the number of updated rows could affect the optimiser's decision to use In-Memory or not. I might not have explained that very well, but I believe the effect would be that the optimiser is likely to flip between using In-Memory or not depending on quite a few variables. Which means one thing to me. Potential Execution Plan instability. I'm not sure how Oracle could get around this because cost-based decisions are the sensible approach but I foresee lots of new performance analysis and tuning opportunities! Not quite "flick a switch and it just works", but who would ever believe that kind of thing anyway?

Great presentation, though. Exactly what Oak Table World is all about so thanks to Kyle Hailey and the various sponsors () and speakers for making it happen!
When Mogens eventually showed up, he was on top form for his enormously entertaining Conference Opening where he delved into that new Big Data thingy. The strange thing about his presentations is that although they're very quotable, I always find I've been enjoying it too much to remember a damn thing he said! LOL But I managed to have many interesting talks with him later in the week about how unstoppable this Big Data thing is for those who need it. You could question who really needs it, but I personally remember the days of 'why would anyone need their own personal computer' too.
Next up was Andy Mendelsohn's Database General Session in an extremely frosty Marriot. I've become more of a fan of air-conditioning over the past 3 months but this was ridiculous! The presentation was very cloudy at first, then came the In-Memory stuff including Maria Colgan giving the cool demo which I've seen before but seems to have been polished up. The other thing that struck me for the first time in this presentation was just how much better Oracle's new slide template is! As anyone who has used it would confirm, the old one was *very* red and blocky and intense and the new one is so much cleaner and spacious and uses colours that don't kill your eyes. I thought the difference was staggering and actually found myself wanting to look at them for a change! ;-) But, on the whole, it was a relatively sober and honest presentation without any great announcements, but plenty of focus on delivering the meat of the previous year's announcements.

Judge for yourself. No need to go to San Francisco!
Then I was straight over to the first Real World Performance group presentation with Andy Holdsworth and Graham Wood talking about some of the higher level application design issues they have discovered via AWR reports. But first they kicked off with their usual dose of performance analysis and design reality, reflecting on the daft way that customers approach performance (and those last word are mine, based on my own experiences). 
They talked about the obsession people seem to have with identifying and treating narrow symptoms of problems that are, in reality, application design problems that need to be treated from the top down in order to relieve the low-level symptoms.
For example, right at the top of the report is the number of sessions. Imagine 3,300 sessions on a 32 core server. Well you don't need to because this was an AWR report from a real system so no imagination is necessary. Does that make any sense to anyone? Then why do we still see that kind of thing all the time? 

... or how about finding open_cursors set to 2000? A per-session limit of 2000 cursors? As Graham pointed out - good luck keeping track of the state of all of those! As soon as you stop and think about these things sensibly, you realise that it's almost certainly a sign of an application leaking cursors. 

There were lots of similar examples but the interesting overall approach that I would say they were illustrating is something that I tend to do when I first arrive at a new client site and I've watched other experienced Oracle techies do the same.

An AWR report is not just the top 5 timed events and the sections at the top are a pretty good description of the actual system workload which, in turn, can tell you a lot about the application design. Then, based on potential application design issues, you can drill down into the report and look at later sections to see where all those leaked cursors or transaction rollbacks or (whatever) ... are coming from.

Updated Later: As Toon Koppelaars highlighted on Twitter later, you can see this version of exactly what I'm talking about here, for free. I should hang my head in shame because Andrew and Graham made a point of all the RWP videos being available online here. Watch and enjoy!

Lucky boy that I am, I was able to retire to the comforting surroundings of the Thirsty Bear to continue the conversation about all things performance related with Graham and JB, much of the conversation being me whining about why people don't use the *full* range of tools that come with the Diagnostics and Tuning Packs that they've paid Oracle good money for. That's why I've been slowly developing a presentation on that very subject. 

Then it was back to Oak Table World to catch Greg Rahn talking about all that Hadoop stuff *again*! :-) Even though I only caught part of the presentation, I do keep managing to pick up bits and pieces on the subject although I wonder when it'll become relevant to my day to day work. Probably whenever I'm too late to the party, as usual ;-)

But my main reason for showing up was to see Kevin Closson talking about using SLOB in some less obvious ways. Because SLOB is a good all-round Oracle workload generator, it shouldn't be seen as simply a tool for testing storage performance and that's probably it's main strength. Kevin is always a great speaker and I find listening to him a very different experience to reading his blog, but I'm not sure I can put my finger on why. Oh, he also had the most ridiculously bright SLOB buttons! (As I found out by making the mistake of looking to closely at it as I tried to switch it on ;-))

At some point, all of the slides for the Oak Table World presentations should be available on the site, so keep a look out for those! (Oh, and I got my T-shirt which is deeply cool and was one of the few items of non-ACE swag I managed to pick up all week)

From there on, it was more or less party all the way.

- First quiet beers and snacks with lots of Oak Table and Oracle types.

- Then my very first ever Customer event that wasn't for a specific technology area, but a sales region. Man, *that* was a mistake! Suits *everywhere*! ;-) but I suppose it was useful to build contacts with the senior support managers in my new region. 

- Instead, I headed towards the OTN night in Howard Street (until I realised I'd just dropped my bag with the entry ticket back at my hotel room)

- So instead I landed at one of the events of this and any other OOW - The Friends of Pythian Party'. As always, beautifully-organised, very generous on the liquid refreshments and the coolest crowd in town. Just because I find myself thanking Vanessa Simmons, Paul Vallee and all of the Pythian crew every year doesn't make it any less sincere.

I have to be honest, though, and say that the highlight of the night for me was spending much more time with Kevin's punchy, beautiful and fun wife Lori. If you think Kevin's smart, wait until you meet his wife! There's a lady who can hold her own and make me chuckle :-) Problem is that I think she's used to scaring people but us Scots don't scare so easily ;-)

It was a great night anyway, as always, and although this is entirely unconnected to the Pythian party but might have had a *lot* to do with jet lag, I didn't wake up until 11:45 the next morning :-(

Upgrading PeopleTools with Zero Downtime (3/3)

Javier Delgado - Wed, 2014-10-08 02:22
In the past post, we covered the approach we followed to have both PeopleTools versions running at once. In this post we will cover the issues we faced and how we got around.

Missing Tables

Our approach for identifying tables was not perfect. By examining the traces and logs, we missed some tables that were directly impacted by Application Designer (we did not enable tracing while copying the PeopleTools projects as it would have taken too much time to complete, so we did not have those tables in our lists). Fortunately enough, we only had to adjust the list of tables a couple of times and we were up and running.

Sequences

For performance reasons, the customer had created Oracle Sequences instead of using the PeopleTools auto-numbering approach. In order to have the sequences in sync between both databases we followed the same approach we applied to the tables, deleting one of the sequences and creating a synonym pointing to the sequence in the other instance.

Performance

Most of the performance in running SQL statements is impacted by how the database builds the execution plans. The execution plans are generated taking into account the database statistics. When using DB Links, the database on which the SQL sentence is executed does not have statistics information of the linked tables, so the execution plan may not be optimal. This is particularly true for mixed queries involving local and linked tables.

During our testing, we identified a few performance issues which required to make the table physically present in both environments. This was not always possible, but for tables that are quite unlikely to change (for instance Business Unit options), it was definitely an option.

Data Types

Some of the data types used by PeopleTools changed from one release to the other. In our case, both timestamps and memo fields (LONG to CLOBS) had changed types. If the table is linked, only one of the data types could be used. In this sense, we were fortunate, as the data types used by the target PeopleTools release worked correctly in the previous release, so we could use the new ones.

Commit

In earlier releases of the Oracle Database, each insert/update/delete operation done against a DB Link table would commit immediately (and implicitly). This would pose a serious integrity issue. Luckily, both the source and the target database releases supported global transactions (which means that the data is committed when the system explicitly calls the commit command).

Conclusions

In the end, our attempt was successful. However, as you can see from the issues we faced, it cannot be concluded that it will work for all types of PeopleTools upgrades nor for certain customer requirements. Still, I thought it was a creative approach and that's why I decided to share it in this blog.

General Availability announcement for Oracle Application Management Pack 12.1.0.2.0 for PeopleSoft

PeopleSoft Technology Blog - Tue, 2014-10-07 23:48


Oracle PeopleSoft is pleased to announce the General Availability of Oracle Application Management Pack 12.1.0.2.0 for PeopleSoft

Oracle Application Management Pack, or AMP, is also known as Oracle PeopleSoft Plug-in for Oracle Enterprise Manager. Oracle PeopleSoft Plug-in Is licensed as part of Application Management Suite for PeopleSoft.

This release of Application Management Pack supports PeopleTools Releases 8.54, 8.53 and 8.52.

Here are some of the new features of Application Management Pack for PeopleSoft:

System Management Enhancements

Administration/Configuration/Monitoring:

· New ADF Based UI: All the Administration/Configuration and Monitoring UI is available now on ADF UI with advanced dashboards.

· Improved PeopleTools System Discovery: Allows user to discover the PeopleTools Database from one of the PeopleTools/Tuxedo Domain Targets.

· New Aggregate Target Homes: Aggregate Target Home pages eases Inter Target Navigation for users. Also comes with new menu based navigation, helping users to navigate within PeopleTools Targets with less hops.

· Configuration Comparison Templates: Configuration comparison templates allow customers to compare configurations of two or more PeopleTools environments.

· Diagnostic Framework: Enables users to collect extensive diagnostic log, leading to faster resolution to Target Discovery/Configuration and Monitoring issues.

· Performance Monitoring: PeopleTools customers will now be able Proactively monitor the targets using new JMX enabled Monitoring Metrics.

Change Management Enhancements

· Cloning: Supports cloning of Web Server and Application Server Domain Configurations.

Release Details

Downloading PeopleSoft Application Management Suite

PeopleSoft Application Management Suite can be downloaded from Oracle Software Delivery Cloud by using following instructions:

1. Go to the Oracle Software Delivery Cloud site.

2. Choose a language and click Continue.

3. Answer export validation questions.

4. Select PeopleSoft Enterprise from the list of product/media packs.

5. Choose Respective Platform and click Go.

6. Select Oracle Application Management Suite 1.0.0.5.0 for PeopleSoft from the list and click on Continue.

7. Select PeopleSoft Application Management Plug-in 12.1.0.2 for Oracle Enterprise Manager 12c and download.

Note: Starting with Enterprise Manager 12c customers can download and install the application management pack as Self Update from EM store. For more details on the EM Store and the Self Update feature, see the Oracle Enterprise Manager Cloud Control Administrator's Guide.

Supported Releases and Platforms

The following Oracle Enterprise Manager Cloud Control releases, PeopleTools releases, and platforms are supported:

  • Oracle Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3.0)
  • Oracle Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4.0)
  • PeopleTools Release 8.54
  • PeopleTools Release 8.53
  • PeopleTools Release 8.52
  • Supported Platforms: Oracle Application Management Pack for PeopleSoft is available on Linux, IBM AIX, Oracle Solaris, and HP-UX Itanium and Windows. For a complete list of supported platforms and operating systems, refer to the certification pages of PeopleTools. Also, for a complete list of Enterprise Manager supported platforms and operating systems, refer to the certification pages of Oracle Enterprise Manager.

Installing Oracle Application Management Pack for PeopleSoft Release 12.1.0.2.0

Installation and Implementation Guides are available on OTN and on OSDC.

  • PeopleSoft Application Management Plug-in 12.1.0.2.0 for Oracle Enterprise Manager 12c Install Guide is available on Part No - E57421-01.
  • PeopleSoft Application Management Plug-in 12.1.0.2.0 for Oracle Enterprise Manager 12c Implementation Guide is available on Part No - E55343-01.
  • The Oracle Application Management Pack PeopleSoft can be downloaded and installed by using the Self Update feature of Oracle Enterprise Manager.
    Please refer to the following documentation to understand more about the Self Update Feature:
    Oracle® Enterprise Manager Cloud Control Administrator's Guide

New Alta UI for ADF UI Shell Application

Andrejus Baranovski - Tue, 2014-10-07 23:14
I have applied new Alta UI for customised ADF UI Shell application. Customised version of ADF UI Shell is taken from my previous blog post - ADF UI Shell Usability Improvement - Tab Contextual Menu. Old application with new Alta UI looks fresh and clean. Runtime performance is improved - ADF transfers less content to the browser, this makes application load and run faster.

Here you can download my sample application with Alta UI applied to ADF UI Shell - MultiTaskFlowApp_v12c.zip.

All three ADF UI Shell tabs are opened and Master-Detail data is displayed in this example:


New style is applied for LOV component and buttons, making all buttons and controls more visible and natural:


Customized ADF UI Shell supports tab menu - user can close current tab or other tabs:


There was a change in 12c related to the tab menu, we need to set align ID property differently. You can see this change in ADF UI Shell template file - Java Script function gets tab ID to align directly from component client ID property:


Alta UI is applied simply by changing a skin name in trinidad file:


This hidden gem was packaged with current JDEV 12.1.3 release, you don't need to download anything extra.

Bringing Clarity To The Avalanche Part 1 - OOW14

Floyd Teter - Tue, 2014-10-07 15:50
Since the prior post here, I've had some people ask why I compared Oracle OpenWorld this year to an avalanche.  Well, to be honest, there are two reasons.  First, it was certainly an avalanche of news. You can check all the Oracle press releases related to the conference here (warning: it's pages and pages of information).  Second, I'm tired of using the analogy of sipping or drinking from a firehose...time to try something new.

So let's talk about some User Experience highlights from the conference.  Why am I starting with UX?  Because I like it and it's my blog ;)

Alta UI

OK, let's be clear.  Alta is more of a user interface standard than a full UX, as it focuses strictly on UI rather than the entire user experience.  That being said, it's pretty cool.  It's a very clean and simplified look, and applies many lessons learned through Oracle's (separate) UX efforts.  I could blab on and on about Oracle Alta, but you can learn about it for yourself here.

Beacons

We all love gadgets.  I had the opportunity to get a sneak peek at some of the "projects that aren't quite products yet" in the works at the Oracle UX Labs.  Beacons are a big part of that work.  Turns out that the work has already progress beyond mere gadgetry.  The beacons were used to help guide me from station to station within the event space - this booth is ready for you now.  The AppsLab team talks about beacons on a regular basis.  I'm much more sold now on the usefulness to beacon technology than I was before OOW.  This was one of the better applications I've seen at the intersection of Wearables and the Internet of Things.

Simplified UI

I like the concepts behind Simplified UI because well-designed UX drives user acceptance and increases productivity.  Simplified UI was originally introduced for Oracle Cloud Applications back when they were known as Fusion Applications.  But now we're seeing Simplified UI propagating out to other Oracle Applications.  We now see Simplified UI patterns applied to the E-Business Suite, JD Edwards and PeopleSoft.  Different underlying technology for each, but the same look and feel.  Very cool to see the understanding growing within Oracle development that user experience is not only important, but is a value-add product in and of itself.

Simplified UI Rapid Development Kit

Simplified UI is great for Oracle products, but what if I want to extend those products.  Or, even better, what if I want to custom-build products with the same look and feel?  Well, Oracle has made it easy for me to literally steal...in fact, they want me to steal...their secret sauce with the Simplified UI Rapid Development Kit.  Yeah, I'm cheating a bit.  This was actually released before OOW.  But most folks, especially Oracle partners, were unaware prior to the conference.  If I had a nickel for every time I saw a developer's eyes light up over this at OOW, I'd could buy my own yacht and race Larry across San Francisco Bay.  Worth checking out if you haven't already.

Student Cloud

I'll probably get hauled off to the special prison Oracle keeps for people who toy with the limits of their NDA for this, but it's too cool to keep to myself.  I had the opportunity to work hands-on with an early semi-functional prototype of the in-development Student Cloud application for managing Higher Education continuing education students.  The part that's cool:  you can see great UX design throughout the application.  Very few clicks, even fewer icons, a search-based navigation architecture, and very, very simple business processes for very specific use cases.  I can't wait to see and hear reactions when this app rolls out to the Higher Education market.

More cool stuff next post...

Little script for finding tables for which dynamic sampling was used

XTended Oracle SQL - Tue, 2014-10-07 14:42

You can always download latest version here: http://github.com/xtender/xt_scripts/blob/master/dynamic_sampling_used_for.sql
Current source code:

col owner         for a30;
col tab_name      for a30;
col top_sql_id    for a13;
col temporary     for a9;
col last_analyzed for a30;
col partitioned   for a11;
col nested        for a6;
col IOT_TYPE      for a15;
with tabs as (
      select 
         to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,1))  owner
        ,to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,2))  tab_name
        ,count(*)                                                                    cnt
        ,sum(executions)                                                             execs
        ,round(sum(elapsed_time/1e6),3)                                              elapsed
        ,max(sql_id) keep(dense_rank first order by elapsed_time desc)               top_sql_id
      from v$sqlarea a
      where a.sql_text like 'SELECT /* OPT_DYN_SAMP */%'
      group by
         to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,1))
        ,to_char(regexp_substr(sql_fulltext,'FROM "([^"]+)"."([^"]+)"',1,1,null,2))
)
select tabs.* 
      ,t.temporary
      ,t.last_analyzed
      ,t.partitioned
      ,t.nested
      ,t.IOT_TYPE
from tabs
    ,dba_tables t
where 
     tabs.owner    = t.owner(+)
 and tabs.tab_name = t.table_name(+)
order by elapsed desc
/
col owner         clear;
col tab_name      clear;
col top_sql_id    clear;
col temporary     clear;
col last_analyzed clear;
col partitioned   clear;
col nested        clear;
col IOT_TYPE      clear;

ps. Or if you want to find queries that used dynamic sampling, you can use query like that:

select s.*
from v$sql s
where 
  s.sql_id in (select p.sql_id 
               from v$sql_plan p
               where p.id=1
                 and p.other_xml like '%dynamic_sampling%'
              )
Categories: Development