Oracle Data Guard Snapshot Standby with Flashback Off – where is my flashback?
No you don’t have to turn flashback database on to use a data guarded snapshot standby… but does it still […]
No you don’t have to turn flashback database on to use a data guarded snapshot standby… but does it still […]
Here is a query that will give you the last 24 hour summary. select to_char(first_time,’dd-mon-yy’) In_Day, round(sum(blocks*block_size)/1024/1024/1024,2) Total_GB_Archived, count(*) Num_of_Archs,
New 11g feature (not sure if this came out in 11gR1 or 11gR2) – but it doesn’t get any easier…
Per https://docs.oracle.com/database/121/SBYDB/views.htm#SBYDB01300 Views Relevant to Oracle Data Guard There are a number of views that are especially useful when monitoring an
alter system set “_query_on_physical”=false scope=spfile; alter system reset “_query_on_physical”=false scope=spfile;
BTW – before I get started on “colorscheme” something that irks me – vi or vim highlights your last matching
Clarification of Oracle Database Version Numbers
Well there are a quite a few ways – here are some of them. Check to see if applied archive
I could not get the DBA panel display – using menu item View -> DBA Fix in SQLDeveloper – pick
Work in progress… testing Lots of stuff about role transition from Oracle Oracle Best Practices Doc ALTER SYSTEM SET FAL_SERVER=GGSTBY;