Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Paste command syntax Linux/Unix
  • Histogram Overview Oracle
  • Composite Index creation tip from Vivek Oracle
  • find_pk.sql /* Find Primary Key */ Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Virtual Indexes in Oracle Oracle
  • scp with ssh2 Linux/Unix
  • Very Good Oralce Internal Tuning Book Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • xargs use Linux/Unix
  • Goog notes on X$ tables Oracle
  • Some useful Unix Commands Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • Giving Grant on v$DATABASE Oracle
  • EXTPROC Oracle

V$CONTROLFILE_RECORD_SECTION reference notes.

Posted on 02-Jul-2008 By Admin No Comments on V$CONTROLFILE_RECORD_SECTION reference notes.

TYPE

VARCHAR2(17)

Identifies the type of record section: DATABASE, CKPT PROGRESS, REDO THREAD, REDO LOG, DATAFILE, FILENAME, TABLESPACE, LOG HISTORY, OFFLINE RANGE, ARCHIVED LOG, BACKUP SET, BACKUP PIECE, BACKUP DATAFILE, BACKUP REDOLOG, DATAFILE COPY, BACKUP CORRUPTION, COPY CORRUPTION, DELETED OBJECT, or PROXY COPY

RECORD_SIZE

NUMBER

Record size in bytes

RECORDS_TOTAL

NUMBER

Number of records allocated for the section

RECORDS_USED

NUMBER

Number of records used in the section

FIRST_INDEX

NUMBER

Index (position) of the first record

LAST_INDEX

NUMBER

Index of the last record

LAST_RECID

NUMBER

Record ID of the last record

Oracle, SQL scripts

Post navigation

Previous Post: metalink all dynamic view reference notes.
Next Post: UTL_FILE test program

Related Posts

  • Export Oracle data and Compress at same time Oracle
  • VIvek Encryption Package and Its Usage Oracle
  • lck.sql Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • find_longsql.sql Oracle
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Find All internal Parameters Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • cold backup scripts to copy locally Linux/Unix
  • currwait.sql Oracle
  • how to find OS block size Oracle
  • Configure ssh authentications for RAC Oracle
  • move_arch_files.ksh /* Good One */ Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme