Recent content by Kirurgs

  1. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I have tried it and it is a lot better now. However, when I'm trying to use code assistant on tables which are used via synonyms they don't appear to be visible for some time, after couple of mins after logging in they are, but not right away as those who are in the current schema...
  2. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I think I understood where the problem is :) See, we are working with Oracle eBusiness Suite which is really large product of Oracle, I took statements from CANames and executed them with the schema I logged in (APPS), results are: objects (1st stmnt) ~ 80000, synonyms (2nd stmnt) ~ 50000...
  3. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! v9.0.1 (1613) have the same CPU usage bug. I still see no queries being performed while CPU usage is high. DB ver. is 11gR2. Edit: In 9.0.1 CPU went down after under 5 mins (approx 3-4). Do You have clue why is that?
  4. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I'm on vacation so I check this very rare. CPU won't go down, it starts even when there are no windows opened at all, just plain PLSQLDev. I went to check sessions and no query is running. That check box didn't help either.
  5. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I have tested it and now it seems that result is instant, if dictionary info is checked it's still slow, but I think that's expected. So in short - problem fixed. BUT for some strange reason now plsqldev.exe process eats whole cpu all the time after connection is made, cpu usage varies from...
  6. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I ran queries and they are still slow. Now there are no excessive nls thing. I have run the same in ver 8 and 9, in 8 result is instant, but in 9 it takes 5 secs now. Now it seems that it's executing dictionary info SQL, I have set that off in preferences. Maybe this is the cause. I sent...
  7. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! Very good, please send me the link/file, I'll gladly provide any debug info. regards Kirurgs
  8. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! Is there anything I can help, like providing any additional debug info to you?
  9. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! Marco have You had a chance looking into issue I'm facing?
  10. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I tried with 1000 lines, virtually no delay, with 10K it was about one sec as Marco said. I have 2.5GHz laptop usually running on 800MHz, when I select that and press execute it will speed up to 2.5. Marco have You had a chance looking into my issue? regards Kirurgs
  11. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! Thank You for info, file sent, hope Marco will look at it soon. regards Kirurgs
  12. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! Additional info. I enabled DebugSQL as well and I see where the problem is. In debug.txt there is this kind of text repeated for 489 times after I run second query: 2011.07.27. 17:57:24 TOracleQuery 96E4B0 Start Query.Execute SQL = select value from v$nls_parameters...
  13. K

    Long "Initializing..." delay running SQL queries in Rel 9

    Hi! I have similar issue, not the same, but maybe related. I'm using the latest version 9.0.0.1601. I have really annoying delay of approx 10 seconds when doing any query which has many columns. When I select a query and press execute it kind of executes the query, in the result list I can see...
  14. K

    PLSD 8 within 2nd quarter - Countdown

    Does anyone expierence stability problems with Alpha2? I ran PLSQLDev A2 once and it worked, I closed it and I can't get it to run second time :( Debug.txt doesn't contain any clue what's wrong (for me at lest)... Alpha1 (reinstalled over A2) works fine... Consider this as a question only as I'm...
  15. K

    PLSD 8 within 2nd quarter - Countdown

    Well, to me it seems ok. It seems it's more productive, thanks to window pinning, object browser enhancements, etc. I like the countdown seconds when executing a query, it feels faster somehow... There are couple things to improve productivity: a) I don't like forward declarations of...
Back
Top