Dali's SAP ABAP Reuse Code Pieces

SRM introduction by LiuTao -mp3 file

http://mtmdali.users.blogmatrix.com/podcasts/#3113f350ce07a5292c65318d825e42a0

play or download mp3 file

http://mtmdali.users.blogmatrix.com/podcasts/2005/06.20/0001/srm04.mp3

posted by Dali @ 12:02 AM

CRITICAL SEGMENTS: d010l

sapdba
>c tablespace admin
>f alert volume

It says that those tablespaces have no room for the next extent
declare in those segments.

Even though the tablespace could have a lot of free space as a whole (
i.e. sum(bytes) from dba_free_space) the max free space chunk is no
large enough to store the next requested extent for that segments
(i.e. max(bytes) from dba_free_space).

You could do a coalesce tablespace (alter tablespace XXX coalesce) or
add more space to the tablespaces.

HTH
Adrian


************ End of list of all segments with more than n extents *************
2005-06-07 01.01.08 Check of all tablespaces
(Checking cr iti cal number of new extents: 1):
SAPDBA: The following tables/indexes/clusters would overflow the tablespace by
allocating the number of extents shown in the appropriate column:
TABLESPACE SEGMENT TYPE EXTENTS NEXT (K)
PSAPEL46CD D010L TABLE 1<= 1 81920
Total: 1 object(s).
SAPDBA: Alert - CRITICAL SEGMENTS:
SEGMENT(S) D010L WOULD CAUSE A TABLESPACE OVERFLOW BY ALLOC. UP TO 1
NEXT EXTENT(S)

posted by Dali @ 10:23 PM

sapdba: add datafile to tablespace (change steps)

How to Increase the Tablespace free space?

Your tablespace PSAPBTABD is 92% used. How to increase the free space?


                  SAPDBA V3.1I - SAP Database Administration

____________________________________________________________________________



                     ORACLE version : 7.3.4.3.0
                     ORACLE_SID     : ALD
                     ORACLE_HOME    : /oracle/ALD
                     DATABASE       : open
                     SAPR3          : 31H, 23 times connected

          a - Startup/Shutdown instance    h - Backup database
          b - Instance information         i - Backup archive logs
          c - Tablespace administration    j - Check (and repair) database
          d - Reorganization               k - Restore/Recovery
          e - Export/import                l - Show/Cleanup
          f - Archive mode                 m - User and Security
          g - Additional functions         n - Help

          q - Quit

          Please select ==>  c


____________________________________________________________________________


                          Tablespace administration

____________________________________________________________________________


                                                  Current value
  a - Tablespace:
  b - Log checks:                                 no

  c - Free space and fragmentation  of all tablespaces
  d - Check   free space of objects in all tablespaces
  e - Check   free space of objects in tablespace

  f - Alter   tablespace Add Datafile
  g - Create/drop tablespace

  h - Display all tablespaces and datafiles
  i - Display raw device drivers in /dev

  q - Return

  Please select  ==>  a

  Enter tablespace name [%] ==> psapbtabd

____________________________________________________________________________

                          Tablespace administration

____________________________________________________________________________


                                                  Current value
  a - Tablespace:                                 PSAPBTABD
  b - Log checks:                                 no

  c - Free space and fragmentation  of all tablespaces
  d - Check   free space of objects in all tablespaces
  e - Check   free space of objects in tablespace PSAPBTABD

  f - Alter   tablespace PSAPBTABD Add Datafile
  g - Drop    tablespace PSAPBTABD

  h - Display all tablespaces and datafiles
  i - Display raw device drivers in /dev

  q - Return

  Please select  ==>  f




____________________________________________________________________________


                   Alter tablespace PSAPBTABD add datafile

____________________________________________________________________________


                                         Current value

      a  -  File system or raw device:   file system
      b  -  File size:                   2088960 K (larger than free space)
      c  -  Select path:                 /oracle/ALD/sapdata5
      d  -  Alter suggested path:        /oracle/ALD/sapdata5
                                         free space: 3608 K
      e  -  Display current files:       10 files, total (in DB): 77


      s  -  Start (Add datafile)

      q  -  Return

      Please select  ==>  s

posted by Dali @ 10:01 PM

sapdba: add datafile to tablespace (error code)

2005-06-07 01.01.08		Check of all tablespaces
(Checking		cal number of new extents: 1):
SAPDBA: The following tables/indexes/clusters would overflow the tablespace by
allocating the number of extents shown in the appropriate column:
TABLESPACE SEGMENT TYPE EXTENTS NEXT (K)
PSAPEL46CD D010L TABLE 1<= 1 81920
Total: 1 object(s).
SAPDBA: Alert - CRITICAL SEGMENTS:
SEGMENT(S) D010L WOULD CAUSE A TABLESPACE OVERFLOW BY ALLOC. UP TO 1
NEXT EXTENT(S)

posted by Dali @ 9:57 PM