Ygthkb

XOR-free sets: Maximum density?

Identical projects by students at two different colleges: still plagiarism?

Specific list manipulation

How to align the top of the text with the top of a figure produced by tikz in minipage

Can I travel from country A to country B to country C without going back to country A?

Possible issue with my W4 and tax return

How can I take a waterfall's effect on a jump into consideration mechanically?

Critique vs nitpicking

Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?

Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?

Insecure private-key encryption

How do I avoid the "chosen hero" feeling?

Is it possible to detect 100% of SQLi with a simple regex?

How bad is a Computer Science course that doesn't teach Design Patterns?

Is the fingering of thirds flexible or do I have to follow the rules?

Why did Luke use his left hand to shoot?

Why might frozen potatoes require a hechsher?

When using Volatility with a memory image, what is the Kernel version?

Is Screenshot Time-tracking Common?

Why are mages sometimes played bot instead of traditional ADCs?

What are some ways of extending a description of a scenery?

What does an unprocessed RAW file look like?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Why do neural networks need so many examples to perform?

Trying to find out what a specific running statement is (Oracle)

How do you show SQL executing on an Oracle database?What are the real life cases for using Oracle advanced queuing?Why I don't need to COMMIT in database trigger?Insert into table from a query to a linked database hangsHow can I find out which tables use reference partitioning from the Oracle data dictionary?Is it good practice to check for existence of records before deleting themInsert with different key values to avoid contraint violationSlow running Oracle query caused by unnecessary full table scanCall trigger during SQL Loader insertneed to get data from Global Temp Table from db1 to db2 and show the data in Oracle formHow do I copy a schema for an instance of Oracle running in a Docker container?

0

I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:

How do you show sql executing on an oracle database

It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.

I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)

I have also executed the script referenced in this post:

How to see the actual Oracle SQL statement that is being executed

And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.

oracle

share

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:

How do you show sql executing on an oracle database

It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.

I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)

I have also executed the script referenced in this post:

How to see the actual Oracle SQL statement that is being executed

And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.

oracle

share

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:

How do you show sql executing on an oracle database

It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.

I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)

I have also executed the script referenced in this post:

How to see the actual Oracle SQL statement that is being executed

And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.

oracle

share

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

RocksaltRocksalt

11

New contributor

Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

RocksaltRocksalt

11