I have an oracle 11g database that I can't start. When I try logging in as / sysdba I get iora-01031: insufficient privileges. If I try to log in regularly I get ora-01033: Oriacle initialization or shutdown in progress. Process ID : 0 Session ID: 0 Serial number: 0
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …