How Deep is Your…Oracle Home?
This is likely the most trivial of pursuits sort of posts I’ve made in a long while. Please don’t ask me why, but I had to take a few minutes to inventory directory depth in an Oracle Database 11g Enterprise Edition (with Real Application Clusters) Oracle Home directory tree on Linux. The data in the following box shows each directory depth that exits under my Oracle Home and a tall of how many directories are nested that deeply.
Maybe we should all breathe a sigh of relief that there are only 3 directories laying 13 levels deep? That is, after all, only .07% of all directories (4208) under a typical 11g Oracle Home! I’m not losing sleep.
Hey, like I said, trivial pursuit. Ho hum.
SQL> select d,count(*) from oh_dirs
2 group by d
3 order by 2 desc ;
D COUNT(*)
---------- ----------
8 796
5 729
6 663
4 651
9 437
7 369
3 306
10 145
2 70
11 31
12 6
D COUNT(*)
---------- ----------
13 3
14 1
1 1
14 rows selected.
SQL> select count(*) from oh_dirs;
COUNT(*)
----------
4208
Kevin Closson's Blog: Platforms, Databases and Storage 
How did you populate oh_dirs?
Greetings
Bernd
cd $ORACLE_HOME
find . -type d -print | sed -e ‘s~/~#~g’ -e ‘s/[^#]//g’ | while read dir
do echo -n “$dir” | wc -c
done | while read cnt
do
echo “INSERT INTO oh_dirs VALUES (‘$cnt’);”
done
When I first saw this I thought you were talking about the depth of the beginning of the OH – I am always amazed at shops with the unruly combination of 6+ level deep OHs and a failure to use tab completion.
Nope…this is a look the various depths and count of each depth starting in OH … trivial pursuit mostly… (well, not really, but I’m not blabbering about why I was looking at that stuff anyway 🙂 )
Hey, say “Hi” to Matt for me would ya?