Tag: performance

Using Oracle’s Lock-Free Reservable Columns with GoldenGate

Using Oracle’s Lock-Free Reservable Columns with GoldenGate

Oracle's lock-free reservations, introduced in version 23c, address the issue of concurrent transaction blocking when updating specific columns. This functionality allows multiple transactions to modify the same row without traditional locking mechanisms. Here's a breakdown of how it works: Reservable Columns: You designate specific numeric columns within a table as "reservable." These columns are typically used … Continue reading Using Oracle’s Lock-Free Reservable Columns with GoldenGate →

Example of bulk collect and performance using different values of limit

Sample code that shows using BULK COLLECT and performance of using different values for LIMIT. declare cursor l_cur is select * from scott.emp; type emp_tbl is table of l_cur%rowtype index by pls_integer; l_emp emp_tbl; limit_in number; i number; begin limit_in := &limit_param; open l_cur; loop fetch l_cur bulk collect into l_emp limit limit_in; for i … Continue reading Example of bulk collect and performance using different values of limit →

How to find the IO stats of filesystem?

Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So using this SQL one can find physical read and write on a filesystem. Note: The data reported is since the database started. SQL> column filesystem format a40 SQL> SELECT substr(vdf.name, 1, instr(vdf.name, '/', -1)) filesystem, … Continue reading How to find the IO stats of filesystem? →