Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Vinodpillai
  • Content: Threads
  • Order by date
  1. Vinodpillai

    Tuning a query which uses like

    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...
  2. Vinodpillai

    archive log size triples up

    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...
  3. Vinodpillai

    Performance issue when moving from 8i to 9i

    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...
  4. Vinodpillai

    Cannot invoke reports thru vb exe when running under citrix

    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...
  5. Vinodpillai

    Incompatiblity with users in same database

    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...
  6. Vinodpillai

    Set Location required when I change my database server..

    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...
  7. Vinodpillai

    Weird MTS Problem

    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...
  8. Vinodpillai

    MTS Hanging and Performance problem

    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...

Part and Inventory Search

Back
Top