SAP Note 359835 - Design of the temporary tablespace in the BW System

Composant : Backoffice Service Delivery -

Solution : https://service.sap.com/sap/support/notes/359835 (Connexion à SAP Service Marketplace requise)

Mots Clés :
svrmgrl> connect internal            svrmgrl> set timing, svrmgrl> drop tablespace psaptest including contents, raw-device>'                     size 500m reuse, svrmgrl> create tablespace psaptest                     '<, underlying data files correctly, initial hash_area_sizenext hash_area_sizenext hash_area_sizeinitial, schedule job sap_drop_tmptable periodically, required temporary tablespace increases, require massively temporary tablespace, dictionary-managed oracle tablespace

Notes associées :

761171CPCC Service Package 2.2.300
745639FAQ: Oracle enqueues
659946FAQ: Temporary tablespaces
619188FAQ: Oracle wait events
567745Composite note BW 3.x performance: DB-specific setting
485755ORA-03232: unable to allocate an extent of blocks
443544IO Problems on AIX Filesystems
432377ODMA modifies Storage settings for Temporary TS
416772General tablespace types, temporary tablespace parameters
387946USE OF LOCALLY MANAGED TABLESPACES FOR BW SYSTEMS
354080Note collection for Oracle performance problems
334713SAP BW 2.1C Installation on UNIX
308533Temporary Database Objects in BW 2.0
180605Oracle database parameter settings for BW
164925Storage parameter of tablespace PSAPTEMP