Skip to content
Rodgers Notes
Rodger Lepinsky, Database Expert, Data Analyst, Data Scientist.
  • Data Modeling
    • testpage_4
  • Database Tuning
  • Database Administration
  • Blog
  • Contact
    • About Rodger Lepinsky

Category: Oracle DBA Subjects

Notes on DEPTREE

January 5, 2012 Rodgers Notes Writer 2 Comments

Notes on Oracle’s solution to find object dependencies, DEPTREE. Written in 1991, and still included on installation.

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: All_Dependencies, Analysis, DEPTREE, Power Scripts, Scripts

Script To List Objects That Won’t Extend

April 19, 2011 Rodgers Notes Writer Leave a comment

Oracle DBA Script To List Objects That Won’t Extend Due to lack of space.

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: Power Scripts, Scripts

DBA Script: How Full Are The Tablespaces?

Rodgers Notes Writer Leave a comment

A useful script to show how full the tablespaces are. I’ve used it many times!

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: Power Scripts, Scripts

Big Advances In Oracle Data Storage

October 20, 2010 Rodgers Notes Writer Leave a comment

Recently I went to see an Oracle presentation on storage.  Since they have bought Sun, they have been doing some…

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: Oracle Data Storage

Script to List Tables With No Foreign Keys

September 19, 2010 Rodgers Notes Writer Leave a comment

Here is an Oracle script to find the tables that don’t have any foreign keys.
Tables that are neither a parent table, or a child table.

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: Database Design Mistakes to Avoid, Oracle DBA, Scripts
  • Architecture
  • Cartesian Products
  • Data Science
  • Database Design Mistakes to Avoid
  • Design
  • Graph Database
  • Humour
  • Oracle Applications
  • Oracle DBA Subjects
  • Power Scripts
  • Quality
  • R
  • Reviews
  • Science
  • Security
  • SQL
  • SQL Server
  • Tuning
  • Uncategorized
  • Uniface
  • Unix and Linux
  • Windows
Copyright © 2025 Rodgers Notes — Velux WordPress theme by GoDaddy