EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

EDB Postgres Advanced Server → 12 → User Guides → Database Compatibility for Oracle® Developers Tools and Utilities Guide
Other versions of this page: 12 · 11 · 10 · 9.6

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

Table of Contents Previous Next


Table of Contents

1 Introduction
1.1 Typographical Conventions Used in this Guide
2 EDB*Loader
2.1 Data Loading Methods
2.2 General Usage
2.3 Building the EDB*Loader Control File
2.4 Invoking EDB*Loader
2.4.1 Exit Codes
2.5 Direct Path Load
2.6 Parallel Direct Path Load
2.7 Remote Loading
2.8 Updating a Table with a Conventional Path Load
3 EDB*Wrap
3.1 Using EDB*Wrap to Obfuscate Source Code
4 Dynamic Runtime Instrumentation Tools Architecture (DRITA)
4.1 Configuring and Using DRITA
4.2 DRITA Functions
4.2.1 get_snaps()
4.2.2 sys_rpt()
4.2.3 sess_rpt()
4.2.4 sessid_rpt()
4.2.5 sesshist_rpt()
4.2.6 purgesnap()
4.2.7 truncsnap()
4.3 Simulating Statspack AWR Reports
4.3.1 edbreport()
4.3.2 stat_db_rpt()
4.3.3 stat_tables_rpt()
4.3.4 statio_tables_rpt()
4.3.5 stat_indexes_rpt()
4.3.6 statio_indexes_rpt()
4.4 Performance Tuning Recommendations
4.5 Event Descriptions
5 Acknowledgements

Table of Contents Previous Next
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks