Hello Anoop Mundhra,
In the admin console,create the driver for oracle and then create the datasource and use the datasource for getting connection whenever u deal with data retrieval,insertion or updation.Your datasource maintain the connection pool.You can see the how many connections are there in the pool when u create a datasource.
Ravi