Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implications/side effects of changing cache size of sequence

orausernJul 19 2012 — edited Jul 19 2012
Hi Experts,

We are on Oracle 11.2.0.2 on Solaris 10. I have a question about sequences. They are defined as NOCACHE in my database and we are seeing a lot of "row cache lock". So I am thinking of changing the sequences to cache 20 values. Does this have any other implication -except that during db restart the cached values can be lost.

Thanks,

Comments

danmcghan-Oracle

Hi user12221353,

Did you see the install instructions? There are several options for Linux:

https://oracle.github.io/node-oracledb/INSTALL.html

Did you already attempt an install? If so, what did you try and what errors did you get?

Regards,

Dan

EFB

Hi Dan,

It is working for every operating system as stated  in https://oracle.github.io/node-oracledb/INSTALL.html.

I have tried to install oracledb driver on linux and windows using this guide and it is working.

This documents did not mention how to install oracledb driver on debian. Debian use deb archiver instead of RPM as on linux.

I have tried to repacked the oracledb RPM for 54 bit linux to oracldb.deb using tool alien on debian. it worked and installed successfully. However when I execute the connection test from nodejs. it showed error no oracledb installed.

Error: Cannot find module 'oracledb'

Hope we can find the way to solve this.

Thanks

Your options are simple

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2012
Added on Jul 19 2012
18 comments
3,090 views