Home » RDBMS Server » Enterprise Manager » OEM guidance
OEM guidance [message #329189] Tue, 24 June 2008 08:11 Go to next message
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

Re: OEM guidance [message #329195 is a reply to message #329189] Tue, 24 June 2008 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Version (at least 2 decimals)?

Regards
Michel
Re: OEM guidance [message #329196 is a reply to message #329195] Tue, 24 June 2008 08:20 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
9.2.0.1.0
Re: OEM guidance [message #329285 is a reply to message #329189] Tue, 24 June 2008 22:50 Go to previous messageGo to next message
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 %.
Re: OEM guidance [message #329293 is a reply to message #329189] Tue, 24 June 2008 23:34 Go to previous messageGo to next message
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.
Re: OEM guidance [message #329309 is a reply to message #329293] Wed, 25 June 2008 00:28 Go to previous messageGo to next message
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.

Re: OEM guidance [message #329491 is a reply to message #329309] Wed, 25 June 2008 10:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: OEM guidance [message #329561 is a reply to message #329549] Wed, 25 June 2008 17:14 Go to previous message
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:
  


Current Time: Fri Nov 22 22:01:53 CST 2024