Friday, April 17, 2015

Weekend Learning: New A/R program for Month-end Close

If you did not get the chance to hear my co-worker's presentation (@viswavadlamani) during OAUG's COLLABORATE conference, you may have missed a new development from Oracle regarding the Account Receivables module at Month-end Close!  Have you ever had transactions which prevent the A/R period from being closed?  Have you had to open P1 SRs to engage Oracle during the Close cycle?  Visit the document on My Oracle Support "How to Setup the New Manage Accounting Exception Program in Receivables?" via note ID 1937611.1 for all the details on a new concurrent manager process which appears to wrap some of their known issue identification scripts in order to find these issues PRIOR to Close!

Thursday, April 16, 2015


8:30 AM - 9:30 AM - Samer Barakat - Getting Optimal Performance from Oracle E-Business Suite

Define the problem - where is the time going?  Identify the techs tack components in-play, refer to architecture Ex. Problem in wrong Linux library, which is not in the Oracle "stack"!
Gather the right data to analyze issue, 1121043.1 for Best Practices, get a "good" SQL trace -> time in the DB? -> time in SQL execution? -> a few bad SQLs?, enhanced performance diagnostics for EBS 1362660.1 -> Gather Diagnostic Data for Traced Session, monitor OS stats -> 301137.1 461053.1, TKPROF 39817.1, Trace Analyzer TRCA 224270.1, SQLTXPLAIN 215187.1, AWR -> $ORACLE_HOME/rdbms/admin/awrrpt.sql
Identify root cause
Search for solution
If it is a product issue, pass it on to Support/Development through MOS, do not just ignore it or deny Oracle feedback!
Try to identify temporary workaround until permanent fix!
If you have a bottleneck that is concurrency related, use global hash-partitioned indexes for hot leaf blocks which can be identified by AWR.
Recommendations about optimization:
Stay current - recommended performance patches 244040.1 &
Use optimal logging settings - FND: Debug Log Level set to Unexpected
Optimize Workflow Processes - 260884.1, 1129203.1
Run (research) $FND TOP/sql/wffngen.sql - I forget why Samer suggested this, but there was something about this optimizing workflow for you.
Research RAC affinity - this was something about getting SQL or processes pinning to a certain node and I need to do some research on it too.
Optimize Forms Processes
Optimize JVM Processes
Size the Middle Tier for Concurrency - JVM, forms, CM processes (especially Java programs)
There is a formula to calculate physical memory for oacore heap!
R12.2 1905593.1 and E22950 are good documents on MOS for sizing!
Optimize the Concurrent Manager - manage CM jobs lifecycle and CM managers - 1 or 2 managers per CPU cores, CM state data -> 842850.1 - 2GB reports.log! (that is in MY presentation too!), CM schedules, Workload Management Strategy
Tune init.ora 396009.1 & 216205.1 R12/11i
Huge Pages in Linux 744769.1
ORION - 727062.1
Optimize Backend Code Execution Path - pin top PL/SQL packages, check for cursor leaks, consider dropping old editions if you get to 25 in R12.2!
Gather Application Statistics - disable 10/11g automatic jobs, 1586374.1, analyze schemas at 10% as a general rule.
9:45 AM - 10:45 AM - Rusty Schmidt (me!) (@TheOracleEMT) - E-Business Suite R12: Application Lessons Learned for Support and Implementers

For the first run of this presentation, it was a pretty good experience!!  The only thing that tripped me up a bit was the room monitor did not kick the previous presenter out so I only had 5 minutes to set up and catch a breath, and that was when I realized that the notes of the presentation were not showing at all like they should be but by then I was already in it and thankfully I have done enough testing that I got through it!  I heard some really good feedback in the COLLABORATE app, and from some people afterwards, plus I saw lots of people scribbling notes down so I think it was a presentation that really had the 40-50 people engaged and hopefully will lead them to better patches/upgrades or at least to read MOS a bit more!  I did catch myself saying um a few times, and there was one thing I spaced on, so I will grade myself at a 9.5 and even though it was not a perfect 10 I am really happy with it!  Looking forward to giving this again for either OAUG or Oracle at the upcoming OpenWorld!!
11 AM - Noon - Werner De Gruyter (@Yoda_EM) & Courtney Llamas (@courtneyllamas) - Under the Hood of Enterprise Manager - A Troubleshooting Primer

