Database Administration & Monitoring, Database management, Oracle sqlplus and its column output 01.04.2018 by Clemens Bleile During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as(…)
Database Administration & Monitoring, Database management, Development & Performance, Oracle Connect-times to the DB suddenly become very slow using sqlcl 12.03.2018 by Clemens Bleile I recently wrote a couple of sql-scripts which had to run on all of my customer’s DBs. The sql-scripts had to be started from a Linux-client, which does not have any Oracle client software installed. So I thought of using(…)
Database Administration & Monitoring, Oracle Configure the Resource Manager with SQL Developer 23.08.2015 by Oracle Team By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I'm already looking at the topics. I'm talking about the 'Configure the Resource Manager' one here. Configuring Resource Manager in commandline(…)