I am running a stored procedure, which is mainly querry
intensive. I spent quite some times to tune the querries
individually and after all of them were satisfactory in terms of
performance I ran the procedure in our test environment
and it ran well. But in the production environment,
which is exactly same as test in terms of configuration( more powerful machine with more SGA) procedure is taking hell lot of time.

The thing I noticed that when I ran it in production it is creating 2 sessions whereas it is not the case in test.

Can anybody suggest me what are the areas I should be looking at?

I am using oracle 8.1.5.0.0 on AIX 4.2 with EMC storage.

Thanks in advance