I think honestly I misread this session, as I was expecting how to use EM12c to troubleshoot an issue/problem, but it was all about troubleshooting EM12c ITSELF!  Of course the Internet blowing up a bit about the new Star Wars trailer or my relief at getting my presentation done may have contributed to not paying attention a bit since Werner went WAYYYY into details I never dreamed of so I will look forward to getting the materials so I can learn about it on my own time.
EM12c is total cloud control!
4 key processes - notifications, data loading, jobs & tasks, and user interaction & real time monitoring.
Information flows are initiated by background processes (callbacks).
Beacons can be added so you can monitor responsiveness of EM over time - very meta because you are monitoring the monitor!
Use EMCLI to trace any UI - I think this is what he was saying there.
More memory in Java heap size with more targets, which sounds like a no duh kind of thing but it is good to mention anyways.
Default 150 sessions, based in Apache limits.

12:15 PM - 1:15 PM - Mazen Arar and Jake Westphal - Testing Oracle E-Business Suite Applications: Best Practices from Development

Testing challenges - schedule, scope, resource - optimizing any of these negatively affects quality!
Testing is 30-50% AT LEAST of your project.
Cost of fixing an error is greatest post release!
Methods for testing - Users, Process, Governance, Technology, Data
Users - theme based testing, exploratory testing (usage patterns, vulnerable areas, derived exploratory testing)
Process - Process Flow Testing
Governance - Role Based Testing (what, why, how), Use Cases, Security Testing (what, why, how)
Technology - Online Patching Testing (during upgrade, during OLP, after OLP), EBS architecture -> QA perspective
Data - Test Data Management, subsetting and masking
<manual ------ automated> - this is the typical range the "Methods for testing" above follows.
Do we test everything?  How much testing is enough?
Oracle Application Testing Suite - Oracle Functional Testing Suite for Oracle Applications - QA reduced automation time by 60%, need to redo 70% of your 70% with some changes
Demo recorded, pausing every few seconds to talk through it - which I thought was interesting how you could record a small 2-3 minute demo and make it last 5-10 minutes with talking through it.  I wonder what demos I will be doing in the future after seeing all of these going on this week!

Wednesday, April 15, 2015


8:00 AM - 9:00 AM - Mahesh Vallampati (@mvallamp) - The Data Architect Manifesto

Work w/users to get a data/business model.
Have a functional perspective!
Store comments!!  USER_COL_COMMENTS is something I have seen recently, but this is great reinforcement that you can store comments for tables or columns for quick documentation inside the DB!
Keep column names consistent across tables org_id vs organization_id.
Favorite alias is for FND_USER, just like me!
ANSI SQL - not fun, but highly portable so another reminder I need to brush up on this.
Who columns, created by/date, last updated by/date should be mandatory!
Build your own TAB_COL_DOMAIN_LOOKUPS similar to FND_LOOKUP_VALUES to add information!
Design for the analytic - capture all the data so it can be mined later, and make sure the data model is analytic friendly.
As Data Architect you should know more than:
Business analyst
Data is now big, we have to think bigger!
Do the math (financial) - large data sets cost money so justify it, or more importantly have the business justify it!
Not enough hardware to support bad business requirements - GREAT quote!
Be savvy about algorithms.
Gartner says users spend 15% of their time analyzing data, so drive the shift of that so users can spend more time analyzing!

9:15 AM - 10:15 AM - Simon Pane (@simonpane) - Oracle Service Name Resolution - Getting Rid of the TNSNAMES.ORA File!

