1 / 21

Michigan OAUG Creating smaller and faster test & dev databases 12/10/02

Michigan OAUG Creating smaller and faster test & dev databases 12/10/02. Why Use Downsizer?. Excessive storage requirements for dev & test databases? Too much time spent maintaining dev and test databases? Poor system performance?. Relational Database Complexity.

ashton
Download Presentation

Michigan OAUG Creating smaller and faster test & dev databases 12/10/02

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. Michigan OAUG Creating smaller and faster test & dev databases 12/10/02

  2. Why Use Downsizer? • Excessive storage requirements for dev & test databases? • Too much time spent maintaining dev and test databases? • Poor system performance? 2

  3. Relational Database Complexity Oracle Applications 11i contains roughly 7,500 tables with an equally astonishing number of rule driven interrelationships. Oracle Applications 10.7 contains approximately 2,400 tables governed by roughly 180,000 separate rules. 3

  4. Source Source Test Source DATA DATA Reduce Data for downsized modules DATA DATA Copy Table Space Unused Table Space Unused Table Space Unused Table Space Reclaim Table Space Test Dev 1 Dev 1 DATA DATA DATA Table Space Table Space Table Space Execute Db Downsizer 4

  5. Flexible Parameters 3 yrs. 2 yr. 1 yr. GL Balances GL Detail Inventory Transactions AP Invoices 5

  6. Example of a Driving Class • Accounts Receivable • (ex: AR Invoice) • Credit Memos • Chargebacks • Debit Memos • Commitments • All related OE/OM data • Accounts Payable • (ex: AP Invoice) • Credit Memos • Payments • Checks • All related PO data 6

  7. Db Downsizer Classes Primary transaction and related data objects (classes) - GL Balances - Purchase Orders - GL Batches - Sales Orders - AP Invoices - Inventory Item Transactions - AP Batches - WIP Transactions - AR Invoices - WIP Operations - AR Batches - AR Receipts 7

  8. Begin Db Downsizer End Db Downsizer Perform Instance Validation Create Rules Pre- Diagnostics Analyze Data Required Downsize Data Post- Diagnostics Reclaim Tablespace Optional Pre- Diagnostic Report Analyze Data Report Post- Diagnostic Report Db Downsizer Process 8

  9. Db Downsizer Rules 9

  10. Resize Tablespace After Downsizing 10

  11. Customer Case Study Run time 9 hrs • Requirements: • 15 months of transaction history • Maintained 8 months for GL, AP, PO THE RULES (Kept) • GL: GL Balances > 01-FEB-2002 • GL: GL Batches > 01-FEB-2002 • AP: AP Batches > 01-FEB-2002 • AP: AP Invoices > 01-FEB-2002 • PO: PO Headers > 01-FEB-2002 11

  12. Competitive Analysis • Complete solution (doesn’t require Quest’s LiveReorg) • Multiple modules downsized simultaneously – results in optimal data integrity • Very fast implementation – less than one day • 4.5 Release on Mar 3rd • Command line execution of combined downsize process and space reclamation • Automated notification of job status 12

  13. Product Roadmap - Release Schedule ApplicationDate • Order Management 11i (ONT) Q4-02 (12/16/02) • Project Accounting Q1-03 (3/03/03) • Fixed Assets Q1-03 (3/03/03) • HR/Payroll Q2-03 (4/28/03) • Cost Q2-03 (4/28/03) • Grants Q3-03 • MRP Q2-03 • Shipping Q4-03 • Quality Q4-03 • Cash Management Q4-03 13

  14. Michigan OAUG Creating smaller and faster test & dev databases 12/10/02

  15. Our Focus To provide a suite of Application Management tools to enable our Oracle Applications customers to: Enable effective change management Improve operating performance Control enterprise growth Reduce total cost of ownership 15

  16. Our Products Automate, Optimize and Manage using our unique suite of Application Management tools: • Setup Reporter • Manage, control configurations • Xpress Archiver • Archive and purge • Db Downsizer • Create smaller test environments • FlexChanger • Change chart of accounts structure • DataCleanser • Identify and resolve duplicate information 16

  17. FlexChanger Setup Reporter DownSizer New Applications DataCleanser XpressArchiver Applimation Platform Applimation Platform 17

  18. 2000 –10.7, 11.03 2001 - 11i Certified 1998 Oracle Certification Certified for use with all modules of Oracle Applications Oracle Partner Program Member since 1998 Certified by Oracle Cooperative Applications Initiative (CAI) Program, April 2000 Oracle Partner Technical Services (PTS) organization approved the integration of Crystallize Products through the Oracle E-Business Suite Integration (EBSI) program, July 2001 18

  19. Our Customers 19

  20. Improved Oracle Application performance Test & Development efficiency Change without customization Reduce cost of storage Version Control assures continuous business operation Key Payback to our Clients Decrease Overall IT Expenditures 20

  21. Applimation’s Credentials • The “GO TO” Company for Applications Management tools • Family of 5 Application Management software products + growing • Lower the cost of Oracle ownership • Architecture based on comprehensive, proprietary Metadata • 75+ Oracle Customers • Deep Oracle expertise on-staff • World class support 21

More Related