image

which process writes previous image to undo tablespace?

server process..Sounds like a trick question. I do not think there is (or can be) such a process. Every server process has to write undo information by itself as it updates the database blocks in the buffer cache. This cannot be deferred to a background operation.  

image

ORA-25153: Temporary Tablespace is Empty

Problem Description: During the Fine Grained Auditing , first i created the following script SQL>connect / as sysdba SQL>begin DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA=>’CMS_USER’, OBJECT_NAME=>’hearing’, POLICY_NAME=>’hearing_policy’, AUDIT_COLUMN=>’hearing_title’, STATEMENT_TYPES=>’UPDATE,DELETE,SELECT’ ); END; After executing the above query , i run the following query SQL>connect cms_user/cms; SQL>select * from hearing Which result the error: ┬áTemporary Tablespace is Empty What the Problem … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube