Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • kill all processes from specific user in solaris. Linux/Unix
  • dbinv.sql Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
  • Oracle 10g for solaris 10 Oracle
  • chk_space_SID.ksh Linux/Unix
  • checking connectivity between two servers Linux/Unix
  • Implementing Listener Security Oracle
  • RAC 11g with vmware Oracle
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • backspace in SQL Plus not working then..? Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • note id 373303.1 Linux/Unix
  • refre.sql Oracle
  • Mutating Table Error while using database trigger 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

  • Find Stale DR Physical Standby Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • This is from Temi Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • Good Site for Oracle Internals Oracle
  • pvm_metric.sql for gathering report from vmstat tables 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
  • newupload.html PHP/MYSQL/Wordpress
  • Roles and Stored Object behaviour Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • ipcs -l Linux/Unix
  • DBMS_SQL for alter session. Oracle
  • Add new columns in dataframe Python/PySpark
  • replace alphabets using sed Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme