I want to know how much pages are used by one user ("used pages" and "long
column pages" of tablestatistics + "used pages" of indexstatistics + "?
pages of sources of PLSQL" + "? pages of bytecodes of PLSQL"). How can I
see this?
Again, very thanks.
-----Mensaje original-----
De: PUB: Anhaus, Thomas [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, May 29, 2002 6:16 AM
Para: '[EMAIL PROTECTED]'
CC: '[EMAIL PROTECTED]'
Asunto: RE:sizes of dbproc
Osvaldo Demiere wrote
>Hi to all,
>If you want know the size of a table, use TABLESTATISTICS.
>If you want know the size of a index, use INDEXSTATISTICS.
>How to check the size of Stored Procedures or Triggers?
>Thanks!
At the moment we have no table, which yields information about the size of a
stored procedure or trigger.
BTW : what would you expect as size of a procedure ?
a) length of the definition
b) size of the generated byte code
c) something else
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