Simon_DBA on MOS Community - a good reminder that I need to participate more on the MOS Communities!
Net Service Name - the name after the @ symbol.
Connect Descriptor - rest of TNSNAMES file.
Tnsping "connect string" and sqlplus system/oracle@"connect string" are both valid ways to connect without using a TNSNAMES file.
Oracle Net Services stops searching when it finds the first TNSNAMES file!!
Strace -e trace=open - shows how it looks for a TNSNAMES file, including a .shadow file locally which is a great way to mess with a DBA!!
TNSNAMES is unstructured because it is not in a DB!
Biggest TNSNAMES he had seen was 700 entries, audience member had 1100 which are both just crazy!!
Management techniques to centralize, but problems can propagate just as fast too.
IFILE can be used up to 4 times which is good to know, since I know we are using that in our environment.
"Old way" does not mean "best way"!
LDAP -> OID, AD, OpenLDAP, other options as well.
EZCONNECT and a Hybrid scheme are different ways to approach this as well - EZCONNECT is required for the RAC interconnect though!
Oracle published LDAP Schema for Oracle Net Services
Idea of having a backup TNSNAMES file - just as I was thinking about it!
Going into an LDAP system is secure because there are no passwords, only stuff that is already in TNSNAMES.
OID used just for this purpose, does not not need to be licensed, using WebLogic front end, new schema, maybe new machines?  Patching/upgrades are needed as well, so is it overkill just for this?
AD benefits - register DB via Oracle Tools (DBCA or Oracle Net Manager)
AD SysAdmin handles all the AD stuff (replication, HA. Patches)!
Critical part of network infrastructure so should already be up and available 100% of the time.
Very easy to setup, and you can find out more in MOS Note 1587824.1 - Configuring MSAD for Net Naming.
Need to work with AD SAs to install/configure, extra AD permissions, 11g clients NAMES.LDAP_AUTHENTICATE_BIND = YES, anon query may be required for Unix clients which could be a no-go in your environment.
OpenLDAP - free on different platforms, master-slave replication, easy updates with yum.
Simple initial setup but need root access, requires some basic Linux skills, must customize text files, no GUI but you can get Apache Directory Studio as a GUI.
All have bulk load options, command line searching, extraction to TNSNAMES.ORA via tool or command line!
Look in $ORACLE_HOME/bin/ldap* for files that are shipped by default already and in $ORACLE_HOME/ldap too!
MOS Note ID 1671486.1 - quick switchover of OID1 to OID2, will have to find out if there is another document for quick switchover of AD1 to AD2.
Not used for RAC interconnect or persistent connections.
Not every app may support it!
HR, HR. WORLD, HR.EXAMPLE.COM, ORCL - put all your aliases in the same line in TNSNAMES
Look up these MOS Note IDs for more details: 846822.1, 395525.1, 146485.1, 1336069.1
trcroute - Oracle Trace Route utility - Active Directory Explorer better than Active Directory Users and Computers!
ldapsearch is in $ORACLE_HOME already!
Introduces ldap.ora file on Linux which I had never seen before!

10:45 AM - 11:45 AM - Jared Still (@PerlDBA) - SQL*Net Troubleshooting - Where Do You Go after Tnsping?

TNS-03505 error, what do you do next?  Strace, sqlnet trace, permissions on TNS_ADMIN/tnsnames.ora
Strace man page -> can pass in CSV list!
/etc/tnsnames.ora overrides all other files because it is the first one found!
Do you have TNS_ADMIN set?
Tnsping ping can only tell you if the listener is up, not the instance!!
Tnsping //IP/junk works because it only validates listener on IP, not that junk is the right service name!
Show parameter service_name just to make sure what the service name really is, and it can be found in lsnrctl status as well.
Interesting script from Tom Kyte about who is connecting to your DB and I shared the tidbit I learned yesterday about V$DBLINK that I am very interested in checking out when returning to work!
Gv$session_connect_info - What is this view about?
Trcasst - new tool to assist with traces!
1550897.1 - Dynamic Oracle Net Server Tracing
$ORACLE_HOME/rdbms/mesg/oraus.msg - Need to see this and find out what is in this file!
19324874 bug - need to use 12c thick client so it throws out overflow packets.

Noon - 12:30 PM - Biju Thomas (@biju_thomas) - Using Virtual Box and Free Online Resources to Learn Oracle Database 12c

Oracle VirtualBox - suggested to have 16GB so you can run multiple VMs!
Free license for personal and academic use. - make sure you install the extension pack too! - Great resource! - Documents on the DB! - For if you want to learn APEX!
Oracle By Example in OLL will walk you through many different things.,, - are more links to get even more knowledge!

2:00 PM - 3:00 PM - Various - OakTable: TED-Style Lightning Talks

