My Oracle Support Banner

ALL_ALL_TABLES performance is slow (Doc ID 3034651.1)

Last updated on JULY 29, 2024

Applies to:

Autonomous Database Serverless - Version N/A to N/A
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

When using ADB-S as a data source of Tableau Desktop, SELECT statements to ALL_VIEWS and ALL_ALL_TABLES issued by Tableau side take more than 150 seconds to execute. It appears to be an Oracle Database issue because running same SELECT statements in Database Actions take the same amount of time.

Changes

About 500 rows in the result.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.