Home » RDBMS Server » Enterprise Manager » Statistics Oracle (Oracle 10g 10.2.0.1 RHEL5)
Statistics Oracle [message #379968] Thu, 08 January 2009 13:04 Go to next message
marcossantos
Messages: 114
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
Re: Statistics Oracle [message #379987 is a reply to message #379968] Thu, 08 January 2009 17:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Statistics Oracle [message #379988 is a reply to message #379987] Thu, 08 January 2009 17:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you licensed to use AWR?
Re: Statistics Oracle [message #380168 is a reply to message #379968] Fri, 09 January 2009 06:36 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,
Its enable AWR.

Marcos santos
Re: Statistics Oracle [message #380179 is a reply to message #380168] Fri, 09 January 2009 07:14 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: Statistics Oracle [message #380186 is a reply to message #379968] Fri, 09 January 2009 07:42 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,
how can I confirm this?

Thanks,
Marcos Santos
Re: Statistics Oracle [message #380194 is a reply to message #380186] Fri, 09 January 2009 08:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
It is documented in the licensing guide.
Re: Statistics Oracle [message #380794 is a reply to message #380194] Tue, 13 January 2009 06:58 Go to previous messageGo to next message
marcossantos
Messages: 114
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
Re: Statistics Oracle [message #380796 is a reply to message #380794] Tue, 13 January 2009 06:59 Go to previous messageGo to next message
marcossantos
Messages: 114
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 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Contact your Oracle support at https://metalink2.oracle.com/metalink/plsql/fee_main.startup

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


Current Time: Sun Dec 11 08:30:01 CST 2016

Total time taken to generate the page: 0.13407 seconds