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

Documents

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!

PDFOracle E-Business Suite Release 12 and 12.1 - Technology highlights

Published: 15.02.2010 - This document is restricted to members

Come learn how the Oracle E-Business Suite Release 12 and 12.1 is adopting the most advanced features of Oracle's development tools and server products. In this session we will see how the E-Business Suite is already leveraging the Oracle Fusion Middleware as well as the latest and greatest of the Oracle Database.

PPTR12 multi organisation architecture and how to use it

Published: 15.02.2010 - This document is restricted to members

Finally, Oracle delivers full multi-organisation flexibility. No more switching in and out of responsibilities to process data from different areas of your business. Shared Service Centres are leaping for joy! But how can you take advantage of these features? What are the technical changes and how will they affect my custom extensions? This presentation will explain the architecture from a business and technical perspective, including: • Real life examples of business functions that benef most and how to configure them • What happens at the database and SQL levels and how to use it in your custom code • Potential pitfalls – how to recognise the symptoms and correct them.

PPTXRAC + ASM: 3 years in production - Stories to share.

Published: 15.02.2010 - This document is restricted to members

In my daily encounters with mora than 70 databases for 4 major Pythian clients, who run almost all possible combinations of RAC, ASM, NETAPP and NFS and Fibre SAN I have some very good stories to share. This presentation is the equivalent of 3 years of RAC+ASM experience, condensed in a few stories of success, failure, tips and tricks along with interactive Q&A opportunities. A few examples: - RAC Migration via LUN re-assignment - Online migration from EMC SAN to a 3PAR san with ASM - Removing ASMLIB and using EMC multipathing - Gotchas when building ASMLIB devices with multipathing - Corrupting your production database beyond repair with duplicate database on ASM - Overwriting your ASM disk due to incorrect naming convention - Corrupting your production database with NETAPP/NFS due to Oracle bug - 2 nodes RAC is not HA - performing network maintenance

PDFThe Oracle Wait Interface is useless (sometimes)

Published: 15.02.2010 - This document is restricted to members

For years, the Oracle Wait Interface has allowed DBAs to quickly get to the root of their performance problems. However, technology changes mean that it is becoming increasingly likely that real performance problems will show no waits at all. This presentation highlights some such scenarios and some techniques to get to the truth.

PDFThe right way to secure data

Published: 15.02.2010 - This document is restricted to members

So often people try and secure Oracle databases by following checklists and applying all the settings recommended to their databases. But often this will not secure the data that matters; It could be possible to spend man-years of labour applying a checklists recommendations BUT the key data is still not secure. Checklists do not directly mention your critical data or tables. To secure data in an Oracle database we MUST start with the data. In this presentation Pete Finnigan shows how we must consider the data model in security terms and understand "how" data is accessed and by "who". Oracle databases and the applications built into them are often complex with heirarchical models that involve multiple privilege levels and paths to the data. Pete cuts through all of the detail and complexity and shows you how to consider the data first, the "complete" access and privilege model and how to think like a data security master."

PPTVital Statistics

Published: 15.02.2010 - This document is restricted to members

This presentation investigates optimizer statistics covering: • the purpose of optimizer statistics • collection intervals and plan stability • differences between ANALYZE and DBMS_STATS • histograms and bind variable peeking • multi-column histograms in Oracle 11g • statistics for partitioned objects • when it may be beneficial to generate your own statistics The maintenance of accurate database statistics is a fundamental requirement for any Oracle database. This presentation will provide some insight into different approaches employed by Oracle users to ensure their optimizer statistics are valid.

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

Top



Library search

Communities: