List of oracle Table Names and Rows

I was looking for ways of displaying table names and number of rows it hold. It took me a lot of time to figure out how this can be done. After nearly completing my script, I found a better script than the one I created and want to share it with you.

You can find the full script @List of oracle Table Names and Rows

Export oracle METADATA_ONLY

steps
1. create dump directory (CREATE DIRECTORY metadata_export AS '/opt/app/oracle';
2. make sure the directory has got read and write permssion
3. create shell script as follows
4. schedule the script to run

#!/bin/sh
. envfile.env
$ORACLE_HOME/bin/expdp \"/ as sysdba\" SCHEMAS=shcema1, schema2, schema3 content='METADATA_ONLY' directory=met
adata_export NOLOGFILE=Y dumpfile=metadata_export:metadata.dmp compression=metadata_only

Invoking oracle ESB API through http protocol

If you want to see the service status of esb in one xml file you can invoke oracle esb API through http protocol. For instance you can use http://hostname:port/esb/esbConfiguration/executeCommand?action=ExploreServices to list all your esb services and statuses in one xml document

This is documented very well @ One of soa blog

Optimizing Oracle on VMware

I have been looking into the issues of running RDMS on vmware and found the following articles to be useful.

optmising oracle on vmware

Deployment of Oracle Databases on VMware Infrastructure

virtual machines versus bare metal

RAC on virtual machines

nice -n 19 rm -rf directory

nice -n 19 rm -rf directory

this command will allow you to run a rm if your directory has got many files. It will run with lowest priority.