Posted in Uncategorized by: yas
Comments Off
05 Feb
It has been asked several times in several places; is there a performance difference between running a query locally in a client on the server and running the same query in a remote client? The obvious answer given by the respondents including myself is: “if you do not return thousands of rows through the network, there must not be any difference”. This type of response is opposed to what I
Posted in General, Internals, Tools by: jonah.harris
Comments Off
05 Feb
If you’ve ever looked into purchasing third-party replication software for Oracle, you’ve likely run across log-based replication products such as Quest Software’s SharePlex or GoldenGate Software’s Transactional Data Management platform. Unlike trigger-based replication systems, log-based replication relies on translating Oracle’s REDO and UNDO data into SQL which can be applied to various target databases […]
Posted in Uncategorized by: Yann Neuhaus
Comments Off
05 Feb
This short post presents how to change online the Data Guard configuration files location (parameters dg_broker_config_fileX) where X is 1 or 2.
REM ================================================
REM renaming of the dg_broker_config_file parameters
REM=================================================
set head off
set feed off
set echo off
set verify off
set trimspool on
ACCEPT site_number CHAR PROMPT 'Enter site number <2: ' DEFAULT '2'
var filename_dg1 varchar2(2000)
var filename_dg2 varchar2(2000)
spool rename_dg_broker_config_file_do.sql
select 'alter system set dg_broker_start=false scope=memory'||chr(10)||'/'
from dual
/
begin
select '/u00/app/oracle/admin/'||name||'/pfile/dr1_'||name||'_SITE'||&site_number||'.dat' into :filename_dg1
from v$database;
select '/u00/app/oracle/admin/'||name||'/pfile/dr2_'||name||'_SITE'||&site_number||'.dat' into :filename_dg2
from v$database;
end;
/
select '!mv '||value||' '||:filename_dg1
from v$parameter
where name = 'dg_broker_config_file1'
/
select '!mv '||value||' '||:filename_dg2
from v$parameter
where name = 'dg_broker_config_file2'
/
select 'alter system set dg_broker_config_file1=''/u00/app/oracle/admin/'||name||'/pfile/dr1_'||name||'_SITE'||&site_number||
'.dat'''||chr(10)||'/'
from v$database
/
select 'alter system set dg_broker_config_file2=''/u00/app/oracle/admin/'||name||'/pfile/dr2_'||name||'_SITE'||&site_number||
'.dat'''||chr(10)||'/'
from v$database
/
select 'alter system set dg_broker_start=true scope=memory'||chr(10)||'/'
from dual
/
select chr(10) from dual;
spool off
set echo on
set feed on print :filename_dg1
print :filename_dg2
spool rename_dg_broker_config_file_do.log
@@rename_dg_broker_config_file_do.sql
spool off
We could consider that the script is not REALLY online because the Data Guard broker is stopped 
, but this has no impact on the instance availability.
Posted in Uncategorized by: Lutz Hartmann
Comments Off
05 Feb
“Making PL/SQL a better language”. This is Steven Feuerstein’s obsession.
In his courses he always encourages his students to send their comments to Bryn Llewellyn the project manager for PL/SQL at Oracle.
A while ago Steven already has launched a PL/SQL forum in OTN where people can directly ask him questions.
Now Steven has put together a website to […]