column
select inst_id,opname, totalwork, sofar, time_remaining from gv$session_longops where totalwork > sofar order by time_remaining;
Parm Patram
Oracle, Linux and UNIX tips, tricks and stuff
-
RMAN, SQL & PL/SQL, SQLPLUS 08-10-2011
Posted by admin @ 8:59 am
-
Category:
- Administration
- APPS
- Articles
- Backup & Recovery
- Certification
- Configuration
- DATABASE STRUCTURE
- DATAGUARD
- Documentation
- EBS
- Enterprise Manager
- FLASHBACK
- HACKING
- HEADS UP
- Installation
- JDeveloper
- Linux
- Monitoring
- MQ
- NFS
- NXclient/server
- Online Resources
- PERL
- python
- RMAN
- Routing & Switching
- SAN – NAS
- Scripts
- Serial-Parallel-Port-Testers
- SNMP
- Software
- Solaris
- Spiritual
- SQL & PL/SQL
- SQLPLUS
- Startup/Shutdown
- Streams
- Tuning
- Version Control
- Vertias
- VMWare
- VNC
- Windows XP
- ZFS
