Table Of Content

Performance Tuning Apex Applications Doug Gault M B Y ACKGROUND • Doug Gault • [email protected] • Using Oracle since 1988 • Versions 5.1b, 6, 7, 8, 9, 10, 11 • Focused on Web Technologies • OWA, ‘PSP’, Web DB, HTML-DB, APEX • Ex-Hotsos Employee of 5 years • Product Development Director - APEX Applications • 2004 through 2008 • Commercial Applications written in APEX • Joined Sumner Technologies January 2009 • Co-Founded Sumneva January 2010 2 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] A GENDA • Introduction - Knowledge is Power • Coding Best Practices ... Get Started Right • Monitoring the Performance of Your Application • Tools Available for Diagnosis 3 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] Introduction: Knowledge is Power 4 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] W D P , K P ... HEN EALING WITH ERFORMANCE NOWLEDGE IS OWER • Know the Architecture • Know the Intended End User • Know the Expectations • Know the Application’s Purpose 5 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] Know Your Architecture 6 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] L A OGICAL RCHITECTURE • APEX is a metadata-based environment • No need to write code to instantiate an APEX component • Rather you specify options with Wizards or the Application Builder • “Metadata-based” does not imply limitations on complexity • APEX’s development environment is quite extensible • Can add calls to PL/SQL almost everywhere • Which can in turn, call other languages • APEX is built in APEX 7 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] L A OGICAL RCHITECTURE • Some benefits of a metadata-based framework: • No code is generated • Impossible to tune • Not extensible • Easy to transfer from one environment to another • Done without leaving the browser • Application Builder masks all complexity • User just sees screens and provides values • You can incorporate APEX metadata in your applications 8 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] APEX S CHEMAS • APEX is comprised of three schemas: All APEX metadata is APEX_030200 stored here Any uploaded files end FLOWS_FILES up here initially All APEX page views APEX_PUBLIC_USER* connect as this schema * When the EPG is used, ANONYMOUS will be the public APEX schema 9 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected] P A HYSICAL RCHITECTURE • Despite its simplicity, the physical architecture of APEX can be configured a number of different ways • Simple for development & testing • Everything on a single box • Sophisticated for production • Multiple HTTP Servers with a Load Balancer • SSL & ASO for end-to-end secure transactions • RAC at the Database tier for performance boosts • Data Guard for fault tolerance 10 Copyright © 2010 Sumneva - All Rights Reserved - http://sumneva.com - [email protected]

Description:

and provides values. • You can incorporate APEX metadata in your applications. 8 Can replace Oracle HTTP server with Embedded PL/SQL Gateway (EPG). • Provides Oracle .. query plans if you have up to date statistics.

Performance Tuning Apex Applications PDF

81 Pages·2010·4.05 MB·English

by Scott Spendolini

Checking for file health...

Save to my drive

Quick download

Download

Download Performance Tuning Apex Applications PDF Free - Full Version

by Scott Spendolini| 2010| 81 pages| 4.05| English

Download Performance Tuning Apex Applications by Scott Spendolini in PDF format completely FREE. No registration required, no payment needed. Get instant access to this valuable resource on PDFdrive.to!

Free Download PDF

About Performance Tuning Apex Applications

and provides values. • You can incorporate APEX metadata in your applications. 8 Can replace Oracle HTTP server with Embedded PL/SQL Gateway (EPG). • Provides Oracle .. query plans if you have up to date statistics.

Detailed Information

Author:	Scott Spendolini
Publication Year:	2010
Pages:	81
Language:	English
File Size:	4.05
Format:	PDF
Price:	FREE

Download Free PDF

Safe & Secure Download - No registration required

Why Choose PDFdrive for Your Free Performance Tuning Apex Applications Download?

100% Free: No hidden fees or subscriptions required for one book every day.
No Registration: Immediate access is available without creating accounts for one book every day.
Safe and Secure: Clean downloads without malware or viruses
Multiple Formats: PDF, MOBI, Mpub,... optimized for all devices
Educational Resource: Supporting knowledge sharing and learning

Frequently Asked Questions

Is it really free to download Performance Tuning Apex Applications PDF?

Yes, on https://PDFdrive.to you can download Performance Tuning Apex Applications by Scott Spendolini completely free. We don't require any payment, subscription, or registration to access this PDF file. For 3 books every day.

How can I read Performance Tuning Apex Applications on my mobile device?

After downloading Performance Tuning Apex Applications PDF, you can open it with any PDF reader app on your phone or tablet. We recommend using Adobe Acrobat Reader, Apple Books, or Google Play Books for the best reading experience.

Is this the full version of Performance Tuning Apex Applications?

Yes, this is the complete PDF version of Performance Tuning Apex Applications by Scott Spendolini. You will be able to read the entire content as in the printed version without missing any pages.

Is it legal to download Performance Tuning Apex Applications PDF for free?

https://PDFdrive.to provides links to free educational resources available online. We do not store any files on our servers. Please be aware of copyright laws in your country before downloading.

The materials shared are intended for research, educational, and personal use in accordance with fair use principles.