Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: dml operation in database if table size grater than sga

    Hai

    Can perform any dml operation in database if table size grater than sga size .i think cannot perform any dml operations but i have doubt
    Thanks in advance

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Yes, you can perform DML on a table that's bigger than your SGA.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Oct 2002
    Posts
    78

    sql statements

    Thanks for your prompt reply

    I have still doubt,if donnot mind give some examples because recently i faced interview ,they asked the same question i unable to explain.

    As for my knowledge the shared pool contains recently executed sql statements code,procedure ,package information .If table size grater than sga size ,where to store sql statements that is being executed by application .Please clarify
    Thanks in advance
    mohan

Posting Permissions

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