Results 1 to 2 of 2

Thread: optimization

  1. #1
    Join Date
    Feb 2003

    Arrow Unanswered: optimization

    Dear Viewers,

    I am confused with these issues. Can any one PLEASE explain this

    1) Difference & when to use first_rows & all_rows parameter, while
    using an optimizer

    2)A user has connect and resource privs allocated by the DBA . He is been allocated quota on three tablespaces by the DBA
    - Default Tablespace Quota 500 M
    - Tablespace 1 Quota 100 M
    - Tablespace 2 Quota 200 M
    Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful ?

    3) How to check to memory gap once the SGA is started in Restricted

    Please mail me at

    thanks and regards

  2. #2
    Join Date
    Apr 2001
    On point 2:

    Yes he will be successfull.

    In the resource role , the 'UNLIMITED TABLESPACE' privilege is included.
    I suggest never to use connect and resource.
    Ruud Schilders
    Oracle DBA
    e-mail :
    URL :
    Twitter :

Posting Permissions

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