SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE APPLICATION EXPRESS ADMINISTRATION
SUMMARY
-
Items Found: 526
- Introduction
- Part I: APEX Overview
- Chapter 1: About APEX
- Part II: Architecture
- Chapter 2: APEX in the Database
- Chapter 3: Middle-Tier
- Chapter 4: Database Advanced Security
- Chapter 5: APEX and Oracle E-Business Suite
- Chapter 6: High Availability
- Chapter 7: APEX in a Multitenant Database
- Part III: Confi guration
- Chapter 8: Installing
- Chapter 9: Upgrading and Patching
- Chapter 10: Confi guring
- Chapter 11: Administering APEX in a Runtime-Only Mode
- Chapter 12: Database and APEX Backups
- Chapter 13: Self-Provisioning Workspaces
- Part IV: Tuning
- Chapter 14: Monitoring
- Chapter 15: Performance and Tuning
- Chapter 16: Resource Manager and APEX
- Index
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: APEX Overview
- Chapter 1: About APEX
- What Is APEX?
- History
- List of Key Features for Applications
- Builder Features
- Specifi c Characteristics
- Development / Deployment Options
- APEX Administration
- Why APEX?
- What Is It For?
- The APEX Community
- APEXORACLECOM
- OTN
- APEXWORLD
- Oracle User Groups
- Meetups
- Summary
- Part II: Architecture
- Chapter 2: APEX in the Database
- Database Schemas
- APEX_PUBLIC_USER
- FLOWS_FILES
- APEX_050000
- APEX Views
- Application Schemas
- APEX Database Sessions
- Application Execution
- Connection Pool
- v$session
- APEX Workspaces
- APEX Users
- Application Users
- Scheduled Jobs
- Oracle Support
- How to Get Support
- APEX Oracle Lifetime Support
- APEX in the Cloud
- Microsoft Azure
- Amazon Web Services
- Oracle Cloud
- Summary
- Chapter 3: Middle-Tier
- Web Listeners
- EPG
- OHS / mod_plsql (Deprecated)
- ORDS
- Application Servers
- GlassFish
- Tomcat
- WebLogic
- Reverse Proxy
- Architecture
- Example of a Reverse Proxy Apache Confi guration
- SSL / HTTPS
- Summary
- Chapter 4: Database Advanced Security
- Real Application Security
- What Is Real Application Security
- Architecture of RAS
- Real Application Security Administration Application (RASADM)
- Example of a RAS Deployment
- Data Redaction
- Example of a Data Redaction Deployment
- Database Vault
- Confi gure Database Vault for APEX
- Summary
- Chapter 5: APEX and Oracle E-Business Suite
- Architecture
- APEX Schema vs APPS Schema
- EBS Patching vs APEX Patching
- Security
- Authentication
- Authorization
- Summary
- Chapter 6: High Availability
- Overview of a High Availability Solution Using RAC
- High Availability Solution for the Database
- High Availability Solution for the Application Server
- Usage of a Load Balancer
- Deploying a High Availability Solution
- Deployment and Confi guration of RAC
- Deployment and Confi guration of ORDS
- Deployment of the Load Balancer
- High Availability Scenarios
- Loss of a Database Node
- Loss of an Application Server Node
- Overview of a Solution Using Data Guard
- Data Guard as a Complement to RAC
- Summary
- Chapter 7: APEX in a Multitenant Database
- Default Installation of APEX in a Multitenant Database
- Different Scenarios of APEX Deinstallation and Installation
- Upgrade APEX in the CDB
- Deinstallation of the Common APEX from the CDB
- Installation of the Common APEX in the CDB
- Installation of a Dedicated APEX in the PDB
- Different Scenarios of Moving/Cloning a PDB
- Source PDB Has APEX in the CDB
- Source PDB Has APEX in the PDB
- Source PDB Doesn’t Have APEX
- Move or Copy a PDB with Incompatible Versions of APEX
- Summary
- Part III: Confi guration
- Chapter 8: Installing
- Preinstallation Steps
- Downloads
- Download APEX
- Download ORDS
- Installing APEX in the Database
- Tablespaces for APEX
- Installing with DBCA
- Installing APEX Using the Downloaded Scripts
- Postinstall
- Installing ORDS
- Confi gure ORDS
- Deploying the War Files
- Uninstall
- Removing APEX
- 1 Drop All APEX-Related Schemas
- 2 Drop APEX Tablespaces
- 3 Undeploy ORDS
- Summary
- Chapter 9: Upgrading and Patching
- Upgrading APEX
- Planning an Upgrade
- Preupgrade Tasks
- Upgrading APEX
- Postupgrade
- Patching
- Planning a Patch
- Downloading an APEX Patch
- Installing an APEX Patch
- Summary
- Chapter 10: Confi guring
- Manage Instance
- Instance Settings
- Manage Metadata
- Manage Logs and Files
- Manage Shared Components
- Messages
- Manage Workspaces
- Create a Workspace
- Create Multiple Workspaces
- Removing / Locking a Workspace
- Manage Workspace to Schema Assignments
- Manage Developers and Users
- Manage Component Availability
- Export/Import
- Existing Workspaces
- Workspace Reports
- Manage Applications
- Monitor Activity
- Monitoring Reports
- Summary
- Chapter 11: Administering APEX in a Runtime-Only Mode
- APEX Runtime-Only Setup
- Install APEX in Runtime Only
- Remove the APEX Builder
- Install APEX Builder
- Managing Applications
- Deploying Applications
- Change Application Build Status
- Manage Translations
- Exporting Applications
- Managing the Instance
- Manage the Instance with APEX_INSTANCE_ADMIN
- Manage Users and Developers
- APEX Administrator Role
- APEX Dictionary Views
- Summary
- Chapter 12: Database and APEX Backups
- Database Backup
- Physical Backup
- Logical Database Backups
- Flashback Technology
- APEX Components Backup
- Using Application Express Developer
- Using APEXExport
- APEX Components Restore
- Parsing Schema Restoration
- Workspace Import
- Application Import
- Summary
- Chapter 13: Self-Provisioning Workspaces
- Self-Service Provisioning Setup
- Enabling Self-Provisioning
- Storage Options
- Manage New Service Signup Wizard
- New Workspace Request Size
- Manage Requests
- How Self-Provisioning Works
- Request a New Workspace
- Workspace Change Requests
- Enable Service Requests
- Workspace Change Request Size
- Request Schema
- Request Storage
- Request Termination
- Service Requests Monitoring
- New Service Requests
- Signup Survey
- Summary
- Part IV: Tuning
- Chapter 14: Monitoring
- Database Monitoring
- Oracle Enterprise Manager
- AWR
- Database Monitor
- APEX Monitoring
- Monitoring APEX Applications at the Database Level
- Monitoring APEX Applications at the Workspace Level
- Monitoring APEX Applications Using APEX and Database Views
- Summary
- Chapter 15: Performance and Tuning
- Tuning Application
- Enabling Oracle Tracing
- Using TKPROF
- Execution Plans
- Tuning Reports
- Using DEBUG mode
- Enabling Debug Mode
- Running the Application in Debug Mode
- Viewing Debug Mode Reports
- Best Practices
- Summary
- Chapter 16: Resource Manager and APEX
- Overview of Resource Manager
- Resource Manager with Multitenant Database
- Confi guring APEX Workspace to Use Resource Manager
- Resource Manager Demonstrations
- CPU Utilization Limits at the CDB Level
- Runaway and Consumer Group Switching at the PDB Level
- Summary
- Index
- Introduction
- Part I: APEX Overview
- Chapter 1: About APEX
- Part II: Architecture
- Chapter 2: APEX in the Database
- Chapter 3: Middle-Tier
- Chapter 4: Database Advanced Security
- Chapter 5: APEX and Oracle E-Business Suite
- Chapter 6: High Availability
- Chapter 7: APEX in a Multitenant Database
- Part III: Confi guration
- Chapter 8: Installing
- Chapter 9: Upgrading and Patching
- Chapter 10: Confi guring
- Chapter 11: Administering APEX in a Runtime-Only Mode
- Chapter 12: Database and APEX Backups
- Chapter 13: Self-Provisioning Workspaces
- Part IV: Tuning
- Chapter 14: Monitoring
- Chapter 15: Performance and Tuning
- Chapter 16: Resource Manager and APEX
- Index
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: APEX Overview
- Chapter 1: About APEX
- What Is APEX?
- History
- List of Key Features for Applications
- Builder Features
- Specifi c Characteristics
- Development / Deployment Options
- APEX Administration
- Why APEX?
- What Is It For?
- The APEX Community
- APEXORACLECOM
- OTN
- APEXWORLD
- Oracle User Groups
- Meetups
- Summary
- Part II: Architecture
- Chapter 2: APEX in the Database
- Database Schemas
- APEX_PUBLIC_USER
- FLOWS_FILES
- APEX_050000
- APEX Views
- Application Schemas
- APEX Database Sessions
- Application Execution
- Connection Pool
- v$session
- APEX Workspaces
- APEX Users
- Application Users
- Scheduled Jobs
- Oracle Support
- How to Get Support
- APEX Oracle Lifetime Support
- APEX in the Cloud
- Microsoft Azure
- Amazon Web Services
- Oracle Cloud
- Summary
- Chapter 3: Middle-Tier
- Web Listeners
- EPG
- OHS / mod_plsql (Deprecated)
- ORDS
- Application Servers
- GlassFish
- Tomcat
- WebLogic
- Reverse Proxy
- Architecture
- Example of a Reverse Proxy Apache Confi guration
- SSL / HTTPS
- Summary
- Chapter 4: Database Advanced Security
- Real Application Security
- What Is Real Application Security
- Architecture of RAS
- Real Application Security Administration Application (RASADM)
- Example of a RAS Deployment
- Data Redaction
- Example of a Data Redaction Deployment
- Database Vault
- Confi gure Database Vault for APEX
- Summary
- Chapter 5: APEX and Oracle E-Business Suite
- Architecture
- APEX Schema vs APPS Schema
- EBS Patching vs APEX Patching
- Security
- Authentication
- Authorization
- Summary
- Chapter 6: High Availability
- Overview of a High Availability Solution Using RAC
- High Availability Solution for the Database
- High Availability Solution for the Application Server
- Usage of a Load Balancer
- Deploying a High Availability Solution
- Deployment and Confi guration of RAC
- Deployment and Confi guration of ORDS
- Deployment of the Load Balancer
- High Availability Scenarios
- Loss of a Database Node
- Loss of an Application Server Node
- Overview of a Solution Using Data Guard
- Data Guard as a Complement to RAC
- Summary
- Chapter 7: APEX in a Multitenant Database
- Default Installation of APEX in a Multitenant Database
- Different Scenarios of APEX Deinstallation and Installation
- Upgrade APEX in the CDB
- Deinstallation of the Common APEX from the CDB
- Installation of the Common APEX in the CDB
- Installation of a Dedicated APEX in the PDB
- Different Scenarios of Moving/Cloning a PDB
- Source PDB Has APEX in the CDB
- Source PDB Has APEX in the PDB
- Source PDB Doesn’t Have APEX
- Move or Copy a PDB with Incompatible Versions of APEX
- Summary
- Part III: Confi guration
- Chapter 8: Installing
- Preinstallation Steps
- Downloads
- Download APEX
- Download ORDS
- Installing APEX in the Database
- Tablespaces for APEX
- Installing with DBCA
- Installing APEX Using the Downloaded Scripts
- Postinstall
- Installing ORDS
- Confi gure ORDS
- Deploying the War Files
- Uninstall
- Removing APEX
- 1 Drop All APEX-Related Schemas
- 2 Drop APEX Tablespaces
- 3 Undeploy ORDS
- Summary
- Chapter 9: Upgrading and Patching
- Upgrading APEX
- Planning an Upgrade
- Preupgrade Tasks
- Upgrading APEX
- Postupgrade
- Patching
- Planning a Patch
- Downloading an APEX Patch
- Installing an APEX Patch
- Summary
- Chapter 10: Confi guring
- Manage Instance
- Instance Settings
- Manage Metadata
- Manage Logs and Files
- Manage Shared Components
- Messages
- Manage Workspaces
- Create a Workspace
- Create Multiple Workspaces
- Removing / Locking a Workspace
- Manage Workspace to Schema Assignments
- Manage Developers and Users
- Manage Component Availability
- Export/Import
- Existing Workspaces
- Workspace Reports
- Manage Applications
- Monitor Activity
- Monitoring Reports
- Summary
- Chapter 11: Administering APEX in a Runtime-Only Mode
- APEX Runtime-Only Setup
- Install APEX in Runtime Only
- Remove the APEX Builder
- Install APEX Builder
- Managing Applications
- Deploying Applications
- Change Application Build Status
- Manage Translations
- Exporting Applications
- Managing the Instance
- Manage the Instance with APEX_INSTANCE_ADMIN
- Manage Users and Developers
- APEX Administrator Role
- APEX Dictionary Views
- Summary
- Chapter 12: Database and APEX Backups
- Database Backup
- Physical Backup
- Logical Database Backups
- Flashback Technology
- APEX Components Backup
- Using Application Express Developer
- Using APEXExport
- APEX Components Restore
- Parsing Schema Restoration
- Workspace Import
- Application Import
- Summary
- Chapter 13: Self-Provisioning Workspaces
- Self-Service Provisioning Setup
- Enabling Self-Provisioning
- Storage Options
- Manage New Service Signup Wizard
- New Workspace Request Size
- Manage Requests
- How Self-Provisioning Works
- Request a New Workspace
- Workspace Change Requests
- Enable Service Requests
- Workspace Change Request Size
- Request Schema
- Request Storage
- Request Termination
- Service Requests Monitoring
- New Service Requests
- Signup Survey
- Summary
- Part IV: Tuning
- Chapter 14: Monitoring
- Database Monitoring
- Oracle Enterprise Manager
- AWR
- Database Monitor
- APEX Monitoring
- Monitoring APEX Applications at the Database Level
- Monitoring APEX Applications at the Workspace Level
- Monitoring APEX Applications Using APEX and Database Views
- Summary
- Chapter 15: Performance and Tuning
- Tuning Application
- Enabling Oracle Tracing
- Using TKPROF
- Execution Plans
- Tuning Reports
- Using DEBUG mode
- Enabling Debug Mode
- Running the Application in Debug Mode
- Viewing Debug Mode Reports
- Best Practices
- Summary
- Chapter 16: Resource Manager and APEX
- Overview of Resource Manager
- Resource Manager with Multitenant Database
- Confi guring APEX Workspace to Use Resource Manager
- Resource Manager Demonstrations
- CPU Utilization Limits at the CDB Level
- Runaway and Consumer Group Switching at the PDB Level
- Summary
- Index
