An Oracle Spin by Alex Lima

Sharing My Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • 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?

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

Join 491 other followers

Categories

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

Visit us at:

Follow Us

  • Twitter
  • LinkedIn

Twitter Updates

  • Love it.. congrats @MensahTamStock , whatttaaa attitude.. you will go far. twitter.com/KPRC2/status/1… 20 hours ago
  • RT @NikkiMcR: Greg Gutfeld rants that American medalists who protest at the Olympics are just "ungrateful brats" and not actually that good… 1 day ago
  • Michael Phelps Unintentionally Raises Marfan Syndrome Awareness fxn.ws/1xmWzAh #FoxNews 1 week ago
  • RT @OracleCloud: .@SierraWireless is an #IoT pioneer. Join us on July 29 to learn how the company empowers businesses to transform and thri… 1 week ago
  • RT @BIASCORP: Explore new opportunities for a fulfilling and innovative career! Discover our open positions globally and learn more about w… 1 week ago
Follow @aoflima

Recent Posts

  • SQL Developer fixed for MacOS Big Sur 11.4
  • Oracle Release Roadmap
  • Postgres – how to find JDBC driver version
  • OGG-01264 cm_mbuf_hdrs_copyout()
  • Oracle Database 19c EE on Docker

Top Posts

  • How to find jobs currently running or history about the jobs?
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to find the NLS_LANG to set for a database?
  • How to see current utilization of processes/sessions and max utilization?
  • How to lock/unlock statistics on a table?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to find row that has non-numeric value in a character column?
  • How to grant SELECT access to v$session to other users?
  • How to extract the DB LINKS DDL with the password
  • ALTER DATABASE BEGIN/END BACKUP
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy