I felt really bad for John since I was the only person in the room for a bit, and luckily another person did join us, but he did come down to us to do a sort of roundtable which was an interesting switch up.
DRM / EPMA - Oracle applications for maintaining HFM data.
Good practice to have business change their things in DEV.
Approach any changes as a project, and make sure it is not done in a vacuum.
Checklist Manifesto - A suggested reading
Member lists is something I am not familiar with, so I will have to look it up when I get home to see if the business has access to this!
9:45 - Fuad Arshad - Exadata Oracle 12c New Features
A vision when Exadata was created, originally called SAGE (Storage and Grid Environment).
Platform is almost never a pure OLTP because there are always batch processes that have to run.
Maximum Availability Architecture to help prevent outages.
KVM, PDU, ILOM, CISCO switch - With older V2 Exadata platforms.
Plugging Exadata into OEM via PDU can help plan for data center power usage.
Hardware improvements from Intel chipsets are low when compared to Exadata software innovations so there is a natural benefit gap between those on Exadata and those that are not.
Finally added support for ACFS file systems which are ASM based for 10.2 databases so they can go to Exadata.
Version 12.1.1.0 of Exadata software adds support for 12.1 (12c) databases, and it added cell to cell data transfers and IORM support for multitenant DBs.
Exadata Storage Cell: MS, RS, CELLSRV, CELLOFLSRV 11.2.x, CELLOFLSRV 12.1.x
Version 12.1.2.1 of Exadata software introduces massive DB optimizations: 3x faster Direct to Wire InfiniBand Protocol, 5x faster Pure Columnar Flash Cache, 3x faster JSON and XML analytics with storage offload.
Exadata can now be virtualized with isolation of the CPU, memory and OS.
Upgrade to Oracle Linux 6.6 without a reimage!
Now instant server death detection because they LOOK instead of WAIT. Awesome proactivity!!
New DBMCLI service dbserverd.
Patching note 888828.1 in MOS.
If you patch your own Exadata, do the pre-checks and resolve any warnings beforehand.
Get the EM 12c Exadata Plugin but you need EM 12.1.0.4 installed first!
MOS note 1070954.1 for checker.
Orachk Collection Manager not just for Exadata and in MOS document ID 1268927.2.
11:15 - Bobby Curtis - Extreme Replication: Performance Tuning Oracle GoldenGate for the Real World
Quick history of GoldenGate: Change Data Capture -> Oracle Advance Replication -> Oracle Streams -> Oracle GoldenGate.
Integrated Extract introduced in GG 11.2.0.2 for Oracle source DB only with 11.2.0.3 or later DB version and it works with the logminer.
Logminer server: Reader, Preparer, Builder, Capture, then it sends the capture off to the trail file.
Integrated Replicat introduced in GG 12.1.2 for Oracle DB only with 11.2.0.4 or 12.1 or later DB versions.
Inbound Server: Receiver, Preparer, Coordinator, Applier.
GG performance areas: GG (LAG, REPORTCOUNT), DB (AWR, ASH, UTL-SPADV, TRACE), and host (mpstat, vmstat, iostat, strace).
LAGINFO, LAGREPORT, LAGCRITICAL are Manager processes for monitoring latency and goes to ggserr.log for some reason.
Streams performance advisor, in $ORACLE_HOME/rdbms/admin/utlspadv.sql but must be installed as GG user.
There are a bunch of run time and configuration views for GG performance tools like V$GOLDENGATE_CAPTURE or DBA_APPLY.
MOS health check 1448324.1.
Go from GG to DB to host on the source for troubleshooting first before you go look at the target at all.
Case Study!! Diving deep into a problem!
STREAMS_POOL_SIZE should be 1G and then add 25% per each additional replicant or extract.
On the target side indexes can cause slowness in applying processes.
TCPBUFSIZE and TCPFLUSHBYTES and use ping to find the average round trip time.
Awesome picture breaking down network tuning after getting your ping results!
12:15 - Various - Oracle ACE conversations
At lunch I sat down at the RAC and Database Internals table, hosted by Riyaj Shamsudeen (@RiyajShamsudeen) and we were joined by Marc Fielding (@mfild), David Fitzjarrell (@ddfdba) and Iordan from yesterday's presentation! Some interesting conversations, and I was glad I picked that table because David and I had several very good conversations.
1:30 - Rusty Schmidt (@TheOracleEMT) - Analyzing Oracle Workflow Data for Increased System Performance
Hey, look at that! It is me! I'll brag a bit and say that I ended right about when I wanted to, had several people engaged asking questions, and had a couple Oracle ACEs come up to me to talk about an aspect of the presentation afterwards too saying that it was interesting and kept their interest! Really awesome to hear, and hope that I get some good scores from the other people in the crowd too.
2:45 - Janis Griffin (@DoBoutAnything) - Advanced Oracle Performance Tuning Tips
Tuning is hard, who needs to be doing it and what expertise do they need?
How to identify? User/batch job complaints, queries with most I/O, queries consuming CPU, response time analysis.
Lots of tables to find this info like V$SESSION, V$SQLAREA, etc.
V$ACTIVE_SESSION_HISTORY gets flushed to WRH$_ACTIVE_SESSION_HISTORY
Get baseline metrics and collect wait event information.
Get the execution plan too! Use EXPLAIN PLAN, V$SQL_PLAN, DBMS_XPLAN, TKPROF, or historical plans from AWR.
There are new functions in DBMS_XPLAN with 12c!
Adaptive plans with 12c introduce new columns in V$SQL of IS_RESOLVED_ADAPTIVE_PLAN and IS_REOPTIMIZABLE which will get read the next time it gets executed.
OPTIMIZER_ADAPTIVE_REPORTING_ONLY is a new parameter to help drive this.
Passing in the +adaptive value into DBMS_XPLAN can have the explain plan include more data which you may want included such as ignored plan rows.
Reminder about using SQL baselines if your 3rd party code cannot be hinted.
4:00 -
Unfortunately Viswa came down with a very bad cold preventing him from coming out to Training Days, so I chipped in and tried to cover it as best as I could! I think it went rather well because the crowd on the last day was pretty interactive and they seemed to get a lot out of it by their comments!
Now, I'm ready to board to leave Denver and return to sunny Phoenix!
No comments:
Post a Comment