OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » Statistics Oracle (Oracle 10g 10.2.0.1 RHEL5)

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

Statistics Oracle [message #379968]

Thu, 08 January 2009 13:04

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
How can I obtain the following data:
a) Total logons (day)
b) Transactions / day
c) Sort on Disc
d) and other information like this.

Thanks,
Marcos Santos

Report message to a moderator

Re: Statistics Oracle [message #379987 is a reply to message #379968]

Thu, 08 January 2009 17:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Enable Auditing.
Look into v$*metric* views.
You may want to hunt down what you want.

Report message to a moderator

Re: Statistics Oracle [message #379988 is a reply to message #379987]

Thu, 08 January 2009 17:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you licensed to use AWR?

Report message to a moderator

Re: Statistics Oracle [message #380168 is a reply to message #379968]

Fri, 09 January 2009 06:36

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
Its enable AWR.

Marcos santos

Report message to a moderator

Re: Statistics Oracle [message #380179 is a reply to message #380168]

Fri, 09 January 2009 07:14

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Only users that licensed Oracle Enterprise Manager Diagnostic Pack are entitled to use AWR. If I were you, I would confirm with management before using it. Unfortunately is is possible (shame on Oracle!) to have it enabled and to use it illegally.

Report message to a moderator

Re: Statistics Oracle [message #380186 is a reply to message #379968]

Fri, 09 January 2009 07:42

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
how can I confirm this?

Thanks,
Marcos Santos

Report message to a moderator

Re: Statistics Oracle [message #380194 is a reply to message #380186]

Fri, 09 January 2009 08:23

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

It is documented in the licensing guide.

Report message to a moderator

Re: Statistics Oracle [message #380794 is a reply to message #380194]

Tue, 13 January 2009 06:58

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I have this information about
my license number to Oracle:

The following products and platforms are listed
under this license number :

Product Platform
All Products All Platforms
Oracle Application Server 10g All Platforms
Oracle Server - Enterprise Edition All Platforms

Thanks,
Marcos Santos

Report message to a moderator

Re: Statistics Oracle [message #380796 is a reply to message #380794]

Tue, 13 January 2009 06:59

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I have this information about
my license number to Oracle:

Quote:

The following products and platforms are listed
under this license number :

Product Platform
All Products All Platforms
Oracle Application Server 10g All Platforms
Oracle Server - Enterprise Edition All Platforms

Thanks,
Marcos Santos

[Updated on: Tue, 13 January 2009 07:01]

Report message to a moderator

Re: Statistics Oracle [message #380800 is a reply to message #380796]

Tue, 13 January 2009 07:19

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

Senior Member
Account Moderator

Contact your Oracle support at https://metalink2.oracle.com/metalink/plsql/fee_main.startup

Regards
Michel

Report message to a moderator

Previous Topic:	Problems to configure destinations in EM Grid Control
Next Topic:	Agent and Grid Control: Error creating aq agent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 23:25:31 CST 2024