Answered Questions

  • Apr 11 2013
    05:41 PM
    7463
    12

    FLASHBACK concept ? What is it?
    • balanagi

    Can any one help me on FLASHBACK concept ? What is it?

    Deepika S Verma

    • Mar 13th, 2014

    Its a feature introduced in oracle9i where oracle DB allows user to view the content of table quickly and easily the way it was at a particular time in the past, even when it is modified and committed...

    NAVEEN

    • Mar 2nd, 2014

    Execute dbms_flashback.enable_at_time(sysdate-5/1440);(for 5 minutes flash back )

  • Mar 09 2010
    06:57 AM
    2975
    3

    Fill Factor in Indexes
    • psingla

    What is fill factor?What should be the ideal value of fill factor for any index?Justify the answer.

    raiyaans

    • Jan 12th, 2012

    The fill factor simply says how large or how full to get our index pages
    you can set it as 70% ,

    If set to 100% it might me a bad thing if we had a lot of DML activity but if this is a read only table then
    fill factor=100% is fine.