Kyle Hailey (@virtdata) talked about DevOps!
Gene Kim - The Phoenix Project a good book that he has read 3 times!
The Goal - book - improvement not made at the constraint is an illusion - great line!
Kellyn Pot'Vin-Gorman (@DBAKevlar) talked on getting SQLT to work w/AWR warehouse
Needed to change the driving package so it will accept the DB name, then look it up.
Pete Sharman (@SharmanPete) spoke a bit about Snap Clone.
PROD -> masking & subsetting -> test master DB.
Missing link - application level cloning!
Pre/post/SQL clone scripts.
Jonah Harris (@oracleinternals) was speaking about alternate DB software!
We learned that MeetMe does 1TB relational calls a day, 30TB NOSQL calls a day!!
Alex Gorbachev (@alexgorbachev) talked about #100miles in 24/26 hours (plus overshared a bit)!
Begin with the end in mind.
Mind is the enemy!
Keep calm and carry on.
Believe. Decide. Do. - but do not be stupid - from Cary Millsap

3:15 PM - 4:15 PM - Raj Garrepally - PeopleSoft Application and System Monitoring Basics

This session was more basics about system monitoring, and maybe less about PeopleSoft monitoring than I wanted but still I was able to get something out of the only Quest session I have visited at the conference!
What to monitor?  Everything, and breaks this down further to monitor the DB, app, web tiers individually.
PeopleTools-> Integration Broker -> SOM-> Monitoring -> Asynchronous Services
paqrydefn table
He monitors the number of sessions on each web tier server because he saw degradation in service after 75 sessions per server.

4:30 PM - 5:30 PM - Brian Bouchard - Understanding the Asset Tables and how to capture data

Core Asset tables:

FA_ADDITIONS -> Additions
FA_ADDITIONS_TL - The last two tables are FA_ADDITIONS split up because of Multi-org!
FA_BOOKS -> Fixed Asset books
For last two tables you need to use TRANSACTION_HEADER_ID_OUT and DATE_INEFFECTIVE = null to find the last values for the assets.

Depreciation tables: -> populated after running Depreciation job


FA_ASSET_KEYWORDS - CCID is not CCID from the GL tables!

Other key Asset tables:


GL tables:

GL_JE_LINES -> Must use GL_SL_LINK* columns to link back to SLA!

Other important tables:

HR_EMPLOYEES - I wonder why he does not link to PER_PEOPLE_F instead, so will need to research myself at work.

Key FND tables:


Tuesday, April 14, 2015


9:45 AM - 10:45 AM - Craig Shallahamer (@cshallahamer) - Optimizing Memory Serialization Control (Latches And Mutexes)

Firefighting Friday webinars for free at!
Memory is not a linear construct which he showed with 3D models!!  I thought I was looking at DNA strands!!
Serialization is death - thought this was an interesting idea!
Relational structure is controlled through locks (enqueues) - app locks under app developer control, data dictionary locks under control of Oracle kernel developers.
Memory structure access is under the control of Oracle kernel code architects - buffers controlled by pinning and sometimes latches, memory lists controlled by latches and mutexes.
Module -> CS control structures -> MS memory structure
"Spin and sleep cycle" did it get latch/mutex?  No?  Keep trying!
Processes either want to consume CPU or they are consuming CPU - sounds obvious, but I never thought of it that way before!
Pin event is backing off because a latch was already given.  Interesting!
When he sees a new wait event he wonders what is going on!  So do I!! script is a free download to see what the CPU is doing breaking it down to the kernel modules w/Frits Hoogland so you know it will be awesome (it looked like it)!
Need to understand the latch/mutex algorithm and be able to detect significant latch/mutex contention
Understand: why it is being requested so often, and why it is being held so long.  Great boil down of a concept!

11 AM - Noon - Suzanne Strasser (@sjstrasser) - Database Links: Best Practices

Public DB links to schema owner users is dangerous!
Fixed user link - includes username and password, stored in SYS.LINK$ which is unencrypted prior to 10gR2.
Connected user link - anonymous DB link, local and remote users are the same, with same password, remote user must have CREATE SESSION privileges.
Use caution if you want to connect DEV to PROD with a DB link.
Current user link- requires Oracle Advanced Security Option so you can use current_user in your DB link connection string.
Invoker vs. definer rights was a great example of something I think I saw from Tom Kyte about who can run a package.
Shared DB link - must be authenticated by user with CREATE SESSION.
Creating a DB link in another user session - audience member piped up saying you can use a proxy DB link to connect to SCOTT without being able to connect to SCOTT as all which sounds like something to look into going forward.
GLOBAL_NAMES - when set to TRUE, link name must match remote DB name.  Good to know!
OPEN_LINKS - another parameter you need to look at.
ORA-02020 - SELECT query using a DB link leaves the connection open.
V$DBLINK - You can use this to see the current open DB links!  I never knew about this!  I smell another proactive alert coming up!
DBA_DB_LINKS, USER_DB_LINKS, ALL_DB_LINKS - The usual suspects, but good to remind people these tables are out there!
ALTER SESSION propagates to any open DB links you have open!!  Did NOT know that!!
DRIVING_SITE hint - can define only 1 table in the hint, but can help if you have to have to make the driving table be the remote table you have instead of the local table if it is smaller.
Insert via DB link causes wrong results - patch 15894143.
Patch 15931910 for ORA-19505 with PDB/CDBs if you are using this on 12c.

