Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [scan]

The tag has no usage guidance.

0
votes
1answer
134 views

Very high (99%) insertion cost in estimated execution plan

I have four tables with 500,000 to 4,000,000 rows. The script joins them and insert into a temporary table with some where clause. It is taking long. The execution plan shows 99% cost only for the ...
0
votes
2answers
59 views

DB2 huge IREF and lots of scans

I received a task from one of my colleagues to check why he always receives high CPU load alerts. I don't have too much experience with databases and I need some clarifications. I created a script to ...
2
votes
1answer
62 views

Vulnerability in Server from SQL Server 2008 R2

We scanned our systems and got a high vulnerability reported in a server. One of the thing that got flagged was MS12-060, which is related to MS Office 2003 Web Components that gets installed along ...
3
votes
1answer
461 views

Number of full table scans

I would like to see information on how many times has a table been fully scanned. I was hoping for something like sys.dm_db_index_usage_stats but for table scans. There is a method described at the ...
1
vote
1answer
754 views

Bitmap Heapscan is slow

I have 2 tables: mailings and form_responses. The form_responses table has a foreign key with the mailings table, so a mailing has one-to-many form_responses. What I want to do is calculate mailing ...
0
votes
1answer
224 views

Delete cascade produce scan intead of index seek

I have two tables in my database. TableA : 1427877 rows TableB : 339939000 rows TableB has a foreignkey column in TableB (TableB.foreignId). It has Delete On Cascade ON. The problem is when I ...
7
votes
1answer
334 views

STATISTICS IO for parallel index scan

Assume that there is a table with clustered index create table [a_table] ([key] binary(900) unique clustered); and some data insert into [a_table] ([key]) select top (1000000) row_number() over (...
1
vote
0answers
818 views

Performance issue in 12c - Additional Full table scan after index range scan

I am trying to improve the performance of a procedure which we recently moved from 11g to 12c. I am simply using a refcursor which gets the result set from an underlying query. In 12c I am having a ...
0
votes
1answer
1k views

Oracle - Scan listener and multiple databases

I have a two node RAC database server hosting 8 databases. I have 3 scan listeners running. 2 in node 1 and one in the 2nd node. All the 8 databases are running for different applications. Are these ...
0
votes
1answer
4k views

Connect to Oracle RAC from SQL Developer?

We have set up RAC database on server. We can connect to database from sqlplus on the server using SCAN address. However, if I try to connect to RAC using SQL developer from client machine using SCAN ...
1
vote
1answer
3k views

SCAN listener redirects connection to another port

I have setup RAC. I have two listeners LISTENER and LISTENER_DG. LISTENER is listening port 1521 LISTENER_DG is listening 1530 When client connects to the database using SHARED connection mode even ...