performance problem

Hello all,

We've some performance problems but we're searching where is the problem. We've found that our tablespaces have many extends :

select tablespace_name tablespace,round(sum(bytes)/1024)||'K' libre, count(*) extent,min(bytes) petit,max(bytes) gros from dba_free_space group by tablespace_name;

TABLESPACE LIBRE EXTENT PETIT GROS --------------- ---------- ----------- ----------- -----------

GFC             72220K              72       30720    15104000
GRH             44994K              58        2048     6932480
RBS             27054K               1    27703296    27703296
SCOL            65658K              33       20480    39524352
SYSTEM          98818K              54       10240    28383232
TEMP            49148K               2     8386560    41940992
TOOLS           41018K               1    42002432    42002432
USERS           8190K                1     8386560     8386560

Do we need to defrag our tablespaces ? or where else is the problem ?

With Oracle Entreprise Manager, I found that we can defrag some tables (many of our tables have 10-15 extends) but we've an error message. A guy said that we must log on oracle with sysdba privilege. The sys user has already the sysdba privilege :
select * from v$pwfile_users

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE

but if I use the password defined with the orapwd command when I "connect sys as sysdba", the password is not ok (ORA-01017)

Thanks for any info. Received on Mon Jun 07 1999 - 05:12:25 CDT