Hello!
I have a particular ETL job that fires below 4 select queries on a view definition to our Oracle database -
select * from view where mod(id,4) = 1;
select * from view where mod(id,4) = 2;
select * from view where mod(id,4) = 3;
select * from view where mod(id,4) = 0;
However when the queries start executing and I check v$session for the 4 sessions running these 4 queries, I see a common sql id showing up for all these 4 queries and the sql text for this sql id seems completely unfamiliar/unrelated to the queries that are actually being executed. So I am a bit lost as I have not come across such scenario earlier. What could this sql id be and why would it be showing up in v$session for all 4 different queries?