Wednesday, July 9, 2008
SCRIPT:To Display all datafiles, tempfiles and logfiles (and their sizes)
\http://www.fasttrackdba.com/
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Basic Oracle database Commands and Usages
Infolinks In Text Ads
Blog Archive
-
▼
2008
(49)
-
▼
July
(41)
- Linux vi Editor
- Alter system archive log
- Renaming Tablespace
- http://www.fasttrackdba.com/
- Oracle Database startup and shutdown process:
- Script:How to check startup time for a database.
- SQL*Net - listener.ora (Sample listener.ora)
- SCRIPT:To list database current users
- SCRIPT:To Check all Connected Users
- SCRIPT:Time since last user activity in database
- SCRIPT:To Check User Session Sorted By LoginTime i...
- SCRIPT:To check user information including OS Proc...
- SCRIPT:To check users current sql
- SCRIPT:To check Session status associated with the...
- SCRIPT:To Check All Active Sql
- SCRIPT:To Display any long operations in the data...
- How to resize tablespaces and data files
- Oracle Database User and Tablespace Creation in Si...
- SCRIPT:To Check used/free space in a TEMPORARY tab...
- SCRIPT:BHR FORMULA
- SCRIPT:Sql to Check Open Cursors in Oracle Database
- SCRIPT:To see the free available space in TABLESPA...
- Basic Linux Commands
- Basics Of Redo, Rollback and Undo in Oracle Database
- Storage - Blocks, Extents, Segments
- Instance Background Processes in Oracle Database
- Oracle Server Parameter File management (SpFile)
- Changing a Parameter value in Oracle database
- Top DBA Shell Scripts for Monitoring the Database
- CRONTAB Basics (Linux/Unix)
- SCRIPT:SCN Number
- Triggers
- SCRIPT:Display shared pool usage
- SCRIPT:PGA usage sorted by username
- System Global Area (SGA) Informations
- SCRIPT:To Display all datafiles, tempfiles and log...
- SCRIPT:To check the List of scheduled jobs
- Script:List open cursors per user
- COLD and HOT Backups in Oracle Database
- To put a database into ARCHIVELOG mode
- Basics of import/export in Oracle Database
-
▼
July
(41)
Posts
No comments:
Post a Comment