info
held-informatik
de
Statistik zur Nutzung von Oracle Datenbank Features
Sie möchten ermitteln, welche Datenbank-Features genutzt werden? Das folgende Skript zeigt Ihnen Datum und Uhrzeit der ersten und letzten Nutzung sowie die Häufigkeit der Nutzung:
Oracle Datenbank-Features: Statistik
ALTER SESSION SET NLS_DATE_FORMAT = 'dd.mm.yyyy hh24:mi'; SELECT a.name, a.detected_usages, a.first_usage_date, a.last_usage_date FROM dba_feature_usage_statistics a WHERE a.version = (SELECT MAX(b.version) FROM dba_feature_usage_statistics b WHERE b.name = a.name) ORDER BY a.name;
Die Ausgabe kann wie folgt aussehen:
NAME DETECTED_USAGES FIRST_US LAST_USA
-------------------------------------------------- --------------- -------- --------
ADDM 0
Advanced Replication 0
Advanced Security 0
Application Express 0
Audit Options 4 15.06.09 12.07.09
Automatic Maintenance - Optimizer Statistics Gathe 4 15.06.09 12.07.09
ring
Automatic Maintenance - Space Advisor 4 15.06.09 12.07.09
Automatic Maintenance - SQL Tuning Advisor 4 15.06.09 12.07.09
Automatic Memory Tuning 4 15.06.09 12.07.09
Automatic Segment Advisor 3 25.06.09 12.07.09
Automatic Segment Space Management (system) 4 15.06.09 12.07.09
Automatic Segment Space Management (user) 1 12.07.09 12.07.09
Automatic SGA Tuning 0
Automatic SQL Execution Memory 0
Automatic SQL Tuning Advisor 3 25.06.09 12.07.09
Automatic Storage Management 0
Automatic Undo Management 4 15.06.09 12.07.09
Automatic Workload Repository 0
AWR Baseline 0
AWR Baseline Template 0
Backup Encryption 0
Backup Rollforward 0
Backup ZLIB Compression 0
Baseline Adaptive Thresholds 0
Baseline Static Computations 0
Bigfile Tablespace 0
Block Media Recovery 0
Change Data Capture 0
Change-Aware Incremental Backup 0
Character Semantics 0
Character Set 4 15.06.09 12.07.09
Client Identifier 0
Clusterwide Global Transactions 0
CSSCAN 0
Data Guard 0
Data Mining 0
Data Recovery Advisor 1 12.07.09 12.07.09
Database Replay: Workload Capture 0
Database Replay: Workload Replay 0
Deferred Open Read Only 0
DICOM 1 15.06.09 15.06.09
Dynamic SGA 0
EM Database Control 0
EM Grid Control 0
Encrypted Tablespaces 0
Extensibility 4 15.06.09 12.07.09
File Mapping 0
Flashback Data Archive 1 12.07.09 12.07.09
Flashback Database 0
HeapCompression 0
Internode Parallel Execution 0
Job Scheduler 0
Label Security 0
LOB 4 15.06.09 12.07.09
Locally Managed Tablespaces (system) 4 15.06.09 12.07.09
Locally Managed Tablespaces (user) 4 15.06.09 12.07.09
Logfile Multiplexing 0
Materialized Views (User) 4 15.06.09 12.07.09
Messaging Gateway 0
MTTR Advisor 0
Multimedia 0
Multiple Block Sizes 0
Object 4 15.06.09 12.07.09
OLAP - Analytic Workspaces 0
OLAP - Cubes 0
Oracle Managed Files 0
Oracle Secure Backup 0
Oracle Text 4 15.06.09 12.07.09
Oracle Utility Datapump (Export) 0
Oracle Utility Datapump (Import) 0
Oracle Utility Metadata API 0
Oracle Utility SQL Loader (Direct Path Load) 0
Parallel SQL DDL Execution 0
Parallel SQL DML Execution 0
Parallel SQL Query Execution 0
Partitioning (system) 4 15.06.09 12.07.09
Partitioning (user) 4 15.06.09 12.07.09
Physical Standby with Real-Time Query 0
PL/SQL Native Compilation 0
Read Only Tablespace 0
Real Application Clusters (RAC) 0
Recovery Area 4 15.06.09 12.07.09
Recovery Manager (RMAN) 1 12.07.09 12.07.09
Resource Manager 3 25.06.09 12.07.09
Restore Point 1 12.07.09 12.07.09
Result Cache 1 02.07.09 02.07.09
RMAN - Disk Backup 1 12.07.09 12.07.09
RMAN - Tape Backup 0
Rules Manager 0
SecureFiles 0
Segment Advisor 2 25.06.09 12.07.09
Segment Shrink 0
Semantics/RDF 0
Server Parameter File 4 15.06.09 12.07.09
Services 4 15.06.09 12.07.09
Shared Server 0
Spatial 0
SQL Access Advisor 0
SQL Performance Analyzer 0
SQL Plan Management 0
SQL Profile 0
SQL Repair Advisor 0
SQL Tuning Advisor 0
SQL Tuning Set (system) 0
SQL Tuning Set (user) 0
SQL Workload Manager 0
Streams (system) 0
Streams (user) 0
Transparent Data Encryption 0
Transparent Gateway 0
Transportable Tablespace 0
Tune MView 0
Undo Advisor 0
Very Large Memory 0
Virtual Private Database (VPD) 0
Workspace Manager 0
XDB 4 15.06.09 12.07.09