Hi,
Is there any method or scripts to check on the monthly file system growth? For example, would wan to check on the total growth on month November..is it possible?
Thanks. (4 Replies)
what's the best way to calculate the raw disk space in format. the system is a Solaris system using EMC disks- df -k will give me what's used plus available.Now I need the total disk space that the system is using/assigned. Which means I must inventory the raw disks in format. the system uses... (6 Replies)
Hello,
I have a script SELECT TO_CHAR(creation_time, 'RRRR Month') "Month",
SUM(bytes)/1024/1024 "Growth in MB"
FROM sys.v_$datafile
WHERE creation_time > SYSDATE-365
GROUP BY TO_CHAR(creation_time, 'RRRR Month')
/
It produces output similar to this
Month ... (2 Replies)
Hi All,
IS there any 'awk' way to manipulate following data?
Fruit Date Count
Apple 20/08/2011 5
Apple 27/08/2011 7
Apple 05/09/2011 11
Apple 12/09/2011 3
Apple 19/09/2011 25
.
.
.
.
Orange 20/08/2011 9
Orange 27/08/2011 20
Orange 27/08/2011 7
Orange 05/09/2011 15
Orange... (3 Replies)
I have a file server that has a pretty large folder tree. There's a shared folder, under that are 5 departmental folders. Nested inside of those are thousands of subfolders and files.
I would like to be able to trace growth of those 5 departmental folders. There are certain particular... (4 Replies)
Hi experts,
I have the below details with me.How to calculate the tablespace growth between two dates.
sample data(have data upto 1 year):
INSTANCE_NAME DATE TABLESPACE_NAME MB_ALLOC MB_FREE MB_USED PCT_FREE PCT_USED MAX
---------------- ---------... (1 Reply)