Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Guide to Linux System Command Mastery Linux/Unix
  • Recovering lost SYS password Oracle
  • Find sort details from Db find_sort.sql Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • Kill a session dynanically using execute immediate Oracle
  • Proc code Oracle
  • My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
  • find the files that are 1 day old. Linux/Unix
  • Processes Parameter decision Oracle
  • My Test Case On 21-OCT-2005 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

  • DBMS_Shared_pool pinning triggers Oracle
  • sql_plan9i.sql Oracle
  • plan10g.sql good1 Oracle
  • Implementing Listener Security Oracle
  • plan10g.sql good 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

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (402)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026
  • Creating a Container Database using dbaascli08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • DBMS_UTILITY PACKAGE Oracle
  • Absolute file number and relative file number Oracle
  • Oracle Identifiers Oracle
  • sid_wise_sql.sql Further explaination Oracle
  • Rman Notes -1 Oracle
  • logminer and my_lbu Oracle
  • Check SQL Server edition SQL Server
  • get_vmstat_linux Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme