Monday, September 26, 2016

DATABASE INFORMATION NOTES

 

Database Information

DATABASE INFORMATION NOTES:


  • Database Name - Name of the database
  • Created - Date/time the database was created
  • Log Mode - Archive log mode: NOARCHIVELOG or ARCHIVELOG
  • Checkpoint Change# - Last SCN checkpointed
  • Archive Change# - Last SCN archived

    select  NAME,
 CREATED,
 LOG_MODE,
 CHECKPOINT_CHANGE#,
 ARCHIVE_CHANGE#
from  v$database
    • By -
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    How To Fix Hive – Partition Table Query Failed When Stored As Parquet

    This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...