CPU consuming perl.exe after start of dbconsole 11g
edited Aug 10, 2009 1:34AM in Managing Databases using Enterprise Manager (MOSC) 18 commentsAnswered
Hi,
we just made an Upgrade from 9.2.0.7.0 to 11.1.0.7.0 on a MS Windows Server 2003 R2, Standard Edition SP2 ( virtual Machine, Test environment ).
Most things worked fine and the database is now running, but :
When starting up the dbconsole-service we have a 100% CPU-Usage of 2 GB memory, ASSM activated of perl.exe for about 2-4 hours.
Looking up the processes we can see it is a process under User dbsnmp executing following statement:
SELECT DISTINCT grantee, privilege
FROM dba_tab_privs
WHERE table_name = 'DBA_ROLE_PRIVS'
( where the table_name varies by time )
We are a little unfamiliar with 11g by now.
we just made an Upgrade from 9.2.0.7.0 to 11.1.0.7.0 on a MS Windows Server 2003 R2, Standard Edition SP2 ( virtual Machine, Test environment ).
Most things worked fine and the database is now running, but :
When starting up the dbconsole-service we have a 100% CPU-Usage of 2 GB memory, ASSM activated of perl.exe for about 2-4 hours.
Looking up the processes we can see it is a process under User dbsnmp executing following statement:
SELECT DISTINCT grantee, privilege
FROM dba_tab_privs
WHERE table_name = 'DBA_ROLE_PRIVS'
( where the table_name varies by time )
We are a little unfamiliar with 11g by now.
0