Database Tuning (MOSC)

MOSC Banner

Data type conversion and TABLE ACCESS BY GLOBAL INDEX ROWID

edited Jun 4, 2012 12:29AM in Database Tuning (MOSC) 5 commentsAnswered
Hi,
Oracle version :11.2.0.2 OS- HP UX

One of my queries have high elapsed time and is causing DB file sequential read.The plan show a data type converion.

The datatype of that column in table is NVARCHAR2(100) where in the v$sql_bind_capture shows it as NVARCHAR2(32). My front end is Java based.Is there any way to pass NVARCHAR2(100) fron front end for bind variable?

Also PFB the plan.Is TABLE ACCESS BY GLOBAL INDEX ROWID good for performance?

-----------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                | Name                       | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center