Recent content by rita

Hi Kalter, Pl. find the tkprof output. The mentiond SQL stmt's fetch time is 31.97 which is quite large as compared to other stmts. Yes, You are right my case not of multithreading. Pl. let me know what can be done to make the stmt execute in lesser time. TKPROF: Release 9.2.0.3.0 -...

Hi All, I am using query "Select d.File#, d.name as Data_File_Name, t.name Tbs_Name, d.Status as File_Status, d.Enabled, d.bytes from v$datafile d, v$tablespace t where d.TS# = t.TS#" with TOracleQuery. It is taking long time to execute with session which is used for other queries too. In a...