UK Oracle User Group


  1. You are here:
  2. Home
  3. What we offer
  4. Library

Library

Library RSS Feed

Our document repository is easily searchable and allows you to search for publications, event presentations, journals, whitepapers and much more. If you have a document that you would like to add to the library repository click here to email your submission.

  1. 1
  2. ...
  3. 47
  4. 48
  5. 49
  6. 50
  7. 51
  8. 52
  9. 53
  10. 54
  11. 55
  12. 56
  13. ...
  14. 63
Page 51 of 63

Documents

PDFThe Oracle DBA's Rough Guide to Hardware

Published: 22.02.2010 - This document is restricted to members

Don't know your front-side from your back-side bus? Thrown everything but the 'log file synch' at your storage and still can't improve redo throughput? Just a bit DIMM over SGA sizing? then the Oracle DBA's Rough Guide to Hardware is your essential guide to pinpointing performance bottlenecks. This paper will chart an unbiased course through the technologies that determine why your database performs, or doesn't perform in the way you expect. From an Oracle wait event perspective with customer workload examples we will plot the way that the Oracle code and data takes in processing your workload from CPU, memory and interconnect through to storage and look at how hardware choices influence the efficiency of each step. We will look at what Oracle latches actually do on the CPU and why being able to process one users workload faster can sometimes mean running a multiuser workload slower. We will look at memory and why 'the more the merrier' may not be the optimal SGA sizing guide. For storage we will see why your poorly performing disk array might actually not be such a slouch after all. Database tuning can be much simpler when you know where to look.

ZIPTop 10, no 11, new features of Oracle database 11g Release 2

Published: 22.02.2010 - This document is restricted to members

This session will focus on eleven new, high impact features of Oracle Database 11g and what they mean to you the developer or DBA. Continuing the format of the last five Oracle Open Worlds – Oracle’s AskTom will present these as a “top ten - no eleven” list – the eleven new features he believes will be the reason to implement on or upgrade to Oracle Database 11g Release 2.

PPTXWhat's new in the Oracle Database?

Published: 22.02.2010 - This document is restricted to members

Continued innovation over 30 years has made the Oracle Database the most fully featured database available. Can there really still be more to come? This session will give an overview of the key features of the latest release of the Oracle Database.

PDF11g features for Developers

Published: 15.02.2010 - This document is restricted to members

Sick of tired of all those session explaining low level DBA kernel mutex latch acquisition notification context switching blah blah blah ..... Then take a step back into the real world, where real work gets done by real developers, with the real cool features in 11g

PPT11gR2 - A look at what's new

Published: 15.02.2010 - This document is restricted to members

This presentation discusses new RAC and ASM features in Oracle 11g Release 2 with an emphasis on those features relevant to existing users planning their upgrade strategy. The features covered cannot be disclosed until the release is in production.

ZIPA closer look at Parsing and possible Application Optimisations

Published: 15.02.2010 - This document is restricted to members

This presentation will take a closer look at the parsing process, the differences between differing degrees of parsing, i.e. soft, hard, cursor cache hit, etc. Further, the effects of setting various Oracle parameters such as cursor_sharing, cursor_space_for_time, and session_cached_cursors will be examined.

PDFAdvanced performance issues: A close encounter with real world performance issues

Published: 15.02.2010 - This document is restricted to members

(i) A case of High Kernel mode CPU usage (ii) A case of hung cluster due to CF enqueue locking (iii) NUMA etc.. (iv) A case of hung instances due to ‘log file sync’ waits. (v) And few more if time permits.

PDFAuditing Recoverability

Published: 15.02.2010 - This document is restricted to members

Numerous RMAN books recommend that you check your ability to recover from RMAN backups using CROSSCHECK commands and V$ views but nobody tells you how. This presentation explains how to use views such as V$BACKUP_DATAFILE_DETAILS and V$OFFLINE_RANGE to accomplish this goal. I have also presented a less technical management level talk at a UNIX SIG last year but this is the highly technical presentation presented in Birmingham in 2007 (with some suggested improvements from Joel Goodman). The talk is linked with my two part article published last year in Oracle Scene.

ZIPBattle of the nodes: RAC performance myths

Published: 15.02.2010 - This document is restricted to members

Following myths will be demystified.. (i) High CPU usage in one node doesn't affect other node performance. (ii) All global cache performance issues are due to interconnect performance. (iii) Inter instance parallelism is excellent, since CPUs from all nodes can be effectively used. (iv) Logical isolation is good enough, so, run same batch process concurrently from both nodes. (v) Set sequence to nocache value in RAC environments to avoid gaps in sequence. (vi) Small tables should not be indexed in RAC. (vii) Bitmap index performance is worse compared to single instance

PPTCompressing very large data sets in Oracle

Published: 15.02.2010 - This document is restricted to members

The use case of CERN for archival of time-based large partitioned data sets in Oracle will be discussed with examples. A comparison of the various compression methods available in Oracle 11g will also be discussed. Results on 11gR2 will presented, given the product is released before the UKOUG conference. Data on compression factors and CPU usage will be presented and conclusions on the value that compression in 11g can add in managing very large databases for read-mostly workload will be discussed.

  1. 1
  2. ...
  3. 47
  4. 48
  5. 49
  6. 50
  7. 51
  8. 52
  9. 53
  10. 54
  11. 55
  12. 56
  13. ...
  14. 63
Page 51 of 63

Top



Library search

Communities: