Category: Internal

How to find definitions of V$, GV$ views?

From v$fixed_view_definition one can find the definitions of V$views which may one in understand them. Example: SQL> set pages 0 SQL> SELECT * FROM v$fixed_view_definition where view_name = 'V$SESSION'; V$SESSION select SADDR , SID , SERIAL# , .... SQL_TRACE_BINDS from GV$SESSION where inst_id = USERENV('Instance') If one tries to grant direct access to view you … Continue reading How to find definitions of V$, GV$ views? →

sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$ sqlplus '/as sysdba' sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied The reason is that SELinux is running in "enforcing" mode. You can check it on file /etc/pam.d/login … Continue reading sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied →

Internal view for Oracle to track features used

In 10g there is a new view called DBA_FEATURE_USAGE_STATISTICS which keeps features have been used. Here is description of some of the columns: name - feature name first_usage_date - first date when the feature was used last_usage_date - latest date when it was detected the feature was used last_sample_date - latest date when the sample … Continue reading Internal view for Oracle to track features used →

View password history

One can view the password change history by querying oracle's internal table SYS.USER_HISTORY$, note this table gets updated only if the user is assigned a profile that has password reuse limit (i.e. PASSWORD_REUSE_TIME set not to UNLIMITED) SYS@TEST> SELECT name, password_date FROM sys.user$, sys.user_history$ WHERE user$.user# = user_history$.user#; NAME PASSWORD_ ------------------------------ ----------- SCOTT 31-JAN-08 SCOTT … Continue reading View password history →