SAP Note 214995 - Oracle locally managed tablespaces in the SAP environment

Component : Oracle - Database Administration with Oracle

Solution : https://service.sap.com/sap/support/notes/214995 (SAP Service marketplace login required)

Key words :
LMTS: Locally Managed TablespaceDMTS: Dictionary Managed TablespaceASSM: Automatic Segment Space ManagementDBA_EXTENTS, DBA_FREE_SPACE, DBA_TABLESPACESORA-01575ORA-01631ORA-01632

Related Notes :

821687FAQ: Space utilization and fragmentation in Oracle
787533Bad performance/ system lockup due to enqueue waits
745639FAQ: Oracle enqueues
706625Oracle9i: Locally managed SYSTEM tablespace
682926Composite SAP note: Problems with "create/rebuild index"
662900Using LMTS in R/3 releases 3.1I-4.6B
659946FAQ: Temporary tablespaces
659487CC-ERROR: Resource analysis terminates on ORACLE
647697BRSPACE - New tool for Oracle database administration
646681Reorganization of tables with BRSPACE
626628ALE: No release of temporary segments
620803Oracle 9i: Automatic Segment Space Management
572060Options in the Oracle database during archiving
541538FAQ: Reorganization
521264Hang situations
515853BR905W No tables found to adjust NEXT extent
485755ORA-03232: unable to allocate an extent of blocks
483856Description of the alerts for Oracle database monitoring
435290Description of BRCONNECT 6.10 DB check conditions
416772General tablespace types, temporary tablespace parameters
409376Use of locally managed tablespaces for SAP R/3
395943exp with compress=y and locally managed tablespaces