How to find current running SQL statement

Please Visit http://www.fasttrackdba.com/sqlscripts/currentsqlsindb.html for the thread

Index created on Table is in use or not???

Please Visit http://www.fasttrackdba.com/oracletips/indexusedbytable.html

New Segment Resource Estimation

Please visit http://www.fasttrackdba.com/oracletips/segmentestimation.html

Online Segment Shrink

Please Visit http://www.fasttrackdba.com/sqlscripts/onlinesegmentshrink.html for the thread

Oracle export and import This is a featured page

check for : http://wiki.oracle.com/page/Oracle+export+and+import+

Transportable Tablespaces-Datafiles

Check for
http://www.fasttrackdba.com/oraclehighendtechniques/transportabletablespace.html

Manually Cloning of Database:

Visit http://www.fasttrackdba.com/oraclehighendtechniques/databasecloning.html

Importing data from oracle to xl sheet.

Please visit http://www.fasttrackdba.com/oracletips/importfromexcelsheet.html

Tablespace Fragmentation

Please visit http://www.fasttrackdba.com/sqlscripts/tablespacefragmentation.html

Way to find the database table that is accessed the most

Please Visit http://www.fasttrackdba.com/sqlscripts/mostaccessedtable.html

Disk Sorts - Database Performance

Please visit http://www.fasttrackdba.com/performancetuning/disksorting.html

Shared Pool Advisory

Please visit http://www.fasttrackdba.com/performancetuning/sharedpooladvisor.html

Oracle Database Tuning Statistics

Please visit http://www.fasttrackdba.com/performancetuning/tuningstatistics.html

Script to identify chained rows in a table

Please Visit http://www.fasttrackdba.com/sqlscripts/chainedrowsinatable.html

Buffer Cache Advisory Statistics

Please visit http://www.fasttrackdba.com/performancetuning/buffercache.html

Oracle Database Tuning

Please visit http://www.fasttrackdba.com/

Solution

http://basic-oracledatabase.com/myopenid-hosted-verification.html:

SQL Tuning - File I/O Performance

http://www.fasttrackdba.com/

TUNING SHARED POOL

Please Visit http://www.fasttrackdba.com/performancetuning/tuningsharedpool.html

ORA-06512-Handling

http://www.fasttrackdba.com/