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

  • From: "Patricia Eyenga" <patricia.e@xxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, <cherokeexc90@xxxxxxxxxxxxx>
  • Date: Thu, 16 Dec 2004 10:24:11 -0500

Apps user has access to all catalog tables

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] =
On
Behalf Of Nisar Tareen
Sent: Thursday, December 16, 2004 10:10 AM
To: cherokeexc90@xxxxxxxxxxxxx
Cc: dba Group; askdba
Subject: [askdba] Re: [dba_gurus] Lock table display to users....


Victoria,
=20
If the user have the correct privilages to the v$ tables , I think it
should,=20
=20
Nisar Tareen=20

Victoria <cherokeexc90@xxxxxxxxxxxxx> wrote:
Will this work with Oracle applications?  The user always shows up as
apps.....


---------------------------------
From: Nisar Tareen [mailto:ntareen@xxxxxxxxx]=20
Sent: Wednesday, December 15, 2004 8:33 AM
To: cherokeexc90@xxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx
Subject: RE: [dba_gurus] Digest Number 261



Victoria,=20
=20
Following is the procedure that can help you to display locks.=20
=20
=20

--      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 =3D 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('*
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D');
                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  ;

=20
=20
Nisar Tareen=20


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?=20



There are 25 messages in this issue.

Topics in this digest:

      1. Actress Asin has stormed Kollywood with a hit film =11M.Kumaran =
S/o
Mahalakshmi=12. 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 =
=11M.Kumaran
S/o Mahalakshmi=12. 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        =20
   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 =11M.Kumaran =
S/o
Mahalakshmi=12. View her latest photos here.



http://www.veenaimovies.com/photogallerydetails.asp?artistid=3D1025&artis=
t_nam
e=3DAsin=20




           =20
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 2        =20
   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

           =20
---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 3        =20
   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:
> =20
>=20
>=20
> Max Li <max.li@xxxxxxxx> wrote:
> Yes, it's the same problem. But cannot solve it with those =
suggestions.=20
>=20
> Max
>=20
> -----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=20
> system)
>=20
>=20
>=20
> hi Li,
>=20
> 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=20
> different from than or it is the same situation and same problem.
>=20
> Nisar Tareen
>=20
>=20
> Max Li <max.li@xxxxxxxx> wrote:
>=20
>=20
> Hi,
>=20
> Anyone here knows this problem?
>=20
> I try to backup some directories of my solaris8 system, totally 12G,
> backup into DTL tape sets using Veritas Netbackup Enterprise V4.5. =20
> But it takes me
> 23 hours. It is unacceptable. This 12G is just OS. my Oracle system=20
> was backup seperately. It take a long time too.
>=20
> Thanks,
>=20
> Max
>=20
>=20
>=20
> 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=20
> and/or privileged information.
> If you are not an intended recipient you must not use, disclose,=20
> 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.
>=20
> [Non-text portions of this message have been removed]
>=20
>=20
>=20
> Yahoo! Groups Sponsor     =20
>=20
> ADVERTISEMENT
>=20
> =
<http://us.ard.yahoo.com/SIG=3D129tagnno/M=3D298184.5639630.6699735.30011=
7
> 6/D=3Dgr
>
oups/S=3D1705115386:HM/EXP=3D1103044457/A=3D2434971/R=3D0/SIG=3D11eeoolb0=
/*http://www.
> netflix.com/Default?mqso=3D60185400> click here     =20
>=20
>
<http://us.adserver.yahoo.com/l?M=3D298184.5639630.6699735.3001176/D=3Dgr=
oups/S=3D
> :HM/A=3D2434971/rand=3D547475869>      =20
>=20
>=20
>   _____
>=20
> Yahoo! Groups Links
>=20
>=20
> *      To visit your group on the web, go to:
> http://groups.yahoo.com/group/dba_gurus/
> <http://groups.yahoo.com/group/dba_gurus/>
>  =20
>=20
> *      To unsubscribe from this group, send an email to:
> dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
> <mailto:dba_gurus-unsubscribe@xxxxxxxxxxxxxxx?subject=3DUnsubscribe>
>  =20
>=20
> *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of =
Service
> <http://docs.yahoo.com/info/terms/> .
>=20
>=20
>=20
>=20
>   _____
>=20
> Do you Yahoo!?
> Yahoo! Mail - now with 250MB free storage. Learn
> =
<http://us.rd.yahoo.com/evt=3D29914/*http://info.mail.yahoo.com/mail_250
> >
> more.
>=20
>=20
>=20
> [Non-text portions of this message have been removed]
>=20
>=20
>=20
>=20
>  ________________________________
> Do you Yahoo!?
>  Take Yahoo! Mail with you! Get it on your mobile phone.
> =20
>  Yahoo! Groups Sponsor
> =20
>  ADVERTISEMENT
> =20
> =20
>  ________________________________
>  Yahoo! Groups Links
> =20
> To visit your group on the web, go to:=20
> http://groups.yahoo.com/group/oracle_dba/
>  =20
> To unsubscribe from this group, send an email to:=20
> oracle_dba-unsubscribe@xxxxxxxxxxxxxxx
>  =20
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>=20
>


________________________________________________________________________
________________________________________________________________________

Message: 4        =20
   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 ..=20

moderator can u please look into this matter ..=20


On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly Dasgupta
<shellydsgpt@xxxxxxxxx> wrote:
>=20
> This is Shelly Dasgupta here .I am a 23 yrs old working porfessional=20
> .I
live in Kolkata , in Phoolbagan ,near V.I.P market .Interested men may =
call
me .
>=20
> ---------------------------------
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
>=20
> [Non-text portions of this message have been removed]
>=20
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Make a clean sweep of pop-up ads. Yahoo!
Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!=20
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
>=20
>=20
> --------------------------------------------------------------------~-
> >
>=20
> Yahoo! Groups Links
>=20
>=20
>=20
>=20
>=20


--
Regards,
Tanmoy=20

-- "Time is the coin of life. Only you can determine how it will be =
spent."


________________________________________________________________________
________________________________________________________________________

Message: 5        =20
   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.=20

Moderator Plz. block all such mail address which post this type of msg.=20

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=20
> discussion for oracle ..
>=20
> this is annoying as it increase our mail boxes with junk ones ..
>=20
> moderator can u please look into this matter ..
>=20
>=20
> On Mon, 13 Dec 2004 11:09:27 -0800 (PST), Shelly Dasgupta
> <shellydsgpt@xxxx> wrote:
> >=20
> > 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 .
> >=20
> > ---------------------------------
> > Do you Yahoo!?
> > Take Yahoo! Mail with you! Get it on your mobile phone.
> >=20
> > [Non-text portions of this message have been removed]
> >=20
> > ------------------------ Yahoo! Groups Sponsor -------------------
-~-->=20
> > Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with =

> > Pop-Up Blocker. Get it for free!=20
> > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> >=20
> >=20
> > ------------------------------------------------------------------
--~->
> >=20
> > Yahoo! Groups Links
> >=20
> >=20
> >=20
> >=20
> >=20
>=20
>=20
> --
> Regards,
> Tanmoy
>=20
> -- "Time is the coin of life. Only you can determine how it will be
spent."





________________________________________________________________________
________________________________________________________________________

Message: 6        =20
   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....


--=20
Vivek Verma

On Tue, 14 Dec 2004 04:43:26 -0000, nsk_leela <nsk_leela@xxxxxxxxxxx> =
wrote:
>=20
>=20
> 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.
>=20
> Moderator Plz. block all such mail address which post
> this type of msg.
>=20
> Cheers!!
>=20
>=20
>=20
> --- In dba_gurus@xxxxxxxxxxxxxxx, Tanmoy <tanmoydc@xxxx> wrote:
> > DBA GURUS is a call centre group now .. we are getting mails for=20
> > friendship ..marriage and for time pass too ..rather than full=20
> > 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=20
> > <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=20
> .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=20
> > > with Pop-Up Blocker. Get it for free!=20
> > > 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."
>=20
> ------------------------ Yahoo! Groups Sponsor=20
> --------------------~-->
> $4.98 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
>=20
>=20
> --------------------------------------------------------------------~-
> >
>=20
> Yahoo! Groups Links
>=20
>=20
>=20
>=20
>


________________________________________________________________________
________________________________________________________________________

Message: 7        =20
   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        =20
   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 =20


On Mon, 13 Dec 2004 Kannan P wrote :
>Hi
>Really there is no oracle errors related to the timeout of=20
>transactions, from the oracle point of view at all but  we get=20
>transaction time out and is creating big issue , the buffer cache hit=20
>ratio is 93%, library cache is 87%,the sql plan cost for important=20
>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=20
>move - it really critical please kindly help me
>
>thanks and regards
>
>
>
>
>
>On 13 Dec 2004 06:11:16 -0000, Vijayaraghavan R=20
><vijayrr76@xxxxxxxxxxxxxx> wrote:
> >
> >
> >
> >  Hi,
> >
> >  I am not sure what made you relate the time out error to SGA size.=20
> > Can
you
> > clearly state what problem include exact error number and message=20
> > 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=20
> > sun  >solaris 2.6 server having 6 gb ram.  >  can be utilised for=20
> > oracle server : I read metalink it recommends  >that SGA formula is
> >  >
> >  >SGA =3D=3D 50% of System ram size
> >  >Buffer Cache =3D 25% of system ram size
> >  >Share pool size =3D 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        =20
   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



           =20
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! =16 Try it today!=20

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 10       =20
   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       =20
   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!=20

Set your idea in motion with a Free Inventors Kit!

http://www.globalfreecash.com/index.asp?refcode=3Dpears

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=3Dpears





________________________________________________________________________
________________________________________________________________________

Message: 12       =20
   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....
>=20
>=20
> --
> Vivek Verma
>=20
> On Tue, 14 Dec 2004 04:43:26 -0000, nsk_leela <nsk_leela@xxxxxxxxxxx>=20
> wrote:
> >=20
> >=20
> > 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.
> >=20
> > Moderator Plz. block all such mail address which
> post
> > this type of msg.
> >=20
> > Cheers!!
> >=20
> >=20
> >=20
> > --- 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."
> >=20
> > ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> > $4.98 domain names from Yahoo!. Register anything.
> >
>
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
> >=20
> >=20
> >
>
--------------------------------------------------------------------~->
> >=20
> > Yahoo! Groups Links
> >=20
> >=20
> >=20
> >=20
> >
>=20



           =20
__________________________________=20
Do you Yahoo!?=20
Read only the mail you want - Yahoo! Mail SpamGuard.=20
http://promotions.yahoo.com/new_mail=20


________________________________________________________________________
________________________________________________________________________

Message: 13       =20
   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

           =20
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 14       =20
   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.=20


When and where is it happening?

 =20



Date:   19th December 2004





Time:   9:00 am - 12:00 noon





Venue: Cyber Gateway

          Hitec City, Madhapur,Hyderabad    =20





What do you need to do?

We request you to inform your friends who would be interested in taking=20
employment with Oracle India. They can directly walk in with a hard copy =
of
the=20
resume. Please intimate them to write your name and employee number on =
the=20
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        =20

Strong experience in JAVA /J2EE Applications development. Having a good=20
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.

    =20



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=20
Apps and Workflow is preferred. Exposure to database design/modeling and =
9i=20
features is a plus.


________________________________________________________________________
________________________________________________________________________

Message: 15       =20
   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.=20



Please help



Regds

Anil



[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 16       =20
   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
































           =20
---------------------------------
Win a castle  for NYE with your mates and Yahoo! Messenger=20

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 17       =20
   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

--=20
Vivek Verma

On Mon, 13 Dec 2004 22:58:53 -0800 (PST), Naresh kumar
<cnaresh25@xxxxxxxxxxx> wrote:
>=20
> Hello gurus,
>=20
> How to findout the database size, used size and remaining size for
existing database (Oracle). I tried using  V$database  view but iam
confusing.
>=20
> plz. help me.
>=20
> Thanks & Regards
>=20
> naresh
>=20
> ---------------------------------
> Do you Yahoo!?
>  Read only the mail you want - Yahoo! Mail SpamGuard.
>=20
> [Non-text portions of this message have been removed]
>=20
>=20
>=20
> Yahoo! Groups Links
>=20
>=20
>=20
>=20
>


________________________________________________________________________
________________________________________________________________________

Message: 18       =20
   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??=20


--- 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 .
>=20
>=20
>=20
>            =20
> ---------------------------------
> Do you Yahoo!?
>  Take Yahoo! Mail with you! Get it on your mobile
> phone.
>=20
> [Non-text portions of this message have been
> removed]
>=20
>=20


=3D=3D=3D=3D=3D



           =20
__________________________________=20
Do you Yahoo!?=20
Meet the all-new My Yahoo! - Try it today!=20
http://my.yahoo.com=20




________________________________________________________________________
________________________________________________________________________

Message: 19       =20
   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 =
=11M.Kumaran
S/o Mahalakshmi=12. 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:

>=20
>=20
>
http://www.veenaimovies.com/photogallerydetails.asp?artistid=3D1025&artis=
t_nam
e=3DAsin
>=20
>=20
>=20
>=20
>=20
>            =20
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Mail - Easier than ever with enhanced
> search. Learn more.
>=20
> [Non-text portions of this message have been
> removed]
>=20
>=20


=3D=3D=3D=3D=3D



     =20
           =20
__________________________________=20
Do you Yahoo!?=20
Yahoo! Mail - You care about security. So do we.=20
http://promotions.yahoo.com/new_mail


________________________________________________________________________
________________________________________________________________________

Message: 20       =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.=20
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       =20
   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       =20
   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



           =20
__________________________________=20
Do you Yahoo!?=20
Take Yahoo! Mail with you! Get it on your mobile phone.=20
http://mobile.yahoo.com/maildemo=20


________________________________________________________________________
________________________________________________________________________

Message: 23       =20
   Date: Tue, 14 Dec 2004 05:49:47 -0800 (PST)
   From: Nisar Tareen <ntareen@xxxxxxxxx>
Subject: Re: Please Please Help! -> Something Like Replication

Ghafarinia,=20

You are replicating data table not the system tables so the Procedure =
you
have to store/replace on each site mannually.=20

Nisar Tareen=20


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



           =20
__________________________________=20
Do you Yahoo!?=20
Take Yahoo! Mail with you! Get it on your mobile phone.=20
http://mobile.yahoo.com/maildemo=20

Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
 =20
   To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
 =20
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20


           =20
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! =16 Try it today!=20

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 24       =20
   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,=20

The feeling is very correct one.=20


But strategically,=20



what will happen to Peoplesoft applications/staff ?=20



Do Oracle will  merge them into Oracle or  de-commissioned them ?.=20

Oracle Gurus will have new opening in  Database side or Application =
side?



Nisar Tareen=20


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
































           =20
---------------------------------
Win a castle  for NYE with your mates and Yahoo! Messenger=20

[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/
 =20
   To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
 =20
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20


           =20
---------------------------------
Do you Yahoo!?
Jazz up your holiday email with celebrity designs. Learn more.

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 25       =20
   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=20
3)construct a parameter file by specifying the req values 4)setup the
environment variable to poing towards the new sid  (set
oracle_Sid=3D<>)
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 =16 Try My Yahoo!

[Non-text portions of this message have been removed]





Yahoo! Groups Links








           =20
---------------------------------
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/
 =20
   To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
 =20
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20



---------------------------------
Do you Yahoo!?
The all-new My Yahoo! =16 What will yours do? =20
        =09
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Helps protect you from nasty viruses.




Other related posts: