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. 62
Page 51 of 62

Documents

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.

PPTCost Accounting As You Want It - R12 Cost Accounting with SLA

Published: 15.02.2010 - This document is restricted to members

Join in discussing how you can use Release 12 Subledger Accounting to meet your costing requirements for distribution and manufacturing. Learn how SLA removes the limitations from 11i Discrete Costing Release and how to use R12 SLA to satisfy Cost Accounting requirements without programming! As a working example, solutions for purchase price variance will be discussed. In addition, if we have time we will touch on the OPM conversion from the MAC to Release 12 SLA.

PPTEvaluating and testing storage performance for Oracle DB's

Published: 15.02.2010 - This document is restricted to members

Storage performance is critical for successful database rollout. However DBAs have often a hard time is assessing the storage performance of existing and new systems. The presence of many stacks of technology and compartmentalised expertise, do not facilitate the task. This talk will report on the use of ORION to evaluate the performances of storage configurations based on SAN for the high energy physics database community. Results of the measurements on the systems evaluated by the author will be presented and discussed. More recently ORION has been used to assess 10Gbps iSCSI storage at CERN in a joint work between DBAs, storage administrators and network administrators. Results on these tests will also be discussed.

PPTEverything you always wanted to know about FIRST_ROWS_N but were afraid to ask

Published: 15.02.2010 - This document is restricted to members

Since Oracle 9i the Oracle cost based optimizer offers a FIRST_ROWS_N optimization mode in addition to the already existing ALL_ROWS and FIRST_ROWS optimization modes. The new FIRST_ROWS_N mode is supposed to be fully cost based whereas the FIRST_ROWS mode uses some built-in heuristics which sometimes lead to inefficient execution plans. The presentation explains the purpose of the different optimizer modes and the evolution of the FIRST_ROWS(_n) optimizer mode. It then continues to delve into the details about the FIRST_ROWS_N optimization mode along with a lot of examples. Finally it reveals some of the yet unpublished internals and limitations of the FIRST_ROWS_N optimization, e.g. why it still chooses obviously more expensive index access paths although being purely cost based.

PDFExecution Plan Stability in Oracle 11g

Published: 15.02.2010 - This document is restricted to members

Oracle11g introduced very important new features that all together guarantee execution plan stability. In this session we will discuss SQL Plan Management, extended statistics and new bind-aware cursor matching which resolve majority of the problems with execution plan instability.

PPTForms and Reports 11g integration into the modern world: Living together as alternative to replacement

Published: 15.02.2010 - This document is restricted to members

Oracle Forms and Oracle Reports have been the most commonly used development tools for applications interacting with an Oracle database in the nineties of the past century. Around 2000 Oracle started to focus on the Java development platform and many people thought that the end of Forms and Reports was near. However, the extremely large installed base of this technology made a quick replacement by Java technology an impossible task, and nowadays many companies are still using applications developed in the traditional technology and are even still developing in it. On the other hand newer technologies, such as Oracle ADF and APEX are often the choice when developing new applications. In most cases a mix of technologies is the result. Forms and Reports 11g offer great features to support the mix of technologies. In this presentation a number of cases will be discussed where integration between Forms and/or Reports 11g and different technologies play a role.

  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. 62
Page 51 of 62

Top



Library search

Communities: