Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: FLASHBACK: Initialization Parameters Jump to:  
Category: >> Oracle PL/SQL >> FLASHBACK: Initialization Parameters Bookmark and Share

<< lastnext >>

Snippet Name: FLASHBACK: Initialization Parameters

Description: Setting the location and size of flashback recovery area.

The Flashback Data Archive can be used to automatically track and maintain historical changes to all Oracle data in a highly application transparent, secure and efficient manner. Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table.

Also see:
» FLASHBACK: Oracle 10G enhancements
» FLASHBACK: AS OF clause
» FLASHBACK: SYS commands and queries
» FLASHBACK: Syntax Elements

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

Initialization Parameters 
 
Setting the location OF the flashback 
recovery area db_recovery_file_dest=/oracle/flash_recovery_area 
 
 
Setting the size OF the flashback 
recovery area db_recovery_file_dest_size=2147483648 
 
Setting the retention TIME FOR flashback files (IN minutes)
-- 2 days
db_flashback_retention_target=2880 
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 277 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?