Re: Rollback Segments

[Anjo Kolk]

How about iag/iap ? And rpt ? Oh and SQL*Menu ?
And there were about 14 enqueue/locks in Oracle Version 5 as far as I can
remember.

Anjo Kolk

Brings back memories of joining Oracle Europe in 1985 ;-)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 6:43 AM


>
> I remember the BI.ORA  (Before-Image) file, IOR and ODS in Oracle 5.
>
> Hemant K Chitale
> Principal DBA
> Chartered Semiconductor Manufacturing Ltd
>
>
> Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
> Sent by: [EMAIL PROTECTED]
>
> Please respond to ORACLE-L
>
>  To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>  cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
>  Subject: RE: Rollback Segments
>
>
>
>
>
>
>
>
> UFI no, but the rest... that's where I started in Oracle -- version 5
>
>
> --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote:
> > Holy cow Mladen, what a memory!
> >
> > Does anybody else remember (or admit to) using UFI?
> >
> > Jim
> >
> > **
> >
> > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Conboy, Jim
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>
> __
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: whitespaces

[Abul Fazal]

Varchar2 will not leave any trailing blank spaces.
Only Char field does.
See this example
Create table temp
( Co1  Varchar2(5)
  Col2 Char(5)
);

Insert into temp 
Values('KING', 'KING');

Select col1, length(col1), col2, length(col2)   
from temp   

COL1  LENGTH(COL1) COL2  LENGTH(COL2)   
-  -    
KING 4 KING 5   

Cheers
Fazal
--- Jon Baker <[EMAIL PROTECTED]> wrote:
> use the rtrim function.
> 
> rtrim(char[,set]) - char, with final characters
> removed after the last
> character not in set.  set defaults to ' '.
> 
> 
> i.e.:
> 
> update  set =rtrim();
> 
> 
> 
> Jon Baker   
> Database Architect
> <[EMAIL PROTECTED]>
> www.netsec.net
> 
>  
> 
> 
> -Original Message-
> Sent: Thursday, February 14, 2002 9:08 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> What query can i run to to eliminate trailing
> whitespaces. e.g. i have
> 'abc  ' and want to update the table so any such
> data is set without the
> whitespace, in this case 'abc'
> 
> the fiels is varchar2
> 8.1.7.
> 
> cheers
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


=
Abul Fazal
Production Support Services - Quantum Leap 
Standard Charted Bank 
Singapore
HP : 65-94887900

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abul Fazal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Disable certain users from login to database while applying Human

[hemantchitale]

As you are talking of Oracle Apps, NONE of the suggested solutions :
1.  Database ON LOGON Trigger
2.  Lock Database Account
3.  Change Database Account Password
4.  Startup Database in Restricted mode
would work.

The users connect to the Database in the APPS schema -- this is the
"universal"
schema that Oracle Apps uses.  The Patch requires APPS so Restricted
doesn't
help (unless you grant Restricted to APPS in which case all the users can
logon).
Ditto about locking, changing password or writing a trigger on the APPS
schema.

What you can do are :
1. Shutdown the Apache server for the Self-Service Modules
2. Shutdown the Forms server for the Forms Module
3. Shutdown the Concurrent Managers.

All of the above would affect ALL users.

Alternatively, login to the Application as the System Administrator user
and
change the Application User Passwords for the users whom you want disabled.
Change the passwords back to a default (WELCOME) later.

However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown
3. Shutdown
as I have listed above.
If you are familiar with Oracle Applications Patching and are comfortable
with reading
the Patch drivers, you can figure out what database objects are being
modified/updated/created
and what Forms/Reports/HTML etc files are being modified/created by the
patch.
Then you can take an intelligent decision  should you allow users to
logon when
applying the patch ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>18/02/2002 03:28 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: Disable certain users from login to database while applying  

 Human 

   

   

   






Hi Gurus,

I need to disable certain users from login to database while I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon trigger to disable
or should I take away their privileges to logon to report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ? What do U guys
do to solve the dead-lock problem (If my users access the HR tables while I
apply the patches, I will encounter dead-lock problem) ?

Please advise. Thanks.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Rollback Segments

[hemantchitale]

I remember the BI.ORA  (Before-Image) file, IOR and ODS in Oracle 5.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: RE: Rollback Segments

   

   

   






UFI no, but the rest... that's where I started in Oracle -- version 5


--- "Conboy, Jim" <[EMAIL PROTECTED]> wrote:
> Holy cow Mladen, what a memory!
>
> Does anybody else remember (or admit to) using UFI?
>
> Jim
>
> **
>
> ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Conboy, Jim
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle 8i patch installation

[Long . Nguyen]

Hi,

At my site I normally install Oracle Server EE using custom installation, i.e. I 
install only the products that I need. 

Now an Oracle 8i patchset (e.g. 8.1.7.3 patchset) contains patches for many products 
(RDBMS, PL/SQL, Networking, Intermedia etc). If I install say 8.1.7.3 on top of my 
current 8.1.7.0 it will install not only patches for products that I
have in my current 8.1.7.0 installation, but also extra patches as well. This is fine 
for now I can foresee a problem in future when I install additional products from the 
8.1.7.0 CD. Should I reapply the 8.1.7.3 patchset then to ensure
that all products are properly patches? Do you see any problem with installing the 
same patchset more than once for an Oracle server?

Thanks
Long
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8i Concept PCTFREE & PCTUSED are 0

[Sinard Xing]

Hi Long,

Do you mean Oracle should come with AI capability ?
then Oracle will be very buggy and Oracle Concept Doc will be the last SOS.
With current version I think Oracle is good in general but certainly not
ready for AI.


Sinardy


-Original Message-
[EMAIL PROTECTED]
Sent: 19 February 2002 09:54
To: Multiple recipients of list ORACLE-L


Hi,

This is an offside comment rather than a direct reply to Sinard's question.
Oracle has made many config parameters tuneable and this makes the software
both flexible and complex. On the other hand MS's SQLServer only has a small
number of
config parameters that could be changed by DBA (about 5 or so in SQLServer
7) which makes the software easier to manage but not very tuneable. I woule
prefer to see s'where in the middle where Oracle could reduce the number of
config
parameters so its environment is easier to manage. For example it is all
good to have pctfree and pctused  parameters to play with, but I just wonder
what is the percentage of developers who have actually thought about these
in advance and
set them up "appropriately" for their applications. And also once they have
set the values for pctused and pctfree, did they actually monitor the space
usage to see if the values used are in fact appropriate? Why don't Oracle
work more
intelligent and manage space smartly without the requirement of developers
setting these parameters. Another example is the pinning of dbms_standard
package. If it is commonly used then Oracle should pin it automatically
every time the db
is started up instead of leaving this decision in the hand of DBAs.

My 2c comments.

What do you reckon?

Long

-Original Message-
Sent: Monday, 18 February 2002 11:38 PM
To: Multiple recipients of list ORACLE-L


Hello Sinardy

PCTUSED means that:
After a block was filled with records and the free space in the block
is less then pctfree the block is no longer available for further inserts.
If however, the data falls beneath PCTUSED the block became again
available for inserts.

In your example, block will never again became available, even if empty,
because: After a data block becomes full as determined by PCTFREE, Oracle
does not consider the block for the insertion of new rows until the
percentage of the block being used falls below the parameter PCTUSED.


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, February 18, 2002 11:08 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  8i Concept PCTFREE & PCTUSED are 0
>
> Hi all,
>
> Oracle 8i (81600)
>
> I create user Panadol and give unlimited quota on TBS.
>
> as Panadol I create 1 table like this:
>
> SQL> CREATE TABLE mytable(
>   2 col1 char(3),
>   3 col2 char(4),
>   4 col4 varchar2(4)
>   5  )
>   6  PCTFREE 0
>   7  PCTUSED 0
>   8  STORAGE (
>   9INITIAL 20K
>  10NEXT 20K
>  11PCTINCREASE 0
>  12MAXEXTENTS 10
>  13  )
>  14  ;
>
> Table created.
>
> SQL> insert into mytable values('abc', 'abcd', 'a');
>
> 1 row created.
>
> SQL> commit;
>
>
> I don't understand That table PCTUSED is 0 ? where Oracle keep those
> data ?
>
> Look at this:
>
> SQL> select * from mytable;
>
> COL COL2 COL4
> ---  
> abc abcd a
>
>
>
> Sinardy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinard Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX:

RE: Where does a DBA go from here?

[Sujatha Madan]

Thanks 
for the information Suhen.
 

  -Original Message-From: Suhen Pather 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 
  2002 11:48 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Where does a DBA go from 
  here?
  
  Sujatha,
      
  
      
  Just spoke to Peter Bach, Miracle 
  AS, 
  Australia
      
  The forum dates are not confirmed yet but it will be towards the end of 
  May.
   
      
  Once he has the dates confirmed he will post it on the Miracle 
  website.
      
  You can call him for more info, the numbers 
  can be obtained from the Miracle AS website.
   
      
  It should be a great training to attend with lots of big names from the 
  industry.    
  
   
  He says 
  that Jonathan Lewis will also be doing a training course (seminar) in 
  Australia similar to the 
  
  one on his website 
  (JLCOMP).
   
      
  Regards 
      
  $uhen
   
   
   
  
  Where 
  can I get more information about this Database Forum in 
  Sydney??
  
   
  
  Cheers,
  
   
  
  Sujatha
  
-Original 
Message-From: Mogens 
Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 10:18 
AMTo: Multiple recipients 
of list ORACLE-LSubject: 
Re: Where does a DBA go from here?
Time for some real marketing here :-). 
Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James 
Morle and a few others will be the main speakers at the Database Forum we're 
doing in Sydney in late May. A couple of days with these guys should prove 
fun and educational. These days we even have an informal organisation called 
The OakTable Network (www.OakTable.net) which, for instance, 
will have a booth at Oracle World in Copenhagen in June where you can ask 
anything you like, sit around my oak table, and drink beer (well, maybe not 
that :) ), listen to mini presentations by the guys, and so on.EoM 
(End of Marketing).PS: We'll also try to build the worlds biggest 
laptop RAC cluster. That's proving a challenge. So far, we've managed to run 
two nodes on the laptops, but then it becomes harder - much harder. But 
James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody 
could bring their laptop, plug it in, be part of the RAC thing for some 
minutes, and then get a certificate stating that the person participated in 
the worlds biggest, etc...?MogensGreg Moore wrote:
Now where
do I go for more Oracle training?
Consider looking at the web sites of the Oracle DBA's who are up on the
latest techniques.  They sometimes teach advanced classes.  Craig
Shallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.
Steve Adams recently taught a class in San Francisco.  Tim Gorman may give
advanced classes.

The latest and best thinking seems to appear first in papers that are freely
available, and then later appears in books and classes.  These four DBA's
offer papers like that on their sites, and link to other sites with more of
the same.  After a certain point you have to turn to quality books, papers
and conferences.

If it's classes you want, a clever move might be to take some UNIX or
Windows system administration ones, to broaden your skills into some new
area like that.
 

RE: 8i Concept PCTFREE & PCTUSED are 0

[Long . Nguyen]

Hi,

This is an offside comment rather than a direct reply to Sinard's question. Oracle has 
made many config parameters tuneable and this makes the software both flexible and 
complex. On the other hand MS's SQLServer only has a small number of
config parameters that could be changed by DBA (about 5 or so in SQLServer 7) which 
makes the software easier to manage but not very tuneable. I woule prefer to see 
s'where in the middle where Oracle could reduce the number of config
parameters so its environment is easier to manage. For example it is all good to have 
pctfree and pctused  parameters to play with, but I just wonder what is the percentage 
of developers who have actually thought about these in advance and
set them up "appropriately" for their applications. And also once they have set the 
values for pctused and pctfree, did they actually monitor the space usage to see if 
the values used are in fact appropriate? Why don't Oracle work more
intelligent and manage space smartly without the requirement of developers setting 
these parameters. Another example is the pinning of dbms_standard package. If it is 
commonly used then Oracle should pin it automatically every time the db
is started up instead of leaving this decision in the hand of DBAs.