12:15 PM - 12:45 PM - Tim Quinlan - Extreme Availability Using Oracle 12c Features

Since we had a sit down lunch, instead of the box lunch we had yesterday, unfortunately I missed this session but it sounded like a really good one so I am a bit sad I missed it!

2 PM - 3 PM - Christina Blincoe - Advancing Your Career without a "TITLE" – Find Your JOY at Work

This ended up being a short session, but one of the opening lines sums up the presentation: Joy is your own definition, and more than happiness which can be temporary! - inspirational writer - This site will measure your strengths, and then tell you why you should focus on them more!
Success magazine is one suggestion that she gave us to get some regular tips about being successful/positive, and not only did nobody in the audience say they read it, but she actually gave out a year-long subscription to it for one lucky session-goer!

3:15 PM - Arjen Visser - The 3 Fundamental Principles of Oracle Replication

Founder of @dbvisit
Physical and logical are 2 types of replication.
Physical - 1:1 copy, block level (redo), standby DB, best suited for DR.
Logical - separate DBs kept in sync with SQL statements, subset of data is replicated, cross platform/version/DB.
Trigger based/redo log are 2 ways to do logical replication.
Redo log -> LCRs -> SQL statements -> applied to target DB
Three principles of replication:
1. Conversion process
Set based SQL operations on source are changed to row by row SQL changes on the target DB.
2. Identification
For data to be replicated, each row in source must be uniquely identified (do not need primary key).
3. Conflicts
Warns of data divergence and lost updates, but your tools may differ on how to deal with conflicts.
Prerecorded demos!  Great idea!  Work out all the kinks and make sure you do not lose valuable time during the session!

4:30 PM - 5:00 PM - Deiby Gomez - (@hdeiby) - Oracle Indexes: From the Concept to Internals

Unfortunately my phone died just as this one started so I could not take notes during this one!!  The session was centered around some of the concepts you can find in the Oracle Database Concepts manual in Chapter 2 and 3, so if you are interested in this I would go back to that manual and brush up on some of your knowledge.

Monday, April 13, 2015


8:00 AM - 9:00 AM - Erik Wahl (@erikwahl) - Keynote

UNthink was not something I was looking forward to, but I must say that I am a believer in what Erik has to say because he was SO passionate about getting "outside the box" that it really was a breath of fresh air!!

9:15 AM - 10:15 AM - Mike Donovan (@dbvisitmike) - The DBA as Linchpin, Not Roadblock. Fast Track Your Career in 60 Minutes

Mike started off saying how his presentation was kind of meta - not about the work, but how to address the work and that was pretty true but still awesome!
Cruise ship analogy with how much work the engine does, but nobody pays attention to it, compared to how much work a DBA does with how much nobody thinks about that either.
Complexity and uncertainty
Oracle DBA blog 2.0 -
DBA stereotypes - territorial, isolated & inaccessible, rigid & distrusting - Do not be this stereotype!
Unique potential in the role! -> Lynchpin book, sounds like worth a read.
Exert emotional labor, invent, lead, connect, happen, create, delight, challenge, love their work are all positive spins on the job!
Demands on the DBA:
Technology - ASM, cloud, virtualization
People - more people, administrator
Business - conflicting demands, cost cutting
The job is more difficult than ever so you can be an indispensable DBA which is an island (holds on to everything) or stream (shares everything, delegates).
DBA.rtisan - DBA is now a craft, an artwork!
Core skills + communicativeness + creativity + resourcefulness
Well ordered, procedures, pleasing
Practical suggestions:
Get certified
Learn how to code
Write & speak
Know your business - A good resource for learning how to code!

10:30 AM - 11:30 AM - Abhay Kumar and Divya Shampur - Weblogic 12c - Top 12 Fundamental Tips to Boost Your Weblogic Server Performance

