XE Idle Instance

Can anyone help resolve an “idle Instance” of a Oracle XE database upon entry of ‘sqlplus / as sysdba’? Oracle are perplexed. sysdba error.PNG Attached Images sysdba error.PNG (13.4 KB)

Posted in SQL

DB2 10.5 Enable parallelism

Hi, We want to enable parallelism in DB2 10.5. First I have enabled intra_Parallel to yes. And then dft_degree to ANY. I am confuse about parameter MAX_QUERY DEGREE, currently its set to 1. Should I change to more then 1?

Posted in SQL

tempspace usage

DB2 10.1 fp2 on linux x64 simple database without dpf having a simple table only db in the instance/machine (0)[db2inst1@plx00003 retrieve]$ db2 describe table legal.gm_ssin Data type Column Column name schema Data type name Length Scale Nulls ——————————- ——— ——————- Continue reading tempspace usage

Posted in SQL