My 2c comments.

What do you reckon?

Long

-Original Message-
Sent: Monday, 18 February 2002 11:38 PM
To: Multiple recipients of list ORACLE-L


Hello Sinardy

PCTUSED means that:
After a block was filled with records and the free space in the block
is less then pctfree the block is no longer available for further inserts.
If however, the data falls beneath PCTUSED the block became again 
available for inserts.

In your example, block will never again became available, even if empty,
because: After a data block becomes full as determined by PCTFREE, Oracle
does not consider the block for the insertion of new rows until the
percentage of the block being used falls below the parameter PCTUSED. 


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, February 18, 2002 11:08 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  8i Concept PCTFREE & PCTUSED are 0
> 
> Hi all,
> 
> Oracle 8i (81600)
> 
> I create user Panadol and give unlimited quota on TBS.
> 
> as Panadol I create 1 table like this:
> 
> SQL> CREATE TABLE mytable(
>   2 col1 char(3),
>   3 col2 char(4),
>   4 col4 varchar2(4)
>   5  )
>   6  PCTFREE 0
>   7  PCTUSED 0
>   8  STORAGE (
>   9INITIAL 20K
>  10NEXT 20K
>  11PCTINCREASE 0
>  12MAXEXTENTS 10
>  13  )
>  14  ;
> 
> Table created.
> 
> SQL> insert into mytable values('abc', 'abcd', 'a');
> 
> 1 row created.
> 
> SQL> commit;
> 
> 
> I don't understand That table PCTUSED is 0 ? where Oracle keep those
> data ?
> 
> Look at this:
> 
> SQL> select * from mytable;
> 
> COL COL2 COL4
> ---  
> abc abcd a
> 
> 
> 
> Sinardy
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Sinard Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a 

for those still wondering whether to attend IOUG(serious plug about IOUG)

[Joe Testa]

IOUG LIVE! 2002

Be sure to check out the educational opportunities at IOUG Live! 2002

-- THE Education Conference for Oracle Users by Oracle Users-- April 
14-18, 2002, in San Diego, CA. Register at www.ioug.org/live2002 before 
March 15 and save $200!

Visit www.ioug.org/live2002 to view abstracts for over 290 technical
sessions in 7 focus areas-- including DBA, Application Development, Data
Warehousing, Project Management, among others. Live! delivers the most
robust technical sessions for Oracle users-- complete with the most
up-to-date information on 9i-- to help you make the most of your Oracle
applications and save you countless dollars and hours on the job!

In addition to the technical sessions, Live! 2002 offers Oracle
professionals: Vendor Forums, Special Interest and Local/Regional User 
Group Meetings, an exhibition showcase of today's leading Oracle 
solutions providers, and a variety of networking opportunities including 
receptions, the Live! Big Bash at SeaWorld and daily Birds-of-a-Feather 
lunches.

Be sure to check out this event to make the most out of your 2002 
training budget!









-- 
Joe Testa, Oracle DBA
Nothing new to put here, hmm






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Where does a DBA go from here?

[Suhen Pather]

Sujatha,

    

    Just
spoke to Peter Bach, Miracle AS, Australia

    The
forum dates are not confirmed yet but it will be towards the end of May.

 

    Once
he has the dates confirmed he will post it on the Miracle website.

    You
can call him for more info, the numbers can be
obtained from the Miracle AS website.

 

    It
should be a great training to attend with lots of big names from the industry.    

 

He says that Jonathan
Lewis will also be doing a training course (seminar) in Australia similar to the 

one on his website (JLCOMP).

 

    Regards


    $uhen

 

 

 



Where can I get more
information about this Database Forum in Sydney??





 





Cheers,





 





Sujatha





-Original Message-
From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 19 February 2002
10:18 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Where does a DBA go
from here?

Time for some real marketing here :-). Jonathan Lewis,
Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few
others will be the main speakers at the Database Forum we're doing in Sydney in
late May. A couple of days with these guys should prove fun and educational.
These days we even have an informal organisation called The OakTable Network (www.OakTable.net) which, for instance, will
have a booth at Oracle World in Copenhagen in June where you can ask anything
you like, sit around my oak table, and drink beer (well, maybe not that :) ),
listen to mini presentations by the guys, and so on.

EoM (End of Marketing).

PS: We'll also try to build the worlds biggest laptop RAC cluster. That's
proving a challenge. So far, we've managed to run two nodes on the laptops, but
then it becomes harder - much harder. But James, Jonathan and Bjorn are working
on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be
part of the RAC thing for some minutes, and then get a certificate stating that
the person participated in the worlds biggest, etc...?

Mogens

Greg Moore wrote:



Now where
do I go for more Oracle training?


Consider looking at the web sites of the Oracle DBA's who are up on the
latest techniques.  They sometimes teach advanced classes.  Craig
Shallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.
Steve Adams recently taught a class in San Francisco.  Tim Gorman may give
advanced classes.

The latest and best thinking seems to appear first in papers that are freely
available, and then later appears in books and classes.  These four DBA's
offer papers like that on their sites, and link to other sites with more of
the same.  After a certain point you have to turn to quality books, papers
and conferences.

If it's classes you want, a clever move might be to take some UNIX or
Windows system administration ones, to broaden your skills into some new
area like that.

 

Install 8.1.7 SE over EE

[Eca Eca]

Hi Friends

I have a instance 8.1.7 EE and i need to install de 8.1.7 Standard Edititon.

How can i do it ?

It is my production environment, so , I can't stop for long time ...
It need to be fast ...

I need to keep the name of the database, because there are a lot of scripts 
using the name.

Regards

Eriovaldo



_
Associe-se ao maior serviço de e-mail do mundo através do MSN Hotmail. 
http://www.hotmail.com/br

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eca Eca
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Performance Tuning

[Rachel Carmichael]

well, we would certainly expect *you* to know this :)

thanks, that helps when I send links to my mom, who still feels she has
to retype the url rather than cut and paste


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> A note about Amazon URLs:
> 
> You can often cut off a lot of the stuff at the end when sharing a
> link with others.  The stuff at the end is just session context.  For
> instance, Chris's list is at:
> 
>
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote:
> 
> > Commit;   :-)
> > 
> > And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website
> with one 
> > of these wonderful, long and strange English names, Ixora, etc. and
> get 
> > the good articles there. This is where you'll find a lot of current
> 
> > thinking.
> > 
> > [EMAIL PROTECTED] wrote:
> > 
> > >Okay, I'll plug my own list of recommendations on Amazon. It 
> > >should come up from this URL:
> > >http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
> > >/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
> > >6595843
> > >
> > >If it doesn't, just enter 'Oracle performance tuning' in a search
> on 
> > >Amazon.com and look to the right. My list usually pops up.
> > >
> > >If you just get one book on performance, go with Performance 101. 
> > >If you're getting two books, get 101 and Tom Kyte's book.
> > >
> > >
> > >On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:
> > >
> > >>  I am interested in purchasing some exceptionally good book on
> Oracle
> > >>Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> > >>Tunning worth purchasing
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Where does a DBA go from here?

[Sujatha Madan]

Where 
can I get more information about this Database Forum in 
Sydney??
 
Cheers,
 
Sujatha

  -Original Message-From: Mogens Nørgaard 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 10:18 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Where does a DBA go from here?Time for some real 
  marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, 
  Bjorn Engsig, James Morle and a few others will be the main speakers at the 
  Database Forum we're doing in Sydney in late May. A couple of days with these 
  guys should prove fun and educational. These days we even have an informal 
  organisation called The OakTable Network (www.OakTable.net) which, for instance, will 
  have a booth at Oracle World in Copenhagen in June where you can ask anything 
  you like, sit around my oak table, and drink beer (well, maybe not that :) ), 
  listen to mini presentations by the guys, and so on.EoM (End of 
  Marketing).PS: We'll also try to build the worlds biggest laptop RAC 
  cluster. That's proving a challenge. So far, we've managed to run two nodes on 
  the laptops, but then it becomes harder - much harder. But James, Jonathan and 
  Bjorn are working on it. Wouldn't it be fun if anybody could bring their 
  laptop, plug it in, be part of the RAC thing for some minutes, and then get a 
  certificate stating that the person participated in the worlds biggest, 
  etc...?MogensGreg Moore wrote:
  
Now wheredo I go for more Oracle training?Consider looking at the web sites of the Oracle DBA's who are up on thelatest techniques.  They sometimes teach advanced classes.  CraigShallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.Steve Adams recently taught a class in San Francisco.  Tim Gorman may giveadvanced classes.The latest and best thinking seems to appear first in papers that are freelyavailable, and then later appears in books and classes.  These four DBA'soffer papers like that on their sites, and link to other sites with more ofthe same.  After a certain point you have to turn to quality books, papersand conferences.If it's classes you want, a clever move might be to take some UNIX orWindows system administration ones, to broaden your skills into some newarea like that.

RE: Rollback Segments

[Gogala, Mladen]

