-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When debugging data issues with GoldenGate one of the first things I like to do, is to check if the… READ MORE
SQLcl has many new little tricks that can help us on a daily basis, below is an example how we… READ MORE
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more… READ MORE
|
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst This file contains hidden or bidirectional Unicode text that may be interpreted or compiled… READ MORE
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is… READ MORE
|
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script… READ MORE
|
http://www.oracle.com/technology/support/tech/sql_plus/htdocs/sub_var9.html READ MORE
|
Using the example below one can include instance name in the spool filename when using SQL*Plus SQL> set termout off… READ MORE
|
Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$… READ MORE
Using the utility rlwrap one can perform command line scrolling on SQL*Plus similar to that is available on windows version… READ MORE
Using the following command one can pass hostname, port, servicename and SID and connect to a database without having an… READ MORE
|
To change default number of bytes to be displayed when selecting LONG and CLOB columns. SQL> SET LONG 2000 SQL>… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 