Monthly Archive: September 2019

So I have been having trouble getting the oracle wallet to auto open, and it’s always messed up in gv$encryption_wallet select * from gv$encryption_wallet; INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID ———- ———— ———————- ————- ———- ———— —— 4 FILE OPEN AUTOLOGIN SINGLE NO 0 1 FILE OPEN AUTOLOGIN SINGLE NO 0 3 FILE …

Continue reading »

I noticed a long running query in one of my databases this morning. SELECT TABLESPACE, ROUND ( ( (max_size_mb – used_space + free_space_mb) / max_size_mb), :”SYS_B_00″) * :”SYS_B_01″ AS pct_free FROM ( SELECT ts.tablespace_name TABLESPACE, ROUND (SUM (NVL (fs.bytes, :”SYS_B_02″))) / :”SYS_B_03″ / :”SYS_B_04″ free_space_mb, ROUND (SUM (df.bytes)) / :”SYS_B_05″ / :”SYS_B_06″ used_space, ROUND ( …

Continue reading »