[askdba] Re: [dba_gurus] Lock table display to users....
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: cherokeexc90@xxxxxxxxxxxxx
- Date: Thu, 16 Dec 2004 07:09:59 -0800 (PST)
Victoria,
If the user have the correct privilages to the v$ tables , I think it should,
Nisar Tareen
Victoria <cherokeexc90@xxxxxxxxxxxxx> wrote:
Will this work with Oracle applications? The user always shows up as apps.....
---------------------------------
From: Nisar Tareen [mailto:ntareen@xxxxxxxxx]
Sent: Wednesday, December 15, 2004 8:33 AM
To: cherokeexc90@xxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx
Subject: RE: [dba_gurus] Digest Number 261
Victoria,
Following is the procedure that can help you to display locks.
-- Procedure by Nisar Tareen Jan. 25. 2000
-- Show Objects locked .
cursor cross1 is
select session_id, PROCESS, ORACLE_Username, o.object_name
from dba_objects o, v$locked_object l
where l.object_id = o.object_id
order by o.object_name, session_id ;
sid numeric (15);
serl numeric (15);
session_id VARCHAR2 (15);
process1 VARCHAR2 (15);
user VARCHAR2 (8);
object_namex VARCHAR2 (30);
Begin
oPEN CROSS1;
DBMS_OUTPUT.Put_line('* ');
DBMS_OUTPUT.Put_line('* ');
DBMS_OUTPUT.Put_line('* CrossHuller Sterling Heights ');
DBMS_OUTPUT.Put_line('* -- -- -- -- -- -- -- -- -- - ');
DBMS_OUTPUT.Put_line('*
By. Nisar Tareen ') ;
DBMS_OUTPUT.Put_line('* Sid. User Name Object lock Porcess
No.');
DBMS_OUTPUT.Put_line('*
====================================================');
DBMS_OUTPUT.Put_line('* ');
LOOP
FETCH cross1 INTO SID, PROCESS1, USER, OBJECT_NAMEx;
exit WHEN cross1%NOTFOUnd;
DBMS_OUTPUT.Put_line('* '|| SID || ' ' || USER ||' ' || object_nameX ||
' ' || process1);
end Loop ;
END show_locks ;
Nisar Tareen
Victoria <cherokeexc90@xxxxxxxxxxxxx> wrote:
Does anyone have a script that will point to the PID of a process running
through Oracle applications. For example I can see the SID through OEM
against the table but I would like to know what is bing executed that is
locking the table?
There are 25 messages in this issue.
Topics in this digest:
1. Actress Asin has stormed Kollywood with a hit film M.Kumaran S/o
Mahalakshmi. View her latest photos here.
From: vicky m <thinish_raj@xxxxxxxxx>
2. Installation of Oracle 8i.....urgent
From: rajesh pr <simple_raju@xxxxxxxxx>
3. Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
From: Vivek Verma <vicky.verma@xxxxxxxxx>
4. Re: call me 09830795714
From: Tanmoy <tanmoydc@xxxxxxxxx>
5. Re: call me 09830795714
From: "nsk_leela" <nsk_leela@xxxxxxxxxxx>
6. Re: Re: call me 09830795714
From: Vivek Verma <vicky.verma@xxxxxxxxx>
7. Re: Installation of Oracle 8i.....urgent
From: "Vijayaraghavan R" <vijayrr76@xxxxxxxxxxxxxx>
8. Re: Re: urgent please help
From: "Vijayaraghavan R" <vijayrr76@xxxxxxxxxxxxxx>
9. how to found out who deleted the records
From: Ananth Antony <ananth_a_75@xxxxxxxxx>
10. how to remove rman records from control file ?
From: "Siddharth Sriwastav" <sid_job@xxxxxxxxxxxxxx>
11. The real thing is here
From: "deepu_streak" <deepu_streak@xxxxxxxxx>
12. Re: Re: call me 09830795714
From: Bikram Betal <bbetal@xxxxxxxxx>
13. How to findout the DBsize
From: Naresh kumar <cnaresh25@xxxxxxxxxxx>
14. Oracle walk in @Hyd - 19th December 2004.
From: Pradeep V <ranideep@xxxxxxxxx>
15. Unable to start Database - Undo Tablespace Problem
From: <anild@xxxxxxxxx>
16. Re: Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
From: amit arora <arora_amit_00@xxxxxxxxx>
17. Re: How to findout the DBsize
From: Vivek Verma <vicky.verma@xxxxxxxxx>
18. Re: call me 09830795714
From: "Anitha .S" <meetanitha_2000@xxxxxxxxx>
19. Re: Actress Asin has stormed Kollywood with a hit film M.Kumaran
S/o Mahalakshmi. View her latest photos here.
From: "Anitha .S" <meetanitha_2000@xxxxxxxxx>
20. Re: how to found out who deleted the records
From: abhinav.saxena@xxxxxxxxxxxxx
21. Oracle 10G Upgrade Exam questions required IZ0-040
From: sguptasolntec
22. Please Please Help! -> Something Like Replication
From: azadeh ghafarinia <alo_markaz@xxxxxxxxx>
23. Re: Please Please Help! -> Something Like Replication
From: Nisar Tareen <ntareen@xxxxxxxxx>
24. Re: Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
From: Nisar Tareen <ntareen@xxxxxxxxx>
25. Re: how to create database manually
From: suresh nambrath <suresh_nambrath@xxxxxxxxx>
________________________________________________________________________
________________________________________________________________________
Message: 1
Date: Mon, 13 Dec 2004 18:29:07 -0800 (PST)
From: vicky m <thinish_raj@xxxxxxxxx>
Subject: Actress Asin has stormed Kollywood with a hit film M.Kumaran S/o
Mahalakshmi. View her latest photos here.
http://www.veenaimovies.com/photogallerydetails.asp?artistid=1025&artist_nam
e=Asin
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 2
Date: Mon, 13 Dec 2004 18:44:29 -0800 (PST)
From: rajesh pr <simple_raju@xxxxxxxxx>
Subject: Installation of Oracle 8i.....urgent
Hi,
Does anyone know how to uninstall oracle? When I uninstalled oracle,
and then tried to install it later I got a error message saying that an
oracle version already exists in the system.
A directory structure was also present with some .dll files. I tried to
delete all the directories, but it got created again and I got the same
error message while installation.
Can't I Install oracle without formatiing my disks?
Regards,
Rajesh
---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 3
Date: Tue, 14 Dec 2004 10:00:54 +0530
From: Vivek Verma <vicky.verma@xxxxxxxxx>
Subject: Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
ITS A GREAT FEELING !!!!!
--
Vivek Verma
On Mon, 13 Dec 2004 11:42:51 -0800 (PST), Nisar Tareen <ntareen@xxxxxxxxx>
wrote:
>
>
>
> Max Li <max.li@xxxxxxxx> wrote:
> Yes, it's the same problem. But cannot solve it with those suggestions.
>
> Max
>
> -----Original Message-----
> From: Nisar Tareen [mailto:ntareen@xxxxxxxxx]
> Sent: 20041213 11:50
> To: Max Li; 'oracle_dba@xxxxxxxxxxxxxxx';
> 'ORACLE-DBA-MASTERS@xxxxxxxxxxxxxxx'; 'dba_gurus@xxxxxxxxxxxxxxx'
> Cc: Max Li
> Subject: Re: [dba_gurus] My backup takes a very long time ( UNIX
> system)
>
>
>
> hi Li,
>
> I remember you have raised the same question some time back, what
> happen to the suggestion for everyone and your reseach to this topic,
> were you able to apply any of the suggetion or done something
> different from than or it is the same situation and same problem.
>
> Nisar Tareen
>
>
> Max Li <max.li@xxxxxxxx> wrote:
>
>
> Hi,
>
> Anyone here knows this problem?
>
> I try to backup some directories of my solaris8 system, totally 12G,
> backup into DTL tape sets using Veritas Netbackup Enterprise V4.5.
> But it takes me
> 23 hours. It is unacceptable. This 12G is just OS. my Oracle system
> was backup seperately. It take a long time too.
>
> Thanks,
>
> Max
>
>
>
> The information contained in this e-mail is intended only for the
> individual or entity to whom it is addressed.
> Its contents (including any attachments) may contain confidential
> and/or privileged information.
> If you are not an intended recipient you must not use, disclose,
> disseminate, copy or print its contents.
> If you receive this e-mail in error, please notify the sender by reply
> e-mail and delete and destroy the message.
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=129tagnno/M=298184.5639630.6699735.300117
> 6/D=gr
>
oups/S=1705115386:HM/EXP=1103044457/A=2434971/R=0/SIG=11eeoolb0/*http://www.
> netflix.com/Default?mqso=60185400> click here
>
>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
> :HM/A=2434971/rand=547475869>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/dba_gurus/
> <http://groups.yahoo.com/group/dba_gurus/>
>
>
> * To unsubscribe from this group, send an email to:
> dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
> <mailto:dba_gurus-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> _____
>
> Do you Yahoo!?
> Yahoo! Mail - now with 250MB free storage. Learn
> <http://us.rd.yahoo.com/evt=29914/*http://info.mail.yahoo.com/mail_250
> >
> more.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ________________________________
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/oracle_dba/
>
> To unsubscribe from this group, send an email to:
> oracle_dba-unsubscribe@xxxxxxxxxxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
________________________________________________________________________
________________________________________________________________________
Message: 4
Date: Tue, 14 Dec 2004 10:02:51 +0530
From: Tanmoy <tanmoydc@xxxxxxxxx>
Subject: Re: call me 09830795714
DBA GURUS is a call centre group now .. we are getting mails for friendship
..marriage and for time pass too ..rather than full discussion for oracle ..
this is annoying as it increase our mail boxes with junk ones ..
moderator can u please look into this matter ..
On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly Dasgupta
<shellydsgpt@xxxxxxxxx> wrote:
>
> This is Shelly Dasgupta here .I am a 23 yrs old working porfessional .I
live in Kolkata , in Phoolbagan ,near V.I.P market .Interested men may call
me .
>
> ---------------------------------
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
>
> [Non-text portions of this message have been removed]
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Make a clean sweep of pop-up ads. Yahoo!
Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
>
>
> --------------------------------------------------------------------~-
> >
>
> Yahoo! Groups Links
>
>
>
>
>
--
Regards,
Tanmoy
-- "Time is the coin of life. Only you can determine how it will be spent."
________________________________________________________________________
________________________________________________________________________
Message: 5
Date: Tue, 14 Dec 2004 04:43:26 -0000
From: "nsk_leela" <nsk_leela@xxxxxxxxxxx>
Subject: Re: call me 09830795714
Yes I agree with Tanmoy we must stop this.
We have requested n times to the moderator to stop this becoz we all share
our technical exp.
Moderator Plz. block all such mail address which post this type of msg.
Cheers!!
--- In dba_gurus@xxxxxxxxxxxxxxx, Tanmoy <tanmoydc@xxxx> wrote:
> DBA GURUS is a call centre group now .. we are getting mails for
> friendship ..marriage and for time pass too ..rather than full
> discussion for oracle ..
>
> this is annoying as it increase our mail boxes with junk ones ..
>
> moderator can u please look into this matter ..
>
>
> On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly Dasgupta
> <shellydsgpt@xxxx> wrote:
> >
> > This is Shelly Dasgupta here .I am a 23 yrs old working
porfessional .I live in Kolkata , in Phoolbagan ,near V.I.P market
.Interested men may call me .
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Take Yahoo! Mail with you! Get it on your mobile phone.
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------ Yahoo! Groups Sponsor -------------------
-~-->
> > Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> > Now with Pop-Up Blocker. Get it for free!
> > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> >
> >
> > ------------------------------------------------------------------
--~->
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> --
> Regards,
> Tanmoy
>
> -- "Time is the coin of life. Only you can determine how it will be
spent."
________________________________________________________________________
________________________________________________________________________
Message: 6
Date: Tue, 14 Dec 2004 10:22:19 +0530
From: Vivek Verma <vicky.verma@xxxxxxxxx>
Subject: Re: Re: call me 09830795714
This has turned out to be more of a time pass group by all these mail
circulating....
--
Vivek Verma
On Tue, 14 Dec 2004 04:43:26 -0000, nsk_leela <nsk_leela@xxxxxxxxxxx> wrote:
>
>
> Yes I agree with Tanmoy we must stop this.
> We have requested n times to the moderator
> to stop this becoz we all share our technical
> exp.
>
> Moderator Plz. block all such mail address which post
> this type of msg.
>
> Cheers!!
>
>
>
> --- In dba_gurus@xxxxxxxxxxxxxxx, Tanmoy <tanmoydc@xxxx> wrote:
> > DBA GURUS is a call centre group now .. we are getting mails for
> > friendship ..marriage and for time pass too ..rather than full
> > discussion for oracle ..
> >
> > this is annoying as it increase our mail boxes with junk ones ..
> >
> > moderator can u please look into this matter ..
> >
> >
> > On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly Dasgupta
> > <shellydsgpt@xxxx> wrote:
> > >
> > > This is Shelly Dasgupta here .I am a 23 yrs old working
> porfessional .I live in Kolkata , in Phoolbagan ,near V.I.P
> market .Interested men may call me .
> > >
> > > ---------------------------------
> > > Do you Yahoo!?
> > > Take Yahoo! Mail with you! Get it on your mobile phone.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------ Yahoo! Groups Sponsor -------------------
> -~-->
> > > Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> > > Now with Pop-Up Blocker. Get it for free!
> > > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> > >
> > >
> > > ------------------------------------------------------------------
> --~->
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Regards,
> > Tanmoy
> >
> > -- "Time is the coin of life. Only you can determine how it will be
> spent."
>
> ------------------------ Yahoo! Groups Sponsor --------------------~-->
> $4.98 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
>
>
> --------------------------------------------------------------------~->
>
> Yahoo! Groups Links
>
>
>
>
>
________________________________________________________________________
________________________________________________________________________
Message: 7
Date: 14 Dec 2004 05:05:20 -0000
From: "Vijayaraghavan R" <vijayrr76@xxxxxxxxxxxxxx>
Subject: Re: Installation of Oracle 8i.....urgent
Based on the oracle version, you would either use orainst or runInstaller to
install/uninstall oracle software.
If the version to remove is 8.1.5 or higher, then you must be using
runInstaller. The software information is stored in Inventory, registry(in
case of windows) or oratab (unix) and ofcourse the oracle_home directory
path as well.
The best way to remove oracle software is to deinstall products from the
universal installer window. If this has failed for some reason, then you can
delete the directory, remove the registry key corresponding to the home(be
careful with this if you are not comfortable) and also remove the inventory
entries. Assuming, this is the only installation in this machine, you can
remove the inventory directory under c:\program files\Oracle.
Additions, corrections and clarifications welcome !
Cheers
On Tue, 14 Dec 2004 rajesh pr wrote :
>
>Hi,
> Does anyone know how to uninstall oracle? When I uninstalled
oracle, and then tried to install it later I got a error message saying that
an oracle version already exists in the system.
>A directory structure was also present with some .dll files. I tried to
delete all the directories, but it got created again and I got the same
error message while installation.
>
> Can't I Install oracle without formatiing my disks?
>
>Regards,
>Rajesh
>
>
>---------------------------------
>Do you Yahoo!?
> Yahoo! Mail - You care about security. So do we.
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 8
Date: 14 Dec 2004 05:39:20 -0000
From: "Vijayaraghavan R" <vijayrr76@xxxxxxxxxxxxxx>
Subject: Re: Re: urgent please help
As I understand, your application has some timeout call after a certain
period. Basic question in the case would be : How did you determine the
timeout period and has the application ever run within this time limit ever
before for similar data? If not, change the timeout period.
To look at the performance issue, run statspack and collect report for 1hr
durations at peak hours or troubled times...
Cheers
On Mon, 13 Dec 2004 Kannan P wrote :
>Hi
>Really there is no oracle errors related to the timeout of
>transactions, from the oracle point of view at all but we get
>transaction time out and is creating big issue , the buffer cache hit
>ratio is 93%, library cache is 87%,the sql plan cost for important
>quries to are less than 5 considering nearly 15lakhs of records
>the cpu ideal time is at an average of 20% at peak hours in solaris
>
>i don't know where the problem occurs - is it related to application?
>, also our software engineers says there is no problem with
>application.
>
>i held up in unknown situation - and i don't know in which direction i
>move - it really critical please
>kindly help me
>
>thanks and regards
>
>
>
>
>
>On 13 Dec 2004 06:11:16 -0000, Vijayaraghavan R
><vijayrr76@xxxxxxxxxxxxxx> wrote:
> >
> >
> >
> > Hi,
> >
> > I am not sure what made you relate the time out error to SGA size. Can
you
> > clearly state what problem include exact error number and message that
you
> > are trying to debug? There are numerous time out errors in oracle.
> >
> > Cheers
> >
> > On Sun, 12 Dec 2004 kannan wrote :
> >
> >
> > >
> > >
> > >Hello friends pl help on the flwg :
> > >
> > >The existing SGA size of a database is 370 M.
> > >
> > >The problem is that time out error occurs in transaction, using sun
> > >solaris 2.6 server having 6 gb ram.
> > > can be utilised for oracle server : I read metalink it recommends
> > >that SGA formula is
> > >
> > >SGA == 50% of System ram size
> > >Buffer Cache = 25% of system ram size
> > >Share pool size = 25% of Buffer cache
> > >
> > >I checked the buf. cache hit ratio .
> > >It is 85% now. It seems increasing
> > >SGA will not serve the purpose.
> > >
> > >Can anybody know how to change etc/system SHMMAX Parameter
> > >setting under this circumstances. and will it serve the purpose
> > >
> > >Is it waranted now or existing thing is okay.
> > >
> > >urgent
> > >
> > >Kannan
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>--
>Kannanlp
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 9
Date: Mon, 13 Dec 2004 21:43:02 -0800 (PST)
From: Ananth Antony <ananth_a_75@xxxxxxxxx>
Subject: how to found out who deleted the records
Hi Friends,
Yesterday night one of our user deleted all the records from a mandatory
table..even though i had a backup, i want to know who did that....can i know
how to found that...
any help welcome...
Thanks
Ananth
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! Try it today!
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 10
Date: 14 Dec 2004 06:07:01 -0000
From: "Siddharth Sriwastav" <sid_job@xxxxxxxxxxxxxx>
Subject: how to remove rman records from control file ?
Dear Friends,
How can I flush the control file and recovery catalog (for the target
database) of all existing rman backup records so that I get no output from
the rman command 'list backup' ? I want to start a fresh backup and recovery
policy/system.
thanks,
Siddharth.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 11
Date: Tue, 14 Dec 2004 06:27:29 -0000
From: "deepu_streak" <deepu_streak@xxxxxxxxx>
Subject: The real thing is here
The real thing is here
Get into the right place right now!
Set your idea in motion with a Free Inventors Kit!
http://www.globalfreecash.com/index.asp?refcode=pears
You can personally use this
you can give it to anybody F_R_E_E
signin. login and earn on...on...on.......with
http://www.globalfreecalling.com/reg1.asp?refcode=pears
________________________________________________________________________
________________________________________________________________________
Message: 12
Date: Mon, 13 Dec 2004 22:44:51 -0800 (PST)
From: Bikram Betal <bbetal@xxxxxxxxx>
Subject: Re: Re: call me 09830795714
Otherwise somebody from KOLKATA itself can take some
time off and cool her out.
--- Vivek Verma <vicky.verma@xxxxxxxxx> wrote:
> This has turned out to be more of a time pass group
> by all these mail
> circulating....
>
>
> --
> Vivek Verma
>
> On Tue, 14 Dec 2004 04:43:26 -0000, nsk_leela
> <nsk_leela@xxxxxxxxxxx> wrote:
> >
> >
> > Yes I agree with Tanmoy we must stop this.
> > We have requested n times to the moderator
> > to stop this becoz we all share our technical
> > exp.
> >
> > Moderator Plz. block all such mail address which
> post
> > this type of msg.
> >
> > Cheers!!
> >
> >
> >
> > --- In dba_gurus@xxxxxxxxxxxxxxx, Tanmoy
> <tanmoydc@xxxx> wrote:
> > > DBA GURUS is a call centre group now .. we are
> getting mails for
> > > friendship ..marriage and for time pass too
> ..rather than full
> > > discussion for oracle ..
> > >
> > > this is annoying as it increase our mail boxes
> with junk ones ..
> > >
> > > moderator can u please look into this matter ..
> > >
> > >
> > > On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly
> Dasgupta
> > > <shellydsgpt@xxxx> wrote:
> > > >
> > > > This is Shelly Dasgupta here .I am a 23 yrs
> old working
> > porfessional .I live in Kolkata , in Phoolbagan
> ,near V.I.P
> > market .Interested men may call me .
> > > >
> > > > ---------------------------------
> > > > Do you Yahoo!?
> > > > Take Yahoo! Mail with you! Get it on your
> mobile phone.
> > > >
> > > > [Non-text portions of this message have been
> removed]
> > > >
> > > > ------------------------ Yahoo! Groups Sponsor
> -------------------
> > -~-->
> > > > Make a clean sweep of pop-up ads. Yahoo!
> Companion Toolbar.
> > > > Now with Pop-Up Blocker. Get it for free!
> > > >
>
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> > > >
> > > >
> > > >
>
------------------------------------------------------------------
> > --~->
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > Regards,
> > > Tanmoy
> > >
> > > -- "Time is the coin of life. Only you can
> determine how it will be
> > spent."
> >
> > ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> > $4.98 domain names from Yahoo!. Register anything.
> >
>
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
> >
> >
> >
>
--------------------------------------------------------------------~->
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
________________________________________________________________________
________________________________________________________________________
Message: 13
Date: Mon, 13 Dec 2004 22:58:53 -0800 (PST)
From: Naresh kumar <cnaresh25@xxxxxxxxxxx>
Subject: How to findout the DBsize
Hello gurus,
How to findout the database size, used size and remaining size for existing
database (Oracle). I tried using V$database view but iam confusing.
plz. help me.
Thanks & Regards
naresh
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 14
Date: Tue, 14 Dec 2004 12:44:38 +0530
From: Pradeep V <ranideep@xxxxxxxxx>
Subject: Oracle walk in @Hyd - 19th December 2004.
Write the following referral details on top of the resume:
Name: Pradeep Kumar V,
Emp# : 3765.
When and where is it happening?
Date: 19th December 2004
Time: 9:00 am - 12:00 noon
Venue: Cyber Gateway
Hitec City, Madhapur,Hyderabad
What do you need to do?
We request you to inform your friends who would be interested in taking
employment with Oracle India. They can directly walk in with a hard copy of
the
resume. Please intimate them to write your name and employee number on the
resume so that you can be given the credit incase of an offer.
What are we looking for?
We are looking for graduates/post graduates (BE/BTech,ME/Mtech,MCA)
from reputed
universities with experience ranging from 1-6 years
Java Developer
Strong experience in JAVA /J2EE Applications development. Having a good
understanding of OOD concepts, Design Patterns, Data Structures, with strong
analytical skills. Exposure to SQL and PL /SQL is desirable and knowledge of
SOAP, XML, Web Services and other open standards is a plus. Experience
in Oracle
Apps and Workflow is preferred.
Forms & PL/SQL Developer
Excellent FORMS, SQL and PL/SQL coding, debugging and performance
tuning skills.
Strong Oracle database concepts including features in 8i. Experience in
Oracle
Apps and Workflow is preferred. Exposure to database design/modeling and 9i
features is a plus.
________________________________________________________________________
________________________________________________________________________
Message: 15
Date: Tue, 14 Dec 2004 12:46:13 +0530
From: <anild@xxxxxxxxx>
Subject: Unable to start Database - Undo Tablespace Problem
Dear All,
I am unable to open the database; alert log shows me the problem of
block corruption in file 2 (which is undo tablespace file). I changed
the undo_management to MANUAL , even then I m not able to open the
database , its currently in mount stage.
Should I delete the undo tablespace datafile and try to open. Will this
help ,,, what are my options ? I don't have the backup.
Please help
Regds
Anil
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 16
Date: Tue, 14 Dec 2004 07:36:20 +0000 (GMT)
From: amit arora <arora_amit_00@xxxxxxxxx>
Subject: Re: Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
Its Really a Great Feeling... congratulations to Oracle and its Employees
for buying Peoplesoft.
Thanks & Regards
Amit Arora @ Oracle Corporation
Ph. No: +91 98450-80103
---------------------------------
Win a castle for NYE with your mates and Yahoo! Messenger
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 17
Date: Tue, 14 Dec 2004 14:08:15 +0530
From: Vivek Verma <vicky.verma@xxxxxxxxx>
Subject: Re: How to findout the DBsize
use dba_data_files
--
Vivek Verma
On Mon, 13 Dec 2004 22:58:53 -0800 (PST), Naresh kumar
<cnaresh25@xxxxxxxxxxx> wrote:
>
> Hello gurus,
>
> How to findout the database size, used size and remaining size for
existing database (Oracle). I tried using V$database view but iam
confusing.
>
> plz. help me.
>
> Thanks & Regards
>
> naresh
>
> ---------------------------------
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
________________________________________________________________________
________________________________________________________________________
Message: 18
Date: Tue, 14 Dec 2004 01:38:00 -0800 (PST)
From: "Anitha .S" <meetanitha_2000@xxxxxxxxx>
Subject: Re: call me 09830795714
CALL u for what??
--- Shelly Dasgupta <shellydsgpt@xxxxxxxxx> wrote:
> This is Shelly Dasgupta here .I am a 23 yrs old
> working porfessional .I live in Kolkata , in
> Phoolbagan ,near V.I.P market .Interested men may
> call me .
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile
> phone.
>
> [Non-text portions of this message have been
> removed]
>
>
=====
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
________________________________________________________________________
________________________________________________________________________
Message: 19
Date: Tue, 14 Dec 2004 01:37:00 -0800 (PST)
From: "Anitha .S" <meetanitha_2000@xxxxxxxxx>
Subject: Re: Actress Asin has stormed Kollywood with a hit film M.Kumaran
S/o Mahalakshmi. View her latest photos here.
waw.. What a piece of information to be shared in this
study group..
moderator pls throw away vicky..
--- vicky m <thinish_raj@xxxxxxxxx> wrote:
>
>
>
http://www.veenaimovies.com/photogallerydetails.asp?artistid=1025&artist_nam
e=Asin
>
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Easier than ever with enhanced
> search. Learn more.
>
> [Non-text portions of this message have been
> removed]
>
>
=====
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
________________________________________________________________________
________________________________________________________________________
Message: 20
Date: Tue, 14 Dec 2004 15:16:09 +0530
From: abhinav.saxena@xxxxxxxxxxxxx
Subject: Re: how to found out who deleted the records
Ananth,
If you find the answer , let me also know.
Rgds,
Abhinav
91-22-28290019
x :1538
----------
This e-Mail may contain proprietary and confidential information and is sent
for the intended recipient(s) only.
If by an addressing or transmission error this mail has been misdirected to
you, you are requested to delete this mail immediately.
You are also hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its
attachment other than by its intended recipient/s is strictly prohibited.
Visit Us at http://www.polaris.co.in
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 21
Date: Tue, 14 Dec 2004 10:29:27 -0000
From: sguptasolntec
Subject: Oracle 10G Upgrade Exam questions required IZ0-040
Friends
If anyone has got IZ0-040 Questions please send me the same.
Thanks in advance
________________________________________________________________________
________________________________________________________________________
Message: 22
Date: Tue, 14 Dec 2004 05:22:06 -0800 (PST)
From: azadeh ghafarinia <alo_markaz@xxxxxxxxx>
Subject: Please Please Help! -> Something Like Replication
Hi Masters!
I have a problem with replicating databases,
we have a formula creation subsystem that create
stored procedures in oracle database 9i,
our application data is replicating between many
databases as materializad view sites and one master
database,
How we can replicate stored procedures?
Any soloution please!
tnx
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
________________________________________________________________________
________________________________________________________________________
Message: 23
Date: Tue, 14 Dec 2004 05:49:47 -0800 (PST)
From: Nisar Tareen <ntareen@xxxxxxxxx>
Subject: Re: Please Please Help! -> Something Like Replication
Ghafarinia,
You are replicating data table not the system tables so the Procedure you
have to store/replace on each site mannually.
Nisar Tareen
azadeh ghafarinia <alo_markaz@xxxxxxxxx> wrote:
Hi Masters!
I have a problem with replicating databases,
we have a formula creation subsystem that create
stored procedures in oracle database 9i,
our application data is replicating between many
databases as materializad view sites and one master
database,
How we can replicate stored procedures?
Any soloution please!
tnx
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! Try it today!
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 24
Date: Tue, 14 Dec 2004 05:55:47 -0800 (PST)
From: Nisar Tareen <ntareen@xxxxxxxxx>
Subject: Re: Re: [oracle_dba] Any reaction from the Gurus about the Oracle
buying Peoplesoft.
Amit,
The feeling is very correct one.
But strategically,
what will happen to Peoplesoft applications/staff ?
Do Oracle will merge them into Oracle or de-commissioned them ?.
Oracle Gurus will have new opening in Database side or Application side?
Nisar Tareen
amit arora <arora_amit_00@xxxxxxxxx> wrote:
Its Really a Great Feeling... congratulations to Oracle and its Employees
for buying Peoplesoft.
Thanks & Regards
Amit Arora @ Oracle Corporation
Ph. No: +91 98450-80103
---------------------------------
Win a castle for NYE with your mates and Yahoo! Messenger
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Jazz up your holiday email with celebrity designs. Learn more.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 25
Date: Tue, 14 Dec 2004 06:11:07 -0800 (PST)
From: suresh nambrath <suresh_nambrath@xxxxxxxxx>
Subject: Re: how to create database manually
i will give a brief idea for windows platform
1)User oradim utility to create a service
2)create necessary folders for controlfile,log file etc
3)construct a parameter file by specifying the req values
4)setup the environment variable to poing towards the new sid (set
oracle_Sid=<>)
5)open sqlplus and connect as sysdba
6)issue create database command by specifying log file,datafile etc
7)run catalog and catproc to create data dict views and pl/sql packages
8)Run pubbld.sql after connection to system
this will take care.
anand kulkarni <ananddec2004@xxxxxxxxx> wrote:
please tell steps to create the database manually.
in oracle and the changes that we have to make in the SPORA file.
---------------------------------
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
[Non-text portions of this message have been removed]
Yahoo! Groups Links
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
------------------------------------------------------------------------
Yahoo! Groups Links
------------------------------------------------------------------------
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! What will yours do?
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
Other related posts:
