In studying aspects of oracle a realize that the schema concept is quite elaborate and that they are many internal tables that I can reference.

For example, I came across this code

SELECT table_name from all_tables where owner = 'My_Schema_Name';

and I got a list of all the tables in my schema. That could be very useful.

Could you provide of list of useful internal "tables" or perhaps some reference material that I can review.
I have no immediate need, but I don't know what I don't know 8-)

Joseph Giallombardo