I do. User Friendly Interface. Hush, don't tell anybody, but I started with
Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole
machine has had a Hercules screen card (text only, no graphics) and 512KB
(no, it's not a mistake, it really is the letter "K") of memory. I still 
have those 3 big, grey boxes with 5 5.25" floppies which used to contain 
the whole installation. Unfortunately, I cannot install it because I no
longer have DOS 3.3 which was required for Oracle 4. 
Oh well, I seem to be getting old. 

-Original Message-
Sent: Monday, February 18, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L


Holy cow Mladen, what a memory!  

Does anybody else remember (or admit to) using UFI?

Jim

**

...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Conboy, Jim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Weird ODBC Issue

[Gogala, Mladen]

Been there, done that. I still prefer fantasy.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L



Welcome to the real world Mladen.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Skewed Wait Times

[Mogens Nørgaard]

And here's the answer from Jonathan:

==
The script was an extended version of the definition
of gv$system_event from v$fixed_view_definition
which included the MAX_WAIT value, which for
some reason is usually missing from v$system_event
even though it is present in v$session_event.

The text is as below - although it now needs some
modification for getting maximum information for
Oracle 9 which uses micro-second timing.


create or replace view v$max_system_event
as
select
   d.kslednam   event,
   s.ksleswts   waits,
   s.kslestmo   timeouts,
   s.kslestim   tot_csecs,
   s.kslesmxt   max_csecs
from
   x$kslei s,
   x$ksled d
where s.ksleswts != 0
and  s.indx = d.indx
and  d.inst_id = userenv('instance')
and  s.inst_id = userenv('instance')
;




Jonathan Lewis
=

Mogens Nørgaard wrote:

   Well, why not ask the man himself?  Jonathan - are you there?
  
 Mogens
  
  
[EMAIL PROTECTED]
 wrote:
  
 Nope. That version of v$system_event would also show me the max wait 
that was done on an event, and not just the total time waited. Its there in
his book, somewhere in a chapter that also talks of v$filestat and IO tuning,
I think.
Raj

Connor McDonald 
<[EMAIL PROTECTED]>

Sent by: 
[EMAIL PROTECTED]

02/09/2002 10:28 AM PST
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>

cc:
bcc:
Subject:Re: Skewed Wait Times



You're thinking of v$mystat, but
v$session_event is
 available in 'vanilla' oracle.

hth
 connor

 --- 
[EMAIL PROTECTED]
 wrote: > Hello All,
 >
 > After setting timed_statistics to true, I am finding
 > something strange with
 > the wait times in v$system_event for the event 'db
 > file sequential read'.
 > The wait times far exceed the uptime of the
 > database.  What I can think of
 > is, say there are 10 sessions waiting for a single
 > hot block for say 1 ms.
 > The wait is actually for 1ms, but for the 10
 > sessions it add to 10ms.
 >
 > Or that the times are skewed. I remember reading
 > about this in 'Practical
 > Oracle 8i' where Jonathan Lewis had addressed these
 > issues. There was also
 > a script in there to create your own version of
 > v$system_event, reading
 > from two x$ tables. I dont have the book handy with
 > me now. Would someone
 > be kind enough to forward the same to me?
 >
 > Thanks
 > Raj
 >
 > --
 > Please see the official ORACLE-L FAQ:
 > http://www.orafaq.com

 > --
 > Author:
 >   INET: 
[EMAIL PROTECTED]

 >
 > Fat City Network Services    -- (858) 538-5051  FAX:
 > (858) 538-5051
 > San Diego, California        -- Public Internet
 > access / Mailing Lists
 >
 
 > To REMOVE yourself from this mailing list, send an
 > E-Mail message
 > to: 
[EMAIL PROTECTED]
 (note EXACT spelling of
 > 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB
 > ORACLE-L
 > (or the name of mailing list you want to be removed
 > from).  You may
 > also send the HELP command for other information
 > (like subscribing).

=
 Connor McDonald
http://www.oracledba.co.uk
  (mirrored at
http://www.oradba.freeserve.co.uk
 )

"Some days you're the pigeon, some days 
you're the statue"

__
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com

 --
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   INET: 
[EMAIL PROTECTED]


Fat City Network Services    -- (858)
538-5051  FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: 
[EMAIL PROTECTED]
 (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --  Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
 --  Author:INET: 
[EMAIL PROTECTED]
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 San
Diego, California-- Public Internet access / Mailing Lists 
 To REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED]
 (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed 
from).  You may also send the HELP command for other information (like subscribing).
   

Re: Where does a DBA go from here?

[Mogens Nørgaard]

Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo
Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the
main speakers at the Database Forum we're doing in Sydney in late May. A
couple of days with these guys should prove fun and educational. These days
we even have an informal organisation called The OakTable Network (www.OakTable.net)
which, for instance, will have a booth at Oracle World in Copenhagen in June
where you can ask anything you like, sit around my oak table, and drink beer
(well, maybe not that :) ), listen to mini presentations by the guys, and
so on.

EoM (End of Marketing).

PS: We'll also try to build the worlds biggest laptop RAC cluster. That's
proving a challenge. So far, we've managed to run two nodes on the laptops,
but then it becomes harder - much harder. But James, Jonathan and Bjorn are
working on it. Wouldn't it be fun if anybody could bring their laptop, plug
it in, be part of the RAC thing for some minutes, and then get a certificate
stating that the person participated in the worlds biggest, etc...?

Mogens

Greg Moore wrote:

  
Now wheredo I go for more Oracle training?

Consider looking at the web sites of the Oracle DBA's who are up on thelatest techniques.  They sometimes teach advanced classes.  CraigShallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.Steve Adams recently taught a class in San Francisco.  Tim Gorman may giveadvanced classes.The latest and best thinking seems to appear first in papers that are freelyavailable, and then later appears in books and classes.  These four DBA'soffer papers like that on their sites, and link to other sites with more ofthe same.  After a certain point you have to turn to quality books, papersand conferences.If it's classes you want, a clever move might be to take some UNIX orWindows system administration ones, to broaden your skills into some newarea like that.

Re: Performance Tuning

[Jeremiah Wilton]

A note about Amazon URLs:

You can often cut off a lot of the stuff at the end when sharing a
link with others.  The stuff at the end is just session context.  For
instance, Chris's list is at:

http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote:

> Commit;   :-)
> 
> And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one 
> of these wonderful, long and strange English names, Ixora, etc. and get 
> the good articles there. This is where you'll find a lot of current 
> thinking.
> 
> [EMAIL PROTECTED] wrote:
> 
> >Okay, I'll plug my own list of recommendations on Amazon. It 
> >should come up from this URL:
> >http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
> >/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
> >6595843
> >
> >If it doesn't, just enter 'Oracle performance tuning' in a search on 
> >Amazon.com and look to the right. My list usually pops up.
> >
> >If you just get one book on performance, go with Performance 101. 
> >If you're getting two books, get 101 and Tom Kyte's book.
> >
> >
> >On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:
> >
> >>I am interested in purchasing some exceptionally good book on Oracle
> >>Performance Tuning. Can anyone suggest me some very good book on Oracle
> >>Tunning worth purchasing

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Frequency of Analyze

[Mogens Nørgaard]

Indeed. One can argue about the 10% threshold that the monitoring 
facility is using to trigger a re-analyze, but it's so much easier to 
set this up now. Should be mandatory for everybody :).

Mogens

John Kanagaraj wrote:

>Arslan,
> 
>Since you are on 8.1.7, have you considered using the ALTER TABLE ...
>MONITORING feature? This will create entries in DBA_TAB_MODIFICATIONS
>detailing the estimated DML on the tables involved along with a Timestamp.
>This will enable you to estimate the required frequency...
> 
>John Kanagaraj
>Oracle Applications DBA
>DBSoft Inc
>(W): 408-970-7002
>
>Wanna know the reason for the season? Click on ' http://www.needhim.org'
> 
>
>** The opinions and statements above are entirely my own and not
>those of my employer or clients **
>
>
>-Original Message-
>Sent: Friday, February 15, 2002 7:23 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>What is the recommended frequency of analyzing schemas in an OLTP
>environment?
>
>DB size near 8 GB. Oracle 8.1.7.0.0 on NT 4.
>
>
>
>BM__MailAutoSigArslan Zaheer Dar
>
>[EMAIL PROTECTED]
>
>Database Administrator
>
>Shaukat Khanum Memorial Cancer Hospital & Research Centre
>
>www.shaukatkhanum.org.pk
>
>
>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Just got back from SQL*Server 2000 training...

[James Manning]

[Jeremiah Wilton]
> How about the good old "readers can block writers?"  That one never
> fails to make jaws drop.  Not just SQL Server, though.  Informix and
> Sybase too.

Is there a specific list of DBMS systems (Oracle is definitely one,
obviously) where "readers don't block writers and writers don't block
readers"?  I had heard Progress was on that list, but never confirmed.
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Just got back from SQL*Server 2000 training...

[Rachel Carmichael]

geez, that (and the truncate log problem) were there back when I worked
with Sybase 4.7

they STILL haven't fixed those problems? WHY does anyone use this?


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> How about the good old "readers can block writers?"  That one never
> fails to make jaws drop.  Not just SQL Server, though.  Informix and
> Sybase too.
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Mon, 18 Feb 2002, Jim Hawkins wrote:
> 
> > During the class, I kept a list of all the "I can't believe this is
> > really the case with SQL*Server..." items, and thought you might
> all
> > like to see it.  These are just notes I took on a Palm Pilot, so
> > forgive me if they are a litte undetailed.  I walked away from the
> > class thinking, "this is just MS Access with bells and whistles."
> > I'm not saying it doesn't have its place in the database market,
> but
> > I just don't see how it competes with Oracle and DB2.  If you even
> > want to think about scaling, you have to implement Windows
> > clustering, which is one of the hidden costs I see that Microsoft
> > doesn't come right out and say.
> > 
> > *Row size cannot span multiple 8k pages, therefore max row size =
> 8k
> > 
> > *Cannot take DB out of "archivelog" mode.  Can limit what is posted
> > to txn log, but cannot stop it.
> > 
> > *Txn logs not mirrored.  Must rely on RAID or other mirroring
> > software.
> > 
> > *Separate permissions for RI checking.  Requires two permission
> > grants if foreign key exists - one for child table and one for
> parent
> > table.  Called REFERENCES permission.
> > 
> > *Recommended that ALL production objects owned by DBO - not
> > conducive to multi-schema instances.
> > 
> > *Activities that are restricted during backups:
> > 1.  Creating or modifying databases.
> > 2.  Performing autogrow operations.
> > 3.  Creating indexes.
> > 4.  Performing nonlogged operations.
> > 5.  Shrinking a database.
> > 
> > *Backups directly to tape require the tape to be attached locally
> to SQL Server.
> > 
> > *When txn log fills up, have to just "truncate" the log in order
> for
> > processing to continue.  Leaves system vulnerable until you get a
> > full DB backup.
> > 
> > *If you have a 100GB DB that is full, your backup will be 100GB. 
> No
> > compression of backups!
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rollback Segments

[orantdba]

HI All,

My first experience with Oracle was version 4 in a Computer Class in 
1986 or 1987.  The class was taught on a Harris Minicomputer and we 
used UFI - User Friendly Interface to enter our queries.  The thing I 
remember the most was that if you issued a sql statement incorrectly and
received an error a rollback of your entire transaction occurred (uh).

I remember the insrtructor talking about the next release which was going
to have these cool new features called sql star forms and sql star reports.

Do we still call that the "good old days".

John
JOhn



[EMAIL PROTECTED] wrote:

  UFI no, but the rest... that's where I started in Oracle -- version 5--- "Conboy, Jim" <[EMAIL PROTECTED]> wrote:
  
Holy cow Mladen, what a memory!  Does anybody else remember (or admit to) using UFI?Jim**...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Conboy, Jim  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BOD
Y, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).

__Do You Yahoo!?Yahoo! Sports - Coverage of the 2002 Olympic Gameshttp://sports.yahoo.com

Re: 'index only' table vs. 'index organized' table

[Mogens Nørgaard]

The reason for the change being that the word "only" sounded negative, 
so "organized" got elected.

Mogens

Bjørn Engsig wrote:

>The term "index only tables" was replaced by "index organized table" sometime 
>during the early stages, so it might have creeped into some documentation 
>somewhere.  It's exactly the same thing and are also known as IOT's.
>
>On Thursday 14 February 2002 22:31, you wrote:
>
>>Greetings all,
>>
>>Can anybody enlighten me as to whether these things are the same or
>>different?  In Designer (v 6.0), I'm seeing a spot to specify a 'percent
>>threshold' and 'overflow tablespace' for my table, under the heading "Index
>>Only Tables".  I've heard of index-organized tables, but never 'index only'
>>tables.  The help file has been unavailing.
>>
>>Thanks!
>>
>>-Roy
>>
>>Roy Pardee
>>Programmer/Analyst
>>SWFPAC Lockheed Martin IT
>>Extension 8487
>>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Just got back from SQL*Server 2000 training...

[Reardon, Bruce (CALBBAY)]

Jeremiah,

Do you have an example / link to details of this.
Is it just long running "verbs" - eg a full table scan, that can block writers or is 
there more to this in the case of SQL Server?

Thanks,
Bruce Reardon

-Original Message-
Sent: Tuesday, 19 February 2002 8:18
To: Multiple recipients of list ORACLE-L


How about the good old "readers can block writers?"  That one never
fails to make jaws drop.  Not just SQL Server, though.  Informix and
Sybase too.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 18 Feb 2002, Jim Hawkins wrote:

