Recent content by oneworld95

  1. O

    Performance issues with 10g

    Hi. We're using PL/SQL Developer 7.0.3.1123 to connect to a 10g database. However, we're seeing performance issues we didn't see with 9i. For example, when we click to expand the Tables node in the Browser, it takes up to 10 seconds or longer for it to display the items. We even tried 7.1 Beta...
  2. O

    Get package dependencies

    Thank you, Marco. I hadn't even noticed that! That's exactly what I needed.
  3. O

    Get package dependencies

    Hi. Is there a way in PL/SQL Developer 7 to get all the objects that a particular Oracle 9i package is depended on? For example, I'd like to get all the tables, views, functions, and procedures my package requires so when requesting a copy to our production database, the DBA can quickly get it...
  4. O

    How do you use trace/profiler?

    I've got PL/SQL Developer 6 and have an Oracle 9i procedure that takes about 30 seconds to run. How do I use the tool to determine where the bottlenecks are in the queries? Thank you.
  5. O

    Test REF CURSOR in PL/SQL Developer

    By the way, I used the right-click > Test to test my procedure. I'd tried using the Test, but never knew how. The trick is to give the input variables values in the area at the bottom of the screen. Our whole department uses PL/SQL Developer, and they didn't know about it either. Many have used...
  6. O

    Test REF CURSOR in PL/SQL Developer

    Thanks, Flieger. I'm about to test your suggestion.
  7. O

    Test REF CURSOR in PL/SQL Developer

    Hi, all. We've got a procedure that returns two REF CURSORS, and we'd like to figure out how to test them in PL/SQL Developer 6.05.931. The two REF CURSORS will return results to a Web page, but we'd like to test it before we build the page. Thanks.
See more
Back
Top