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 →

Advertisements

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 →

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 →

Blog at WordPress.com.

Up ↑