Skip to Main Content

SQL & PL/SQL

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!

Query to find out rows deleted from a table

ORA_AJDec 8 2009 — edited Oct 19 2010
Hi

Suppose i have a table with a sequence i.e its an header table containing GRN nos.Now suppose someone has deleted some of serials from it like i am having 1,2,4,5,6 etc 3 is missing.Now what will be the query to find out what are the serials that are missed out in the table.


--Ajay Sharma

Comments

User13342426-Oracle

Would be great if you could validate/test & showcase the SPARC T7-1 performance advantage over an IBM Power8 system with same # of cores like an E850 32-core or even Power E870 system. Ive seen sizings done by the Flexcube folks recently for a banking customer that shows that SPARC M7 @ 4.13GHz has superior performance/core than Power8 @ 4.19GHz!

Randal-Oracle

Would be great if you could validate/test & showcase the SPARC T7-1 performance advantage over an IBM Power8 system with same # of cores like an E850 32-core or even Power E870 system. Ive seen sizings done by the Flexcube folks recently for a banking customer that shows that SPARC M7 @ 4.13GHz has superior performance/core than Power8 @ 4.19GHz!

You are not the first to ask for this. Nor will you be the last.  I have been asking for access to IBM Power8 systems to tune and run FLEXCUBE workloads for years to publish comparisons. Especially given that I see the same anecdotal evidence you mention.  I also have been pushing to publish relative sizing from the sizing team.  If I get approval, I will author an article. Finally, if you know where we can get access to Power8 for a while to run the FLEXCUBE workloads, let me know offline, I'm sure I can find resources to setup, tune and run FLEXCUBE workloads against it.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 16 2010
Added on Dec 8 2009
9 comments
18,895 views