 Database Usage Statistics page in Database Control? [message #118492] |
Thu, 05 May 2005 10:20  |
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 #118520 is a reply to message #118518] |
Thu, 05 May 2005 12:17  |
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 |
Frank Naude
Messages: 4581
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 |
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 |
Frank Naude
Messages: 4581
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
|
|
|
|
 Re: Database Usage Statistics page in Database Control? [message #118629 is a reply to message #118625] |
Fri, 06 May 2005 10:03 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
