cancel
Showing results for 
Search instead for 
Did you mean: 

DB13 Check and Update Optimizer Statistics Error

Former Member
0 Kudos

Dear Gurus,

While Updating the Update stats in DB13 Calender it shows the Below mentioned error.

BR0881I Collecting statistics for table SAPPSU.EKUB with method/sample C ...

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.01

BR0884I Statistics collected for table: SAPPSU.EKUB, rows old/new: 4093/6243

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.14

BR0883I Table selected to collect statistics after check: SAPPSU.EQBS (4288797/6962268)

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.14

BR0881I Collecting statistics for table SAPPSU.EQBS with method/sample E/P3 ...

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.28

BR0301E SQL error -25153 at location stats_tab_collect-16

ORA-25153: Temporary Tablespace is Empty

BR0886E Checking/collecting statistics failed for table SAPPSU.EQBS

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30

BR0883I Table selected to collect statistics after check: SAPPSU.ESLH (278/420)

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30

BR0881I Collecting statistics for table SAPPSU.ESLH with method/sample C ...

BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30

BR0884I Statistics collected for table: SAPPSU.ESLH, rows old/new: 278/420

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19

BR0883I Table selected to collect statistics after check: SAPPSU.HRS1210 (13400/25026)

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19

BR0881I Collecting statistics for table SAPPSU.HRS1210 with method/sample E/P30 ...

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19

BR0884I Statistics collected for table: SAPPSU.HRS1210, rows old/new: 13400/13400

BR0986W Index SAPPSU.HRS1210~0 is unbalanced - please rebuild the index

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.38

BR0883I Table selected to collect statistics after check: SAPPSU.JGTBP00 (75747/117862)

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.38

BR0881I Collecting statistics for table SAPPSU.JGTBP00 with method/sample E/P10 ...

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.39

BR0884I Statistics collected for table: SAPPSU.JGTBP00, rows old/new: 75747/106197

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.40

BR0883I Table selected to collect statistics after check: SAPPSU.JGTGPNR (76144/117862)

BR0280I BRCONNECT time stamp: 2009-01-18 02.24.40

Please help me to sort out this issue.

Thanks

Anbu

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Anbu,

the reason for this error is that you have no TEMPFILEs in your temporary tablespace (usually PSAPTEMP).

Please add one with the BR*Tools:

http://help.sap.com/saphelp_nw70/helpdata/de/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

Regards

Stefan

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

My guess is that this is a refreshed system, that PSAPTEMP is temporary and that you forgot to add the TEMP datafile. you must re-add your datafile like in this comamnd:

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'G:\ORACLE\DEV\SAPDATA1\TEMP_1\TEMP.DATA1'

SIZE 2768M REUSE AUTOEXTEND ON NEXT 268435456 MAXSIZE 16000M;

Is my Crystal ball right?