> During the class, I kept a list of all the "I can't believe this is
> really the case with SQL*Server..." items, and thought you might all
> like to see it.  These are just notes I took on a Palm Pilot, so
> forgive me if they are a litte undetailed.  I walked away from the
> class thinking, "this is just MS Access with bells and whistles."
> I'm not saying it doesn't have its place in the database market, but
> I just don't see how it competes with Oracle and DB2.  If you even
> want to think about scaling, you have to implement Windows
> clustering, which is one of the hidden costs I see that Microsoft
> doesn't come right out and say.
> 
> *Row size cannot span multiple 8k pages, therefore max row size = 8k
> 
> *Cannot take DB out of "archivelog" mode.  Can limit what is posted
> to txn log, but cannot stop it.
> 
> *Txn logs not mirrored.  Must rely on RAID or other mirroring
> software.
> 
> *Separate permissions for RI checking.  Requires two permission
> grants if foreign key exists - one for child table and one for parent
> table.  Called REFERENCES permission.
> 
> *Recommended that ALL production objects owned by DBO - not
> conducive to multi-schema instances.
> 
> *Activities that are restricted during backups:
> 1.  Creating or modifying databases.
> 2.  Performing autogrow operations.
> 3.  Creating indexes.
> 4.  Performing nonlogged operations.
> 5.  Shrinking a database.
> 
> *Backups directly to tape require the tape to be attached locally to SQL Server.
> 
> *When txn log fills up, have to just "truncate" the log in order for
> processing to continue.  Leaves system vulnerable until you get a
> full DB backup.
> 
> *If you have a 100GB DB that is full, your backup will be 100GB.  No
> compression of backups!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Performance Tuning

[Mogens Nørgaard]

Commit;   :-)

And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one
of these wonderful, long and strange English names, Ixora, etc. and get the
good articles there. This is where you'll find a lot of current thinking.

Mogens

[EMAIL PROTECTED] wrote:

  Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL:http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-6595843If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up.If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book.Regards,Chris GaitOn 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:Date sent:  	Wed, 30 Jan 2002 02:25:19 -0800To: 	Multiple recipients of list ORACLE-L Send reply to:  	[EMAIL PROTECTED]Organization:   	Fat City Network Services, San Diego, California
  
Hi Everyone	I am interested in purchasing some exceptionally good book on OraclePerformance Tuning. Can anyone suggest me some very good book on OracleTunning worth purchasingBinay KumarOracle Cerified DBALondon***Binay KumarFocus 3 -Technical SupportP & O NedllyodLondon0044 207 441 1648***---The contents of this e-mail are confidential to the ordinary userof the e-mail address to which it was addressed and may also beprivileged. If you are not the addressee of this e-mail you shouldnot copy, forward, disclose or otherwise use it or any part of itin any form whatsoever. If you have received this e-mail in errorplease notify us by telephone or e-mail the sender by replying tothis message, and then delete
 this e-mail and other copies of itfrom your computer system. Thank you.We reserve the right to monitor all e-mail communications throughour network.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from
).  You mayalso send the HELP command for other information (like subscribing).

RE: Rollback Segments

[Rachel Carmichael]

UFI no, but the rest... that's where I started in Oracle -- version 5


--- "Conboy, Jim" <[EMAIL PROTECTED]> wrote:
> Holy cow Mladen, what a memory!  
> 
> Does anybody else remember (or admit to) using UFI?
> 
> Jim
> 
> **
> 
> ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Conboy, Jim
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Just got back from SQL*Server 2000 training...

[Jeremiah Wilton]

How about the good old "readers can block writers?"  That one never
fails to make jaws drop.  Not just SQL Server, though.  Informix and
Sybase too.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 18 Feb 2002, Jim Hawkins wrote:

> During the class, I kept a list of all the "I can't believe this is
> really the case with SQL*Server..." items, and thought you might all
> like to see it.  These are just notes I took on a Palm Pilot, so
> forgive me if they are a litte undetailed.  I walked away from the
> class thinking, "this is just MS Access with bells and whistles."
> I'm not saying it doesn't have its place in the database market, but
> I just don't see how it competes with Oracle and DB2.  If you even
> want to think about scaling, you have to implement Windows
> clustering, which is one of the hidden costs I see that Microsoft
> doesn't come right out and say.
> 
> *Row size cannot span multiple 8k pages, therefore max row size = 8k
> 
> *Cannot take DB out of "archivelog" mode.  Can limit what is posted
> to txn log, but cannot stop it.
> 
> *Txn logs not mirrored.  Must rely on RAID or other mirroring
> software.
> 
> *Separate permissions for RI checking.  Requires two permission
> grants if foreign key exists - one for child table and one for parent
> table.  Called REFERENCES permission.
> 
> *Recommended that ALL production objects owned by DBO - not
> conducive to multi-schema instances.
> 
> *Activities that are restricted during backups:
> 1.  Creating or modifying databases.
> 2.  Performing autogrow operations.
> 3.  Creating indexes.
> 4.  Performing nonlogged operations.
> 5.  Shrinking a database.
> 
> *Backups directly to tape require the tape to be attached locally to SQL Server.
> 
> *When txn log fills up, have to just "truncate" the log in order for
> processing to continue.  Leaves system vulnerable until you get a
> full DB backup.
> 
> *If you have a 100GB DB that is full, your backup will be 100GB.  No
> compression of backups!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Weird ODBC Issue

[Jan Pruner]

Typical table in our system lokks like:
create table ab (
ab1 NUMBER(10) NOT NULL  --row_id
ab2 DATENOT NULL--row_dt
ab3 NUMBER(1) NOT NULL  --inac_ind
ab4 NUMBER(10)  NOT NULL -- subject_id 
ab5 NUMBER(10)  NOT NULL -- type of information - from key table
ab6 date-- valid from
ab7 date-- valid to
ab8 VARCHAR2(256)   -- value

) blah blah ... ;
create unique index ab_1 on ab( ab1) ... ;

Row_id is unique number of touple but only in this table
row_dt is a "timestamp" of rowchange
and inac_ind is status of the touple (valid/invalid etc.)

So, there is no column to use for primary key.
I have to store not only 1 value but the whole history line of values of type 
ab5 for subject with id ab4.

JP

On Mon 18. February 2002 20:18, you wrote:
> Can you explain that a bit? Why would a primary key be a problem and unique
> would not. Essentially, primary key constraint is "NOT NULL" constraint +
> a unique index. The difference between the two is that primary key is a
> declared
> property of the table and, as such. can be used for logical modelling.
> Unique index,
> on the other hand is only used for access to the tables and it usually
> allows
> the NULL values. If your hardware is fast enough for the unique index, it's
> fast enough for the primary key.
>
> -Original Message-
> Sent: Monday, February 18, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I don't use primary keys on tables.
> I'm using only unique index.
>
> Primary keys are problem on slow HW.
>
> JP
>
> On Mon 18. February 2002 16:38, you wrote:
> > What good is a table without a primary key? I know that some duhsigners
> > sometimes create them, but the DBA should attempt to block shuch a
>
> duhsign.
>
> > -Original Message-
> > Sent: Monday, February 18, 2002 9:43 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Do they have primary keys? I seem to remeber that Access needed the
> > Oracle table to have a primary key on it.
> >
> > -Original Message-
> > Sent: Friday, February 15, 2002 4:43 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > No clue.  User installed.
> >
> > -Original Message-
> > Sent: Friday, February 15, 2002 4:14 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > What ODBC Driver are you using?  I've seen this with certain builds of
> > Microsoft's driver, really quirky on W98.
> >
> >
> > David A. Barbour
> > Oracle DBA, OCP
> > AISD
> > 512-414-1002
> >
> >
> >
> >
> > "Bellows,
> >
> > Bambi"   To: Multiple recipients of
> > list ORACLE-L <[EMAIL PROTECTED]>
> >  >
> > com> Subject: Weird ODBC Issue
> >
> > Sent by:
> >
> > [EMAIL PROTECTED]
> >
> > om
> >
> >
> >
> >
> >
> > 02/15/2002
> >
> > 11:34 AM
> >
> > Please respond
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I'm not exactly sure why, but I have a user who wants to see Oracle
> > tables in Access.  Whatever.  So, the user can go into our pal
> > SCOTT/TIGER no problem and look at tables from user_tables (not
> > all_tables, which I find weird, but, what the hay).  But, if the user
> > tries to go into APPS/APPS,
>
> he
>
> > can only see one table, and that one is owned by ADS.
> >
> > Anyone have similar problems?  Any clue as to a resolution?  Let me
>
> know...
>
> > Yer pal,
> > Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Disable certain users from login to database while applying Human

[Nikunj Gupta]

Pick One..

1. Change the password.. and then reset to original.
2. Revoke CREATE SESSION from user.
3. Startup database in Restrict mode.

Hope this helps..

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, February 17, 2002 11:28 PM


> Hi Gurus,
>
> I need to disable certain users from login to database while I apply the
> Human Resources Patches for our Oracle HR 11i Applications.
> Which is the best way to do it ? Should I write on-logon trigger to
disable
> or should I take away their privileges to logon to report/forms/sqlplus ?
> What about the rest of the DBA Applications administrator ? What do U guys
> do to solve the dead-lock problem (If my users access the HR tables while
I
> apply the patches, I will encounter dead-lock problem) ?
>
> Please advise. Thanks.
>
> Regds,
> New Bee
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nikunj Gupta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Weird ODBC Issue

[mkonisze]

The user needs to have select permissions on the table. I'm assuming they
are using the file,get external data, link tables and choosing ODBC data
sources method to get to the data. Does the user APPS/APPS own the tables?
Are there public synonyms on the tables? What ODBC driver are you using? I
feel the Merant drivers are the best. From my experience any user trying to
access the data this way was able to see all users.tablenames in the system
but did not have authority to access them. Access needs to define unique
keys to identify each record so it can update it. When attaching a table and
there is no PK access will ask you to pick a number of columns that will
make the record unique. Hope this helps.

> -Original Message-
> From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 12:35 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Weird ODBC Issue
> 
> I'm not exactly sure why, but I have a user who wants to see Oracle tables
> in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
> problem and look at tables from user_tables (not all_tables, which I find
> weird, but, what the hay).  But, if the user tries to go into APPS/APPS,
> he
> can only see one table, and that one is owned by ADS.
> 
> Anyone have similar problems?  Any clue as to a resolution?  Let me
> know...
> Yer pal,
> Bambi.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bellows, Bambi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Oracle Advanced Replication

[Jim Hawkins]

Pete,

While SharePlex does quite nicely in replicating DML, it is all the other stuff that 
it doesn't replicate that ruled it out for us - adding datafiles, creating 
tablespaces, etc.  If its not captured in the redo logs, SharePlex won't replicate it. 
 Basically, keeping your standby and primary in sync meta-data wise is not possible 
with SharePlex.  Just something to consider.  If you have a very active environment, 
this becomes a nightmare.

Jim
Oracle Database Administrator

Nick Wagner <[EMAIL PROTECTED]> wrote:

