e******r
发帖数: 220 | 1 I have a sample like this at hand.
EXEC DBMS_STATS.GATHER_TABLE_STATS(null,'JN_LINK_NAV_SPATIAL',estimate_
percent => 5, cascade => true);
thanks | t*********i
发帖数: 217 | 2 this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema | e******r
发帖数: 220 | 3 How to visit package DBMS_STATS in SYS schema? hehe
schema
【在 t*********i 的大作中提到】
: this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema
| t*********i
发帖数: 217 | 4 since you are using toad, find SYS in the drop down list on upperleft side,
click it; find the package or procedure label on left panel, click it, then
find the procedure.packages you want to see.
Ask your DBA for privilege if you don't have the permission to view sys/
system objects.
But I doubt they will give it to you if you are not a DBA... | e******r
发帖数: 220 | 5 cool, got it , thanks a lot.
,
then
【在 t*********i 的大作中提到】
: since you are using toad, find SYS in the drop down list on upperleft side,
: click it; find the package or procedure label on left panel, click it, then
: find the procedure.packages you want to see.
: Ask your DBA for privilege if you don't have the permission to view sys/
: system objects.
: But I doubt they will give it to you if you are not a DBA...
| B*****g
发帖数: 34098 | 6 desc DBMS_STATS
【在 e******r 的大作中提到】
: cool, got it , thanks a lot.
:
: ,
: then
| j***a
发帖数: 10844 | 7 You can only see the procedure name and passing parameters of those packages
, but not the actual code because they are wrapped. |
|
