Select Menu

Ads

Random Posts

Powered By Blogger
Powered By Blogger

Blog Archive

Search This Blog

Blog Archive

Thirupal Boreddy. Powered by Blogger.

My Blog List

Followers

Lorem 1

Technology

Circle Gallery

Shooting

Racing

News

Lorem 4

» » Change db_recovery_file_dest_size

SQL> select name from v$database;


NAME

---------

XXXXXXX


SQL> show parameter db_recovery



NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string +FLASHDG

db_recovery_file_dest_size big integer 13000M


SQL> alter system set db_recovery_file_dest_size=20G scope=both;


System altered.


SQL> show parameter db_recovery


NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string +FLASHDG

db_recovery_file_dest_size big integer 20G

About Oracle DBA World

WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
«
Next
Newer Post
»
Previous
Older Post

No comments

Leave a Reply

QUERY FOR CPU USAGE

select  a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...