Hi,
Oracle 9i R2
I would like to know where Oracle stores the external refereence to it's pl/sql-object when it's native compiled.
Regards
Orca
:cool:
Hi,
Oracle 9i R2
I would like to know where Oracle stores the external refereence to it's pl/sql-object when it's native compiled.
Regards
Orca
:cool:
Hi amar,
thank you!
i looked at the article but nothing about a view which shows external path of the internal pl/sql-object. :-(
PS.: i like your phrase : "There is a difference between knowing the path and walking the path."
it's spiritual deeply true!
Orca
:cool:
Try all_stored_settings,dba_stored_settings,user_stored_settings... Though im not sure if this what you are looking for...
No, sorry
this views show only the state of Pl/Sql-object but not the
storage-place on filesystem.
Orca
:cool:
AFAIK the location of the library storage is defined by the parameter
PLSQL_NATIVE_LIBRARY_DIR
But if you are looking for a view or a table that shows the exact file name that was generated with native compilation, then i haven't seen any such view which shows the name of the library generated. May others can help on this.