On Jul 4, 7:32 pm, Niraj Parihar <parihar.nirajsi...@gmail.com> wrote: > Hi > I need a help in one case , if suppose i am performing data migration and > if suppose i want to check how many rows have been inserted in last hour or > so so is there a query which will be able to find it out, basically i wanted > to know the rate of record insertion. > *-- > Thanks and Regards, > Niraj Singh Parihar > Mobile Number : +918007250962.*
You can create a copy of USER_TAB_MODIFICATIONS adding a PROCESS_DT Column then populate that table with the current data from USER_TAB_MODIFICATIONS; in the next hour you can add data for the current run, then query the difference between the two with LAG() to get your per-hour insert totals. I tried using flashback query but failed with an "ORA-01466: unable to read data - table definition has changed" error (using 10gR2) but you could also try that (it uses the 'AS OF [TIMESTAMP|SCN] ...' syntax) and attempt to return the difference that way. Presuming you're on a current release of Oracle the tables should be monitored so USER_TAB_MODIFICATIONS will be populated. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
