Hello Everyone,
I need your help in getting this issue solved its urgent and i am not able to get to the conclusion. Here is my scenario I am getting slow execution of query due to some non visible characters that are copied with the original query from PL/SQL developer tool . Please find below attached screen shot: Oracle_Issue
Note: This non visible characters are caused when we write query then we hit space bar or hit TAB in PL/SQL developer tool
I am using PL/SQL developer tool to write or test the query. Now i take this query and copy paste into my company application( which takes this query connects to Oracle or any database source, grabs Data and produce PDF Reports for clients).
Now one my client is Oracle User when i write and run this query from the PL/SQL developer it runs fine, but when i copy paste into my application(reporting system) function box it and execute it, it runs slower and jams the client's database. Now after little bit of researching i found that when i copy the query directly from PL/SQL developer to my application it copies some non visible characters( introduced when we press SPACEBAR or TAB in PL/SQL developer tool while writing query) with query then i have to copy this query again from my application function box to NOTEPAD and delete those non visible characters. Now after removing the non visible characters again i copy back query into my application and execute query, it runs normal. Please find below attached screenshot : Oracle_Issue 2
So i think the cause of slow execution is due to INVISIBLE CHARACTERS present in the query..
My application uses SQL server 2008/2012 at backend to store the data coming from different sources.
Character Set used: SQL_Latin1_General_CP1_CI_AS
To write or test queries : PL/SQL developer tool
My Client Use Oracle 11g
Character Set used: Normal Character: NLS_CHARACTER : AL16UTF16
**National Characeter : NLS\_NCHAR\_CHARACTER : WE8WIN1521**
Just i wanted to know the process jamming up the database and how non visible characters in query affecting database query slow execution.
Please let me know if i am missing anything or you need more information regarding this issue.
Thanks in Advance,
HP