Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No DDL in V$SQL

Justin BleisteinDec 27 2017 — edited Jan 10 2018

I read a thread on ask tom once where he said that starting in oracle version 10g, DDL was included in v$sql. I don't see it on my 11g or 12c dbs. All of my DML is in V$SQL when I search via the SQL_TEXT column but not my DDL. I also checked via COMMAND_TYPE like 1 for CREATE TABLE and it still doesn't show up. Is it incorrect that DDL is visible via V$SQL? Is DDL just not shareable and that's why? I do however see my statement in V$DB_OBJECT_CACHE view.

Thanks,

---Justin

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2018
Added on Dec 27 2017
33 comments
2,415 views