SELECT CURRENT_SCN FROM V$DATABASE; To get the current SCN SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL 1.1 ORA_ROWSCN Is a pseudocolumn of any table that is not fixed or external. It represents the SCN of the most recent change to a given row, that is, the latest COMMIT operation for the row. For example: SELECT ora_rowscn, last_name, [...]
Tech Blog
Blog Stats
- 56,060 hits
Tea Break
Blog Post History
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Apr | ||||||
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |
Oracle Blogs
Oracle Documentation
UNIX/LINUX
Categories
- Backup and Recovery (11)
- Business Intelligence (1)
- Data Dictionary (7)
- Dictionary Tables (2)
- Performance Views (1)
- Data Storage (1)
- DBA Tasks and Interview Stuff (1)
- Hardware (1)
- oracle (1)
- Oracle Architecture (23)
- Initialization parameters (5)
- Memory Architecture (4)
- Oracle Memory (3)
- Process Architecture (3)
- SGA (2)
- Storage Architecture (11)
- Tablespaces (3)
- Oracle Concepts (2)
- Oracle DBA (2)
- Oracle Installation Creation Configuration (2)
- Oracle Issues (3)
- Oracle Network (4)
- Listener (2)
- Oracle TNS (2)
- Oracle SQL (9)
- Dynamic SQL (1)
- SQL Functions (1)
- String Functions (1)
- SQL Hints (1)
- Table SQL (2)
- Oracle Tools (1)
- Oracle Utilities (6)
- Performance Monitoring and Maintenance (1)
- Performance Tuning (14)
- SQL Optimization (5)
- SQL Joins (1)
- STATISTICS (1)
- SQL Optimization (5)
- PL SQL (6)
- Functions (1)
- Packages (2)
- Procedures (2)
- Portals (1)
- Schema Objects (10)
- Security (4)
- Privileges (1)
- Table (1)
- Users (2)
- SQL Server (3)
- Streams (1)
- Uncategorized (5)
- UNIX (7)
- AWK and SED (2)
- Utilities (3)
- Windows Utilities (1)
Category Cloud
Backup and Recovery Data Dictionary Indexes Initialization parameters Listener Logical Backup Export Import Memory Architecture Oracle Architecture Oracle DBA Oracle Issues Oracle Memory Oracle Network Oracle SQL Oracle TNS Oracle Utilities Performance Tuning PL SQL Process Architecture RMAN backup and recovery Schema Objects SGA SQL Optimization SQL Server Storage Architecture Tables Tablespaces Table SQL Uncategorized UNIX Utilities
Blog at WordPress.com. Theme: Spring Loaded by the449.
