U01 size

[saadqkhan]

Hello Erman,

I am noticing that size of u01 is increasing suddenly and now only 72G is left out of 485G. Can you please what thing is taking too much space?

Thanks and Regards,
Saad

[ErmanArslansOracleBlog]

/u01 means nothing. :)
I mean anyone can name any mount point as u01.
Anyways, most probably logs/debug files/core dumps and etc is your problem.  
But, you sould investigate..
Use Os tools to find the huge sized directory first.
In Linux you can use "du -sh".
This is a very generic question bytheway, but as I said you, investigate..

Thanks

[saadqkhan]

Hello erman,

I type command du -sh under /u01/ but it looks it hangs? its not showing anything.

Thanks and Regards,
Saad

[ErmanArslansOracleBlog]

it is computing Saad. Wait a little bit.

[saadqkhan]

admin/
5.1M    .

apps/
34G     .

archive/
4.2G    .

backup/
8.0K    .

cfgtoollogs/
48M     .

checkpoints/
4.0K    .

db/
342G    .

diag/
40K     .

inst/
7.9G    .

oradata/
8.0K    .

rman/
4.0K    .

[ErmanArslansOracleBlog]

Go inside the directories (where you see huge size) using cd
After that reissue du -sh.

do these steps till you reach the leaf directory. After you reach the leaf directory, check the files there, check what files they are, what kind of files they are and consider if they can be deleted..

[saadqkhan]

Okay erman,

Also does audit have impact on increasing size of DB? I am drilling down what you have told.

thanks and Regards,
Saad

[saadqkhan]

Hello,

Erman I see that in apps_st/data there are too many .dbf files. Which are taking 323G. Are these files useful?

thanks and Regards,
Saad

[ErmanArslansOracleBlog]

Yes. audit data will occupy space. The amount of space is dependent on what you audit and the amount of operations related with the things you audit.

[saadqkhan]

Does these impact on base tables? Because when we do audit the audit store its data in shadow tables?

Thanks and Regards,
Saad

[ErmanArslansOracleBlog]

If it is EBS audit, then audit data is stored in shadow tables.
If you have also db audit, then the audit data is stored in sys.aud$

In general, audit data will be stored in DB , as you may guess. (unless you do a pure db audit and configured it to write the audit data to filesystem)

[saadqkhan]

Hello,

Erman I see that in apps_st/data there are too many .dbf files. Which are taking 323G. Are these files useful?

thanks and Regards,
Saad

[saadqkhan]

btw we have both audit enabled in db as well app.

thanks and Regards,
Saad

[ErmanArslansOracleBlog]

dbf files are your datafiles, they are ofcourse useful :), they are your database basically.

[ErmanArslansOracleBlog]

Send me the following outputs, if you want  to have more diag on this.

1)output of df -h
2)output of "du -sh" (recursively, for all directory levels..
"Go inside the directories (where you see huge size) using cd
After that reissue du -sh.

do these steps till you reach the leaf directory. After you reach the leaf directory, check the files there, check what files they are, what kind of files they are and consider if they can be deleted..)"