>Not yet, support for those objects are scheduled for this winter. 
> 
>Nick
>-Original Message-
>Sent: Friday, February 15, 2002 12:58 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Nick,
> 
>Does SharePlex support user defined object types?
> 
>Richard
>
>-Original Message-
>Sent: Friday, February 15, 2002 2:09 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>All this talk of replication is really nice.   
>
>SharePlex for Oracle, can handle master to master replication. Conflicts are
>handled via pl/sql procedures inside the database, where you can determine
>exactly what happens when there is a conflict. SharePlex performs really
>well whether it is a batch program doing massive DML operations, or many
>small OLTP type transactions.  SharePlex can handle around 300-500 DML
>operations per second in most situations... more if the hardware and
>database are tuned properly.  
>
>As for failover, it works VERY well, and can handle many of the datatypes
>that trigger based replication can not support.  LONGs and LONG RAWs
>especially...  One other thing SharePlex can replicate are sequences.  If
>you have sequences that generate PK's or unique keys, then you should
>probably replicate them, otherwise after a failure, you will have to find
>out what the highest value for those sequences are for each of your tables,
>and then rebuild all the sequences. This can take a long time, even on a
>medium sized database.  
>
>Just a couple of things to think over, when selecting a replication product.
>
>
>Nick 
>
>-Original Message- 
> ] 
>Sent: Friday, February 15, 2002 10:14 AM 
>To: Multiple recipients of list ORACLE-L 
>
>
>Pete, 
>
>I've implemented a very similar solution recently for BEA-based application.
>
>Two database servers, Multi-master replication between two databases, 1 
>minute propagation interval. Works great on our hardware, which was designed
>
>for the purpose and is pretty fast. Small transactions - OLTP stuff - seem 
>to replicate well. The same can not be said for large DML operations. So 
>far, I've been unable to tune replication so that it is capable of 
>propagated batch type changes for large amounts of data - the receiving site
>
>seems to be converting the DML based on internal algorithm, which throws my 
>indexing approach out of the window. Oracle Support has been of no help, 
>other then suggesting different indexing for failover site. 
>
>Gary Weber 
>Senior DBA 
>Charles Jones, LLC||Superior Information Services, LLC 
>609-530-1144, ext 5529 
>
>-Original Message- 
>Sent: Thursday, February 14, 2002 5:04 PM 
>To: Multiple recipients of list ORACLE-L 
>
>
>We are looking at Advanced Replication as a fail over 
>option for a web site.  Straight forward installation, 
>both boxes on the same subnet on their own dmz. The 
>servers will be located on the same rack in the 
>computer room. Very few tables storing data from an 
>application that is tracking click through data. 
>
>Does anyone see any flaws with the basic plan?  Any 
>hidden 'features' that we may run into? 
>
>Thanks 
>
>
>
>= 
>Pete Barnett 
>Lead Database Administrator 
>The Regence Group 
>[EMAIL PROTECTED] 
>
>__ 
>Do You Yahoo!? 
>Send FREE Valentine eCards with Yahoo! Greetings! 
>http://greetings.yahoo.com   
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>  
>-- 
>Author: Peter Barnett 
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
>San Diego, California-- Public Internet access / Mailing Lists 
> 
>To REMOVE yourself from this mailing list, send an E-Mail message 
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
>the message BODY, include a line containing: UNSUB ORACLE-L 
>(or the name of mailing list you want to be removed from).  You may 
>also send the HELP command for other information (like subscribing). 
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>  
>-- 
>Author: DENNIS WILLIAMS 
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
>San Diego, California-- Public Internet access / Mailing Lists 
>-

Just got back from SQL*Server 2000 training...

[Jim Hawkins]

During the class, I kept a list of all the "I can't believe this is really the case 
with SQL*Server..." items, and thought you might all like to see it.  These are just 
notes I took on a Palm Pilot, so forgive me if they are a litte undetailed.  I walked 
away from the class thinking, "this is just MS Access with bells and whistles."  I'm 
not saying it doesn't have its place in the database market, but I just don't see how 
it competes with Oracle and DB2.  If you even want to think about scaling, you have to 
implement Windows clustering, which is one of the hidden costs I see that Microsoft 
doesn't come right out and say.

*Row size cannot span multiple 8k pages, therefore max row size = 8k

*Cannot take DB out of "archivelog" mode.  Can limit what is posted to txn log, but 
cannot stop it.

*Txn logs not mirrored.  Must rely on RAID or other mirroring software.

*Separate permissions for RI checking.  Requires two permission grants if foreign key 
exists - one for child table and one for parent table.  Called REFERENCES permission.

*Recommended that ALL production objects owned by DBO - not conducive to multi-schema 
instances.

*Activities that are restricted during backups:
1.  Creating or modifying databases.
2.  Performing autogrow operations.
3.  Creating indexes.
4.  Performing nonlogged operations.
5.  Shrinking a database.

*Backups directly to tape require the tape to be attached locally to SQL Server.

*When txn log fills up, have to just "truncate" the log in order for processing to 
continue.  Leaves system vulnerable until you get a full DB backup.

*If you have a 100GB DB that is full, your backup will be 100GB.  No compression of 
backups!


Jim
Oracle Database Administrator
-- 
_
Jim Hawkins
Oracle Database Administrator
[EMAIL PROTECTED]



__
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Advanced Replication

[Nick Wagner]

Title: RE: Oracle Advanced Replication



Not 
yet, support for those objects are scheduled for this winter. 

 
Nick
-Original Message-From: Ji, Richard 
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 
12:58 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: Oracle Advanced Replication
Nick,
 
Does SharePlex support user defined object 
types?
 
