Questions tagged [recompile]
The recompile tag has no usage guidance.
7
questions
3
votes
1answer
79 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
217 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 ...
0
votes
1answer
59 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
89 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
68 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
833 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 ...
0
votes
0answers
139 views
Deferred Compile Event Subclass Meaning in SQL Profiler?
While tracing excessive recompilation (SQL:StmtRecompile) I found the main cause of it is 'Deferred Compile" as a event subclass. It is explained this way.
Deferred compile occurs if an object ...
