from oracle doc,
If temporary table, then duration is sys$session or
sys$transaction, else NULL.

can you clarify,

what is meant by sys$session?

what is meant by sys$transaction.

thank you,

-Raja