Db space

[former_member251537]

Hi Experts,

As per DBACOCKPIT

Db size

Date	Name	Size(Gb)	Chg.Size	Free(Gb)	Chg.Free	Used(%)
12/1/2015	XXX	216.30	0.00	89.10	-5.25	59
11/2/2015	XXX	216.30	1.50	94.35	-0.09	56
10/1/2015	XXX	214.80	0.00	94.44	-2.62	56
9/1/2015	XXX	214.80	0.00	97.06	-2.19	55
8/1/2015	XXX	214.80	0.00	99.25	-2.12	54
7/1/2015	XXX	214.80	0.16	101.37	-4.78	53
6/1/2015	XXX	214.64	63.48	106.15	44.00	51
5/1/2015	XXX	151.16	0.00	62.15	-1.44	59
4/1/2015	XXX	151.16	0.00	63.59	-0.82	58
3/1/2015	XXX	151.16	13.70	64.41	13.06	57
2/1/2015	XXX	137.46	0.21	51.35	-0.71	63
1/1/2015	XXX	137.25	0.22	52.06	-0.84	62
12/1/2014	XXX	137.03	0.23	52.90	-0.45	61

5/1/2015 to 6/1/2015 we added 65 Gb manually

but there is a chg.size like .23,.22....1.50 and as per the attached screen shots sapdata file size is 299GB and free space is 144GB

as per DB02 the size of ORA is 222.86GB and free space is 88.9GB

How to understand the DB growth

and we plan to increase the file size, kindly advice which are the file size needs to be increased.

Thanks and Regards,

Kathir

[Former Member · Accepted solution]

Hi,

For space mismatch - try refreshing the the DB02 screen. This will schedule a background job, once the job is complete you will have latest information in DB02.

About what file to increase..

If i take the about table info is related to tablespaces available in your system than they all have enough space for growth. When you find the any tablespace reaching 85% for Used(%) you can go for extending that tablespace by adding datafile in it.

You can get the details of datafiles associated to a tablespace in tablespace analysis report in DB02

Regards,

Prithviraj.

[former_member251537 · Accepted solution]

Hi Prithviraj,

Thanks for your immediate response,

I have done the refresh in DB02

ORA size is same 222.86GB

Our client wants to increase the size of the drives like USR(F:),SAPDATA(G:)

Need advice on this

Thanks,

Kathir.

[Former Member · Accepted solution]

Hi,

In BRTOOLS you have a option to list all the datafiles, in this way you will be able to see on what all drives your database resides and according to that you can go ahead increasing drives.

1. Start the procedure using BRGUI or BRTOOLS, or from the command line:
2. Choose Space management → Additional space functions  → Show data files.

You can also query select name,status from v$datafile;

Regards,

Prithviraj.