Show all connected users
set lines 100 pages 999 col ID format a15 select username , sid || ',' || serial# "ID" , status , last_call_et "Last Activity" from v$session where username is not null order by status desc , las[...]
Ask TEM Dba
Oracle DBA Tips Corner
-
About
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
more →
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...] -
Tags Cloud
Delete the 500 oldest files 10.2.0.4 Upgrade with DataGuard Mesure redo-log FlashBack Les annulations sur Oracle UNDO management Killing Oracle Sessions memory Hit Miss Ratios Recycle bin Reset/Unset a spfile parameter oracle non-default parameters database startup time Recreating Online Redo Log Redo Log Resizing connected users Sessions sorted open cursors java installed in the database largest objects in the database user info os pid Find large files Linux Initialization Parameter SPFILE PFILE Create Read only user for a Schema Oracle 10g Data Guard Windows and UNIX servers ORA-01940: Cannot drop a user that is currently connected Compare table structure in oracle Find Invalid Synonyms Find Full Table Scans Instance Background Processes Information Comparing Contents of Two Tables with Identical Structure database B14239-04 TEMPORARY tablespace Linux Top Command oracle 10g RAC administration Oracle Database Administration Fundamentals find free space in a TEMPORARY tablespace free size temp tablespace Oracle Data Guard Concepts and Administration 10g Release 2 orafaq Oracle 10g Create a Physical Standby Database
dba- Ask TEM Dba
- How to Use DVSYS.DBMS_MACADM procedures to Prohibit Data Access to Users
- How to Drop and Recreate the DB Control Repository
- Exploring the Oracle Database Architecture
- Error 1044 in MySQL: Access denied when using LOCK TABLES
- ORA-08102: index key not found, obj# … Solution to resolve
- Freeing up db_recovery_file_dest reclaimable space.
- Cannot export empty tables in 11.2
- Automatic Workload Repository (AWR) in Oracle Database 10g
- A Unix/Linux “find” Command Tutorial
- Upgrade an Oracle Instance 10.2.0.3 to 10.2.0.4
Ratings
- Les annulations sur Oracle (> 9i)
(0.00 out of 5) - How do I Use the Linux Top Command? (0.00 out of 5)
- How do I find used/free space in a TEMPORARY tablespace? (0.00 out of 5)
- Oracle 10g – Manually Create a Physical Standby Database Using Data Guard (0.00 out of 5)
- Create Read only user for a Schema (0.00 out of 5)
- ORA-01940: Cannot drop a user that is currently connected (0.00 out of 5)
- Compare table structure in oracle (0.00 out of 5)
- Comparing Contents of Two Tables with Identical Structure (0.00 out of 5)
- Instance Background Processes Information (0.00 out of 5)
- Find Full Table Scans (0.00 out of 5)