Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • initUOCIOTTO.ora Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • find_string_in_database.sql Oracle
  • DBMS_JOB all example Oracle
  • This is from Temi Oracle
  • How to find password change date for user Oracle
  • To see only files and/or folders using LS command Linux/Unix
  • perf_today.sql Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • New Latest Param.sql for finding all hidden parameters also Oracle
  • Oracle Metalink useful notes Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • catall.sh Linux/Unix
  • Sort with ASCII order and Numeric Order Linux/Unix
  • kill all processes from specific user in solaris. Linux/Unix

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

  • Good Link from metalink 1 Oracle
  • CPU Core related projections AWS
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
  • FGA Part-I Oracle
  • Vivek Tuning for Row Locks. Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • How to see which patches are applied. Oracle
  • Proc code Oracle
  • fuser to check who is using diretory Linux/Unix
  • Implementation of key based authentications Linux/Unix
  • Some OS level threshold for performance. Linux/Unix
  • chk_space_SID.ksh Linux/Unix
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme