SQL Performance (MOSC)

MOSC Banner

oracle system one sql run too long time

edited Jul 28, 2025 1:59PM in SQL Performance (MOSC) 10 commentsAnswered

select t., o., m.comments
from sys.all_tables t,
sys.all_tab_comments m,
sys.all_objects o
where t.owner = :object_owner
and t.table_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and o.owner (+) = :object_owner
and o.object_name (+) = :object_name
and :object_type is not null
and :sub_object is null

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center