APT_ORACLE_NO_OPS

seanc217 · Post by **seanc217** » Thu Apr 13, 2006 12:32 pm

Does anyone know what the environment variable APT_ORACLE_NO_OPS does? I read an old post here about an Oracle error I was receiving and after I applied this to my project it worked. I was just wondering if anyone knows what it does.

Thanks,

Sean

Ultramundane · Post by **Ultramundane** » Thu Apr 13, 2006 1:05 pm

From one of the previous posts.

There is an environment variable APT_ORACLE_NO_OPS that can be set to 1 which will tell Ascential not to check for the existence of the table SYS.GV_$INSTANCE. Once this was added to our Job, it ran fine.

So it would seem that it is used to disable any parallel server checks/optimizations for the stage.

seanc217 · Post by **seanc217** » Thu Apr 13, 2006 1:49 pm

I guess I should read better.
Sorry. Thanks for the reply!!

eduardoanl · Post by **eduardoanl** » Wed May 24, 2006 8:04 am

Ultramundane wrote:From one of the previous posts.

There is an environment variable APT_ORACLE_NO_OPS that can be set to 1 which will tell Ascential not to check for the existence of the table SYS.GV_$INSTANCE. Once this was added to our Job, it ran fine.
So it would seem that it is used to disable any parallel server checks/optimizations for the stage.

Thanks for thi Tip, it works correctly!!!
Eduardo.

DSXchange

APT_ORACLE_NO_OPS

APT_ORACLE_NO_OPS

Re: APT_ORACLE_NO_OPS

Re: APT_ORACLE_NO_OPS