create table t (processed_flag varchar(1)); create bitmap index t_idx on t(processed_flag); From Tom Kyte “Expert Oracle Database Architecture – 3rd Edition” insert into t values (‘N’); declare pragma autonomous_transaction; begin insert into t values (‘N’);…
Assumptions: a ULN subscription – Oracle Support for oracle Linux – i.e a valid CSI use the link: How to create a local Unbreakable Linux Network mirror
Using ASH to Monitor Temporary Tablespace Usage To use ASH (Active Session History) to monitor temporary tablespace usage use SQL similar to the query below. Detect the space used by queries.
Database Level
Oracle – Multitenant – Create a sysdba Common User 😎 To create a sysdba user that can administrate all containers: If it is necessary to change the common user prefix (or get rid of it!),…
Move keepass Database File from iPhone to PC tap Share icon (square/arrow) at bottom centre select “copy to (Google) Drive” save it somewhere on the drive In Google Drive, find the file and tap three…
Install java and javac on RedHat Linux To install java and the java compiler on RedHat Linux, it is required to installed a couple of packages using yum. As root, or sudo as a privileged…
Collect diagnostic info for Oracle Virtual Machine Manager and Servers If you are experiencing issues with OVM, and an SR is opened, Oracle support will request diagnostic information. The shell session below shows collection of…