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: time

August 27, 2010February 9, 2016 Alex Lima

How to find the last time a session performed any activity?

February 7, 2010February 9, 2016 Alex Lima

SET STATISTICS

January 23, 2010February 9, 2016 Alex Lima

How to see backup history through the back-end?

May 15, 2009January 23, 2017 Alex Lima

How to extract start and end time of a job in SQL Server?

January 27, 2009January 23, 2017 Alex Lima

How to find the date when a role was created?

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 (274)
  • Globalization (6)
  • GoldenGate (30)
  • 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 (15)
  • 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 (3)
  • 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 102 other subscribers

Twitter Updates

  • DO NOT MISS THIS ONE: This is something we get questioned about all the time. Did you always want to know more abo… twitter.com/i/web/status/1… 38 minutes ago
  • Looking forward to this fantastic panel of women technology leaders, sharing insights on the best Oracle technologi… twitter.com/i/web/status/1… 4 hours ago
  • .@Oracle Key Vault’s latest update includes some exciting new features: social.ora.cl/601838S8a 🔐 Simplified key an… twitter.com/i/web/status/1… 7 hours ago
  • We have all been there. 😂 https://t.co/CySAjqOAAn 17 hours ago
  • one person followed me and one person unfollowed me // automatically checked by fllwrs.com 22 hours ago
Follow @aoflima

Recent Posts

  • Oracle GoldenGate Advantages
  • GoldenGate Automation with REST API and Python
  • Where is the TNS_ADMIN in GoldenGate Microservices 21c?
  • GoldenGate Lifetime Support Schedule
  • Oracle MAA Never Down Series

Top Posts

  • How to find jobs currently running or history about the jobs?
  • How to find the NLS_LANG to set for a database?
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to see current utilization of processes/sessions and max utilization?
  • How to lock/unlock statistics on a table?
  • How to grant SELECT access to v$session to other users?
  • How to delete archive logs already archived to backup device?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to pass host, port, SID/Service name to connect to a database?
  • How to extract the DB LINKS DDL with the password
Powered by WordPress.com.
 

Loading Comments...
 

You must be logged in to post a comment.