An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • Oracle White Papers
  • Disclosure
  • About

Tag: V$session

September 9, 2010February 9, 2016 Alex Lima

How to find the session and SQL statement that is not closing the ResultSet?

May 9, 2010February 9, 2016 Alex Lima

How to find SQL running for a user/sid?

May 8, 2010February 9, 2016 Alex Lima

dba_scheduler_running_jobs

May 18, 2009January 23, 2017 Alex Lima

How to find blocking session?

April 8, 2009January 23, 2017 Alex Lima

v$session osuser/program issue when sqldeveloper and oracle client installed

April 8, 2009January 23, 2017 Alex Lima

Oracle – JDBC v$session osuser/program issue

December 18, 2008January 23, 2017 Alex Lima

How to grant SELECT access to v$session to other users?

Follow Me

  • Twitter
  • LinkedIn
  • YouTube

Categories

  • 18c (2)
  • 19c (4)
  • AIX (1)
  • Archivelog (3)
  • Auditing (2)
  • AWR (10)
  • Backup (4)
  • Backup & Recovery (35)
  • Batch (1)
  • Big Data (1)
  • Built-in stored procedures (1)
  • Connections (1)
  • Control file (3)
  • Cursor (3)
  • Database (12)
  • Dataguard (4)
  • Dataguard (3)
  • Datatypes (6)
  • Date (2)
  • Docker (1)
  • exp (2)
  • Export (6)
  • Flashback (5)
  • General DBA (272)
  • Globalization (6)
  • GoldenGate (27)
  • Grant (5)
  • Initialization (4)
  • install (2)
  • Internal (4)
  • JDBC (5)
  • Jobs (4)
  • Linux (1)
  • Listener (4)
  • LOB (2)
  • Lock (3)
  • Log Miner (1)
  • mac (2)
  • Microservices (12)
  • Monitor (1)
  • MySQL (2)
  • NetApp for Oracle (2)
  • OCI (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • oradebug (9)
  • OS (2)
  • osql (1)
  • Parameters (8)
  • partition (1)
  • Password (3)
  • performance (1)
  • PL/SQL (5)
  • postgres (1)
  • Power Shell (2)
  • Primavera (3)
  • Profiler (1)
  • Project Management (3)
  • REST API (1)
  • RMAN (36)
  • role (3)
  • Scheduler (9)
  • Scripts (26)
  • Security (7)
  • sga (4)
  • Shared Pool (3)
  • Shell (15)
  • snapshot (1)
  • SQL – DDL (5)
  • SQL Developer (3)
  • SQL Server (69)
  • SQL*Plus (18)
  • SQLcl (2)
  • startup (4)
  • Statistics (14)
  • Statspack (3)
  • Table (3)
  • tablespace (2)
  • trace (32)
  • Transaction (5)
  • Tuning (35)
  • Tuning (6)
  • Undo (1)
  • Unix (33)
  • Upgrade (1)
  • vi (5)
  • windows (9)

Follow Alex's Blog

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 621 other subscribers

Twitter Updates

  • Did you know that we have a #GoldenGate community forum where users help each other with questions and solutions?… twitter.com/i/web/status/1… 4 hours ago
  • See how the team at @UCLAHealth are utilizing resources from @OracleCloud and @OracleResearch to build… twitter.com/i/web/status/1… 14 hours ago
  • Hear experts from Accenture and VMware discuss the most pressing sustainability trends and how companies can achiev… twitter.com/i/web/status/1… 14 hours ago
  • Fueled by data 🏎💨 @RedBullRacing runs billions of race simulations each weekend using @Oracle Cloud Infrastructure. social.ora.cl/6018MBsWi 15 hours ago
  • Mark your calendar for the next @OracleExadata Master Class on August 25! Oracle’s Alex Lima will explore GoldenGa… twitter.com/i/web/status/1… 1 day ago
Follow @aoflima

Recent Posts

  • GoldenGate Lifetime Support Schedule
  • Oracle MAA Never Down Series
  • Oracle Database Support Schedule
  • SQL Joins Made Easy
  • GoldenGate Microservices Initial Load Instantiation with WebUI

Top Posts

  • How to find jobs currently running or history about the jobs?
  • Oracle MAA Never Down Series
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • GoldenGate Lifetime Support Schedule
  • Oracle Database Support Schedule
  • How to see current utilization of processes/sessions and max utilization?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to create cold backup using RMAN?
  • How to grant SELECT access to v$session to other users?
  • ALTER DATABASE BEGIN/END BACKUP
Powered by WordPress.com.
 

Loading Comments...
 

You must be logged in to post a comment.