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 / gogune suresh kumar
For DDL operations query user_objects table.
For DML you need to create a trigger for that.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is fill factor? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
when does an alert gets signaled?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Why would you use sql agent? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
How to start SQL Server in minimal configuration mode?
which background process invoke at the time of upgradation tell me???
how can you implement fine-grained auditing?
What are the different sql server versions you have worked on? : sql server DBA
what is the diffrence between core dba and apps dba?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?