Java

Java is a set of computer software and specifications developed by Sun Microsystems, which was later acquired by the Oracle Corporation, that provides a system for developing application software and deploying it in a cross-platform computing environment. Java is used in a wide variety of computing platforms from embedded devices and mobile phones to enterprise servers and supercomputers.

Spring Logo

Spring Framework

The Spring Framework provides a comprehensive programming and configuration model for modern Java-based enterprise applications - on any kind of deployment platform. A key element of Spring is infrastructural support at the application level: Spring focuses on the "plumbing" of enterprise applications so that teams can focus on application-level business logic, without unnecessary ties to specific deployment environments.

Hibernate Logo

Hibernate Framework

Hibernate ORM is an object-relational mapping framework for the Java language. It provides a framework for mapping an object-oriented domain model to a relational database.

Wednesday, October 30, 2013

Extend the System Tablespace on Oracle

There are two ways to extend the system table space.

1. Set the current datafile to AUTOEXTEND
2. Add a new datafile

1. Set the Current datafile to AUTOEXTEND

SELECT 'ALTER database datafile ''' || file_name || ''' ' || ' AUTOEXTEND ON maxsize 2097152000;'
FROM dba_data_files
WHERE tablespace_name = 'SYSTEM';

ALTER database datafile '/u01/app/oracle/oradata/XE/system.dbf'  AUTOEXTEND ON maxsize 2097152000;

database datafile '/U01/APP/ORACLE/ORADATA/XE/SYSTEM.DBF' altered.

2. Add a New datafile

alter tablespace SYSTEM add datafile '/u01/app/oracle/oradata/XE/system2.dbf' size 1024m;