[askdba] Re: [dba_gurus] Lock table display to users....

  • From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, <cherokeexc90@xxxxxxxxxxxxx>
  • Date: Thu, 16 Dec 2004 11:35:14 -0500

This might  help as well
NDS@SENDSS<gdph-d1> @who_locked
NDS@SENDSS<gdph-d1> select s.osuser "O/S-User", s.username "Ora-User", s.sid
"Session-ID",
  2  s.serial# "Serial", s.process "Process-ID", s.status "Status",l.name
"Obj Locked",
  3  l.mode_held "Lock Mode"
  4  from v$session s,dba_dml_locks l,v$process p
  5  where l.session_id = s.sid and p.addr = s.paddr

============================

HTHU

Ankur Shah
Oracle DBA
DHR-GA

----- Original Message -----
From: "Nisar Tareen" <ntareen@xxxxxxxxx>
To: <cherokeexc90@xxxxxxxxxxxxx>
Cc: "dba Group" <dba_gurus@xxxxxxxxxxxxxxx>; "askdba" <askdba@xxxxxxxxxxxxx>
Sent: Thursday, December 16, 2004 10:09 AM
Subject: [askdba] Re: [dba_gurus] Lock table display to users....


> 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: