|
| oa_user_form_activities.sql | Administration | This script gives a breakdown of Oracle Application 11i user activity. This script reports on the form and responsibilities which a user has logged into over a certain number of days. | Download |
| VPD_Workbench_Install.zip | OpenWorld Downloads | OpenWorld 2009 Supporting APEX application "VPD Workbench" | Download |
| RLS_XE.pdf | OpenWorld Downloads | OpenWorld 2009 Reference Whitepaper "VPD Alternatives for Oracle XE" | Download |
| RLS_APEX.pdf | OpenWorld Downloads | OpenWorld 2009 Presentation "Row Level Security and Oracle Application Express" | Download |
| JSF_Custom_Components_OW_2009.pdf | OpenWorld Downloads | OpenWorld 2009 Presentation: An introduction to JSF custom component development. | Download |
| odm_presentation.pdf | Other | ODTUG Kaleidoscope 2010 Presentation "Integrating Statistics with Oracle Application Express". Presentation demonstrates how to embed BI and data mining modules in APEX applications. | Download |
| KB_Install.sql | Other | Oracle Application Express Knowledge Base tool developed by Aderas, Inc. This is a free version and is not supported in any way. Log onto Oracle Application express and import a new application. Use this script when prompted for the build script. | Download |
| oa_cm_by_param.sql | Performance Tuning | This script helps identify Oracle Application 11i Concurrent Programs that have performance issues when submitted with a different set of parameters. | Download |
| db_dba_hist_plan.sql | Performance Tuning | This Database script utilizes the dba_hist_sql_plan table to determine the history of a sql_id and compare executions over time. Can be useful in diagnosis of performance problems with an individual sql statement. If the plan changes even though you have not gathered statistics in between then you may want to evaluate the bind variable peeking or dynamic sampling | Download |
| kill-all-processes.sh | Unix | How to kill all unix processes owned by a user named oracle (substitute oracle with any user name). | Download |
| OracleAppsPlanStabilityGuide-ADERAS.pdf | Whitepapers | Jason Delano, Aderas' Performance Engineer, outlines the setup and configuration to utilize Plan Stability (Stored Outlines) with Oracle 11i and the Oracle 10g Database. | Download |
| OracleAppsLoadRunnerGuide-ADERAS.pdf | Whitepapers | Jason Delano, Aderas' Performance Engineer, outlines the setup and configuration of LoadRunner and Oracle 11i (11.5.9) | Download |