No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 27-MAR-14
Type Bug
User Anonymous
Message # sqlplus 'plato/*********' @plato_54_10gR2.sql

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Mar 27 13:12:28 2014

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)

================================================================================
== VERIFYING PREREQUISITES ... ==
================================================================================

Prerequisites ok.

Creating main package specification...
No errors.
Creating utility package...
No errors.
Creating utility package body...
No errors.
Creating stats package...
No errors.
Creating stats package body...
No errors.
Creating storage package...
No errors.
Creating storage package body...
No errors.
Creating audit package...
No errors.
Creating audit package body...
No errors.
Creating main package body...
No errors.
=============================================================================================
= PLATO Database report 54, build 1397, generated on 27-Mar-14 13:16:16 on instance ****** =
= Geert De Paep, www.dba-village.com =
=============================================================================================


PLATO - PLsql package for Auditing and Tuning of Oracle databases
=================================================================
This package is intended for Oracle 8.1.7 and higher.
It uses only selects, no ins/upd/del, create, alter, drop or truncate,
except the Tuning module, which inserts into the temporary table PLATO$GDP_TEMP
You may be able to run it in 8.1.5 or 8.1.6 if you first create the htp
package that comes with the mod_plsql of Oracle 8.1.7 and higher,
or at least this package.procedure: htp.prn(X in varchar2)

Usage:
------
Local HTML file:
Open DOS or unix prompt
sqlplus "sys@<DbAlias> as sysdba"
SQL> set serveroutput on
SQL> spool report.htm
SQL> exec plato.audit('HTM');
SQL> spool off
SQL> exit

Ascii mode:
Open DOS or unix prompt
sqlplus "sys@<DbAlias> as sysdba"
SQL> set serveroutput on format wrapped
SQL> set lines 1000 trimspool on feed off
SQL> spool report.txt
SQL> exec plato.audit('TXT');
SQL> spool off
SQL> exit
Note: do "exec plato.env" to remember SQL*Plus settings

Mod_plsql:
Configure DAD
http://host:port/pls/DAD/plato.audit?FormatA=HTP

Others:
plato.Help('HTM');
plato.About('HTM');
plato.Inventory('HTM');
plato.Footprint('HTM');
plato.Storage('HTM');
plato.SystemState('HTM');
plato.Tuning('HTM',30); ("30": run for 30 seconds)
plato.SessionDetails('HTM',<SessionId>[,<InstId>]);
plato.ProcessDetails('HTM',<Spid>[,<InstId>]);
plato.Complete('HTM');

E.g. copy/paste:

set serveroutput on format wrapped
set lines 1000 trimspool on feed off
spool rep_****_20140327.htm
exec plato.audit('HTM');
spool off


Changelog now available in procedure plato.About
To uninstall: DROP packages PLATO% and tables PLATO$GDP% ,
DROP VIEWS SYS.PLATO$GDP$KSPPI and SYS.PLATO$GDP$KCCDI;

(c) Geert De Paep, Belgium - http://www.dba-village.com
[Report generated in 0 seconds with 0 sort usage.]
This package expires on Feb 01, 2014
===================================================
The problem is:

"generated on 27-Mar-14 13:16:16 on instance ****** "
and
"This package expires on Feb 01, 2014"

In reports I have:
"This package is expired."


Thank You