Richard

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle Advanced Replication
  All this talk of replication is really nice.   
  
  SharePlex for Oracle, can handle master to master replication. 
  Conflicts are handled via pl/sql procedures inside the database, where you can 
  determine exactly what happens when there is a conflict. SharePlex performs 
  really well whether it is a batch program doing massive DML operations, or 
  many small OLTP type transactions.  SharePlex can handle around 300-500 
  DML operations per second in most situations... more if the hardware and 
  database are tuned properly.  
  As for failover, it works VERY well, and can handle many of 
  the datatypes that trigger based replication can not support.  LONGs and 
  LONG RAWs especially...  One other thing SharePlex can replicate are 
  sequences.  If you have sequences that generate PK's or unique keys, then 
  you should probably replicate them, otherwise after a failure, you will have 
  to find out what the highest value for those sequences are for each of your 
  tables, and then rebuild all the sequences. This can take a long time, even on 
  a medium sized database.  
  Just a couple of things to think over, when selecting a 
  replication product. 
  Nick 
  -Original Message- From: Gary 
  Weber [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication 
  Pete, 
  I've implemented a very similar solution recently for 
  BEA-based application. Two database servers, 
  Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was 
  designed for the purpose and is pretty fast. Small 
  transactions - OLTP stuff - seem to replicate well. 
  The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable 
  of propagated batch type changes for large amounts of 
  data - the receiving site seems to be converting the 
  DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no 
  help, other then suggesting different indexing for 
  failover site. 
  Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 
  -Original Message- Sent: 
  Thursday, February 14, 2002 5:04 PM To: Multiple 
  recipients of list ORACLE-L 
  We are looking at Advanced Replication as a fail over 
  option for a web site.  Straight forward 
  installation, both boxes on the same subnet on their 
  own dmz. The servers will be located on the same rack 
  in the computer room. Very few tables storing data 
  from an application that is tracking click through 
  data. 
  Does anyone see any flaws with the basic plan?  
  Any hidden 'features' that we may run into? 

  Thanks 
  = Pete Barnett Lead Database Administrator The Regence 
  Group [EMAIL PROTECTED] 
  __ 
  Do You Yahoo!? Send FREE Valentine 
  eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: Peter Barnett 
    INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: DENNIS WILLIAMS   INET: 
  [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other 

RE: Weird ODBC Issue

[Gogala, Mladen]

Can you explain that a bit? Why would a primary key be a problem and unique
would not. Essentially, primary key constraint is "NOT NULL" constraint + 
a unique index. The difference between the two is that primary key is a
declared
property of the table and, as such. can be used for logical modelling.
Unique index,
on the other hand is only used for access to the tables and it usually
allows 
the NULL values. If your hardware is fast enough for the unique index, it's 
fast enough for the primary key.

-Original Message-
Sent: Monday, February 18, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L


I don't use primary keys on tables.
I'm using only unique index.

Primary keys are problem on slow HW.

JP

On Mon 18. February 2002 16:38, you wrote:
> What good is a table without a primary key? I know that some duhsigners
> sometimes create them, but the DBA should attempt to block shuch a
duhsign.
>
> -Original Message-
> Sent: Monday, February 18, 2002 9:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Do they have primary keys? I seem to remeber that Access needed the Oracle
> table to have a primary key on it.
>
> -Original Message-
> Sent: Friday, February 15, 2002 4:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> No clue.  User installed.
>
> -Original Message-
> Sent: Friday, February 15, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What ODBC Driver are you using?  I've seen this with certain builds of
> Microsoft's driver, really quirky on W98.
>
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
>
>
>
> "Bellows,
>
> Bambi"   To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> 
> com> Subject: Weird ODBC Issue
>
> Sent by:
>
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 02/15/2002
>
> 11:34 AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> I'm not exactly sure why, but I have a user who wants to see Oracle tables
> in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
> problem and look at tables from user_tables (not all_tables, which I find
> weird, but, what the hay).  But, if the user tries to go into APPS/APPS,
he
> can only see one table, and that one is owned by ADS.
>
> Anyone have similar problems?  Any clue as to a resolution?  Let me
know...
> Yer pal,
> Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Rollback Segments

[Conboy, Jim]

Holy cow Mladen, what a memory!  

Does anybody else remember (or admit to) using UFI?

Jim

**

...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Conboy, Jim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Async I/O on Sun Solaris

[Karniotis, Stephen]

I don't think you need raw devices for asynch I/O.  We used asynch I/O
without raw for years quite successfully.  Veritas vxfs with Q I/O also
helped.

You need raw if you are going to implement Oracle9i RAC or Oracle Parallel
Server.  If not the issue, I would highly recommend asynch I/O over
synchronous I/O to eliminate the intercommunication between the slave
processes.  Not to mention the memory consumption.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Monday, February 18, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Async I/O on Sun Solaris

Works like a charm against qio files as well.   May work on vxfs (I 
haven't checked).  It may be a metter of definition, but I wouldn't 
characterize not working on ufs as not working on Solaris.  That seems 
an overly sweeping statement to me.

George


On Saturday, February 16, 2002, at 09:03 PM, Jared Still wrote:

>
> Well, no not actually.
>
> You must use raw devices for async IO to work with Oracle on Solaris.
>
> It's pretty easy to prove this using svrmgrl and truss.  If you dig 
> around
> in the archives you may find some references to it, or search on google
> as there are a couple of sites that archive this list.
>
> With cooked filesystems, you won't get async IO on Solaris, at least
> on 2.6 and 2.7.  Not sure about 2.8.
>
> Jared
>
> On Saturday 16 February 2002 16:08, George Schlossnagle wrote:
>> Huh?
>>
>> asynch_io works fine on Solaris.  At least on Solaris 2.6, 7, and 8.
>>
>> On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote:
>>> Async IO on Solaris does not work - or at least it has
>>> not worked with lower OS releases.  Someone might have
>>> more up to date information on Solaris 8.
>>>
>>>
>>> --- "Daiminger, Helmut"
>>>
>>> <[EMAIL PROTECTED]> wrote:
 Hi!

 How can I find out whether my operating system
 supports async I/O? Can I
 turn this on/off?

 What is the relation between async I/O and the usage
 of Oracle I/O slaves?

 Can anybody shed some light on this?

 This is 8.1.7 on Sun Solaris 8.

 Thanks,
 Helmut
>>>
>>> =
>>> Pete Barnett
>>> Lead Database Administrator
>>> The Regence Group
>>> [EMAIL PROTECTED]
>>>
>>> __
>>> Do You Yahoo!?
>>> Got something to say? Say it better with Yahoo! Video Mail
>>> http://mail.yahoo.com
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>> --
>>> Author: Peter Barnett
>>>   INET: [EMAIL PROTECTED]
>>>
>>> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>> San Diego, California-- Public Internet access / Mailing Lists
>>> 
>>> To REMOVE yourself from this mailing list, send an E-Mail message
>>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>> the message BODY, include a line containing: UNSUB ORACLE-L
>>> (or the name of mailing list you want to be removed from).  You may
>>> also send the HELP command for other information (like subscribing).
>>
>> // George Schlossnagle
>> // 1024D/1100A5A0? 1370 F70A 9365 96C9 2F5E?56C2 B2B9 262F 1100 A5A0
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
// George Schlossnagle
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 53

RE: Rollback Segments

[Gogala, Mladen]

It's very simple: don't use rollback segments. Set up your UNDO_TABLESPACE
and let oracle handle it. If you use oracle managed datafiles, oracle will 
create as much room as it needs.  The parameters that you need to look at
are:

DB_CREATE_FILE_DEST 
DB_CREATE_ONLINE_LOG_DEST_n 
UNDO_MANAGEMENT 
UNDO_TABLESPACE 
UNDO_RETENTION 
UNDO_SUPPRESS_ERRORS 

The UNDO_MANAGEMENT=auto setting will make oracle manage it's own rollback
structures
and you will not see the rollback segments. It is just like the BI file
(does anybody
still remember VAX/VMS, ORACLE$BI, IOR and ODT?) In particular, that means
that you will
not have to worry about the rollback segments ever again.

-Original Message-
Sent: Monday, February 18, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L


Hello DBAs

Is there a command that tells me which rollback segment is being 
used by current transaction?
Also, can you force a session to use particular rollback segment? I 
have used in the past the command:

set transaction use rollback segment rbs_01 

but the named rollback segment seemed to be used until the end of 
tranasction. After a commit or rollback a different rollback segment 
could have been used by Oracle. I wonder if there is a way to make 
sure that once a user logs in, a particular rollback segment is used.

Thanks

Witold

==
Witold Iwaniec
Sr Software Developer
NovaLIS Technologies
[EMAIL PROTECTED]
http://www.novalistech.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Rollback Segments

[Baker, Barbara]

Witold:
This will show which rollback segment is being used by a current transation.
(Also shows current sql as well as a time stamp.  You can get rid of that
stuff if you don't need it.)

There's no way I know of to force a user to a particular rollback segment.
Barb




select TO_CHAR(SYSDATE,'DD-MON-:HH24:MI:SS'),
   osuser o,   username u,
   segment_name s, substr(sa.sql_text,1,500) txt
from v$session s,
 v$transaction t,
 dba_rollback_segs r,
 v$sqlarea sa
where s.taddr=t.addr
and   t.xidusn=r.segment_id(+)
and   s.sql_address=sa.address(+)
/

> --
> From: Witold Iwaniec[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, February 18, 2002 8:33 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Rollback Segments
> 
> Hello DBAs
> 
> Is there a command that tells me which rollback segment is being 
> used by current transaction?
> Also, can you force a session to use particular rollback segment? I 
> have used in the past the command:
> 
> set transaction use rollback segment rbs_01 
> 
> but the named rollback segment seemed to be used until the end of 
> tranasction. After a commit or rollback a different rollback segment 
> could have been used by Oracle. I wonder if there is a way to make 
> sure that once a user logs in, a particular rollback segment is used.
> 
> Thanks
> 
> Witold
> 
> ==
> Witold Iwaniec
> Sr Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED]
> http://www.novalistech.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Weird ODBC Issue

[Jan Pruner]

I don't use primary keys on tables.
I'm using only unique index.

Primary keys are problem on slow HW.

JP

On Mon 18. February 2002 16:38, you wrote:
> What good is a table without a primary key? I know that some duhsigners
> sometimes create them, but the DBA should attempt to block shuch a duhsign.
>
> -Original Message-
> Sent: Monday, February 18, 2002 9:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Do they have primary keys? I seem to remeber that Access needed the Oracle
> table to have a primary key on it.
>
> -Original Message-
> Sent: Friday, February 15, 2002 4:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> No clue.  User installed.
>
> -Original Message-
> Sent: Friday, February 15, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What ODBC Driver are you using?  I've seen this with certain builds of
> Microsoft's driver, really quirky on W98.
>
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
>
>
>
> "Bellows,
>
> Bambi"   To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> 
> com> Subject: Weird ODBC Issue
>
> Sent by:
>
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 02/15/2002
>
> 11:34 AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> I'm not exactly sure why, but I have a user who wants to see Oracle tables
> in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
> problem and look at tables from user_tables (not all_tables, which I find
> weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
> can only see one table, and that one is owned by ADS.
>
> Anyone have similar problems?  Any clue as to a resolution?  Let me know...
> Yer pal,
> Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Async I/O on Sun Solaris

[George Schlossnagle]

Works like a charm against qio files as well.   May work on vxfs (I 
haven't checked).  It may be a metter of definition, but I wouldn't 
characterize not working on ufs as not working on Solaris.  That seems 
an overly sweeping statement to me.

George


On Saturday, February 16, 2002, at 09:03 PM, Jared Still wrote:

>
> Well, no not actually.
>
> You must use raw devices for async IO to work with Oracle on Solaris.
>
> It's pretty easy to prove this using svrmgrl and truss.  If you dig 
> around
> in the archives you may find some references to it, or search on google
> as there are a couple of sites that archive this list.
>
> With cooked filesystems, you won't get async IO on Solaris, at least
> on 2.6 and 2.7.  Not sure about 2.8.
>
> Jared
>
> On Saturday 16 February 2002 16:08, George Schlossnagle wrote:
>> Huh?
>>
>> asynch_io works fine on Solaris.  At least on Solaris 2.6, 7, and 8.
>>
>> On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote:
>>> Async IO on Solaris does not work - or at least it has
>>> not worked with lower OS releases.  Someone might have
>>> more up to date information on Solaris 8.
>>>
>>>
>>> --- "Daiminger, Helmut"
>>>
>>> <[EMAIL PROTECTED]> wrote:
 Hi!

 How can I find out whether my operating system
 supports async I/O? Can I
 turn this on/off?

 What is the relation between async I/O and the usage
 of Oracle I/O slaves?

 Can anybody shed some light on this?

 This is 8.1.7 on Sun Solaris 8.

 Thanks,
 Helmut
>>>
>>> =
>>> Pete Barnett
>>> Lead Database Administrator
>>> The Regence Group
>>> [EMAIL PROTECTED]
>>>
>>> __
>>> Do You Yahoo!?
>>> Got something to say? Say it better with Yahoo! Video Mail
>>> http://mail.yahoo.com
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>> --
>>> Author: Peter Barnett
>>>   INET: [EMAIL PROTECTED]
>>>
>>> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>> San Diego, California-- Public Internet access / Mailing Lists
>>> 
>>> To REMOVE yourself from this mailing list, send an E-Mail message
>>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>> the message BODY, include a line containing: UNSUB ORACLE-L
>>> (or the name of mailing list you want to be removed from).  You may
>>> also send the HELP command for other information (like subscribing).
>>
>> // George Schlossnagle
>> // 1024D/1100A5A0† 1370 F70A 9365 96C9 2F5E†56C2 B2B9 262F 1100 A5A0
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
// George Schlossnagle
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rollback Segments

[Connor McDonald]

select r.name 
from v$rollname r, v$session s, v$lock l
where r.usn = trunc(l.id1/65536)
  and l.type = 'TX'
  and l.sid = s.sid
  and s.sid = 

 --- Witold Iwaniec <[EMAIL PROTECTED]> wrote:
> Hello DBAs
> 
> Is there a command that tells me which rollback
> segment is being 
> used by current transaction?
> Also, can you force a session to use particular
> rollback segment? I 
> have used in the past the command:
> 
> set transaction use rollback segment rbs_01 
> 
> but the named rollback segment seemed to be used
> until the end of 
> tranasction. After a commit or rollback a different
> rollback segment 
> could have been used by Oracle. I wonder if there is
> a way to make 
> sure that once a user logs in, a particular rollback
> segment is used.
> 
> Thanks
> 
> Witold
> 
> ==
> Witold Iwaniec
> Sr Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED]
> http://www.novalistech.com
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rollback Segments

[orantdba]

Hi Witold,

This is "exactly" the way it is documented to work.  After each
commit you must reissue the

set transaction use rollback segment rbs_01 

statement.

John

[EMAIL PROTECTED] wrote:

>Hello DBAs
>
>Is there a command that tells me which rollback segment is being 
>used by current transaction?
>Also, can you force a session to use particular rollback segment? I 
>have used in the past the command:
>
>set transaction use rollback segment rbs_01 
>
>but the named rollback segment seemed to be used until the end of 
>tranasction. After a commit or rollback a different rollback segment 
>could have been used by Oracle. I wonder if there is a way to make 
>sure that once a user logs in, a particular rollback segment is used.
>
>Thanks
>
>Witold
>
>==
>Witold Iwaniec
>Sr Software Developer
>NovaLIS Technologies
>[EMAIL PROTECTED]
>http://www.novalistech.com
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle Advanced Replication

[Rahul Dandekar]

Adar,

How do you take care of backups?
I mean, what kind of backups do you take? How are you addressing the
scenario of incomplete recovery?
Following are some of my doubts.

1.  What kind of Backup should be taken? Online or Offline? Does
replication would generate substantially higher redo?

Ø  Lets analyze the possibility of Online Backups :

q   Redo Generation
Apparently, a database in replicated environment would generate
significantly more redo if the same database was not in replicated
environment. Is there sufficient bandwidth (diskspace, tapes) for the
additional redo?

q   Need for Complete Recovery
If we need to recover one of the databases then it should be complete
recovery. Incomplete recovery will not be permissible since the databases
are in replicated environment. (Lets not consider 'All' the databases
restored from their backups till a certain SCN.)

q   Quick Recovery
Also, the recovery must be done quickly. This is because as one of the
databases in replicated environment is down, the DEFTRAN queues in other
master sites would start getting larger and larger and it might reach to a
stage where we would also need to do the 'Offline Instantiation' for
replicated objects.

q   When complete ercovery is not possible….
In case complete recovery is not possible then we need to recover the
databases and then perform 'Offline Instantiation' for replicated objects.

Ø  What if we take Offline Backups :

q   For a simple recovery, entire database needs to be restored from the
cold backup.

q   'Offline Instantiation' needs to be performed each time media
recovery is performed. This is because media recovery would always bring the
database till the time of cold backup and other master sites would be ahead
in time.

q   In case datafiles affecting 'only' those tablespaces which have
objects which are replicated are needing recovery then recovery can be done
by using transportable tablespaces feature.

   i.  First, we would
need to drop those tablespaces from the database.

 ii.  We can then drop
replication for this master group.

iii.  Transport and
Plug-in the tablespace's datafile from other master site.

   iv.  Rebuild replication.

TIA,

+Rahul


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, February 17, 2002 11:18 AM


> Hello Peter
>
> We implemented Advance Replication as part of dealing room.
> We defined master to master real-time replication.
> Synchronous, 2 phase commit, from the primary to the backup DB as each
deal
> is a
> lot of money and standby database will not reflect updates since the last
> log file was archived.
> Since we need master to master we defined the replication from the backup
DB
> to the primary as asynchronous even though no body is using the backup DB.
>
> I think that the cases are similar.
>
> Points to take care off:
>
> 1) Prepare a script to drop the replication on each machine if the other
> machine fails.
> Lets say that you got a CPU fault on the primary and you switch to the
> backup.
> In this case you might get off with the asynchronous replication as
> updates will
> accumulate in the backup machine until the CPU is replaced. When the
> primary
> will come up the replication will update the primary DB with all the
> changes.
> Now, if the disk drive fails on the primary you will probably have to
> rebuild the
> DB from scratch (or from export from the backup). In this case there
is
> no point
> to accumulate updates in the backup machine.
>Also, if the backup machine fails you do not want the updates to the
> primary to
> fail. In this case you drop replication and go on working.
>
> 2) Ensure that the log files, rollback segments, datafiles (size) and all
> init ora are the
> same on both machines. You do not want to swap to the backup only to
> find that
> the parameters are ok for one connection (replication) but fails when
> working as
> a primary DB.
>
> 3) Hey, what happens if the air condition stopped working and ALL the
> machines heats
> up and stopped working. Both machine will fail.
>Worse if that room gets on fire you are out of luck.
>Move the backup machine at least a couple of rooms away.
>
> 4) Use stand by database in another building so in case of a serious
problem
> (11 seqptember)
> you will not lose all your data, only the data since the last archive.
>
> 5) Test, Test, Test again all failure scenarios, and test again each
month,
> quarter or whatever.
>
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Peter Barnett [SMTP:[EMAIL PROTECTED]]
> > Sent: Fri, February 15, 2002 1:04 AM
> > To: Multiple recipi

