Uploaded September 2026 | Updated November 2026, 2 days ago
How do you troubleshoot common Oracle Database issues across application design, Data Pump, multitenant architecture, and PL/SQL?
Ask TOM Live for Database gives developers and DBAs practical answers to real Oracle Database questions. In this episode, Connor McDonald covers object types, Data Pump column mismatches, Application Containers, session protection, and BULK COLLECT behavior.
You will learn how to:
- Query object types used as table columns
- Investigate Data Pump column mismatches
- Understand the role of Application Containers
- Review session protection as a DBA safeguard
- Investigate unexpected FETCH BULK COLLECT counts
Resources:
docs.oracle.com/en/database/oracle/oracle-database/26/multi/application-containers2.html
docs.oracle.com/en/database/oracle/oracle-database/26/sutil/oracle-data-pump-overview.html
docs.oracle.com/en/database/oracle/oracle-database/26/lnpls/bulk-sql-and-bulk-binding.html
https://linktr.ee/connor
Subscribe for new Oracle Database technical videos every week.
Chapters
00:00 Introduction
13:00 Querying object types as table columns
19:20 Handling Data Pump column mismatches
28:50 Exploring Application Containers
48:10 Session protection
56:30 Investigating anomalous FETCH BULK COLLECT counts
#OracleDatabase #ApplicationContainers #DataPump #PLSQL #AskTOMLive
How do you troubleshoot common Oracle Database issues across application design, Data Pump, multitenant architecture, and PL/SQL?
Ask TOM Live for Database gives developers and DBAs practical answers to real Oracle Database questions. In this episode, Connor McDonald covers object types, Data Pump column mismatches, Application Containers, session protection, and BULK COLLECT behavior.
You will learn how to:
- Query object types used as table columns
- Investigate Data Pump column mismatches
- Understand the role of Application Containers
- Review session protection as a DBA safeguard
- Investigate unexpected FETCH BULK COLLECT counts
Resources:
docs.oracle.com/en/database/oracle/oracle-database/26/multi/application-containers2.html
docs.oracle.com/en/database/oracle/oracle-database/26/sutil/oracle-data-pump-overview.html
docs.oracle.com/en/database/oracle/oracle-database/26/lnpls/bulk-sql-and-bulk-binding.html
https://linktr.ee/connor
Subscribe for new Oracle Database technical videos every week.
Chapters
00:00 Introduction
13:00 Querying object types as table columns
19:20 Handling Data Pump column mismatches
28:50 Exploring Application Containers
48:10 Session protection
56:30 Investigating anomalous FETCH BULK COLLECT counts
#OracleDatabase #ApplicationContainers #DataPump #PLSQL #AskTOMLive










