Posts

How to move datafiles in Oracle.

Posted by on
0

How to check archive amount per day and hour

Posted by on
0

How to obtain schema size and number of objects

Posted by on
0

How to check table size including their indexes.

Posted by on
0

Script to generate dbverify for all datafiles.

Posted by on
0

How to check repeated datafiles

Posted by on
0

How to check i/o load in database datafiles.

Posted by on
0

How to check invalid objects and compile them.

Posted by on
0

Script for Dropping all objects for an schema.

Posted by on
0

How to know the undo retention and undo recommended size in Oracle Data Base.

Posted by on
0

Script for checking db info

Posted by on
0

Check roles and privilegies for an user.

Posted by on
0

How to check size for each user

Posted by on
0

How to commit an update each 10000 rows.

Posted by on
0

How to do import tables and objects

Posted by on
0

How to do tables export with several options

Posted by on
0

How to do tables export with several options

Posted by on
0

How to do export excluding objects.

Posted by on
0

How to see last query executed.

Posted by on
0

How to see Database locks.

Posted by on
0

How to see percentage tables fragmentation.

Posted by on
0

How to obtain all dictionary tables in Oracle.

Posted by on
0

How to obtain trace name for current Oracle session

Posted by on
0

How to see active session in Oracle

Posted by on
0

How to kill user session through database and Unix command

Posted by on
0

How to see open cursors for each users in Oracle

Posted by on
0

How much memory does have each user in Oracle.

Posted by on
0

How to reorganize tables with brspace commands.

Posted by on
0

How to resize a redolog file.

Posted by on
0

How to create a metaset solaris 10

Posted by on
0