RE: Weird ODBC Issue

[DBarbour]

Welcome to the real world Mladen.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

"Gogala,   

Mladen"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: Weird ODBC Issue 

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

02/18/2002 

09:38 AM   

Please respond 

to ORACLE-L

   

   





What good is a table without a primary key? I know that some duhsigners
sometimes create them, but the DBA should attempt to block shuch a duhsign.

-Original Message-
Sent: Monday, February 18, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


Do they have primary keys? I seem to remeber that Access needed the Oracle
table to have a primary key on it.

-Original Message-
Sent: Friday, February 15, 2002 4:43 PM
To: Multiple recipients of list ORACLE-L


No clue.  User installed.

-Original Message-
Sent: Friday, February 15, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L


What ODBC Driver are you using?  I've seen this with certain builds of
Microsoft's driver, really quirky on W98.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




"Bellows,

Bambi"   To: Multiple recipients of
list
ORACLE-L <[EMAIL PROTECTED]>
 Subject: Weird ODBC Issue

Sent by:

[EMAIL PROTECTED]

om





02/15/2002

11:34 AM

Please respond

to ORACLE-L









I'm not exactly sure why, but I have a user who wants to see Oracle tables
in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
problem and look at tables from user_tables (not all_tables, which I find
weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
can only see one table, and that one is owned by ADS.

Anyone have similar problems?  Any clue as to a resolution?  Let me know...
Yer pal,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Di

RE: Weird ODBC Issue

[Gogala, Mladen]

What good is a table without a primary key? I know that some duhsigners
sometimes create them, but the DBA should attempt to block shuch a duhsign.

-Original Message-
Sent: Monday, February 18, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


Do they have primary keys? I seem to remeber that Access needed the Oracle
table to have a primary key on it.

-Original Message-
Sent: Friday, February 15, 2002 4:43 PM
To: Multiple recipients of list ORACLE-L


No clue.  User installed.

-Original Message-
Sent: Friday, February 15, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L


What ODBC Driver are you using?  I've seen this with certain builds of
Microsoft's driver, really quirky on W98.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

"Bellows,

Bambi"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
 Subject: Weird ODBC Issue

Sent by:

[EMAIL PROTECTED]

om

 

 

02/15/2002

11:34 AM

Please respond

to ORACLE-L

 

 





I'm not exactly sure why, but I have a user who wants to see Oracle tables
in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
problem and look at tables from user_tables (not all_tables, which I find
weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
can only see one table, and that one is owned by ADS.

Anyone have similar problems?  Any clue as to a resolution?  Let me know...
Yer pal,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Rollback Segments

[Witold Iwaniec]

Hello DBAs

Is there a command that tells me which rollback segment is being 
used by current transaction?
Also, can you force a session to use particular rollback segment? I 
have used in the past the command:

set transaction use rollback segment rbs_01 

but the named rollback segment seemed to be used until the end of 
tranasction. After a commit or rollback a different rollback segment 
could have been used by Oracle. I wonder if there is a way to make 
sure that once a user logs in, a particular rollback segment is used.

Thanks

Witold

==
Witold Iwaniec
Sr Software Developer
NovaLIS Technologies
[EMAIL PROTECTED]
http://www.novalistech.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

test - pl delete

[Praful Thakkar]

 
 

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praful Thakkar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Weird ODBC Issue

[Shaw John-P55297]

Do they have primary keys? I seem to remeber that Access needed the Oracle
table to have a primary key on it.

-Original Message-
Sent: Friday, February 15, 2002 4:43 PM
To: Multiple recipients of list ORACLE-L


No clue.  User installed.

-Original Message-
Sent: Friday, February 15, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L


What ODBC Driver are you using?  I've seen this with certain builds of
Microsoft's driver, really quirky on W98.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

"Bellows,

Bambi"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
 Subject: Weird ODBC Issue

Sent by:

[EMAIL PROTECTED]

om

 

 

02/15/2002

11:34 AM

Please respond

to ORACLE-L

 

 





I'm not exactly sure why, but I have a user who wants to see Oracle tables
in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
problem and look at tables from user_tables (not all_tables, which I find
weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
can only see one table, and that one is owned by ADS.

Anyone have similar problems?  Any clue as to a resolution?  Let me know...
Yer pal,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find avg data blocks for an index.

[DENNIS WILLIAMS]

Ayyappan - What I have found useful for estimating Index size is to analyze
the index and use the LEAF_BLOCKS column in USE_INDEXES. This is usually
close enough for estimation purposes, and it is easy to join with other
tables.
Another thought, you may want to run Don Burleson's script,
http://www.dba-oracle.com/art_index1.htm, and rebuild any indexes it
suggests. Some of these indexes may be taking up too many blocks, and that
will throw off your estimates.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, February 18, 2002 2:13 AM
To: Multiple recipients of list ORACLE-L


Hi 

I want to estimate the size for a growing database for 2004, I want to find
the avg bytes occupied by an index. how to find & calculate it.

Ayyappan.S


This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ayyappan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Disable certain users from login to database while applying H

[Jeff Hyde]

Title: RE: Disable certain users from login to database while applying H



Try 
getting the original password values for the users concerned from dba_users - 
make an exact copy of the "values" field for each user. 
 
Now 
change the password for the users concerned.
 
When 
you want to re-establish the original password use:-
 
alter 
user  identified by values 'put original values string here' 
(remember to use the quotes).
 
This 
will reset the original password without you having to know what it 
was.
 
Jeff
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, February 18, 2002 
  01:03To: Multiple recipients of list ORACLE-LSubject: 
  RE: Disable certain users from login to database while applying 
  H
  But then how do you know what to change it back to?  I'd 
  steer away from this - head w/ the revoke create session 
  -Original Message- From: Abdul 
  Aleem [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, February 18, 2002 3:53 AM 
  To: Multiple recipients of list ORACLE-L Subject: RE: Disable certain users from login to database while 
  applying H 
  How about changing their password for the time being. 
  
  Aleem 
   -Original Message- Sent:   Monday, February 18, 2002 12:28 PM To: Multiple recipients of list ORACLE-L 
  Subject:    Disable 
  certain users from login to database while applying Human 
  Hi Gurus, 
  I need to disable certain users from login to database while I 
  apply the Human Resources Patches for our Oracle HR 11i Applications. Which is 
  the best way to do it ? Should I write on-logon trigger to disable or should I 
  take away their privileges to logon to report/forms/sqlplus ? What about the 
  rest of the DBA Applications administrator ? What do U guys do to solve the 
  dead-lock problem (If my users access the HR tables while I apply the patches, 
  I will encounter dead-lock problem) ? 
  Please advise. Thanks. 
  Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: CHAN Chor Ling Catherine 
  (CSC)   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed from).  You 
  may also send the HELP command for other information (like 
  subscribing).
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: Abdul Aleem   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed from).  You 
  may also send the HELP command for other information (like 
  subscribing).

RE: Disable certain users from login to database while applying H

[Szecsy Tamas]

Title: RE: Disable certain users from login to database while applying H



I 
agree with using the revoke session solution.
 
All 
the same you can change a user's password to something else and change it back 
again without ever knowing what it was:
 
1. 
select 'alter user scott identified by values '''||password||''';' 
    
from 
dba_users    
where username = 'SCOTT';
  
put away the result
 
2. 
change the password to something else
 
3. 
change the password back again to what it was previously:
 
   execute the result of the first 
point.
 
Regards,
Tamas 
Szecsy

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 18, 2002 
  14:03To: Multiple recipients of list ORACLE-LSubject: 
  RE: Disable certain users from login to database while applying 
  H
  But then how do you know what to change it back to?  I'd 
  steer away from this - head w/ the revoke create session 

RE: Disable certain users from login to database while applying H

[michaelcupp]

Title: RE: Disable certain users from login to database while applying H





But then how do you know what to change it back to?  I'd steer away from this - head w/ the revoke create session


-Original Message-
From: Abdul Aleem [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 3:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Disable certain users from login to database while applying H



How about changing their password for the time being.


Aleem


 -Original Message-
Sent:   Monday, February 18, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Subject:    Disable certain users from login to database while applying
Human


Hi Gurus,


I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? 

Please advise. Thanks.


Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).

RE: Disable certain users from login to database while applying Human

[Seefelt, Beth]

Startup the database in restricted mode -

startup restrict;

-Original Message-
Sent: Monday, February 18, 2002 2:28 AM
To: Multiple recipients of list ORACLE-L
Human


Hi Gurus,

I need to disable certain users from login to database while I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon trigger to disable
or should I take away their privileges to logon to report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ? What do U guys
do to solve the dead-lock problem (If my users access the HR tables while I
apply the patches, I will encounter dead-lock problem) ? 

Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8i Concept PCTFREE & PCTUSED are 0

[אדר יחיאל]

Hello Sinardy

PCTUSED means that:
After a block was filled with records and the free space in the block
is less then pctfree the block is no longer available for further inserts.
If however, the data falls beneath PCTUSED the block became again 
available for inserts.

In your example, block will never again became available, even if empty,
because: After a data block becomes full as determined by PCTFREE, Oracle
does not consider the block for the insertion of new rows until the
percentage of the block being used falls below the parameter PCTUSED. 


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, February 18, 2002 11:08 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  8i Concept PCTFREE & PCTUSED are 0
> 
> Hi all,
> 
> Oracle 8i (81600)
> 
> I create user Panadol and give unlimited quota on TBS.
> 
> as Panadol I create 1 table like this:
> 
> SQL> CREATE TABLE mytable(
>   2 col1 char(3),
>   3 col2 char(4),
>   4 col4 varchar2(4)
>   5  )
>   6  PCTFREE 0
>   7  PCTUSED 0
>   8  STORAGE (
>   9INITIAL 20K
>  10NEXT 20K
>  11PCTINCREASE 0
>  12MAXEXTENTS 10
>  13  )
>  14  ;
> 
> Table created.
> 
> SQL> insert into mytable values('abc', 'abcd', 'a');
> 
> 1 row created.
> 
> SQL> commit;
> 
> 
> I don't understand That table PCTUSED is 0 ? where Oracle keep those
> data ?
> 
> Look at this:
> 
> SQL> select * from mytable;
> 
> COL COL2 COL4
> ---  
> abc abcd a
> 
> 
> 
> Sinardy
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Sinard Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ERR: ORA-04031 unable to allocate

[cjgait]

Take a look at Metalink note :1076835.6. You may be running out of 
underlying OS user process memory. Changing some kernel parameters 
may help. 

One other thing to check: Is this query going parallel (i.e. is the degree of 
any of the underlying objects > 1 and you are seeing parallel query 
process slaves showing up on the server?).

Regards,
Chris Gait

On 14 Feb 2002, at 16:03, Baker, Barbara wrote:

Date sent:  Thu, 14 Feb 2002 16:03:32 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> Oracle 8.0.5
> Solaris 2.6
> 
> List:
> One of our users is getting this error message running a query:
> 
> ERROR:
> ORA-04031: unable to allocate 4194304 bytes of shared memory ("shared
> pool","unknown object","cursor work he","KKRH Hash Table")
> 
> The query is very simple (see below).  Happens consistently.  Error occurs
> after about 1 minute of execution.  No other problems in the database (no
> errors in alert, etc.)
> 
> I'm seeing latch wait this for the sid involved:
> 
> 
> 
> 
> 
>   SID EVENTP1TEXT  P1 P2TEXT P2 P3TEXT
> P3
> -  -- ---   
> --
>   409 latch free   address 2147519876 number 59 tries
> 0
> 1 pmon timer   duration   300 0
> 0
> 6 smon timer   sleep time 300 failed  0
> 0
> 
> 
> 
> and then I see this for the same sid in v$lock (resource is type+id1+id2,
> query is from Steve Adams' site)
> 
> 
> 
> 
> RESOURCE  NSID  SID HOLDING WANTINGSECONDS
>  -  --- --- --
> CU--1595636348-0   409  409   X  0
> RT-1-0   4 LGWR   X  0
> TS-1-8388610 6 SMON  SX  55604
> 
> 
> 
> According to Anjo Kolk's description, a CU is a Bind enqueue.  Does this
> mean I'm running out of open_cursors?? (And if so, why are no other
> processes affected?)
> 
> Anyone seen this one before?
> 
> Thanks for any help!
> Barb
> 
> 
> Here's the query:
> 
> select distinct
> v.sales_id,
> a.receiver,
> a.adno,
> a.unet,
> a.vno,
> a.enddate
> from advdb.ad a,
>  advdb.pub p,
>  advdb.voluntary_reps v
> where a.adno = p.adno
> and a.vno = p.vno
> and a.receiver = v.name
> and p.state = 'VAR'
> and p.vnoflag = 'Y'
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Baker, Barbara
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: script to populate tables, i just wrote one

[P Jeram]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 1:28 PM


> List,
> i just finished writing a script to generate random data to populate
> tables for load testing... the script takes into account the check
> constraint
> of a column and generate the correct/valid values. Also, a DEFAULT value
of
> a column is also considered and generated accordingly. values for ALL the
> columns
> are generated (to keep it simple). I'm sure there are many scripts like
this
> on available on the
> web.. but hey!!! i needed to jog the pl/sql side of my brain ;-))
>
> mail me privately to request the script ...
>
> regards
>
> PS: please do not fill the list with "me too" messages
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: P Jeram
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Disable certain users from login to database while applying H

[Arslan Dar]

Title: RE: Disable certain users from login to database while applying H





Alter user  Account Lock;
This statement will lock their accounts,


And the next time the locked user tries to login, it will get following error


ORA-28000: the account is locked



Hope this helps,


Arslan Zaheer Dar
[EMAIL PROTECTED]
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
www.shaukatkhanum.org.pk



-Original Message-
From: Abdul Aleem [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Disable certain users from login to database while applying H


How about changing their password for the time being.


Aleem


 -Original Message-
Sent:   Monday, February 18, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Subject:    Disable certain users from login to database while applying
Human


Hi Gurus,


I need to disable certain users from login to database while I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon trigger to disable
or should I take away their privileges to logon to report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ? What do U guys
do to solve the dead-lock problem (If my users access the HR tables while I
apply the patches, I will encounter dead-lock problem) ? 


Please advise. Thanks.


Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: help needed

[Shishir]

Thanx Adary !
  I could not think in such simple way .
Anyway thanx again..


Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 2:13 PM


> As simple as:
>
> select * from
> (select 'ptMASTER' , 'Master' col2 from dual
>  union
>  select 'ptMKT' , 'Market' from dual
>  union
>  select 'ptOFFICE' , 'Office' from dual)
>
>
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Shishir [SMTP:[EMAIL PROTECTED]]
> > Sent: Mon, February 18, 2002 9:23 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: help needed
> >
> > Hi folks !
> >   I have some constants value   i want to show then in tabular format
with
> > two cloumns and n rows
> >   is it possible to get them through in that way by manipulating SQL
> > statements i dont want to define user defined data type
> >  i want the sql to be written in way that it ud give me result like :
> >col1 col2
> >   'ptMASTER'  'Master',
> >   'ptMKT' 'Market',
> >   'ptOFFICE''Office',
> >   'ptPDCR'   'Producer',
> >   'ptQUOTE' 'Quote',
> >   'ptREGL'   'Regulator',
> >   'ptROLE'   'Role',
> >
> > these are  constant values and not stored in database at all .I ud
> > appreciate any help from u gurus.
> >
> > thanx in advance
> > Shishir Kumar Mishra
> > Agni Software (P) Ltd.,
> > Bangalore-560055, India
> > www.agnisoft.com 
> >
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >  This e-mail was scanned by the eSafe Mail Gateway
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shishir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find avg data blocks for an index.

[אדר יחיאל]

Hello

First analyze all indexes and then 
I think that the following query will give you a good approximation.
The first part of the sub query compute the size needed to store the keys
values
 based on the columns length times distinct values.
The second part of the sub query compute the length needed to store the
rowids
for the rows in the index.

SELECT SUM(LEN) FROM 
(select ALL_INDEXES.INDEX_NAME , SUM(COLUMN_LENGTH * DISTINCT_KEYS) LEN
from ALL_IND_COLUMNS , ALL_INDEXES 
where ALL_IND_COLUMNS.index_name IN
(SELECT INDEX_NAME FROM ALL_INDEXES WHERE OWNER = 'TAV')
AND ALL_IND_COLUMNS.INDEX_NAME = ALL_INDEXES.INDEX_NAME
GROUP BY ALL_INDEXES.INDEX_NAME
UNION 
select ALL_INDEXES.INDEX_NAME , SUM(NUM_ROWS * 18) LEN
from ALL_INDEXES 
where  OWNER = 'TAV'
GROUP BY ALL_INDEXES.INDEX_NAME)


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Ayyappan S [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, February 18, 2002 10:13 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  How to find avg data blocks for an index.
> 
> Hi 
> 
> I want to estimate the size for a growing database for 2004, I want to
> find
> the avg bytes occupied by an index. how to find & calculate it.
> 
> Ayyappan.S
> 
> **
> **
> This communication contains information, which is confidential and may
> also
> be privileged. It is for the exclusive use of the intended recipient(s).
> If
> you are not the intended recipient(s), please note that any distribution,
> printing, copying or use of this communication or the information in it is
> strictly prohibited. If you have received this communication in error,
> please notify the sender immediately and then destroy any copies of it.
> **
> **
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ayyappan S
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find avg data blocks for an index.

[Mike Hately, Choiceline IT Ltd.]

Hi,

2 possibles spring to mind:

A simple average of the space allocated to indexes

SELECT AVG(BYTES)
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE='INDEX';

This is a bit rough-and-ready but may be OK if your indexes are all well
sized.

Alternatively you can analyze each index in turn (ANALYZE INDEX 
VALIDATE STRUCTURE or VALIDATE INDEX ) and use the column
INDEX_STATS.USED_SPACE to derive an average of the actual space in use
rather than the space allocated to index extents. Because each VALIDATE
overwrites the previous set of results you'll find it's convenient to write
a procedure which will validate an index and archive the INDEX_STATS results
to a separate table (perhaps prefixing a DATE_VALIDATED column to help you
later. Then you can call the procedure for each of your indexes and
summarise the results at your leisure.

Hope this helps,
Mike Hately
(Oracle DBA)

-Original Message-
Sent: 18 February 2002 08:13
To: Multiple recipients of list ORACLE-L


Hi

I want to estimate the size for a growing database for 2004, I want to find
the avg bytes occupied by an index. how to find & calculate it.

Ayyappan.S


This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ayyappan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Hately, Choiceline IT Ltd.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

8i Concept PCTFREE & PCTUSED are 0

[Sinard Xing]

Hi all,

Oracle 8i (81600)

I create user Panadol and give unlimited quota on TBS.

as Panadol I create 1 table like this:

SQL> CREATE TABLE mytable(
  2 col1 char(3),
  3 col2 char(4),
  4 col4 varchar2(4)
  5  )
  6  PCTFREE 0
  7  PCTUSED 0
  8  STORAGE (
  9INITIAL 20K
 10NEXT 20K
 11PCTINCREASE 0
 12MAXEXTENTS 10
 13  )
 14  ;

Table created.

SQL> insert into mytable values('abc', 'abcd', 'a');

1 row created.

SQL> commit;


I don't understand That table PCTUSED is 0 ? where Oracle keep those
data ?

Look at this:

SQL> select * from mytable;

COL COL2 COL4
---  
abc abcd a



Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Disable certain users from login to database while applying H

[Abdul Aleem]

How about changing their password for the time being.

Aleem

 -Original Message-
Sent:   Monday, February 18, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Subject:Disable certain users from login to database while applying
Human

Hi Gurus,

I need to disable certain users from login to database while I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon trigger to disable
or should I take away their privileges to logon to report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ? What do U guys
do to solve the dead-lock problem (If my users access the HR tables while I
apply the patches, I will encounter dead-lock problem) ? 

Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: help needed

[אדר יחיאל]

As simple as:

select * from
(select 'ptMASTER' , 'Master' col2 from dual
 union 
 select 'ptMKT' , 'Market' from dual
 union 
 select 'ptOFFICE' , 'Office' from dual)



Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Shishir [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, February 18, 2002 9:23 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  help needed 
> 
> Hi folks ! 
>   I have some constants value   i want to show then in tabular format with
> two cloumns and n rows 
>   is it possible to get them through in that way by manipulating SQL
> statements i dont want to define user defined data type
>  i want the sql to be written in way that it ud give me result like :
>col1 col2
>   'ptMASTER'  'Master',
>   'ptMKT' 'Market', 
>   'ptOFFICE''Office',
>   'ptPDCR'   'Producer', 
>   'ptQUOTE' 'Quote', 
>   'ptREGL'   'Regulator', 
>   'ptROLE'   'Role',
> 
> these are  constant values and not stored in database at all .I ud
> appreciate any help from u gurus.
>  
> thanx in advance
> Shishir Kumar Mishra
> Agni Software (P) Ltd.,
> Bangalore-560055, India
> www.agnisoft.com 
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Disable certain users from login to database while applying Human

[Stephane Faroult]

>- Original Message -
>From: "CHAN Chor Ling Catherine (CSC)"
><[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Sun, 17 Feb 2002 23:28:24
>
>Hi Gurus,
>
>I need to disable certain users from login to
>database while I apply the
>Human Resources Patches for our Oracle HR 11i
>Applications.
>Which is the best way to do it ? Should I write
>on-logon trigger to disable
>or should I take away their privileges to logon to
>report/forms/sqlplus ?
>What about the rest of the DBA Applications
>administrator ? What do U guys
>do to solve the dead-lock problem (If my users
>access the HR tables while I
>apply the patches, I will encounter dead-lock
>problem) ? 
>
>Please advise. Thanks.
>
>Regds,
>New Bee
>-- 
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>-- 
>Author: CHAN Chor Ling Catherine (CSC)
>  INET: [EMAIL PROTECTED]
>

Catherine,

 The simplest thing to do for maintenance operation is to shut the database down 
and to restart it in RESTRICT mode, which only allows people who have been granted the 
CONNECT RESTRICT privilege (in practice, accounts which have the DBA role) to connect. 
Shutting down the listener is also a solution, if you have to work on the server and 
all users are connected through SQL*Net, but beware that it will not terminate 
existing sessions.
  If you need to target *some* but not all users, you can revoke CREATE SESSION from 
them.

Stephane Faroult
Oriole Corporation
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to find avg data blocks for an index.

[Ayyappan S]

Hi 

I want to estimate the size for a growing database for 2004, I want to find
the avg bytes occupied by an index. how to find & calculate it.

Ayyappan.S


This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ayyappan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).