Category Archives: Java

DST in Russia

Daylight Saving Time in Russia has been changed last year. Oracle published a FAQ on the support site about this: Russia abandons DST in 2011 – Impact on Oracle RDBMS [ID 1335999.1].

JIT

Starting with Oracle 11gR1 Oracle JVM includes Just-in-Time compiler. Its goal is to convert JVM bytecode into platform-specific native code based on the performance data gathered in run-time. It is stated in the documentation that JIT “enables much faster execution” – and this is, in general, true. There are ways to control the behavior of [...]

When column name matters

There’s a thread on the OTN forum with a case of amusing behavior of the 11.2.0.1 JDBC driver: it fails to detect properly all bind variables in an SQL statement referencing column named NORDER. WTF?! PS. 1) Oracle’s SSO is actually Multi Sign-On because I have two accounts (one for OTN forums and one for [...]

WLS + Oracle benchmark – 2

Another press release from Oracle on the same topic: benchmark of WLS 10.3.3 (not released yet) + Oracle 11.2.0.1 @ Dell PowerEdge R910 Server with 4×8-core beasts X7560 (announced today by Intel). Benchmark was done by Oracle itself (previous were conducted by Cisco & HP). Results and FDA are here. DB & WLS configuration are [...]

WLS + Oracle benchmark

Today Oracle announced this press release. Cisco Systems tested WebLogic SE 10.3.3 (not available yet) + single-node Oracle 11gR2 @ Cisco UCS C250 M2 Rackmount Server with 2×6-core Intel Xeon X5680 (not available yet) – here are the results. I want to highlight some specifics about this test bed – after all, it’s interesting to [...]

Cardinality of table collection expression

Table collection expression has been in Oracle for more than 10 years. It is handy for passing an array to Oracle. Quite often, though, there is was a well-known problem with a default cardinality associated with table collection expressions used in the SQL.

Edition name as a property for JDBC thin client

A question on Edition-Based Redefinition appeared on the OTN forum: The purpose is to try to upgrade an app in production. For most application users they will keep using the pre-upgrade app connecting to the old edition by default, while at the same time some UAT users will test out the post-upgraded app on the [...]

DatabaseMetaData#getIndexInfo()

If you were an Oracle developer and you were asked to implement a small part of the JDBC driver functionality – the getIndexInfo() method of the java.sql.DatabaseMetaData interface – how’d you do that?

JNI in Oracle

JNI – Java Native Interface – is an interface for cooperating Java and legacy code. Oracle RDBMS doesn’t support it officially in embedded Oracle JVM (aka “Aurora”): Oracle Database does not support the use of JNI in Java applications. If you use JNI, then your application is not 100 percent pure Java and the native methods [...]

“java.lang.OutOfMemoryError: unable to create new native thread” in WLS

Recently I’ve struggled with subj. One of the customers of the company I’m working has encountered several “java.lang.OutOfMemoryError: unable to create new native thread” appearances in a clustered WebLogic Server 9 environment. Here I’ll describe why it could happen and possible workarounds for this error.

Follow

Get every new post delivered to your Inbox.

Join 100 other followers