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 14-NOV-05
Type Comment
User Guy Gyles
Message Although PLATO was not new for me, great stuff Geert.

It's indeed consuming a lot of CPU, even when invoking exec plato.audit('TXT');.

In the MV section we have (for one of our databases): "Error in Materialized views: ORA-06502: PL/SQL: numeric or value error."! All the MV's are in compiled state and are recently refreshed!

Is there a specific reason why there is a limit on:
- Omitting datafile info, because too many files
- Tablespace storage parameters: skipping, because too many tablespaces
- Skipping file IO statistics, because too many files
- Segment size owner vs tablespace: skipping, too many tablespaces

Okay, a solution is mentioned ... Use plato.storage instead, but a parameter whould be nice parameter to increase / modify this? Just an idea.

Kind regards,
Guy