• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » how to check fra size in oracle: Location, usage, change size

how to check fra size in oracle: Location, usage, change size

January 24, 2023 by techgoeasy Leave a Comment

The Flash recovery area(FRA) is an important location. It stores archivelog, flashback logs, backups etc. Here in this post, we will see how to check fra size in oracle, flash recovery area usage query, and how to increase fra size in oracle

Table of Contents

  • how to check fra size in oracle
  • flash recovery area usage query
  • how to increase fra size in oracle
  • How to check fra location in oracle
  • How to change FRA location in oracle

how to check fra size in oracle

select * from v$recovery_file_dest;

flash recovery area usage query

set linesize 200 trim pool on
col name form a72
select * from v$flash_recovery_area_usage;

how to increase fra size in oracle

alter system set DB_RECOVERY_FILE_DEST_SIZE=<new size> scope=both;

How to check fra location in oracle

sqlplus / as sysdba
show parameter DB_RECOVERY_FILE_DEST

How to change FRA location in oracle

sqlplus / as sysdba 
show parameter DB_RECOVERY_FILE_DEST
alter system set db_recovery_file_dest='<new location>' scope=both;

Now the database will start generating the files in the new location. If the flashback is set to ON, then flashback logs will keep generating at the old location. We can enable and disable flashback to generate the flashback logs on the new location

Hope you like this short and quick post on how to check fra size in oracle

Related Articles

oracle create tablespace: This article on how to create tablespace in oracle, various characteristics associated with it and different create tablespace statements
ORA-01652: ORA-01652 error usually because when the tablespace does not have free space in Permanent and Temporary tablespace in oracle database. Check out how to resolve it
shrink datafile in Oracle: Check out how to shrink the datafile and reclaim space on the filesystem. How to resolve ORA-03297
Oracle database administration tutorial: This lists all the Oracle DBA-related stuff. Very helpful for administration
how to change default tablespace in oracle: Default tablespace is the tablespace where the objects are created when no tablespace name is specified by users. Find out how to check default tablespace
How to check temp tablespace in Oracle: This article is about temp tablespace in Oracle, resize the tempfile, drop the temp file, find the temp usage by Session
alter tablespace add datafile: Check out this post on How to add a datafile to tablespace in Oracle, add tempfile to the temporary tablespace, how to add datafile in ASM
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm

Filed Under: Oracle, Oracle Database

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us