I’ve seen it done on Oracle before like replicating 11 -> 10 or 11->9. The intermediate format for GoldenGate has been standard forever, so as long as you have GG binaries certified to connect to each database then theoretically it should be possible to get…
I opened an SR recently while I was trying to get a feature to work in 19c... was politely directed to this resource... A listing of Oracle features and what version they're available in... Not sure when this was made available but I hope they…
If you have clients connecting to a server and the clients don't specify a specific encryption algorithm in SQLNET.ENCRYPTION_TYPES_CLIENT, be aware that the order of the algorithms listed in SQLNET.ORA on the server side matters... If you don't specify SQLNET.ENCRYPTION_TYPES_CLIENT from a 12.2 client configuration,…
This is something I have been wanting for a while. I need a way to quickly show SQL Statement performance over time for 1 statement, especially to identify Execution Plan volatility. When researching performance problems I often need to quickly digest historical performance of a…
I am throwing together a quickie Play Framework application for a DB process dashboard. I love Play. Its quick, powerful, and does a pretty good job of getting out of your way when you need it to. But as a cutting edge open source app…
Yes, I tagged it with a '1' because I already know there are more to come :) I created a notebook on this site to collect information about PowerDesigner. My first entry deals with basic script generation options for Oracle and how to get better…
I have been checking out some usage patterns on a database I am migrating to Exadata. I won't go into the 'drop all of the indexes' herd mentality... but I would like to know what is really being used on this system so we can…
I posted my GoldenGate / Gnuplot lag time alerting shell scripts to a new GitHub repository: http://github.com/dmann99/ggtools The scripts worked on v8 and I don't think the INFO ALL screen has changed much since then so hoping it will work on v11 with a minimum…
...well not yet... An Infoworld article was released today describing an Oracle vulnerability. The SCN space can be exhausted via bugs or attackers exploiting bugs. Metalink doc: 1376995.1 [Bulletin : Information on the System Change Number (SCN) and how it is used in the Oracle…
Oracle is supplying some ready-to-run downloadable VMs including Operating Systems, OSes with Oracle already installed and ready-to-run RAC systems. I was hoping to leverage these to save some time for sandbox environments but from what I have seen so far they are only for the…
Came upon this post during my travels. Jonathan Lewis reveals how to write a string to the Alert Log, Current Session Trace File, or Both. Also a few misc functions are included. dbms_system.ksdwrt(1,'test') writes to alert log dbms_system.ksdwrt(2,'test') writes to session's trace file dbms_system.ksdwrt(3,'test') writes…
If you want to record copies of changed records on a target system you can do this with Golden Gate Software and not incur much in the way of source side resource drain. To capture changes you configure a Golden Gate Extract process. The Extract…
I recently fielded a question about getting data out of Oracle quickly. Without much detail on the systems involved here is my answer: I need to migrate data from Oracle to MySQL quickly (in less than 1 day). What are my options? Oracle does not…
I keep coming across a construct in some legacy SQL that has been causing all kinds of performance issues for us. I guess you could call it using the IN condition with multi-column subqueries. I located the syntax for the IN condition here but it…
This script will generate dbv commands into a shell script and then execute the shell script. run-dbv.sql: set head off set lines 200 set feedback off set define off spool dbv.sh select 'dbv file='||name||' blocksize = '||block_size|| ' LOGFILE=FILE-'||FILE#||'.LOG' from v$datafile; spool off host chmod…