Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    38

    Unanswered: Array Size setting in SQL Plus

    What does the Set Arraysize 1 do from the SQL Plus prompt?

    Thanks.

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    What does the Set Arraysize 1 do from the SQL Plus prompt?
    It means that you will fetch results one at a time from the server when issuing SELECT statements, ie one client-server roundtrip for each row fetched. This is very bad in terms of performance. Increasing it will be much more efficient but use more memory. A good value would be between 50 and 500, more than 500 would use more memory for a very little performance gain.

    AFAIK the default is 100 in 10g while it was 15 in 9i. Someone correct me if I'm wrong.

    HTH & Regards,

    RBARAER

    PS : here is the doc about it (for 10g).
    Last edited by RBARAER; 11-30-05 at 11:26. Reason: added doc link
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •