tablespace is not showing

[Former Member]

hi to everyone,

i am new in basis

i had install ECC 6.0 with orcale 10 g and windows 2003.i had made 2 partition in the hard disk.

C:30 gb and D:300 gb.

C drive for os and D drive for data.

now every thing is ok and i had complete the installation.and into 😧 drive almost 200 gb space is free.

but when i am checking in to DB02

it is showing 19% space free only why?

whenever i am clicking on current size then it is showing blank screen .....

not showing any information..why?

not showing which tablespace having what size why?

How can i check the size of PSAPSR3

PSAPSR3700

System and other table space...

i login in to 000 cliect not created and other client ....because i am surprised to see the 19% free space only.

please provide me the solution.

regrds

dik

[former_member204746 · Accepted solution]

a tablespace is made up of multiple datafiles. those datafiles occupies disk space.

your database sees free space from within the datafiles. it does not really check free space at Os level.

so, your datafiles has 19% of free space but your disk might have more free disk space.

to extended or add datafiles, use these:

brspace -c -u / -f tsextend (to add a datafile)

brspace -c -u / -f dfalter (to increase size of datafile)

good luck.

[Former Member · Accepted solution]

Thanks to every one

but what is my requriment i want to increase PSAPSR3....

but as i already said not able to see information here...

also suggest me if i create a new client and copy that client with 000 all profile.

ok now....

on the 😧 drive i am having 200 gb space but how can i measure that how much PSAPSR3 having...

if i want to increase tablespace then how can i

have to increase datafile or simply can i increase tablespace....

to extended or add datafiles, use these:

brspace -c -u / -f tsextend (to add a datafile)

brspace -c -u / -f dfalter (to increase size of datafile)

suggest....

[former_member204746 · Accepted solution]

2 choices will work, it depends on you. I prefer less datafiles with bigge size, but that's just me.

choose whatever you prefer.

to view datafiles/tablespace usage:

brspace -c -u / -f dbshow

option 2

option 1

[Former Member · Accepted solution]

I think you have enough answers about how to get tablespace info and how to add datafiles to them (Brtools, Oracle command, etc) just wan to answer you about the new client you want.

SAP recomends to do the client copy using client 001 as reference and not 000 because this last one has some configuration that should not be copied to different clients. And yes you can use SAP ALL profile to do the copy altough SAP recomends to use Customizing for the copy.

Good Luck

[Former Member · Accepted solution]

Thanks for the reply...

now after refreshingin DB02 and sheduling dbcheck job...

i am getting the tablespace information and here i am sharing what are the size of that .....

size (kb) free(kb)

PSAPSR3 40960000(kb) 11923072

PSAPSR3700 38113280 9152

PSAPSR3USR 20480 18560

so now suggest me should i increase PSAPSR3 or any datafile.....

if i am going to increase tablespace PSAPSR3 then how at BRTOOL...

what will be the steps...?

is it be possible when server is up or for that i have to down the server and stop the orcale services....

plese suggest

Edited by: dik on Mar 18, 2009 7:50 AM

[Former Member · Accepted solution]

one more thing ,

i had create a new client and and trying to copy ALL profile from 000 and 001.

every thing was ok but i found that client copy has been cancelled due to less PXA.

got abapdupm that PXA is not enough...

so how can i increase ....it according to DUMP it is 145032kb

i am using Win 2003 ....then what is that ipclimits utility program....

please suggest

[Former Member · Accepted solution]

PXA is program execution area that is belong to abap/buffersize

you can increase it through RZ10 and restart the server and shedule client copy.....

check logs in to SCC3 .

abap/buffersize should be 250 mb or 300 mb for windows. for 32 bit....

set it as per requirement...and try... you will get the ...

hope this will work.

Reagard

ANUJ

Edited by: anuj sharma on Mar 18, 2009 8:09 AM

[Former Member · Accepted solution]

Hi,

Look for parameter abap/buffersize in rz10 instance profile.

Cheers

Deepanshu

[Former Member · Accepted solution]

Thanks Sharma ji,

after increaseing that parameter i had completed client copy from 000 or 001 with ALL profile.

but please provide me the solution related to brtools

please...

[Former Member · Accepted solution]

Hi ,

For space please check with db02 or brtools.

For brtools please refer

brtools

option 2 Space Management \7 Addition Space function \ 1 show tablespace\ c\c\

Here you can find the same.

Cheers

Deepanshu

[Former Member · Accepted solution]

Dear All,

now i did client copy success fully...

every this is ok but when in DB13 i am sheduling job check db ....its completed with an error related to oracle parameter.

log_archive_start is not ok....

it is critical error and can i resolve it.

please suggest

[Former Member · Accepted solution]

Dear Dik,

Check that parameter into init<sid>.ora file.....

what is its status.....

and check what is the error into DB16...then set the parameter....

through SQLPLUS @ Sysdba accordingly...

hope it will helpyou...

cheers!

Anuj

[Former Member · Accepted solution]

Dear Sharma ji,

thanks for immediate reply....

parameter LOG_ARCHIVE_START is not mention into init<SID>.ora file....

how can i change it...please give me the solution.....

regards

dik

[Former Member · Accepted solution]

go to cmd level...

brspace -f dbparam...

then show parameter

4 option...

at 133 no you will find that parameter...ok

here you can change and set it default also...

at SQLPLUS @sysdba level

SQL>alter system set log_archive_start =true scope =spfile;

iten restart the db...

hope it will help you..

cheers!

one comment for you your marking cretirea is so good....

[Former Member · Accepted solution]

i had change it that parameter and shedule CHECK DB in DB13 .

now i am not getting error.

thank you all

[Former Member · Accepted solution]

hi to every one,

one more issuse that i had install ECC 6.0 not applied any patch....

now want to apply SAPKE60004 patch for HR....

will it work

or else i have to apply BASIS patch first...

suggest me....

thanks

Edited by: dik on Mar 21, 2009 10:18 AM

[Former Member · Accepted solution]

Dik,

You can go through the patch information on marketplace for SAPKE60004 and you will find all the pre-requisites including Basis, ABAP etc.

hope this helps.

Manoj

[Former Member]

please help me can i do that ...

[Former Member]

Hi Dik,

New query should be in new post.

Once you upload patch through SPAM . Please run the same in TEST mode and you will find the dependcy.

Cheers

Deepanshu

[Former Member]

Dik,

You can check tablespaces from DB02, BRTOOLS, via oracle directly etc.

To check at oracle level:

1. sqlplus "/as sysdba"

2. select * from dba_tablespaces;

OR

BRTOOLS->Space Management->Additional space functions->show tablespaces

Also there is possibility that archive logs and backups have taken some space on your system.

Hope this helps.

Manoj Chintawar

[former_member208679]

Hi,

USE brtools / brspace to show the Actual tablespace statistics.

Regards

Chetan Anguralia

[Former Member]

Hello,

a few things to consider:

1) DB02 will only show data that has been collected before. One way of collecting data will be by clicking the refresh button in DB02. In the long run you should run a daily dbcheck job, for examply by means of transaction DB13.

2) The percentage of free space shown in DB02 always is the free space within a tablespace, or within its data files, but not within a disk. It doesn't matter how big your disk is. What does matter is the amount of disk space that has been assigned to a tablespace.

hope this helps