Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: parameter _log_block_during_backup
This parameter guarantees that in "hot" backup processing (when the alter tablespace begin command is issued) the entire block's image/data will be logged in the redos when a change occurs in that block.
You can retrieve its current value (definition/description and "default" value) by issuing the following select statement in ORACLE 7.3/7.4:
select b.ksppimn, a.ksppstvl, a.ksppstdf, b.ksppidesc from x$ksppi b, x$ksppcv a where a.indx = b.indx;
In ORACLE 7.2 issue the following to obtain its current and default value
select ksppinm, ksppivl, ksppidf from x$ksppi;
To retrieve a listing of other interesting "X$" tables select * from v$fixed_table.
Hervé <hdoornbos_at_magic.fr> wrote in article
<6d27bi$bp5$1_at_paris.magic.fr>...
> What is the meaning of the parameter _log_block_during_backup and how is
it
> possible to retrieve its value ?
> Thanks
>
>
>
Received on Thu Mar 05 1998 - 00:00:00 CST