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 [recompile]

The tag has no usage guidance.

0
votes
1answer
42 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
45 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
62 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
64 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 ...
1
vote
0answers
244 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
58 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 ...