1 / 16

OraSnap

OraSnap. Stephen T. Murphy University at Albany November 10, 1999 Capital District Oracle Users Group. Agenda. Site Introduction Product Description Demo How It Works Albany Customizations Possible Enhancements Q & A. University at Albany. Multi-year PeopleSoft implementation

leah-parker
Download Presentation

OraSnap

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. OraSnap Stephen T. Murphy University at Albany November 10, 1999 Capital District Oracle Users Group

  2. Agenda • Site Introduction • Product Description • Demo • How It Works • Albany Customizations • Possible Enhancements • Q & A

  3. University at Albany • Multi-year PeopleSoft implementation • Higher Ed 7.5 (Student Admin. + HRMS) • 5200+ tables, 9100+ indexes • Financials for Public Sector 7.5 • Legacy systems on IBM mainframe

  4. University at Albany • Operating Environment - Hardware • 3 IBM RS-6000, model H70 systems • Higher Ed, Financials, Development • AIX 4.3.2 with HACMP • Production systems fails over to Development

  5. University at Albany • Operating Environment - Software • Oracle 8 Enterprise Edition, Release 8.0.6 • 14 instances over 4 boxes • Tuxedo App. Servers • SQR (used by PeopleSoft)

  6. Issues • New, complex technology • Small staff • Multiple platforms • “Instance creep” • Need tools to simplify DBA’s work life • Need to expand Oracle knowledge base

  7. OraSnap • Oracle Snapshot Performance Utility • Written by Stewart McGlaughlin • http://www.pobox.com/~dba/oracle/orasnap • Collection of 90+ performance scripts • Output formatted as HTML • Convenient menu system • Freeware

  8. OraSnap • Required Operating Environment • Oracle 7.3.X or 8.X • SQL-Plus • Either local or remote Oracle database • Any platform • Any browser • Any webserver

  9. Demonstration • Link to demo

  10. How Does It Work? • Main script SNAP8.Sql calls worker scripts • View SNAP8.Sql code fragment • 1 inner script per HTML page • Spools output to XXXXX.Htm file • Generates HTML code via prompts and selects • Data obtained from V$xxx and DBA_ tables • View DBI.Sql code fragment

  11. Snap8.Sql

  12. Dbi.Sql

  13. Dbi.Sql Continued…...

  14. Albany Customizations • Multiple instances • Separate directories for each instance • Deletion of some reports • e.g. Recently analyzed tables (5900 tables) • Database views (5200 views) • CRON processing • Information refreshed nightly • Email notification with URL link

  15. Possible Enhancements • Replace links page with local web page • REPORT.txt from Utlbstat.sql • Key indicators page • Statistics from Oracle Performance class • Application specific information

  16. Q & A • OraSnap is downloadable from: • http://www.pobox.com/~dba/oracle/orasnap • Stephen Murphy, University @ Albany • SMurphy@UAMail.Albany.Edu • (518) 442-3753 • Return to OraSnap demo

More Related