Hi,
My databases are running on 11.2.0.2. Currently database is showing about Oracle ASO usage. Last usage date also updated on last month.
But I'm not using any encryption or wallet? How Oracle ASO is used by databases.
| Option/Management Pack | Used | DBID DB Name DB Version | Host Name | ReportGen Time |
------------------------------------------------------------ ----- ---------- --------- ----------------- ------------------------------ -------------------
| Advanced Compression | YES | 847309849 DING | 11.2.0.2.0 | vm6.domain.com | 2015-05-04 22:46:10 |
| Advanced Security | YES | 847309849 DING | 11.2.0.2.0 | vm6.domain.com | 2015-05-04 22:46:10 |
SQL> select * from dba_encrypted_columns;
no rows selected
SQL> select encrypted from dba_tablespaces;
ENC
---
NO
NO
NO
NO
NO
NO
NO
7 rows selected.
SQL> select * from v$encryption_wallet;
WRL_TYPE
--------------------
WRL_PARAMETER
----------------------------------------------------------------------------------------------------
STATUS
------------------
file
/u01/app/oracle/admin/DING/wallet
CLOSED
Thanks