User eckes

1 vote

1 answer

533 views

Oracle 12.2 shows high parse per execution ratio for unknown lob$ query

asked Jul 3, 2019 at 13:18

2 votes

1 answer

421 views

Oracle DISTINCT with NULLable columns

asked Sep 16, 2019 at 15:23

8 votes

2 answers

385 views

Why does this seek on BIGINT col have extra constant scan, compute scalar, and nested loops operators?

asked Feb 18, 2017 at 22:11

0 votes

1 answer

145 views

Does psql \dt cache schema?

asked Sep 5, 2018 at 11:01

1 vote

1 answer

750 views

Permissions for runtime user on all objects in schema (including future objects)

asked Aug 2, 2018 at 21:42

0 votes

1 answer

346 views

Golden Gate activity auditing with SQL?

asked Oct 26, 2017 at 8:28

0 votes

0 answers

33 views

Increased rate of bad plans (Oracle ACS)

asked Jul 10, 2018 at 7:14

3 votes

1 answer

132 views

Does SQL Server use (unused)index stats for optimizer

asked May 13, 2018 at 23:13

1 vote

2 answers

3k views

Finding extents of Oracle BIN$ segments

asked Nov 9, 2017 at 2:39

1 vote

0 answers

113 views

Wasted space for compressed SecureFile LOBs?

asked Aug 12, 2017 at 2:20

Stack Exchange Network

10 Questions

Oracle 12.2 shows high parse per execution ratio for unknown lob$ query

Oracle DISTINCT with NULLable columns

Why does this seek on BIGINT col have extra constant scan, compute scalar, and nested loops operators?

Does psql \dt cache schema?

Permissions for runtime user on all objects in schema (including future objects)

Golden Gate activity auditing with SQL?

Increased rate of bad plans (Oracle ACS)

Does SQL Server use (unused)index stats for optimizer

Finding extents of Oracle BIN$ segments

Wasted space for compressed SecureFile LOBs?