Home » RDBMS Server » Enterprise Manager » Database Usage Statistics page in Database Control?
icon5.gif  Database Usage Statistics page in Database Control? [message #118492] Thu, 05 May 2005 10:20 Go to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
I'm looking for a feature in 10g that claims to be on the "Database Usage Statistics" page, which I can't find. The online help says you can reach this page from the main Administration page by clicking the Database Usage Statistics link under the Instance heading. This link doesn't exist on my Admin page, let alone under Instance.

Has anyone seen this page?

I'm using OEM DC v10.1.0.2

Thanks,
John
Re: Database Usage Statistics page in Database Control? [message #118518 is a reply to message #118492] Thu, 05 May 2005 12:09 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

From the DB Control Home page, click "Administration" and then "Database Usage Statistics" under the "Configuration Management" section.

However, it might be easier to just do a "select * from dba_feature_usage_statistics;"

Best regards.

Frank
Re: Database Usage Statistics page in Database Control? [message #118520 is a reply to message #118518] Thu, 05 May 2005 12:17 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Hi Frank,

The only link I have under Configuration Management is "Last Collected Configuration". That doesn't seem to give the stats I'm looking for.

The "dba_feature_usage_statistics" view seems to be empty for me: I got 59 empty (and very badly formatted) rows as a result, which makes sense, since I can't locate the OEM page to use play with the stats!

A query on DBA_HIGH_WATER_MARK_STATISTICS gave me some stats, but I would guess these are different than those I would find in that page/view.

BTW, is there a way to fix query output so it doesn't sprawl itself needlessly over multiple lines and becomes a bit more readable than what I'm getting now?

Thanks,
John
Re: Database Usage Statistics page in Database Control? [message #118542 is a reply to message #118520] Thu, 05 May 2005 15:12 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Very strange. Can you verify that your STATISTICS_LEVEL parameter is set to either TYPICAL or ALL (and not BASIC).

DBControl formats the data nicely, but doesn't display any information that you cannot SELECT from SQL*Plus. You can use normal sqlplus formatting to make the output more readable.

Best regards.

Frank
Re: Database Usage Statistics page in Database Control? [message #118544 is a reply to message #118542] Thu, 05 May 2005 15:19 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Frank Naude wrote on Thu, 05 May 2005 16:12

Very strange. Can you verify that your STATISTICS_LEVEL parameter is set to either TYPICAL or ALL (and not BASIC).

DBControl formats the data nicely, but doesn't display any information that you cannot SELECT from SQL*Plus. You can use normal sqlplus formatting to make the output more readable.

Best regards.

Frank

Yup: STATISTICS_LEVEL=ALL. Some sources say the link is under "Instance", and some folks say "Configuration Management". Unfortunately, for me it's nowhere on the page.

Actually, how to set SQL*Plus SELECT query formatting was exactly what I meant to ask... I never use DC to query data, but it comes out looking badly-wrapped and ugly at times in SQL*Plus. How do you do it?

Thanks,
John
Re: Database Usage Statistics page in Database Control? [message #118625 is a reply to message #118544] Fri, 06 May 2005 09:44 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
SQL*Plus formatting is documented in the SQL*Plus User's Guide and Reference. Here is a quick example:

SQL> SET PAGES 50000
SQL> COL "Component" FORMAT A50 TRUNC
SQL>
SQL> SELECT name "Component", currently_used "Used",
  2         first_usage_date "Start", last_usage_date "Last Time"
  3    FROM dba_feature_usage_statistics
  4  /

Component                                          Used  Start Last Time
-------------------------------------------------- ----- --------- ---------
Advanced Replication                               FALSE
Advanced Security                                  FALSE
Audit Options                                      FALSE
Automatic Database Diagnostic Monitor              FALSE
Automatic Segment Space Management (system)        TRUE  05-JAN-05 30-APR-05
Automatic Segment Space Management (user)          TRUE  05-JAN-05 30-APR-05
Automatic SQL Execution Memory                     TRUE  05-JAN-05 30-APR-05
Automatic Storage Manager                          FALSE
Automatic Undo Management                          TRUE  05-JAN-05 30-APR-05
Automatic Workload Repository                      FALSE
Change-Aware Incremental Backup                    FALSE
Client Identifier                                  FALSE
Data Guard                                         FALSE
Data Guard Broker                                  FALSE
Data Mining                                        FALSE
Dynamic SGA                                        FALSE
File Mapping                                       FALSE
Flashback Database                                 FALSE
Internode Parallel Execution                       FALSE
Label Security                                     FALSE
Locally Managed Tablespaces (system)               TRUE  05-JAN-05 30-APR-05
Locally Managed Tablespaces (user)                 TRUE  05-JAN-05 30-APR-05
Messaging Gateway                                  FALSE
MTTR Advisor                                       FALSE
Multiple Block Sizes                               FALSE
OLAP - Analytic Workspaces                         FALSE
OLAP - Cubes                                       FALSE
Oracle Managed Files                               FALSE
Parallel SQL DDL Execution                         FALSE
Parallel SQL DML Execution                         FALSE
Parallel SQL Query Execution                       FALSE
Partitioning (system)                              TRUE  05-JAN-05 30-APR-05
Partitioning (user)                                FALSE
PL/SQL Native Compilation                          FALSE
Protection Mode - Maximum Availability             FALSE
Protection Mode - Maximum Performance              TRUE  05-JAN-05 30-APR-05
Protection Mode - Maximum Protection               FALSE
Protection Mode - Unprotected                      FALSE
Real Application Clusters (RAC)                    FALSE
Recovery Area                                      FALSE
Recovery Manager (RMAN)                            FALSE
RMAN - Disk Backup                                 FALSE
RMAN - Tape Backup                                 FALSE
Resource Manager                                   FALSE
Segment Advisor                                    FALSE
Server Parameter File                              TRUE  05-JAN-05 30-APR-05
Shared Server                                      FALSE
Spatial                                            FALSE
SQL Access Advisor                                 FALSE
SQL Tuning Advisor                                 FALSE
SQL Tuning Set                                     FALSE
Standby Archival - LGWR                            FALSE
Standby Archival - ARCH                            FALSE
Standby Transmission                               FALSE
Streams (system)                                   TRUE  05-JAN-05 30-APR-05
Streams (user)                                     TRUE  05-JAN-05 30-APR-05
Transparent Gateway                                FALSE
Undo Advisor                                       FALSE
Virtual Private Database (VPD)                     TRUE  05-JAN-05 30-APR-05

59 rows selected.


SQL> COL description FORMAT A50 TRUNC
SQL>
SQL> SELECT description, highwater, last_value
  2    FROM dba_high_water_mark_statistics
  3  /

DESCRIPTION                                         HIGHWATER LAST_VALUE
-------------------------------------------------- ---------- ----------
Number of User Tables                                     761 761
Size of Largest Segment (Bytes)                     158334976 158334976
Maximum Number of Partitions belonging to an User           0 0
Maximum Number of Partitions belonging to an User           0 0
Number of User Indexes                                   1353 1353
Maximum Number of Concurrent Sessions seen in the          16 7
Maximum Size of the Database (Bytes)               1107558400 1107558400
Maximum Number of Datafiles                                 7 7
Maximum Number of Tablespaces                               8 8
Maximum Number of CPUs                                      1 1
Maximum Query Length                                     1645 0
Maximum Number of Services                                  4 4

12 rows selected.


Frank
icon14.gif  Re: Database Usage Statistics page in Database Control? [message #118629 is a reply to message #118625] Fri, 06 May 2005 10:03 Go to previous message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Excellent... thanks for the formatting primer and info! It will come in handy.

Now, about that missing "feature statistics" feature in the EM... how can this be possible? And why are different sources (books, users, Oracle's own online help) reporting the location of the link in two different places? What's the "real" location?
Previous Topic: Oracle management server
Next Topic: dbsnmp
Goto Forum:
  


Current Time: Thu Mar 28 13:33:38 CDT 2024