Keynote Session - Jenn Lim - deliveringhappiness.com
There was SO much good stuff here that it was hard to capture, so I recommend that you check it out for yourself BUT there were six keys that I thought were important to capture: commitment, revisit your core values, commit to transparency, purpose, build meaningful relationships, build the right team!
Get More from Data by Giving It to Your Customers - Bryan Brewer
This was interesting as Womble is a pipe coating company that doesn't own their inventory!
Internal challenge to find a dashboard with the following features: real time, integrated, secure, Internet enabled, summary and detail reporting, easy to install design/develop, and train/support.
External challenge to provide the customers the same thing!
What they did is come up with a combined checklist!
Looked at BI Publisher, OBIEE, OBIFS, Hubble (Insightsoftware.com) and finally used Hubble in their efforts.
Went from a report with over 900 lines to a dashboard with 4-5 visual reports that can be drilled down into!
JSON is not another YAML ("Yet Another Markup Language") - Coleman Leviter - @cleviter
Lightweight compared to XML.
Basic types - number, string, Boolean, null, whitespace
JSON data types are few and predefined, it has a simple structure-defining and document-combining constructs, order of the objects is insignificant, is very data centric
JSON doesn't have its own data type like XML does
JSON operators - json_exists, json_query, json_table, json_value, RETURNING
json.org
What you need to know about Oracle's password file - Michael Nelson
Password file is stored at the OS level so you can log into a down DB!
If you are on the server, be part of the ora_dba or dba group, but if you are not on the server, use the password file stored on the server!
Run select * from v$pwfile_users to see who is in the password file.
Password file is encrypted on the OS for security!
The file is usually located at $ORACLE_HOME/DBAs/orapw$ORACLE_SID
orapwd command - can be used on ASM only in 12c, only if ASM is set to 12c also
ORA-1996 indicates that the password file is full!
Oracle E-Business Suite SysAdmin SIG - @kansasdba and @michaelbrownorg
EBS 12.2.6 released on 9/2016, while 12.1 was released on 5/2009, and 12.3 is coming at some point.
EBS 12.1 supported until 2021!
My Oracle Support note ID 742060.1
https://blogs.oracle.com/stevenChan/entry/db121_extfee
https://blogs.oracle.com/stevenChan/entry/db112_extfee
Housekeeping
-Bylaws
-I'm now the Vice Chair!
Santiago Bastidas with Oracle gave us a presentation on EBS on Oracle Cloud.
This strategy uses both PaaS and IaaS.
Shift to the cloud is going to be assisted by automation!
DataBase Cloud Services (DBCS) is different from the offering for Exadata Cloud.
My Oracle Support note ID 1383621.1
My Oracle Support note ID 2066260.1
Lift and Shift - process of moving an existing EBS system from on prem to the Oracle Cloud.
Enhanced EBS management with EBS Cloud Admin Tool, adds SOA CS, OAM/OID instance, Mailer instance.
Roadmap - lots of things, but major takeaway is REST/SOAP enablement is being worked on in the Cloud!
McDonalds's journey to re-platform Java applications from IBM WebSphere to Oracle WebLogic Server - Chandan Bedi & Sundeep Khurana
I felt sorry for these gentlemen, as I was the only person in attendance and it was a pretty good presentation! Since I was the only person, it was kind of hard to take notes while they were talking directly to me, but it was a good overview of their project, pitfalls they encountered, and how they got the applications from one system to the other.
What's New in PL/SQL and EBR in Oracle Database 12c Release 2 - @BrynLite
Bryn started with a ten minute pep talk about using coding correctly, which seemed a bit odd, but what the hey, right?
Edition-based Redefinition (EBR) has been around since Oracle OpenWorld 2009 in 11gR2!
Brand new code coverage tool - start coverage, run the tests, stop coverage (there didn't seem to be a lot of detail about this, so I am going to have to go searching for this).
alter session set Plsql_Warnings = 'Error:All' - This was a new one for me, since I'm not a developer, but I'm squirreling this away for later if I ever need it!
It took about ten seconds to refresh his 12.2 PDB locally, so try to be destructive and curious if you can recover from it with little to no effort!!
Pl/Scope (what is this program?)
HPROF (hierarchical performance profiler) enhancements - identifies SQL "subprograms" with the SQL_ID (again, what is this?)
Accessible by is a feature that is pretty new, but not a lot of people in the room were using it.
New pragma allows an element of any kind to be marked as depreciated.
Showing posts with label AZNM. Show all posts
Showing posts with label AZNM. Show all posts
Monday, April 3, 2017
Sunday, April 2, 2017
COLLABORATE17: Pre-Day
Testing Oracle E-Business Suite Best Practices - Mazen Arar - 12:30 PM
"Change is constant" was on his first slide, and this is SO true these days for many of us!
Testing readiness means challenging facts.
A great insight that Mazen had was that QA needs to be proactive, as early as possible, even to listen.
Have the hardware on hand, including different versions of it.
Where/how do we start? Plan, Execute, Automate
Planning - what is the task on hand, what documentation is at hand? RCD (Release Content Document), FIAD (Functional Impact Assessment Document)
Scope - key business flows, impacted flows, usage patterns
Mark test flows with priority - basic, sanity check, detailed
Follow a testing methodology based on task - theme based, exploratory, role based, end to end flow based
Make sure to have well defined entry and exit criteria
Cloud testing - Shorter Release Cycle (automation), Rapid Addition of features, security, integration, multi tenancy
IoT testing - Complex Architecture, Complex data, security, validation, performance and scalability
Good practice - be creative/innovative, review results, learn from them, plan next cycle with a new flavor, improve scoping
Automation! Who can do it? Anyone. What do you automate? Critical and repeatable flaws. When should we? Now! Allows more innovation out of employees
There are several different applications for this in Oracle Application Testing Suite (OATS), Oracle Load Testing Suite, and Oracle Test Manager.
Oracle QA reduced their automation time by 60%!
Flow Builder application allows you to generate test scripts.
API and WebServices support in Advance Pack
Due to their own use of these applications, EBS patching won't break OATS.
If you are around at the conference, stop by Demo Booth 14 to see this in action!
Real- time Data Integration in Oracle E-Business Suite using Integrated Service Oriented Architecture (SOA) Gateway by Faraz Khalik with @DeloitteOracle - 1:45 PM
This was supposed to be a case study about transitioning to SOA, which was technically what was provided, but really what Faraz talked about was the solution/process that was put in place, not much technical information. This was kind of frustrating, but I'll check out the addendum in the whitepaper/presentation to see if there is any kind of technical information included.
Geo Land setup! - 3:00 PM
The coordinators of the Geo's had a blast getting everything set up for the OAUG members!
OAUG Geo Land! - 4:00 PM
This was even more fun than the setup hour was! The Arizona/New Mexico Geo had a cactus themed ring toss game, and a LOT of the OAUG members had a blast!!
OAUG Meeting of the Members - 5:30 PM
There were some awesome awards given out, and even had a sneak peek of an Oracle and OAUG survey which is going to be made public in a few days!
"Change is constant" was on his first slide, and this is SO true these days for many of us!
Testing readiness means challenging facts.
A great insight that Mazen had was that QA needs to be proactive, as early as possible, even to listen.
Have the hardware on hand, including different versions of it.
Where/how do we start? Plan, Execute, Automate
Planning - what is the task on hand, what documentation is at hand? RCD (Release Content Document), FIAD (Functional Impact Assessment Document)
Scope - key business flows, impacted flows, usage patterns
Mark test flows with priority - basic, sanity check, detailed
Follow a testing methodology based on task - theme based, exploratory, role based, end to end flow based
Make sure to have well defined entry and exit criteria
Cloud testing - Shorter Release Cycle (automation), Rapid Addition of features, security, integration, multi tenancy
IoT testing - Complex Architecture, Complex data, security, validation, performance and scalability
Good practice - be creative/innovative, review results, learn from them, plan next cycle with a new flavor, improve scoping
Automation! Who can do it? Anyone. What do you automate? Critical and repeatable flaws. When should we? Now! Allows more innovation out of employees
There are several different applications for this in Oracle Application Testing Suite (OATS), Oracle Load Testing Suite, and Oracle Test Manager.
Oracle QA reduced their automation time by 60%!
Flow Builder application allows you to generate test scripts.
API and WebServices support in Advance Pack
Due to their own use of these applications, EBS patching won't break OATS.
If you are around at the conference, stop by Demo Booth 14 to see this in action!
Real- time Data Integration in Oracle E-Business Suite using Integrated Service Oriented Architecture (SOA) Gateway by Faraz Khalik with @DeloitteOracle - 1:45 PM
This was supposed to be a case study about transitioning to SOA, which was technically what was provided, but really what Faraz talked about was the solution/process that was put in place, not much technical information. This was kind of frustrating, but I'll check out the addendum in the whitepaper/presentation to see if there is any kind of technical information included.
Geo Land setup! - 3:00 PM
The coordinators of the Geo's had a blast getting everything set up for the OAUG members!
OAUG Geo Land! - 4:00 PM
This was even more fun than the setup hour was! The Arizona/New Mexico Geo had a cactus themed ring toss game, and a LOT of the OAUG members had a blast!!
OAUG Meeting of the Members - 5:30 PM
There were some awesome awards given out, and even had a sneak peek of an Oracle and OAUG survey which is going to be made public in a few days!
Tuesday, April 12, 2016
COLLABORATE16: Pre-Day + Day 1
After weather delays leaving Phoenix, due to thunderstorms over Las Vegas, I missed a few sessions I wanted to attend on Sunday but I luckily was able to attend fellow Upgrade SIG Art Dowd and then make the Meeting of the Members! On Day 1 there was a lot to take in, so that has a much fuller download to share with you, but I am going to have to skim and give you the high level takeaways or MOS notes you should look up later - if you are an OAUG member look these presentations up later! Not a member but interested in some of the things I posted? Change that and sign up!
Upgrading to R12.2 - Lessons Learned and Tips That You Need to Know to be Successful - Art Dowd - o2works.com
Great point that there are 2 types of projects, technical and full "business-aligned", and there is an 8 piece plan to build a repeatable process for both of them.
269.1
461705.1
aaplcust.txt 889733.1
At least 3 iterations of upgrade before go live.
Add 50% time to previous 11i project for R12.
416699.1
12.2.2 is the Holy Grail of patching with 2 file systems - 1 run, 1 patch.
SYSTEM and SEED tablespaces double!
Going to the cloud? Need to adopt SaaS and PaaS, and a full reimplementation.
General Session - Trends & Technologies Shaping Your Future
The big takeaway here was only about 20% of companies are going to the Cloud, and most of the rest are not due to security and cost reasons.
Linux/UNIX Tools for the Oracle DBA - Tim Gorman - @timothyjgorman
Why CLI? GUI not supported, vendor support, automation and scripting.
Unixtools.com is a good resource.
Sar is really underneath what you see in OEM/TOAD!
Mpstat gives you information per CPU, can show a busy system for instance XTTS is single threaded no matter how parallel you make it - interesting!
Uptime and w give you uptime and user stats.
jstat shows JVM memory usage displays.
Dtrace.org is a free tool.
Architecting for the Cloud: Best Practices - Zeeshan Baig - @IamZeeshanBaig
What is Cloud computing? gMail has been SaaS for a while we just didn't realize it at the time!
Hybrid, private, public, community - different cloud deployment models!
Core concepts for Cloud, elasticity - allows you to scale up and out!
Business benefits of cloud - low up front costs, in time infrastructure, efficient resource utilization, usage based cost, reduce time to market.
Technical benefits of Cloud - automation, auto-scaling, proactive scaling, efficient development lifecycle, DR and business continuity.
Design for failure - remove single of failure, design for automatic recovery, graceful failures, consistent backup and recovery strategy, don't fix - start a new instance, avoid stateful sessions.
Decouple components!
Elasticity + parallelization = WIN
Productivity Enhancing SQL*Plus Scripting Techniques - Bert Scalzo - @bertscalzo
set linesize 512 produces a larger file than set linesize 256!
set trimout on is different when going to the screen.
Do not forget about the BREAK or the COMPUTE commands.
Dynamic scripting is the most important technique where you can have SQL producing other SQL to run!!
Oracle Database Networking Basics - Eric Siglin - @ESiglin
What is a DB? That is where we start, and if you do not know the answer go look it up. :}
Access challenges - must be connected, logging into the host is impractical, security challenges with DB.
What is a client? Anything that connects to a DB, even another DB!
Two ways to register performance stats: response time and throughput.
Shutting the listener down does nothing to current connections, only new connections - important to know!
Creating and destroying database session is one of the biggest things to ask the DB to do!
docs.oracle.com - Database Net Services Administrator's Guide (Part I: Understanding Oracle Net), Database High Availability Overview
OAUG E-Business Suite SysAdmin SIG Meeting - Various
Drew Chiaiese and David Heisler from Oracle joined us!
We went over and adopted the bylaws for the group and then I was put forward for Secretary of the SIG!
432.1
1939637.1
1584210.1
1581299.1 - 12.2 Information Center
1633974.2
793436.2 - Hot Topics
1580100.1 - MOS Accreditation
Arizona/New Mexico OAUG - Kickoff Meeting - Various (including Me!)
This was a really positive meeting!! There were individuals in attendance which had run groups in both states before, so I think we will have a lot of good information about what works and does not so going forward we will be more successful!
The Bad One In Your Crop - SQL Tuning Analysis For DBAs - Martin Klier - @MartinKlierDBA
If you can do it, submit abstracts for the DOAG conference in Germany, but even if you do not do that make sure to follow the hashtag #DOAUG2016 later this year!
SQL -> Syntax -> Semantic -> Library Cache check -> Optimizer -> Execution is a hard parse!
Soft parse avoids the Optimizer because it has been found in the Library Cache.
Great story about bad weather affecting DB performance, and something I have seen happen in person (not with bad weather, we never have that in Arizona).
Bind peeking is a harder soft parse.
Before you tune, analysis is mandatory!
Starts with "What's the problem?"
His style is to simplify your toolset by using AWR/ statspack, SQL*Plus, SQLci, SQL Developer, dbms_xplan.display_cursor; being suspicious; looking thoroughly; having situational awareness; using intuition (over time you will get the right approach 80%); going down to the second, one hour has 3600 seconds which is a static and common measurement.
Finding the culprit (unfortunately this is where I had to step out and take a phone call, but I cannot to download the presentation and finish it!)
Upgrading to R12.2 - Lessons Learned and Tips That You Need to Know to be Successful - Art Dowd - o2works.com
Great point that there are 2 types of projects, technical and full "business-aligned", and there is an 8 piece plan to build a repeatable process for both of them.
269.1
461705.1
aaplcust.txt 889733.1
At least 3 iterations of upgrade before go live.
Add 50% time to previous 11i project for R12.
416699.1
12.2.2 is the Holy Grail of patching with 2 file systems - 1 run, 1 patch.
SYSTEM and SEED tablespaces double!
Going to the cloud? Need to adopt SaaS and PaaS, and a full reimplementation.
General Session - Trends & Technologies Shaping Your Future
The big takeaway here was only about 20% of companies are going to the Cloud, and most of the rest are not due to security and cost reasons.
Linux/UNIX Tools for the Oracle DBA - Tim Gorman - @timothyjgorman
Why CLI? GUI not supported, vendor support, automation and scripting.
Unixtools.com is a good resource.
Sar is really underneath what you see in OEM/TOAD!
Mpstat gives you information per CPU, can show a busy system for instance XTTS is single threaded no matter how parallel you make it - interesting!
Uptime and w give you uptime and user stats.
jstat shows JVM memory usage displays.
Dtrace.org is a free tool.
Architecting for the Cloud: Best Practices - Zeeshan Baig - @IamZeeshanBaig
What is Cloud computing? gMail has been SaaS for a while we just didn't realize it at the time!
Hybrid, private, public, community - different cloud deployment models!
Core concepts for Cloud, elasticity - allows you to scale up and out!
Business benefits of cloud - low up front costs, in time infrastructure, efficient resource utilization, usage based cost, reduce time to market.
Technical benefits of Cloud - automation, auto-scaling, proactive scaling, efficient development lifecycle, DR and business continuity.
Design for failure - remove single of failure, design for automatic recovery, graceful failures, consistent backup and recovery strategy, don't fix - start a new instance, avoid stateful sessions.
Decouple components!
Elasticity + parallelization = WIN
Productivity Enhancing SQL*Plus Scripting Techniques - Bert Scalzo - @bertscalzo
set linesize 512 produces a larger file than set linesize 256!
set trimout on is different when going to the screen.
Do not forget about the BREAK or the COMPUTE commands.
Dynamic scripting is the most important technique where you can have SQL producing other SQL to run!!
Oracle Database Networking Basics - Eric Siglin - @ESiglin
What is a DB? That is where we start, and if you do not know the answer go look it up. :}
Access challenges - must be connected, logging into the host is impractical, security challenges with DB.
What is a client? Anything that connects to a DB, even another DB!
Two ways to register performance stats: response time and throughput.
Shutting the listener down does nothing to current connections, only new connections - important to know!
Creating and destroying database session is one of the biggest things to ask the DB to do!
docs.oracle.com - Database Net Services Administrator's Guide (Part I: Understanding Oracle Net), Database High Availability Overview
OAUG E-Business Suite SysAdmin SIG Meeting - Various
Drew Chiaiese and David Heisler from Oracle joined us!
We went over and adopted the bylaws for the group and then I was put forward for Secretary of the SIG!
432.1
1939637.1
1584210.1
1581299.1 - 12.2 Information Center
1633974.2
793436.2 - Hot Topics
1580100.1 - MOS Accreditation
Arizona/New Mexico OAUG - Kickoff Meeting - Various (including Me!)
This was a really positive meeting!! There were individuals in attendance which had run groups in both states before, so I think we will have a lot of good information about what works and does not so going forward we will be more successful!
The Bad One In Your Crop - SQL Tuning Analysis For DBAs - Martin Klier - @MartinKlierDBA
If you can do it, submit abstracts for the DOAG conference in Germany, but even if you do not do that make sure to follow the hashtag #DOAUG2016 later this year!
SQL -> Syntax -> Semantic -> Library Cache check -> Optimizer -> Execution is a hard parse!
Soft parse avoids the Optimizer because it has been found in the Library Cache.
Great story about bad weather affecting DB performance, and something I have seen happen in person (not with bad weather, we never have that in Arizona).
Bind peeking is a harder soft parse.
Before you tune, analysis is mandatory!
Starts with "What's the problem?"
His style is to simplify your toolset by using AWR/ statspack, SQL*Plus, SQLci, SQL Developer, dbms_xplan.display_cursor; being suspicious; looking thoroughly; having situational awareness; using intuition (over time you will get the right approach 80%); going down to the second, one hour has 3600 seconds which is a static and common measurement.
Finding the culprit (unfortunately this is where I had to step out and take a phone call, but I cannot to download the presentation and finish it!)
Tuesday, March 1, 2016
ANNOUNCEMENT: Arizona/New Mexico OAUG Geographic Region
Tonight I return from a short sabbatical to let you know that a new Geo has been formed by OAUG to represent the Arizona and New Mexico region, and you can go to the LinkedIn group to stay informed about recent updates which should be coming over the next few days and weeks leading up to OAUG's COLLABORATE conference!
Subscribe to:
Posts (Atom)