Querying Oracle Advanced Queuing to see text messages through SQL

To see character data in an Oracle Advanced Queuing using SQL.
use the following query

select q.USER_DATA.TEXT_LOB from schema.AQTableName q

make a SOA 10 g BPEL Process not to dehydrate any data at a Process level and not at Domain Level

To make a SOA 10 g BPEL Process not to dehydrate any data at a Process level and not a domain Level.

This can be done by simply adding an entry into bpel.xml

<configurations>
<property name="inMemoryOptimization" encryption="plaintext">true</property>
<property name="completionPersistLevel" encryption="plaintext">instanceHeader</property>
<property name="completionPersistPolicy" encryption="plaintext">off</property>
<property name="deliveryPersistPolicy" encryption="plaintext">off</property>
</configurations>

Percent of memory used in a Mount point

dirsize=`df -k $src | tail -1 | awk '{print substr($4, 1, length($4) -1);}'`

Removing n Oldest files in a Unix/Linux mount point

To remove the oldest files even though they lie in multiple directories

files=`find /var/share/temp/ \( ! -regex '.*/\..*' \) -type f -exec stat -c "%y %n" {} \; | sort | head -5 | tr -s ' ' ' ' | cut -d' ' -f4 "$@" `

for file in $files
do
rm -f ${file}
done