After giving an absolutely crazy reason for being 15 mins late to the room, so a total 30 minutes late since they were not there when the previous speaker ended, Abhay got down to business and gave a pretty decent presentation.
Good design, good implementation gets you good system performance - performance tuning is not a silver bullet - do not eliminate all bottlenecks -> sounds a lot like Cary Millsap!
Performance objectives depend on the number of users as well as the number and size of requests.
Amount of data and consistency is very important too!
Determine target CPU with testing so you do not wind up pegging it anywhere below peak load.
Monitor data transfers across the network - I thought this was a pretty good lesson!
Use WebLogic clusters for scalability and load balancing.
Tune the OS since it might not release sockets, adjust TCP wait_time value.
Tune JVM focusing on heap size and GC (Garbage Collection).
Use Work Managers to optimize work - I need to see if we have this in one of our new WebLogic instances!
Tuning network I/O - picking right muxer (kind of lost on this, but a good question to be asking folks back at the ranch).
Tuning network channels - it is possible to get a different QoS (Quality of Service) on the same platform.
Tuning WebLogic file store - it is usually faster than JDBC store since there is no network traffic!  Good to know!
Tuning data sources - set Initial Capacity to Maximum Capacity, cache JNDI lookups
Tuning WebLogic JMS
Tuning Class and Resource Loading - using class caching and filter loading
Plan for server capacity
Admin Console -> Monitoring -> Threads -> Core Dump instead of doing OS level core dumps.
JRockit Mission Control - out of box, no price attached!
Node Manager helps manage uptime with monitoring and automated restarts
WLDF - Diagnostic Framework

12:00 - 12:30 PM - Bobby Curtis (@dbasolved) - Exadata Exachk and Oracle Enterprise Manager 12c: Keeping up with Exadata

Check out these MOS notes 1070954.1, 757552.1, 1110675.1
Environment changes
Start Exachk as a daemon with ./Exachk -d start and then call it with ./Exachk -daemon -a
You must "force" the agent to collect Exadata metrics!

12:45 PM - 1:45 PM - Sandra Vucinica and many others - OAUG E-Business Applications Technology Stack SIG - Visit the SIG home page and sign up!
EBS patching - Last year with one update there were 37 Java updates and 4 of them had 10.0 CVSS scores!
403537.1 - Security MOS note
Security AMP plugins for EBS will check these automatically for you.
AD and ADTXK delta 6 really just delivers new features for online patching so you should not need to redo your business process testing!

2:00 PM - 3:00 PM - Dan Norris (@dannorris) - Oracle Exadata Technical Deep Dive: Architecture and Internals

MAA team integrates the different Oracle technologies so each team can focus on doing what they do best, and this group tests the intersection of technologies in their labs under real situations!  Pretty cool!
X5-2 overview since it is new, and I thought with a 50/50 mix of people that had Exadata and that did not that this was a good review presentation but it was not the "deep dive" I was looking for even if I did find it interesting.
New Extreme Flash Storage Server, replaces high performance drives for no actual price increase.
X4-8 has some built in support for In Memory.
ZDP RDSv3 is a network transport protocol that has low network overhead and is used in the InfiniBand switching SOFTWARE Oracle provides so buying your own InfiniBand HARDWARE will not get you the same benefits without that other piece of the puzzle.  Important to know!
Can expand existing racks with newer technology nodes (X2-2 having an X5-2 added along side it).
When he got to the slide about the software upgrades with Exadata, it felt like what I saw in Denver.
I am also wondering if we need to have Exadata in our DR, and he was not sure if Platinum Support customers need to have it in DR so he will follow up on that for us.
Oracle VM is an option for Exadata but you need to reinstall so it is very involved and risky! supports a PDB snapshot with a sparse diskgroup.
IM Fault Tolerance with X5, memory is mirrored to other nodes which in the long run just means that Oracle can keep selling you more nodes to get a little more cash.  :}
DBMCLI is a new feature for monitoring on DB nodes!
FIPS 140-2 security compliant w/smart scans.  What is FIPS 140-2?  That is what I want to know now!
The MAA group now has posted their information up on -> Engineered Systems
You can also visit
If you want to be part of the Exadata SIG then visit this site too:

