Database Administrators

Questions tagged [recompile]

Ask Question

The tag has no usage guidance.

9 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
0answers
38 views

Pull out top stored procs with high recompile rate

Is there any other easy way other than running profiler that I can pull out the worst offending stored procs with high recompiles? Any helpful DMVs?
1
vote
2answers
45 views

Why does this stored proc cause a clustered index scan, but seek when using OPTION RECOMPILE?

I think I may know the answer based on my research, but am looking for confirmation on how/why the engine compiles the plan the way it does with Parameters being passed in: @ID int ,@OtherID INT ...
1
vote
2answers
78 views

Is it normal to UPDATE STATISTICS this frequently? [duplicate]

I have a stored procedure that processes data from a source table and is executed many times (about 20,000 executions) throughout the day. I believe it's getting choked up sometimes, due to parameter ...
3
votes
1answer
94 views

Parameterized Plan Flushed

I cannot find documentation anywhere on what would trigger this recompilation reason. We are investigating a sudden query performance drop and the only thing that I can think of is that the plan got ...
0
votes
1answer
707 views

utlrp.sql fails to execute

I just created a docker image of Oracle 11g ee following this tutorial https://vitalflux.com/how-to-install-oracle-11g-ee-on-docker/ and loaded some tables inside. The process worked fine and no ...
1
vote
1answer
86 views

RECOMPILE function

We had a production level event over the weekend where execution of a function suddenly went from MS to nearly a minute. Unfortunately, SQL wasn't able to execute the ALTER Function and it kept '...
0
votes
2answers
196 views

Compile Dynamic Sql before Running

I have a table, and want to test if dynamic sql will compile. Example: create Table dbo.Product ( ProductId int, ProductName varchar(255) ) This will succeed: Column Name exists declare ...
1
vote
2answers
76 views

SQL Server Execution Plan on server level

Case: I have application which is doing search from database. That is going very slowly (more than 40 seconds). With trace I caught a query. When I run query in SSMS, it takes 2-3 seconds, but when I ...
0
votes
0answers
2k views

Oracle XML Database database invalid, how to validate/recompile … can i drop and recreate it. Please suggest

The installed components and their status, Oracle Database Catalog Views 12.1.0.2.0 Valid Oracle Database Packages and Types 12.1.0.2.0 Valid Oracle XML Database 12.1.0.2.0 ...