1 / 22

OAUG Sys Admin SIG Meeting Connection Point Conference

September 13, 2004 Orlando, FL Randy Giefer, Chair. OAUG Sys Admin SIG Meeting Connection Point Conference. Welcome. Welcome to OAUG Connection Point 2004 Welcome to the SysAdmin SIG. Agenda. Introduction What is OAUG? What is the SysAdmin SIG? Summary of Non-Conference Activities

kalona
Download Presentation

OAUG Sys Admin SIG Meeting Connection Point Conference

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. September 13, 2004 Orlando, FL Randy Giefer, Chair OAUG Sys Admin SIG MeetingConnection Point Conference

  2. Welcome • Welcome to OAUG Connection Point 2004 • Welcome to the SysAdmin SIG

  3. Agenda • Introduction • What is OAUG? • What is the SysAdmin SIG? • Summary of Non-Conference Activities • Discussion of Committees • Open Discussion

  4. Introduction • Randy Giefer - SIG Chairperson • Apps DBA Consultant • Trainer • Educator • Solution Beacon, LLC • rgiefer@solutionbeacon.com

  5. What is OAUG? • Oracle Applications Users Group (OAUG)

  6. What is OAUG? • Oracle Applications Users Group (OAUG) • OAUG is a global organization that provides Oracle users the opportunity to enhance their productivity, maximize their investment, and influence the quality, usability, and support of Oracle Applications.

  7. OAUG Membership Benefits • Advocacy • Influence Oracle • Knowledge • National and Regional Events • Publications • Communication • Geographical and Special Interest Groups • Interaction with Oracle Initiatives • Education • Conference Paper Database • Networking Opportunities • Member Database • Online Vendor Directory

  8. What is the OAUG SysAdmin SIG? • Special Interest Group • Share knowledge and experience about a variety of topics relating to Oracle Applications System Administration • Related SIGs • DBA SIG • Upgrade SIG • Workflow SIG

  9. What is the OAUG SysAdmin SIG? • Consists of Several Functional Areas: • Oracle Applications System Administration • Operating System Administration for Oracle Applications Installations

  10. Mission Statement The SysAdmin Special Interest Group (SIG) provides a forum for OAUG members and participants to share updates, tips and successful practices relating to System Administration in an Oracle Applications environment. The SysAdmin SIG strives to enable System Administrators to become more effective and efficient in their jobs by providing them with access to people and information that can their System Administration knowledge and experience.

  11. Committees • Concurrent Managers • Scripts • Printer drivers & keyboard mappings • System Administrator Roles and Responsibilities • Oracle Tools and Utilities • Third-Party Tools • Useful Links • Oracle Enhancement Requests • Architecture • Workflow • NT System Administration • UNIX System Administration • Linux System Administration

  12. Committee Chairpersons • Concurrent Managers (Netta Kausalik) • Scripts • Printer drivers & keyboard mappings (Tammy Vandermey) • System Administrator Roles and Responsibilities • Oracle Tools and Utilities (Sandra Vucinic) • Third-Party Tools • Useful Links (Mary Lou Weiss) • Oracle Enhancement Requests (Randy Giefer) • Architecture (John Stouffer) • Workflow (Noah Chanmala) • NT System Administration (Basheer Khan) • UNIX System Administration • Linux System Administration (Will Cordle)

  13. Committees Without Chairs • SysAdmin Scripts • System Administrator Roles and Responsibilities • Third-Party Tools

  14. Miscellaneous • AppsWorld Meeting • Website http://sysadminsig.oaug.org

  15. Open Discussion • New Topic Areas • Website using OAUG SIG Template • Questions / Suggestions

  16. OATM • Oracle Applications Tablespace Model (OATM) • Takes ~400 Tablespaces and consolidates them to 12! • Easier Maintenance • Available via patch 3381489 / 11.5.10 • OATM migration Utility

  17. OATM Migration • OATM takes into account the following object I/O characteristics of an object: • Its size • Its lifespan • Its access methods • Its locking granularity

  18. OATM Migration Actions • Facilitate administration and configuration ease. • Take advantage of wide stripe configurations. • Allow for conversion to locally managed tablespaces with uniform extent size. Using uniform extent sizes allows for exact control over unused space. • Take advantage of Automatic Segment Management. • Reclaim space after the migration. • Increase block-packing, which will reduce the overall number of buffer gets. • Improve recovery times and procedures.

  19. OATM Tablespaces

  20. OATM MetaLink Notes • Oracle Applications Tablespace Model FAQs 269293.1 • Oracle Applications Tablespace Model Release 11i - Tablespace Migration Utility 248857.1 • Oracle Applications Tablespace Migration Utility User Documentation 269291.1

  21. 11.5.10 Oracle User Management (UMX) • UMX leverages workflow to implement business logic around the registration process. • Raising business events • Provide temporary storage of registration data • Identity verification • Username policies • Include the integration point with Oracle Approval Management • Create user accounts • Release usernames • Assign access roles • Maintain registration status in the UMX schema • Launch notification workflows

  22. Wrap Up • Thanks to OAUG for sponsoring this OAUG SIG meeting. • Thank you for attending! rgiefer@solutionbeacon.com

More Related