OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » OEM guidance

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OEM guidance [message #329189]

Tue, 24 June 2008 08:11

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

hey,

I am using OEM for the first time.

Can anyone please tell me how does one check the

initialisation parameters
buffer cache hit ratio
locks
schema
security
storage

from OEM

Please navigate me through this

Report message to a moderator

Re: OEM guidance [message #329195 is a reply to message #329189]

Tue, 24 June 2008 08:17

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Version (at least 2 decimals)?

Regards
Michel

Report message to a moderator

Re: OEM guidance [message #329196 is a reply to message #329195]

Tue, 24 June 2008 08:20

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

9.2.0.1.0

Report message to a moderator

Re: OEM guidance [message #329285 is a reply to message #329189]

Tue, 24 June 2008 22:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>buffer cache hit ratio
The BCHR is a Mythical Indicator of Performance.
It is as relevant to RDBMS performance as is Relative Humidity %.

Report message to a moderator

Re: OEM guidance [message #329293 is a reply to message #329189]

Tue, 24 June 2008 23:34

ora110
Messages: 42
Registered: September 2007
Location: China

Member

I think you should use shell-script to check THESE items.
It is not a good idea to see information from OEM.

Report message to a moderator

Re: OEM guidance [message #329309 is a reply to message #329293]

Wed, 25 June 2008 00:28

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

yes i use scripts only to check , but i want to know how to see them through the OEM.

Report message to a moderator

Re: OEM guidance [message #329491 is a reply to message #329309]

Wed, 25 June 2008 10:26

alanm
Messages: 284
Registered: March 2005

Senior Member

hi,
so you currently have shell scripts that call sqlplus and run a sql script?

You can create a sql job in OEM to run these scripts.

From most pages on OEM there is a 'jobs' link. From here you just create you sql script and then you can give it a schedule or just run it now.

regards

Alan

[Updated on: Thu, 17 July 2008 11:16] by Moderator

Report message to a moderator

Re: OEM guidance [message #329549 is a reply to message #329491]

Wed, 25 June 2008 15:21

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

hey,

Ya i just want to know how do u check the above parameters through oracle enterprise manager. Where do we go once we have connected to the DB using OEM

Report message to a moderator

Re: OEM guidance [message #329561 is a reply to message #329549]

Wed, 25 June 2008 17:14

alanm
Messages: 284
Registered: March 2005

Senior Member

when you installed the DB did you opt for em control if yes then you will have a URL like

http://ip address of server:1158/em

login to this to bring up the gui interface for you database.

you will see the db home page. have a look round here first and see what OEM has to offer.

regards

Alan

[Updated on: Thu, 17 July 2008 11:16] by Moderator

Report message to a moderator

Previous Topic:	Agent Unavailable
Next Topic:	Linking a new database with some existing datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 07:12:06 CST 2024