Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Operating Systems & Databases (http://www.baanboard.com/baanboard/forumdisplay.php?f=4)
-   -   RHEL7 & Oracle 12 C (http://www.baanboard.com/baanboard/showthread.php?t=69912)

jeffersyuan 4th April 2017 14:09

RHEL7 & Oracle 12 C
 
Hi, all,

Did somebody tried to install the LN on rhel7 & Oracle 12C?

I found when run the create table session, it became very slowly, which takes 4-5 times of speed on SQL server. (Same CPU, same memory, same SSD).

Any suggestion on it?

Thanks.

Jeffers

oirfeodent 12th April 2017 13:52

Quote:

Originally Posted by jeffersyuan (Post 202538)
Hi, all,

Did somebody tried to install the LN on rhel7 & Oracle 12C?

I found when run the create table session, it became very slowly, which takes 4-5 times of speed on SQL server. (Same CPU, same memory, same SSD).

Any suggestion on it?

Thanks.

Jeffers

There is a specific problem with 12C... refer KB 1643631 if it helps.

Regards,

jeffersyuan 13th April 2017 15:41

oirfeodent,
Thanks a lot for your update.
And unlucky, I am using 12CR2, in that KB, it said the performance issue had been solved for the new version oracle. But, it does not.

Jeffers
Quote:

Originally Posted by oirfeodent (Post 202608)
There is a specific problem with 12C... refer KB 1643631 if it helps.

Regards,


Brendan Shine 1st May 2017 06:26

Can you give more specific details on the performance issue you are seeing?

jeffersyuan 2nd May 2017 03:56

Hi, Brendan,
It seems clearly that using unicode method, it caused the performance issue, especial when inserting data.
Hope you have any ideas on it.

Thanks.
Jeffers

Quote:

Originally Posted by Brendan Shine (Post 202915)
Can you give more specific details on the performance issue you are seeing?



All times are GMT +2. The time now is 02:43.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com