Oracle11gR1 – To Read…

 Database Replay – OTN  Documentation  Interval and Reference Partitions – Paper   Documentation  SQL Query Result Cache – OTN   Documentation SQL Performance Analyzer – OTN Documentation  SQL Plan Baseline – OTN  Documentation Automatic SQL Tuning Enhancements – Documentation Snapshot Standby – Documentation Active Data Guard (Real-time query) – Documentation OLTP Table Compression – OTN-OOW   Documentation AutoTask Infrastructure … Read more

Passwords are Case Sensitive in Oracle11g

The passwords in Oracle11g are case sensitive. All new users created in the 11g database have case sensitive password by default. For databases upgraded from earlier releases, the passwords are not case sensitive for existing accounts. They become case sensitive when you change password. A new column PASSWORD_VERSIONS is added to DBA_USERS view. A value … Read more