With Oracle DB, setting the Cardinality option causes a b-tree index to be built instead of a bitmap index even if it is not a line item dim.
Setting it as a Line Item dim also causes a b-tree index to be built instead of a bitmap index, but also embeds SID directly in the fact [...]
Check
sysdumpdev -l # to list dump device
sysdumpdev -L # to list last time system dumped
sysdumpdev -e # to estimate the size of a dump under current loading
You can make your dumplv large enough to fit your needs:
extendlv lg_dumplv NUM_PPS (example lg_dumplv is your dump lv )
Or:
Add more space to /var ( chfs -a size=xxxxxx /var (where [...]
Use BRTools.
$ORACLE_HOME/dbs/init[SID].ora and spfile[SID].ora
T-code: st04 — top menu — goto — setup — parameter changes — active parameters
In sqlplus, for init parameters.
SHOW PARAMETERS
V$PARAMETER
For hidden parameters (use/change carefully!!)
SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, ‘TRUE’, ‘FALSE’) SESMOD, DECODE( BITAND(KSPPIFLG/65536, 3), 1, ‘IMMEDIATE’, 2, ‘DEFERRED’, 3, ‘IMMEDIATE’, ‘FALSE’ ) SYSMOD, KSPPDESC DESCRIPTION FROM SYS.X_$KSPPI X WHERE X.INST_ID = [...]