Oracle on linux configurtion

we find out huge differences when retrieving huge amount of data from oracle , when it was installed on linux and on windows ( the windows was allot faster)

DBA:

 check the next articles and compare/add/fix the values that suggested by oracle for Linux  - you might find there what we are looking for https://docs.oracle.com/database/121/LTDQI/toc.htm#BHCCADGD

Have a look at this article http://www.dba-oracle.com/art_builder_tns.htm - there are some critical parameters to check (tcp.nodelay = yes ?????).

IT:

I suggest to improve the kernel for all our application server RedHat + zLinux with the necessary changes for best throughput , concentrate with the Network tuning

There are allot of resources how to improve it if you didn’t    (specially net.core.rmem_max , net.core.wmem_max)

e.g.  https://tweaked.io/guide/kernel/

https://russ.garrett.co.uk/2009/01/01/linux-kernel-tuning/

enjoy 

Yaniv 

Instant Oracle Using C# / asp.net

I  developed  a WS site , via oracle client 12 , when i tried to deploy it on server i find out  that there is an oracle client 11 install there, i found the way to use oracle 12 in my web site , and managed to grab the right dll to make it work.



its all started when i get the next error on server, i undertood that i am running with different oracle version:

Could not load file or assembly 'Oracle.DataAccess, Version=4.121.1.0 Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.


i looked in my machine.config and i found out that i am using oracle data access  Version=4.112.3.0 - an older verion.


i download the oracle instant client  (based on the version i wanted )  instantclient-basic-nt-12.1.0.2.0.zip.

i copied the next dlls into my bin folder :



oci.dll

oraocci12.dll

oraociei12.dll

oraons.dll

OraOps12.dll


and also the Oracle.DataAccess.dll from my dev machine.

the connection string must look like this :



connectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = Yaniv-il-db.domain.int)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = Yanivil)));User Id=MyUSer;Password=Mypwd;" providerName="Oracle.DataAccess.Client"



and its worked

enjoy

Yaniv Tzanany

V8Compatible , What is going on with DATE and TIMESTAMP

Suddenly, i could not see the time part in  date column , in my screen.
the time part arrive such 00:00:00

i realized that i am using Data Source Name (ORACLE connection pooling) who used different jdbc driver , and i forget to set the V8Compatible flag.
i suggest you to read the next article that will explain to you what is all about.
What is going on with DATE and TIMESTAMP:

another good explanation with samples could be found here:
Summary of features afftected by oracle.jdbc.V8Compatible 

enjoy
Yaniv Tzanany

ORACLE locks report script

the next script works on oracle 11g , report on all DB locks.

select s.osuser "O/S-User", s.username "Ora-User",s.sid "Session-ID",s.serial# "Serial",

s.process "Process-ID", s.status "Status",l.name "Obj_Locked",l.mode_held "Lock_Mode",

t.used_ublk "Left undo block"

from v$session s,dba_dml_locks l,v$process p,v$transaction t

 where l.session_id = s.sid and p.addr = s.paddr

Yaniv Tzanany

Java stored procedure in Oracle

I found out a very nice way to write your own Java code and run it as a stored procedure in oracle database, I play with it, and I understand how strong this way to find out a simple solution to a complex problem, for example my issue was to find a way to call to a COBOL program that runs on SUN box, via C++ on windows.
So I ask the COBOL developer to create a shell script in SUN to activate his COBOL program, and I created a JAVA class that runs as a Stored procedure and activate this script , and get the result from the stdoutput .
The C++ developers only needs to call to the stored procedure, and we are there.
BTW - the Oracle and my scripts file are on the same server.

A very good example how to do it , you can find here
An Introduction to Java Stored Modules in Oracle
and here
Shell Commands From PL/SQL
Last one - > another Step by step article and Demo
Java Stored Procedure in Oracle, Database Interaction
Enjoy