Search results for query: *

Hi dima I fired the query without the hint after dropping the unwanted index and then got the response time. Post that dropped the statistics and got the statistics. Now i am monitoring this in production and the response is better then when the table is analyzed. The query in production is...

Hi Dima AS of now i have dropped the index on c_address_res. It was put for testing purposes. I did not list the entire tables , but just to give u an idea listed some fields in the table. The table has primary key as c_ref_no, indexes on c_stdcode_res, c_index_add. Tried adding the combi of...

for the first two staements the plan is similar SELECT STATEMENT, GOAL = CHOOSE 0 02/06/2004 9:13:29 PM SELECT STATEMENT TABLE ACCESS BY INDEX ROWID 1 0 NUCLEUS NAPS_DDUP_PER_INDX_NEW 02/06/2004 9:13:29 PM TABLE ACCESS BY INDEX ROWID INDEX RANGE SCAN 2 1 NUCLEUS PART_DDUP...

removing the leftmost index will result in a different resultset. We added an index on the C_ADDRESS_RES field and the query when run uses the index but the time taken is around 120 sec

structure of table is C_REF_NO NOT NULL VARCHAR2(13) C_INDEX_ADD VARCHAR2(100 C_INDEX_ADD_WORD VARCHAR2(100 C_INDEX_NAME VARCHAR2(100 C_INDEX_ADD_OFFI VARCHAR2(100...

The below query when fired with a like on a 800K records table takes 90 sec and fetches 2000 rec. Even without hint takes the same time SELECT /*+ index (A DDUP_INDEX_NEW) */ A.* FROM NAPS_DDUP_PER_INDX_NEW A WHERE A.C_REF_NO <> '0713403128312' AND A.C_STDCODE_RES = '0671' AND...

I have added some new tables and new proceeses to my application. This has increased the dataflow. Earlier my archive log size was 2 gb now it isaorund 7-8 gb on certain days. What can i attribute this to. Certain tables in my database has 4000K records and i am updating these tables. The issue...

unfortunately the statspack report from 8i is not avaialbale. I am trying to setup an 8i env to do some additional tracing. any inputs from the 9i statspack report that i could use to get a qucik solution

I have a vb-oracle app. I moved the backend from 8i to 9i. No change in logic. Kept the oracle parameters the same. The number of apps that hit above the 20 sec resonse time has increased from 3% to 6%. I have checked the hit ratio, disk I/O rates, no queries executing for long, in short the...

I have a vb ap that is installed on a machine running citrix metaframe. This vb app is a 3 tier app and hence gives calls to a com components on another server. all the users are able to run the app and use the transaction screens but when they try to call the crystal reports it gives an error...

We have not yet solved this problem. We have had Microsoft, oracle etc review code, check our app servers put patches etc, but non have resolved the problem. The issue becomes sever at times when the system gets hanged. Primarily we have been able to reduce it. Like if you execute any long...

Are you passing a blank recordset to method in classB. If yes then create a structure for the recorset and then send it. Another option you can try is build the dll with No compatiblity and then with Binary compatiblity. This can solve the problem. Quite a few time s we had to re-install the...

The only solution to this is thru programming rpts. You can thru Crystal libraries included in VB or ASP programs, Change the user and logons dynamically. After changing you can verify database and then invoke the report. But the problem with this approach is that it is very slow. The firing...

In crystal Report rpt if I design using a user XYZ and take it to my client site where a user ABC exists, I have to use SET LOCATION on all the rpts. I am using Oracle as my database and at client site I have 2 user databases in ORacle , one production and other UAT. If I have to move a rpt from...

I am using Oracle as backend, Segate V7.0 as report tool. I fire reports using crystal control on a vb form. to connect i use Microosft odbc DSN and send the user id and password. My problem is when I change the database server to a different machine with same user id and password, i need to...

I am using an ActiveX Dll built using Vb6.0 and MTS 2.0. Backend is Oracle 8.0.5 with patch 80525. The application server is Compaq P6 - Winnt 4.0 SP6 , 1 GB ram , 20GB HDD dual processor. The mtx.exe size increses upto 50MB plus and then the system does not allow users to connect to the...

The settings of ODBC connection timeout is related to this. suppose if the odbc timeout is 60 sec then if within 60seconds you do not use the object it is disconnected and returned to the pool. This should not be of concern as mts frees session based on settings done.

I am using an ActiveX Dll built using Vb6.0 and MTS 2.0. Backend is Oracle 8.0.5 with patch 80525. The application server is Compaq P6 - Winnt 4.0 SP6 , 1 GB ram , 20GB HDD dual processor. The mtx.exe size increses upto 50MB plus and then the system does not allow users to connect to the...