A fantastically well attended SIG, the large room is packed and it’s at my favourite venue used by UKOUG, just a hop from the houses of parliament. In fact there were 125 registered attendees, which is roughly double the number of the last UNIX SIG event, held in the midlands.
However, I would say having so many Oracle employees presenting (4 out of the 6) is a real shame – perhaps there is a danger in evangelising the product too much rather than giving a more balanced view.
Of course, perhaps it needs more end users to volunteer to do the presenting.
Support Update – Phil Davies (Oracle)
ASM instance hang/ORA-2103 in DB instance. see Note: 468572.1. A few issues with 10.2.0.4 Enterprise Manager.
New Oracle clusterware process oprocd appears with 10.2.0.4. This might cause issues with certain Linux flavours and the hangcheck timer.
Making Life Easier with Grid Control – James Anthony (Oracle)
Came from a command line mindset, but grid control has caused him to become a convert to a more gui based approach. A reasonable minority of people in the audience using grid control. The base product is free, though the “good stuff” is a cost option via various optional “packs”. He has a slide with “Reduced Cost of Ownership”" Whenever I see this, I immediately translate this to the vendor has a product to sell that will cost you money.
Inventory management – reporting what versions of the oracle and O/S software the servers in your database constellation are running. Appealing to the larger companies to keep track of things. This is not just capable of reporting on Oracle DB, but other DB’s and app servers.
A tiny percentage of attendees have applied the April 2008 CPU – this is 3 months after it appeared. PCI DSS demands that relevant patches are installed within 1 month of becoming available. Though of course according to the register 88% of business are ignoring PCI DSS.
Patch advisory will show which patches are needing to be applied to which server software.
Best practice reporting/compliance – apparently over 220 best practice policies that you can automatically test against your various instances with grid control. Other useful feature is automating daily checks. Big push on security checking.
James is really selling this as a tool for reassuring management by pointing them to the varous graphs – heck they can even give you a compliance score – “this database is 89% compliant”!
Auditing & Tracking Changes, Comparing two systems.
Provisioning Pack and automating patch updates. Not one audience member is keen on automated patching of production systems, however I can see that if you had a large number of db servers going round each of them manually would be a full time and tedious job.
Not one audience member is using Oracle Unbreakable Linux.
Data Masking. Only a few DBAs are taking steps to mask production data in test database – the vast majority are not doing this. This can be automated with grid control – assuming you pay for the data masking pack – you pay on a per cpu basis for the machine you are doing the masking on. You can mask on 1 machine and then clone the masked data out to numerous test systems.
Claims masking is fast 120Million row table masked in 1.2 hours on 1 cpu system – of course this table could have few columns or lots of columns, but he has not said what quantity of data this represents.
Active Dataguard, Backup & Recovery – Mike Appleyard (Oracle)
A pre-sales presentation – though the presenter has worked in Oracle Support for 10 years or so. Really hammering home the fact that a standby database is often not providing a great ROI as it has a lot of spare CPU cycles apart from just apply redo data – oh this is where Active dataguard comes in, this is where the standby is open for read only operations but you can still run managed recovery on the standby so your queries are bang up-to-date in terms of the data they are seeing.
Block change tracking can be implemented on the standby facilitating faster RMAN incremental backups.
The big sell, is taking read only reports away from your primary and putting them on your standby you can shovel more transactions through your primary – so instead of paying for more cpu on your primary you can pay for an active dataguard license instead.
Mentions itunes using active dataguard – they used to use logical standby – they have many standby instances.
Active dataguard is a cost option, it costs around 12.4% of an EE license. Hmm, another slide seems to contradict that pricing. Some real confusion out there around the licensing of the dataguard – quite a few questions being generated.
A huge percentage of the audience have a physical standby already.s
snapshot standby is basically opening a standby read-write and then flash it back to become a physical standby. This has become a less manual process with 11g. This is FREE, not a cost option.
He was somewhat skeptical (in terms of reliability) regarding rolling upgrade with a physical standby becoming a logical during the upgrade.
A slide regarding the performance of media recovery, claiming practically doubled number of MB/s that the same system can do going from 10gR2 to 11gR1 – that seems a big claim to make.
A Beginners Guide to Statspack (AWR) – Jonathan Lewis (Independent Consultant)
At last a non-oracle employee. What can you do with statspack:
routine checks for anomalies
Occasional health checks
diagnosing historic performance problems
statspack is not a response time tuning tool. it aggregates over sessions.
Interesting point about victims and culprits – is it my query that is at fault, or is my query just the victim of some other query hogging a lot of system resources? Explaining that competition for resources can be a big cause of increased response time, affecting both wait time & service time.
Advocating checking how various metrics are changing over time, so that any exception really stands out.
Pointed out some inconsistencies in the numbers that statspack reports and not to always cross-check the numbers.
Jonathan is talking about the wait time histograms available with 10g statspack (but I don’t see it in AWR). This shows the breakout from an average wait time – maybe you have some waits that are waiting a very long time that are hidden by the average.
Certification Exams – Joel Goodman (Oracle)
Joel helps write the Oracle University curriculum so has a somewhat vested interest in Oracle certification.
My take on certification is that it’s worthwhile to gain an understanding of features that you rarely encounter in your day to day DBA work, but just having certification without being backed up by practical experience it’s not that useful.
Best Practices for Gathering Oracle Database Statistics – Martin Widlake (ORA600 LTD)
Martin was talking a lot about the automated stats gathering job that is turned on by default in 10g. The idea of this job is to collect stats when the underlying tables have changed enough to have the stats marked as stale. Of course it may run at a very inconvenient time for your system and there is little information on what it is really doing.
I hope there are less Oracle employee presentations in future.