 |
|
|
When I almost........
Posted on : 18 - January - 2005
|
SQL> sortsize
TABLESPACE_NAME totalsize used free maxused
------------------------------- ---------------- ---------------- ---------------- ----------------
TEMP 46,293,581,824 40,479,227,904 5,814,353,920 46,293,581,824
TEMP_OM 2,096,103,424 861,929,472 1,234,173,952 1,296,039,936
TEMP_APPLPROC 2,096,103,424 49,283,072 2,046,820,352 1,817,182,208
3 rows selected.
SQL> @psort
SID USERNAME MODULE CONTENTS SEGTYPE TABLESPACE size
------ --------------- --------------- --------- --------- --------------- ----------------
159 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
161 APPS MWAJDBC TEMPORARY SORT TEMP 103,809,024
178 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
186 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
187 APPS MWAJDBC TEMPORARY SORT TEMP 408,944,640
194 APPS MWAJDBC TEMPORARY SORT TEMP 396,361,728
208 APPS MWAJDBC TEMPORARY SORT TEMP 20,971,520
210 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
222 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
1367 APPS MWAJDBC TEMPORARY SORT TEMP 16,777,216
1385 APPS POXPOVPO TEMPORARY HASH TEMP 174,063,616
1385 APPS POXPOVPO TEMPORARY SORT TEMP 44,040,192
1475 APPS_OM ASOCUORD TEMPORARY HASH TEMP_OM 393,216,000
1834 APPS XXATLPLT TEMPORARY SORT TEMP 18,874,368
2132 APPS oracle.apps.pos TEMPORARY SORT TEMP 114,294,784
.isp.server.Pos
HPageAM
2195 APPS MWAJDBC TEMPORARY SORT TEMP 48,234,496
2607 APPS oracle.apps.pos TEMPORARY SORT TEMP 114,294,784
.isp.server.Pos
HPageAM
3031 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
3266 APPS oracle.apps.pos TEMPORARY SORT TEMP 114,294,784
.isp.server.Pos
HPageAM
3368 APPS WSHFRREL TEMPORARY HASH TEMP 1,030,750,208
3587 APPS MWAJDBC TEMPORARY SORT TEMP 87,031,808
3690 M00431338 PL/SQL TEMPORARY HASH TEMP 28,311,552
Developer
3926 APPLPROC T.O.A.D. TEMPORARY SORT TEMP_APPLPROC 19,922,944
4021 APPS ASOCUORD TEMPORARY SORT TEMP 18,874,368
4099 APPS QLTRSINF TEMPORARY SORT TEMP 15,728,640
4100 APPS_OM ASOCUORD TEMPORARY HASH TEMP_OM 187,695,104
4406 APPS T.O.A.D. TEMPORARY HASH TEMP 19,964,887,040
5044 APPS POXRQVRQ TEMPORARY HASH TEMP 109,051,904
5119 APPS QLTRSINF TEMPORARY SORT TEMP 15,728,640
5165 APPS TEMPORARY SORT TEMP 41,943,040
5220 APPS MWAJDBC TEMPORARY SORT TEMP 198,180,864
5657 M00431338 PL/SQL TEMPORARY SORT TEMP 38,797,312
Developer
6407 APPS TEMPORARY SORT TEMP 33,554,432
6451 APPS APXINWKB TEMPORARY HASH TEMP 2,584,739,840
6451 APPS APXINWKB TEMPORARY SORT TEMP 422,576,128
6602 APPS WSHFSTRX TEMPORARY SORT TEMP 1,606,418,432
36 rows selected.
SQL> @sessinfo
Please enter the value for Sid if known : 4406
Please enter the value for terminal if known :
Please enter the machine name if known :
Please enter the value for Client Process if known :
Please enter the value for Server Process if known :
Please enter the value for OS User if known :
Please enter the value for DB User if known :
Session Info
-------------------------------------------------------------------------------------
'ACTION/MODULE:'||S.ACTION||'/'||S.MODULE||CHR(10)||'USERNAME:'||FU.DESCRIPTION
------------------------------------------------------------------------------------------------------------------------------------
Sid, Serial#, Aud sid : 4406 , 6452 , 213511119
DB User / OS User : APPS / asim
Machine - Terminal : WORKGROUP\asim-in - asim-in
OS Process Ids : 3332:2364 (Client) 9978 (Server) (Since) 17-JAN-2005 20:44:
48
Client Program Name : TOAD.exe
Action / Module : / T.O.A.D.
User Name :
|
User Comments : |
| |
|
| Name : |
Sonya |
| Comments : |
paxil http://www.bestrx-drugs.com |
| |
|
| Name : |
Dimitar |
| Comments : |
meridia http://www.bestrxpills.com |
| |
|
| Name : |
order viagra |
| Comments : |
http://www.viagra4u.info
Viagra, buy viagra, viagra online
Order viagra, cheap viagra |
| |
|
| Name : |
look this |
| Comments : |
Look this grate site Domain. It is really very interesting. I am excited. |
| |
|
| Name : |
Joe Fuentes |
| Comments : |
The text was good, but i stil cant find the play ipdates. looking for it dude. |
| |
|
| Name : |
Peter Jackson |
| Comments : |
A heap of wheat, says the Song of Songs
but I've never seen wheat in a pile :)
did you like it? |
| |
|
| Name : |
Richard Davis |
| Comments : |
Nice one, but what about der weg ? anywya, congrats from me. |
| |
|
| Name : |
Hans Millard |
| Comments : |
sehr gut Saite. Was machen Sie mein Freund?
keep it up ! |
| |
|
| Name : |
viagra online |
| Comments : |
http://www.viagrasite.info
viagra online, buy viagra, order viagra |
| |
|
| Name : |
Antique Clock |
| Comments : |
Clock Radio |
| |
|
| Name : |
Us Bank Online Banking |
| Comments : |
Investment Banking |
| |
|
| Name : |
Bill Collector |
| Comments : |
Collector Doll |
| |
|
| Name : |
Rain Coat |
| Comments : |
Coats |
| |
|
| Name : |
Art Cat |
| Comments : |
Bed Cat |
| |
|
| Name : |
Mariah Carey |
| Comments : |
Your site blog is interesting and has good info, although little bit scarce. Good Luck. |
| |
|
| Name : |
Jennifer Lopez |
| Comments : |
Interesting information you have, but more updates will be super. cheers. |
| |
|
| Name : |
Philip |
| Comments : |
gdansk hotels
http://www.gdansk-life.com |
| |
|
| Name : |
Angelina Jolie |
| Comments : |
Nice one but it will be better if more info is present |
| |
|
| Name : |
50 Cent |
| Comments : |
Informational site. Keep posted and updated. |
| |
|
| Name : |
Britney Spears |
| Comments : |
nice page with lots of useful info but keep updating. thanks. |
| |
|
| Name : |
Payday Loan |
| Comments : |
Just wanted to tell you that it is nice page you got. cheers. |
| |
|
| Name : |
Home Equity Loan |
| Comments : |
Great Information Blog you have. |
| |
|
| Name : |
Prague hotels |
| Comments : |
Your site is realy very interesting.
http://www.ms.gov/frameset.jsp?URL=http://www.ohotels.net |
| |
|
| Name : |
Krakow Hotels |
| Comments : |
Krakow accommodation
http://hotels.krakow.pl |
| |
|
| Name : |
Jesica Simpson |
| Comments : |
I like your site so much i wanted to say it. Good Luck. Please post more info. |
| |
|
| Name : |
College Loan |
| Comments : |
Get more information and everything will be super. Good work. |
| |
|
| Name : |
Payday Loan |
| Comments : |
Excellent comments. The more we contribute the better will be for all of us. Good Luck. |
| |
|
| Name : |
debt loan |
| Comments : |
You have excellent and very informative site. |
| |
|
| Name : |
Stylish shoes for women |
| Comments : |
Stylish shoes for women |
| |
|
| Name : |
Mortgage Loan |
| Comments : |
Great information for us users. Keep up. |
| |
|
| Name : |
Play Backgammon |
| Comments : |
Your site is realy very interesting.
http://s3.phpbbforfree.com/forums/backgammon.html |
| |
|
| Name : |
Bad Debt |
| Comments : |
You have very curious information site. |
| |
|
| Name : |
ediburghcars |
| Comments : |
I think I will share this with my friends, it mifght be interesting to them as well. |
| |
|
| Name : |
rentalservice |
| Comments : |
I think I will share this with my friends, it mifght be interesting to them as well. |
| |
|
| Name : |
Cheap Loan Motorcycle |
| Comments : |
this site is very good designed and has lot of info |
| |
|
| Name : |
Singapore hotels |
| Comments : |
Hotel Singapore |
| |
|
| Name : |
Fort Lauderdale hotels |
| Comments : |
Fort Lauderdale hotels |
| |
|
| Name : |
Bangkok hotels |
| Comments : |
Bangkok hotels |
| |
|
| Name : |
resources.php?city=Albuquerque |
| Comments : |
resources.php?city=Albuquerque |
| |
|
| Name : |
Online dating tip |
| Comments : |
I love this site! My very best wishes to its owners! http://www.online-dating-tip.grandsearch.net |
| |
|
| Name : |
Peter |
| Comments : |
i will recommend your site to all my friends its nice |
| |
|
| Name : |
Links Directory |
| Comments : |
Links and Site Directory |
| |
|
| Name : |
Phentermine |
| Comments : |
OoO! Nice site! I juuust LOVE it! Found it rather interesting and useful, you know:) http://www.phentermine.grandsearch.net |
| |
|
| Name : |
Nashville hotels |
| Comments : |
Nashville hotels |
| |
|
| Name : |
Madrid City |
| Comments : |
Madrid City |
| |
|
| Name : |
Dublin hotels |
| Comments : |
Dublin hotels |
| |
|
| Name : |
Alex |
| Comments : |
Hi i came your site and i like it very much but get more updates |
| |
|
| Name : |
Travel |
| Comments : |
Your site is realy very interesting.
http://www.community.harvard.edu/frame/?url=http://journals.aol.com/alexandro4spain/AlexandrosJournal/ |
| |
|
| Name : |
Erotik |
| Comments : |
Gut Seite! Sehr gut! Danke schoen fuer Information! http://erotik.freehostpro.com |
| |
|
| Name : |
Phentermine |
| Comments : |
OoO! Nice site! I juuust LOVE it! Found it rather interesting and useful, you know:) http://www.phentermine.grandsearch.net |
| |
|
| Name : |
roger |
| Comments : |
I will recommend your site to my friend its so nice |
| |
|
| Name : |
Peter |
| Comments : |
Your website is very informative but get more updates |
| |
|
| Name : |
Accommodation |
| Comments : |
Perfect site
http://texascenter.tamiu.edu/frame.asp?surl=http://blog.myspace.com/johnmcrow |
| |
|
| Name : |
Mayers |
| Comments : |
Hello and congratulations on your very nice web site |
| |
|
| Name : |
Automobile |
| Comments : |
Ooo.! Gut Seite:) Sehr schoen! http://automobile.batcave.net/ |
| |
|
| Name : |
Phentermine |
| Comments : |
Hi there! Nice site you have:) I wish you good luck! http://www.phentermine1.greatnow.com |
| |
|
| Name : |
George |
| Comments : |
Yes it would be great to comment on this but still i like it |
| |
|
| Name : |
Victoria hotels |
| Comments : |
Victoria hotels |
| |
|
| Name : |
Washington hotels |
| Comments : |
Washington hotels |
| |
|
| Name : |
Alicia |
| Comments : |
You have an excellent site easy on the eye and very easy to navigate |
| |
|
| Name : |
Alexia |
| Comments : |
You have an excellent site easy on the eye and very easy to navigate |
| |
|
| Name : |
Alexia |
| Comments : |
You have an excellent site easy on the eye and very easy to navigate |
| |
|
| Name : |
Alexia |
| Comments : |
Your site is realy very interesting. |
| |
|
| Name : |
BMW |
| Comments : |
Ehmm..m. Sehr gut Seite! Ich sage innig..!:) <a href="http://bmw-auto.125mb.com">bmw</a> |
| |
|
| Name : |
Tucson hotels |
| Comments : |
Tucson hotels |
| |
|
| Name : |
Brussels hotels |
| Comments : |
Brussels hotels |
| |
|
| Name : |
Hydrocodone |
| Comments : |
;-) Very informative! Good work http://20mbweb.com/Health/medicine/hydrocodone.html |
| |
|
| Name : |
Phentermine |
| Comments : |
Great site you have! Nice stucture, easy to browse! thaks for useful info:) http://20mbweb.com/Health/medicine/phentermine.html |
| |
|
| Name : |
Copenhagen hotels |
| Comments : |
Copenhagen hotels |
| |
|
| Name : |
Katrina |
| Comments : |
Very nice website with a lot of informative response from members |
| |
|
| Name : |
Tokyo hotels |
| Comments : |
Tokyo hotels |
| |
|
| Name : |
Miami hotels |
| Comments : |
Miami hotels |
| |
|
| Name : |
Puerto Vallarta hotels |
| Comments : |
Puerto Vallarta hotels |
| |
|
|
|
|
