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!

need help with the query

curious_mindDec 11 2020

Hi All,
I have a below query which i am using to do the manual mock up of data as i have to go through the Performance test.
select distinct C.eods_grp_id,'DMU_1' PRTT_CDE,(select face_prfl_id from seods02.face_prfl
where face_prfl_id not in
(select face_prfl_id from seods02.grp_face_prfl)
and rownum=1)
from GRP C
where eods_grp_id not in (select eods_grp_id from grp_face_prfl);

here i basically have to mock up the table called grp_face_prfl where the primary key is on the columns EODS_GRP_ID,FACE_PRFL_ID,PRTT_CDE
I am getting EODS_GRP_CDE,PRTT_CDE from GRP which is fine but to get FACE_PRFL_ID i have another table which is in the inner query of the select statement. unfortunately there is no join between FACE_PRFL & GRP table and hence i am writing select statement like this:
I am getting below output from my query where the value of face_prfl_id is not changing with every row:
eods_grp_id prtt_cde face_prfl_id
35016657 DMU_1 5654808
35016807 DMU_1 5654808
35016821 DMU_1 5654808

Please help how i can get the distinct value for the face_prfl_id for every row:

Comments

843798
The is no guarantee how much, when or why the VM allocates and/or frees memory. In some cases, the VM might reserve memory as 'used' even though the objects occupying that memory have been freed. The only real metric is to go through by hand and calculate the size. freeMemory() is really only good for getting a general idea of resource usage.
843798
But how can you measure the memory usage by hand? Java isn't very helpful for this. You can have a educated guess about the size of the basic types, but in the end you're guaranteed nothing. And for non trivial object types the things become much harder. The only way to work out the size of a complex structure I found so far was to have a big array full of these objects and use the method I have described above to measure the total memory usage.
1 - 2

Post Details

Added on Dec 11 2020
2 comments
130 views