Oracle Apps – Analysis of the Files and Filesystems


Continuing my analysis of Oracle Apps R12.  This time, the actual files on the server.  There are over 1/2 million files in APPL_TOP and COMMON_TOP!  Wow!

—————-

On my installation of Apps R12, there is:

APPL_TOP
/oapps/applmgr/VIS/apps/apps_st/appl

COMMON_TOP
/oapps/applmgr/VIS/apps/apps_st/comn/

ORACLE_HOME
/oapps/oracle/VIS/db/tech_st/11.1.0

—————-

The top parts of the directory structure:

find /oapps  -maxdepth 5 -type d

/oapps

/oapps/applmgr
/oapps/applmgr/VIS
/oapps/applmgr/VIS/inst
/oapps/applmgr/VIS/inst/apps
/oapps/applmgr/VIS/inst/apps/VIS_blue
/oapps/applmgr/VIS/apps
/oapps/applmgr/VIS/apps/tech_st
/oapps/applmgr/VIS/apps/tech_st/10.1.2
/oapps/applmgr/VIS/apps/tech_st/10.1.3
/oapps/applmgr/VIS/apps/apps_st
/oapps/applmgr/VIS/apps/apps_st/comn
/oapps/applmgr/VIS/apps/apps_st/appl

/oapps/oracle
/oapps/oracle/VIS
/oapps/oracle/VIS/db
/oapps/oracle/VIS/db/tech_st
/oapps/oracle/VIS/db/tech_st/11.1.0
/oapps/oracle/VIS/db/apps_st
/oapps/oracle/VIS/db/apps_st/data

/oapps/oracle contains files for the Oracle database.
/oapps/applmgr contains files for the middle tier.

——————

Database side:

cd /oapps/oracle

find /oapps/oracle  -type d  | wc
6675    6675  492154

– over 6.5K directories

find /oapps/oracle  -type f  | wc
59186   59186 5235705

– almost 60K files

Disk space:
du -hs .
195G

What types of files, according to file suffix?

cd /oapps/oracle
find . -type f |  xargs -n1 basename | cut -d ‘.’ -f2 | sort | uniq -c | sort -n


235 sbs
242 dbf
281 dlf
289 pls
302 svg
307 java
325 html
348 msg
367 xsl
373 1
403 o
419 trc
419 trm
453 3
498 aud
529 sh
554 ouibak
557 txt
559 properties
598 jspf
667 png
741 pm
765 so
862 pl
866 class
1191 nlb
1243 plb
1653 uix
1896 msb
1968 jar
2872 xml
3254 js
3633 jsp
5389 sql
6250 htm
6448 gif

———————-

Root of applmgr.

/oapps/applmgr

find /oapps/applmgr -type d | wc
38730   38730 3053997

– almost 39K directories

find /oapps/applmgr -type f | wc
562507  562509 52169424

– over 1/2 million files!!!

Disk space used:
du -hs .
28G

———————-

$COMMON_TOP
cd /oapps/applmgr/VIS/apps/apps_st/comn/

find . -type d | wc
16209   16209  782838

– over 16K directories

find . -type f | wc
258795  258795 18622540

– over 1/4 million files

Disk Space used:
4.1G    .

Mostly in $COMMON_TOP/java/classes

find /oapps/applmgr/VIS/apps/apps_st/comn/java/classes -type f | wc
230815  230815 14221389

What types of files, according to file suffix?

cd /oapps/applmgr/VIS/apps/apps_st/comn/java/classes

find . -type f |  xargs -n1 basename | cut -d ‘.’ -f2 | sort | uniq -c | sort -n


6 xsd
7 sql
11 hs
12 uix
15 dat
16 pls
22 dtd
25 jpg
32 png
83 uit
113 htm
172 properties
180 jar
202 txt
7115 gif
61370 xml
161388 class

Lots of *.class and *.xml files!

——————–

$APPL_TOP
cd /oapps/applmgr/VIS/apps/apps_st/appl

find . -type d | wc
13095   13095  484041

– over 13K directories

find . -type f | wc
245229  245229 10789592

– almost 1/4 million files

Disk space used:
20G

What types of files, according to file suffix?

find . -type f |  xargs -n1 basename | cut -d ‘.’ -f2 | sort | uniq -c | sort -n

436 dtd
622 hdt
685 wft
816 drvx
862 o
862 plb
984 wfx
1097 uix
1258 pdf
1349 jlt
1646 lct
1757 drv
1992 plx
2010 pll
2217 rdf
2293 ildt
2588 rtf
3213 eex
3940 fmx
3952 fmb
5092 odf
5499 xdf
5895 pkh
5909 pkb
8048 jsp
10768 gif
20183 sql
28906 xml
29678 ldt
37903 htm
48104 pls

Most common file types are:
jsp, gif, sql, xml, ldt, htm, and pls

pls: Oracle package definitions

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: