Would the Oracle monitoring of SQL PI product expect to see data (i.e. how does the functionality work) in the following scenario?
• The database ran out of TEMP space in Oracle in the instance on Nov-17 night around midnight.
• A DBA watched the system and confirmed that this was caused by the INSERT INTO TABLENAME statement
• SQL PI did not show that INSERT statement running on Nov-17 around midnight and the Files area in the tree did not show the systemtemp.dbf file listed
• The only activity for this INSERT statement was around midnight on Nov15
Should the user have seen the INSERT statement in SQL PI on Nov-17 when the datafile ran out of temp space?
Should the user have seen the systemtemp.dbf data file in the tree if Nov-17 when the datafile ran out of temp space?. "