I searched extensively but I couldn't find clarity, whether Primary Key (In this case, composite of Foo1ID and Foo2ID) should be selected into foo_cursor, even if not used in the procedure? Is it sufficient to rely on some internal mechanism (ROWID?) that will be able to uniquely...

Sometimes when I use a QB_NAME hint, when I later look at the execution plan, there is no record of that query block name. Why is this the case ?

Why is the size of shared pool in the query not exactly the same as in the init.ora (52,428,800)? It is slightly large (54,361,560). SVRMGR> select pool,to_char(sum(bytes),'999,999,999') from v$sgastat group by pool ; POOL TO_CHAR(SUM( ----------- ------------ java pool

Hi Tom, It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import. We've lost impdp logs, How could we get information about the impdp command that was run and clarify the issue? Thanks a lot Regards!

hi Tom, when a remote table is referred in sub query then it is not retrieving the data and it throws error. refer the below sql, I am trying to get latest record, so I am doing order by DATEM in sub query and taking first record in outer sql. here, OWNERDOCUMENTS used in FROM cl...