3:15 PM - 4:15 PM - Jim Czuprynski (@jczuprynski) - A Smart Optimizer Gets Even Smarter: New Histograms in Oracle 12cR1

In and before, you could only have 254 histograms, but after you can have 2048 histogram buckets!
Dba_histograms and dba_tab_col_statistics shows the system generated buckets from gather stats - another good reminder to be looking at (proactively alerting on) these tables for creation and/or drift!
12.1 top-frequency and hybrid are 2 new types of histograms.
Height-balanced histograms is a legacy histogram now!
Passing in anything for sample_size in DBMS_GATHER_STATS will make the DB generate a height-balanced histogram!

4:30 PM - 5:30 PM - David Gilpin - Oracle Linux and Oracle VM Strategy, Update, and Roadmap

I wanted to go to this one, but instead Jim and I got chatting about some things so I did miss out on this but I will try to find the slides online this week!

Sunday, April 12, 2015

OAUG COLLABORATE 2015 - Day Minus 1

Since today is a travel day for a lot of people, which is why my OEM session started at 10:30 AM and not 9:00 AM when it actually started, and the Opening Keynote is tomorrow, I am calling today a pre-conference day!!  Yet that does not mean we rested on our laurels at all though!

10:30 AM - 1:00 PM - Kellyn Pot'Vin (@dbakevlar), Courtney Llamas (@courtneyllamas), Warner De Gruyter (@Yoda_EM) - Everything I Needed to Know About Enterprise Manager I Learned at COLLABORATE - Hands-on Lab

Simply put, the EM12c lab was amazing!!  If you get a chance to experience this, take the opportunity to get outside your comfort zone and learn about the OEM application!!

1:00 PM - 2:00 PM - Debra Lilley (@debralilley) - Understanding User Group and Oracle Programs

Debra had some technical issues but got through it!
CIO Advisory Board?!?  First time I ever heard of this, and I wonder who is on it!
Early Customer Programs - While this is cheaper, and you can go to Oracle for help, challenges await.
Oracle does not run any user groups, they are independent and can change minds at Oracle!  Remember how I said Oracle does not run any user groups?  Well the IOUC IS an Oracle user group they own!  This is a council of the other user groups and helps interface with Oracle!
Debra is part of EOUG which is a regional user group, and this opens up some more discussion around regional groups.

2:15 PM - 3:15 PM - Brent Bent (@BrianBent) and Michael Barone - OAUG Archive & Purge SIG

ILM means Information Lifecycle Management, not Industrial Light & Magic!  :}
You have to remember this is a limited subset of data gets purged from, as not all tables or data can get targeted for archive or purging.
There is a Steven Chan blog post about 12c purging features out there, and I will update you when I find it!
Refer to Oracle document B12270-03 Chapter 8 for information on Archiving and Purging for the General Ledger module!
GL period has to be Permanently Closed, data cannot be reloaded!
Reminder to rebuild indexes periodically!
LOTs of AP tables compared to just a couple for GL.
Refer to Oracle document A81018-02 Chapter 10 for information on Archiving and Purging for the Accounts Receivable module!
Refer to Oracle document E13581-04 Chapter 10 for information on Archiving and Purging for the Projects module!
Check out the new Archive Purge portal in 12.1 under OAM -> Purging/Critical.
MOS Note ID 110168.1

3:30 PM - 4:30 PM - John Peters, Karen Brownfield, Bill Burbage and Vijay Shanmugam - OAUG Workflow SIG

There is a mobile EBS app for iOS and Android - 1642423.1 / 1641772.1
R12.2.4 changes proxy user access control to require UMX (User Management) on the System Administration end, and also changes how the users can do this in the application as well.
"Striping" different WF addresses based on OU is a potential feature down the road, which sounds like a very interesting idea!
There is a Workflow blog from Oracle at: and you can get up to speed with the workflow SIG at!

4:45 PM - 5:45 PM - Various - Meeting of the OAUG Members

Some awards were given out, which was fun to see Susan Behn and Elke Phelps win, and then there were a lot of questions from the audience that I thought the panel took seriously and gave good responses to them!

6:00 PM - 8:00 PM - LIGHT Night Club - OAUG Reception: Welcome to Wonderland

This was a pretty trippy event, with a lot of psychedelic lighting and Alice in Wonderland themed dancers but everybody seemed to be having fun and the food was pretty good too!  I know I'll enjoy my OAUG 25 baseball jersey!!