TRCA, native compilation.
I am trying to use natural compilation for TRCA, but it doesn't work. I set the plsql_code_type to NATIVE in my session (connected as sysdba) and run tacreate. When I check the result here is what I get:
SQL> select owner,object_name,object_type
2 from dba_objects o, ncomp_dll$ d
3 where o.object_id=d.obj#;
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------- -------------------
SYS SQLT$_TRCA$_DIR_SET PROCEDURE
SYSTEM DBA_HELPER PACKAGE BODY
There is only a single procedure owned by sys which is compiled natively. Not even utl_recomp.recomp_serial('TRCADMIN') will do the trick.
SQL> select owner,object_name,object_type
2 from dba_objects o, ncomp_dll$ d
3 where o.object_id=d.obj#;
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------- -------------------
SYS SQLT$_TRCA$_DIR_SET PROCEDURE
SYSTEM DBA_HELPER PACKAGE BODY
There is only a single procedure owned by sys which is compiled natively. Not even utl_recomp.recomp_serial('TRCADMIN') will do the trick.
0