Oracle Database Administration, Monitoring and Operations Tutorials and Help
Data Loads into Oracle Compressed Tables
Oracle introduced table compression feature in Oracle 9i to help reduce the disk space utilization in databases. Datawarehousing and decision support systems have been evolving over years and have become the biggest hogs of disk space. Managing disk capacity has become a challenge for the dba as well as the infrastructure team. In todays world terabyte systems have become very common and require large volumes of data to be stored in various large tables. The compression of data is transparent to users and applications and the access to data continues the same way it has already been developed.
 
Oracle Instant Client : Ease your client deployment

Oracle 10g introduces a lighter weight database client called Oracle Instant Client. Oracle Instant client allows you to get away from the standard Oracle Client installation for running applications from desktops or Servers. All applications that need OCI, Pro*C, ODBC, and JDBC will work without any issues and this client takes significantly less disk space than a full 10g client.

 
Oracle Instance : What is Large Pool

Oracle Large Pool is an optional memory component of the oracle database SGA. This area is used for providing large memory allocations in many situations that arise during the operations of an oracle database instance.

 
ORA-00600 : internal error code

Oracle RDBMS Kernel raises an ORA-00600 error when an unexpected condition is met during its normal functioning. An ORA-00600 oracle error may not necessarily be a bug all the time and could be caused due to various reasons. Oracle error 600 reasons can include a Lack of System Resources, Operating System Issues, Hardware Failures and many other dependent system driver issues. In many instances, ORA-00600 error indicates an existing corruption in the oracle database or can be a indication of events leading to data or database corruption.Oracle database administrators should take an ORA-00600 error very seriously and work with oracle support to resolve this issue.


 
ORA-4031: Unable to allocate bytes of shared memory
ORA-4031 is a very common error that many dba's face in their day to day activities. This error can commonly occur due to the SHARED POOL SIZE. This error can be due to an inadquate sizing of the SHARED POOL or due to  fragmentation of the shared pool. 
 
<< Start < Prev 1 2 Next > End >>

Results 1 - 5 of 8