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. 48
  4. 49
  5. 50
  6. 51
  7. 52
  8. 53
  9. 54
  10. 55
  11. 56
  12. 57
  13. ...
  14. 62
Page 52 of 62

Documents

PPTGetting Connected!

Published: 15.02.2010 - This document is restricted to members

Before 11g there was only two ways to connect to the database – Dedicated and Shared Server was your lot. In 11g theres now Database Resident Connection Pooling which is different again and in some cases can offer great performance improvements. In this presentation I want to talk about the architecture behind the scenes of all three methods, compare and contrast them to show when each method is appropriate and to talk about how to configure, use, monitor them.

PDFHow to Backup and Recover enormous databases

Published: 15.02.2010 - This document is restricted to members

The backup & recovery of large databases (20TB+) is always a problem. On one site expensive solutions and on the other site limited budgets cause you to find cost effective but working solutions. In this presentation you will find how ASM, RMAN (including some from 11g Release 2), and other file system solutions can satify your needs both in performance and money. You will also find why you should rely on RMAN while I am going over a real life disaster of disaster scenario.

PDFIndex Clustering Factor deep dive

Published: 15.02.2010 - This document is restricted to members

This real life story from a major bank shows how a shortcoming in Oracle's statistics gathering process caused over 80 queries to slow down by a factor of 100 - but only on alternate months! This highly advanced talk discusses how to recognise, avoid, and recover from this issue which can affect any index that has more than one column.

PDFLife after Forms

Published: 15.02.2010 - This document is restricted to members

Are you wondering about the evolution of your existing applications based on Oracle Forms? This presentation will discuss and demonstrate the most common options: Using existing Forms as components in a web application or portal; Building ADF Business Components based on your Forms and then building an ADF Faces web application on these components; Building an Oracle Application Express application, using the Forms Conversion capability of APEX to jumpstart development; All three approaches will be shown in live demonstrations. This gives the audience a first-hand impression of the capabilities and effort needed for each approach in order to make an informed decision about the future of their Forms applications.

PPTMake Release 12 work for your LG45 implementation

Published: 15.02.2010 - This document is restricted to members

Over the past few years a large number of CRM solutions have been implemented in the UK to handle the logging of Citizen issues via the Oracle LG45 solution. Over the years a lot of the functionality that was originally part of the LG45, has now been included in the core Release 12 product. Therefore an upgrade to R12 provides an authority with many benefits including, ability to be configured for a service centre, as well as the ability to move away from the 11i LG45 consulting solution and onto core product, therefore reducing any additional support costs. This presentation intends to explain the approach being used to upgrade existing Oracle Release 11 LG45 customers to the Release 12 solution. It explains the approach, the areas to be aware of in the upgrade and the differences and between the Release 11 LG45 solution and what is now available as standard in Release 12.

PDFMangled or Managed - Does Grid Control deliver?

Published: 15.02.2010 - This document is restricted to members

This presentation will look at what Grid Control can, and more importantly cannot do. In doing so we will explore the ideas above and attempt to understand where it significantly improves the job of the DBA and where it might be more trouble than it is worth.

PDFOracle Active Data Guard best practices: Standby for more than Disaster Recovery

Published: 15.02.2010 - This document is restricted to members

Oracle Active Data Guard standby databases have many more uses than just recovering from disasters, whether a simple data corruption or a “smoking hole in the ground”. Learn detailed best practices for using an active standby for read-only queries including new Active Data Guard 11g Release 2 features that automatically enforce service level objectives for data lag on the standby, including zero tolerance for delay between primary and standby. Details of fine-grained reporting for current query lag and historical performance are also discussed. The session also explains implementing scalable reader farms, and using standby databases for development, testing and data center migration, which reduce downtime and business risk.

PDFOracle Data Guard 11g Release 2 = High Availability to protect your business

Published: 15.02.2010 - This document is restricted to members

Oracle Data Guard is increasingly used for High Availability (HA) because it is the ultimate way to eliminate single points of failure. Storage failure, media corruption, and human error cause much more downtime than fires, hurricanes, floods, earthquakes – and they strike both clusters and single node configurations alike. Your architecture must include a local Data Guard HA standby if you are serious about HA. It provides zero data loss and rapid (even automatic) failover if your primary database fails. Regardless of the disaster recovery solution you use, Data Guard 11g Release 2 and Maximum Availability Architecture best practices make it easy to add a local HA standby with minimal to zero impact on primary database performance.

PDFOracle Database 11g: SQL Plan Management

Published: 15.02.2010 - This document is restricted to members

Since the introduction of the Cost Based Optimizer (CBO) in Oracle7, database administrators (DBA) have occasionally been required to prevent the creation of sub-optimal execution plans and the regression of good plans. Originally, hints were the only feature available to control the optimizer but these could cause more problems than they solved even when used by experienced DBAs. Optimizer Plan Stability was introduced in Oracle 8i and was an effective solution at preventing plan regression into less optimal plans but it prevented potentially better execution plans from being used. Oracle 11g introduced SQL Plan Management which provides DBAs with an effective solution for controlling the optimizer. In this presentation Harald will explain both the workings of Plan Stability and SQL Plan Management, with an emphasis on SQL Plan Management,with live demos that support the theory.

PDFOracle Database Security done right

Published: 15.02.2010 - This document is restricted to members

Oracle database security on the operating system level for linux and unix. Security is an important part of modern database administration, and is getting even more important with security audits because of SOX, HIPAA and/or ISO 27001, among others. Most database are installed using the oracle provided installation guide. Few people realise the purpose of that guide is to install the database software in the most simple way with most flexibility, not in a secure way. This presentation discusses this common setup, and provides a method for installing a database in a secure way. Learn about operating system and database security, and securing the database on the operating system level, and getting it in line with security policies!

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

Top



Library search

Communities: