Home » RDBMS Server » Server Administration » Missing in oracle10g OEM (merged)
Missing in oracle10g OEM (merged) [message #349017] Thu, 18 September 2008 10:14 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Hello,

I was using oracle9i OEM and I was able to list the session based on the below columns.

CPU,
Memory-PGA
I/O-Phys Reads
Logical Reads
Hard Parse


Now I installed oracle10g OEM and I am missing these. Did I miss anything in the installation? Can any one help me on this?


Missing in oracle10g OEM [message #349018 is a reply to message #349017] Thu, 18 September 2008 10:15 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Hello,

I was using oracle9i enterprise Manager console and I was able to list the session based on the below columns.

CPU,
Memory-PGA
I/O-Phys Reads
Logical Reads
Hard Parse


Now I installed oracle10g enterprise Manager console and I am missing these. Did I miss anything in the installation? Can any one help me on this?


Re: Missing in oracle10g OEM [message #349051 is a reply to message #349018] Thu, 18 September 2008 13:03 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
You can check the similar information under
Performance -> Top Consumers -> Top Sessions

regards
--Mak
Re: Missing in oracle10g OEM [message #349293 is a reply to message #349051] Fri, 19 September 2008 13:07 Go to previous message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Mak, I have installed oracle enterprise manager console.

For oracle9i,

Login to system user, then click session, then right hand side, i see the below info.

SID
CPU
Memory -PGA
IO-phys reads
logical reads
hard parse
status
username
osuser
os process id
machine name
program
consumer group
timeout

After i intall oracle enterprise manager, i see only these columns

sid
status
username
osuser
os processid
machine name
program
consumer group
time out

I don't find this Performance -> Top Consumers -> Top Sessions in oracle10g Enterprise manager console.

[Updated on: Fri, 19 September 2008 13:08]

Report message to a moderator

Previous Topic: Kill IDLE sessions after time out (merged)
Next Topic: analyze schema hangs
Goto Forum:
  


Current Time: Sat Dec 07 04:56:33 CST 2024