Home » RDBMS Server » Performance Tuning » Statspack
Statspack [message #139101] Mon, 26 September 2005 10:29 Go to next message
pjose
Messages: 6
Registered: September 2005
Location: NJ
Junior Member

Hi,

I'm on Solaris2.9 and Oracle 9i.

If I've more than one database running on a machine, do I need to install statspack in each and every Databasse to monitor them? Or is there a way to get the status of all these DBs just installing it in one DB?

Thanks

Report message to a moderator

Re: Statspack [message #139236 is a reply to message #139101] Mon, 26 September 2005 23:46 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

I am afraid , you need to install statspack on both the databases.
But if there is any option to do it just for one then even i want to know the procedure.

Waiting for others to chip in.

Report message to a moderator

Re: Statspack [message #139723 is a reply to message #139236] Thu, 29 September 2005 05:52 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Yes, you need to install statspck separately on each database.

As for way to get the status of all these DBs, did you ever considered configuring the OEM. It might help.

--Girish

Report message to a moderator

Previous Topic: SQL TRACE
Next Topic: how to rebuild index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:41:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.