hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table
Answer Posted / naga bandaru
we should go with log minor or streams to find when DML
operation have been performed.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How would you go about verifying the network name that the local_listener is currently using?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How would you extract DDL of a table without using a GUI tool?
what is a crs resource?
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How do you trace the traffic hitting a sql server? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the steps you will take to improve performance of a poor performing query?
how can a session indicate its interest in receiving alerts?