Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Aggregating data

user572405Nov 18 2010 — edited Nov 19 2010
I have a table like this :
 Day, Qty
 10, 1
 11, 1
 12, 1
 13, 1
 14, 1
The output that I need to create is a summary data like:
 Day_List, Qty
  10,       1
  11,       1
  12,       1
  13,       1
  14,       1
  10_11,    2
  11_12,    2
  12_13,    2
  13_14,    2
  10_11_12, 3
  11_12_13, 3
  12_13_14, 3
The aggregate data will comprise for any 2 or 3 consecutive days. Thank you,

Kumar

Comments

Frank Nimphius-Oracle
Hi,

first of all, 11.1.1.2 is quite all and you should consider upgrading to a more recent version, which in your case currently is 11.1.1.6. In regards to the temporary files, it depends on what these are. If the files are of not interest (e.g. logs you don't need) then I suggest to setup a job that deletes the files frequently. If the files are logs and only grow because the logging is too fine grain then change the log level for your applications. Dependent on the number of users your run on this systems, 8 GB is not much disk space

Frank
891682
Thanks for Replying Frank,
In C Drive total Space is 80GB.But Right now Any Solution is there How to fix the issue.

Please help me..

Thanks
Anup
Timo Hahn
Search for *.log files in Middleware folder and its sub folders. The log files can be removed. Next time you start jdev the one needed are created again. This it what Frank meant by setup a job which cleans the the directory periodically.
Next check where your workspaces are created. They may end up somewhere in the Middleware folder as well and workspaces consume some memory (e.g. for the classes and deployment folders).

Timo
891682
Hi Timo,
I have searched log file in the middleware folder there is 60KB space is there.And My application is in E Drive.Deployement i have also moved the folder .
But i am thinking that how the middleware size is 38GB its imjagine..

Plz help me..

Thanks
Anup
Timo Hahn
Have you searched in the sub folders too? I don't believe that there is no other log file.
However, as we can't see what's inside your Middleware folder it'S hard to help. My Middleware folder is <2GB!
Get yourself a tool like treesize and find out which directory (file) consumes the most memory. Then report back, as we then may know what's wrong.

Timo
891682
Hi Timo,
I have checked folder wise but in C:\Oracle\Middleware\jdeveloper size is 37GB.So how the file is bigger.
Plz help me..

Thanks
Anup
Timo Hahn
C:\Oracle\Middleware\jdeveloper is a folder!
open the folder and dig deeper!

Timo
891682
Hi Timo,
I have seen that C:\Oracle\Middleware\jdeveloper\jdev\bin inside this folder so many created java_pid268.hprof file and approx 56 File this type is there.and that file size is 36GB taking Space.
So i want to know Can i delete the .hprof file.?

Please help me..

Thanks
Anup
Timo Hahn
'.hprof' files are normally thread dumps which you can delete. Question is why do you have them at all?
Do you use/run memory or cpu profiling sessions?
Check the creation time of the files. Are they from a current date? Are thy old?
Again, You can delete them for now, but you should keep an eye on this.

Timo
891682
Thanks Timo,
I have deleted hprof file.So it was taking more space.

Thanks
Anup
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2010
Added on Nov 18 2010
4 comments
395 views