Results 1 to 2 of 2

Thread: optimization

  1. #1
    Join Date
    Feb 2003
    Posts
    23

    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
    mode?

    Please mail me at manips15@hotmail.com


    thanks and regards
    MANI PS

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    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 : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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