Oracle XE Tuning

Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased. Database Sessions Increase the number of sessions that the database can handle at one time.  This will allow for more users to access the database. sqlplus /nolog SQL> show parameters sessions SQL> alter system […]

Oracle XE Backup

After installing Oracle XE you should setup backups. Backups for XE For Oracle XE there is ready a backup script that uses Oracle’s RMAN.   Setup Archive Log Mode After installing the database change it to archivelog mode: [oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 – Production on Sun May 25 01:28:00 2008 Copyright (c) […]

Checking for a User in OID

Test to see if a user is already in OID The following java code checks to see if there is a user in OID, returning true if they are there.   import oracle.ldap.util.*; import oracle.ldap.util.jndi.*; import java.io.*; import java.util.*; import javax.naming.*; import javax.naming.directory.*;   public class Application1 { InitialDirContext ctx; public Application1() throws NamingException { […]