date:20030117

Unfortunately, Cary & gang are still paying their bills ;) 

It is not free. But it is worth every penny you will pay and more!

Check it out at http://www.hotsos.com/events/symposium/index.html. 
I booked early and saved a few $$ :) May be the discount rate is still available. 

Hope you can attend. 

- Kirti 

PS: No, I do not work for Hotsos.

PS: Wish I did ;>) 



-Original Message-
Sent: Friday, January 17, 2003 8:29 PM
To: Multiple recipients of list ORACLE-L


Is it a free symposium ? if not how much ? maybe I'm consider to attend.

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, January 18, 2003 12:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: OT: HOTSOS Symposium
> 
> It's a maybe for me.
> 
> Waiting for the execs to finalize our budget.
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Larry Elkins" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  01/16/2003 04:19 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:OT: HOTSOS Symposium
> 
> 
> Listers,
> 
> Just curious if anyone from the list will be going to the HOTSOS Symposium
> in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good, but
> don't know yet if I will be able to tear away from work to attend. I'm
> already in Dallas so travel isn't the difficulty -- just finding the time 
> is
> the trick.
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
> 
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OT: HOTSOS Symposium

2003-01-17 Thread Sony kristanto

Is it a free symposium ? if not how much ? maybe I'm consider to attend.

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, January 18, 2003 12:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: OT: HOTSOS Symposium
> 
> It's a maybe for me.
> 
> Waiting for the execs to finalize our budget.
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Larry Elkins" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  01/16/2003 04:19 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:OT: HOTSOS Symposium
> 
> 
> Listers,
> 
> Just curious if anyone from the list will be going to the HOTSOS Symposium
> in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good, but
> don't know yet if I will be able to tear away from work to attend. I'm
> already in Dallas so travel isn't the difficulty -- just finding the time 
> is
> the trick.
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Larry Elkins
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Sony kristanto
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Mogens Nørgaard





And in the extreme end of the spectrum, you might want to learn about block
dumps in order to be prepared for the day when you have a corrupted block.
The block dumps can show people - who know what they're looking for, ie have
prepared - a lot of useful information. Might be a valuable piece of documentation
for an iTAR, too.

Mogens

Fink, Dan wrote:

  Pui Ho,
	Stephane raises a good point, unfortunately, many operations groups
stop at the backup. It is not the responsibility of operations to backup the
database/system. It is the responsibility of operations to recover the
database/system. There are many stories of backups that execute flawlessly,
but they cannot be used to recover. An untested backup strategy is an
invalid backup strategy.
	As for the corruption, export and dbverify each have
advantages/disadvantages. 
	Export performs a full table scan on each table in the exported
schema. However, it does not export SYS objects and it does not read the
indexes. It may/may not read rollback segments. 
 	Dbverify reads the header and footer of each block in the datafile.
As I recall (from the Internals seminar 3 years ago), it does not read the
bytes in between, so a corruption may be missed. It also may report
incorrectly, if the block it is verifying is written at the same time.

	To guard against corruption, do 3 things. 
	1) Have a solid and tested recovery process
	2) Run periodic exports (send output to /dev/null)
	3) Run dbv on live datafiles (during slow times) and backup files
(if kept on disk)

Dan Fink

-Original Message-
Sent: Friday, January 17, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L


  
  
I am considering the appropriate way to do database
corruption prevention.

Should I use  one or more of the following as a
proactive measure ?
 a) Export  
 b) DBVerify	
 c) Analyze table  validate structure
cascade 

Any advice ?

Thanks,

PH


  
  
Pui Ho,

   The only way you can be 'proactive' concerning corruption is to have a
sound backup strategy - if you really feel nervous about your hardware,
first change it, and then use archive logging and the rest; export is a bad
solution, because it will be long to restore. By definition, a corruption
doesn't give any warning (it's even worth than earthquakes). If you want to
be very reactive, set something to regularly scan your alert.log file.

Regards,

Stephane Faroult
Oriole

RE: 1998 UK Oracle Users Group conference papers

2003-01-17 Thread John Kanagaraj

Jeremiah,

If you are looking for a very specific article by Megh, why not send him a
note directly? I believe he is in Quest down-under...

John

> -Original Message-
> From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 3:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 1998 UK Oracle Users Group conference papers
> 
> 
> Hopefully this should be the last of these requests.
> 
> I am looking for anyone with program materials or whitepapers,
> especially the CD ROM from the 1998 UK Oracle Users Group conference.
> I am searching for a paper called "An artistic look at tuning very
> large Oracle8 databases" by Meghraj Thakkar.
> 
> If you have any such materials that you would be willng to share,
> please contact me off the list.
> 
> [EMAIL PROTECTED]
> 
> Thanks,
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: quest SharePlex

2003-01-17 Thread Nick Wagner

Title: RE: quest SharePlex





You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine.   Then we go through an activation process that takes the table name on the source and grabs the object id from Oracle and the primary key columns (if no primary key, we use all the columns except for LOB's and LONGs).  Then the capture process scans through the redo logs only capturing changes to object ids in our list.  

configuration file is pretty simple...  



source_owner.source_table target_owner.target_table [EMAIL PROTECTED]


so to replicate scott.emp to scott2.emp2 on system XYZ, with instance ORCL it would be...


scott.emp scott2.emp2 [EMAIL PROTECTED]


However, it can get complicated if you want to replicate only certain columns, or only certain rows.  


-Original Message-
From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: quest shareplex




Since the redo log contains only details about
object id, row location, and changed values , how
do you  derive a table-name and key value for
the SQL to be applied ?



Regards


Jonathan Lewis
http://www.jlcomp.demon.co.uk


Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )


England__January 21/23
USA_(CA, TX)_August



The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html






-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 17 January 2003 19:25



>I was going to keep quite...  but here goes. :)
>-
>
>Yes, of course I'll be glad to help.
>
>Basically...
>
>Log Based replication for Oracle.  A capture process continually
reads the
>online redo logs and parses out information based on a list of tables
you
>provide.  The raw redo log data is then converted into standard
Oracle SQL,
>and using OCI calls is posted to target database(s).  The target(s)
are
>fully open and available, so you can do peer-to-peer, reporting,
failover,
>DR, upgrades, migrations...
>
>No SQL*Net, no Streams, no AQs, no triggers, no OAR.
>
>It's a pretty broad product,  so if you need more info, just let me
know.
>
>Nick
>



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


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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: Calculating new PCTFREE and PCTUSED !!!!!1

2003-01-17 Thread DENNIS WILLIAMS

Wow Charlie - I do somewhat the same thing, but do it manually, when the
mood strikes me. But most of my applications don't update the data,
increasing the size, hence my question to Reddy about how much of that his
application does. 
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 3:56 PM
To: Multiple recipients of list ORACLE-L



What I've done, is I have some PL/SQL code which looks for chained rows.
When the number of chained rows exceeds 5% it proceeds to unchain the rows.
Upon completion it increases the PCTFREE by 5% & decrease PCTUSED by 5%.
This process continues until they reach values which don't induce chaining.
This process runs once a month after our month-end processing completes.



 

  DENNIS WILLIAMS

  
  UCH.COM> cc:

  Sent by: Subject:  RE: Calculating new
PCTFREE and PCTUSED !1 
  [EMAIL PROTECTED]

 

 

  01/17/2003 01:04

  PM

  Please respond to

  ORACLE-L

 

 





Reddy - No I have not used that script. But most of Don's stuff is quite
good. I thought it might illuminate some issues for you. Sorry if it didn't
help.
   The PCTFREE and PCTUSED parameters mainly need tweaked when your data is
volatile, when existing rows are updated with additional data. Is your data
very volatile?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, January 17, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Have you used the script ??

I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .

here is the script:

- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set pages ;
set feedback off;

spool pctused.lst;

define spare_rows = 2;

define blksz = 4096; ( I used 8192 )

select
' alter table '||owner||'.'||table_name||
' pctused '||least(round(100-((&spare_rows*avg_row_len)/(&blksz/10))),95)||
' '||
' pctfree '||greatest(round((&spare_rows*avg_row_len)/(&blksz/10)),5)||
';'
from
dba_tables
where
avg_row_len > 1
and
avg_row_len < 2000
and
table_name not in
(select table_name from dba_tab_columns b
where
data_type in ('RAW','LONG RAW')
)
order by owner, table_name
;

spool off;

Sample o/p:  alter table .TSFDETAIL pctused 95  pctfree 5;

And previous value for PCTFREE is 20  and the chained rows are 1054757 in
that table..



Does anyone have good idea to calculate PCTFREE would like to share with me
???


I need help !!!

Thanks
Madhu



-Original Message-
Sent: Wednesday, January 15, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L


Madhu
   Here is a good article that discusses the various aspects:
http://www.dba-oracle.com/art_pctfree.htm

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, January 15, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I have found some of the tables are heavily chained in one of the database
.
I want to fix them by exp and imp, but before that I would like to have a
formula or some better method to identify the new PCTFREE and PCTUSED for
each individual table.

Many of you have might have done this in the past , would you pl share your
ideas on this ??

Thanks in advance,
Madhu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.ne

Re: OT: HOTSOS Symposium

2003-01-17 Thread Mogens Nørgaard





I'm presenting. So is Anjo. Jonathan. And Cary. So that's four list members
more attending the symposium :).

Mogens

[EMAIL PROTECTED] wrote:

  Hi Larry,

  I am attending. Wonder who else on the list is attending. 

Regards,
Denny

Quoting Larry Elkins <[EMAIL PROTECTED]>:

  
  
Listers,

Just curious if anyone from the list will be going to the HOTSOS
Symposium
in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good,
but
don't know yet if I will be able to tear away from work to attend. I'm
already in Dallas so travel isn't the difficulty -- just finding the
time is
the trick.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

Re: BCHR Tuning

2003-01-17 Thread Jonathan Lewis


There was a flurry of notes about Richard Niemiec's
most recent article in Oracle Magazine, about which
I passed the comment:

>
>Having said that, I thought the article was far better
>than usual.  There was still plenty of scope for
>criticism, but it seemed to convey more useful
>information than usual, even though presentation
>and ordering were somewhat garbled in places, and
>there were several small errors and misunderstandings.
>

Jared, I think, suggested that it would be it would be
appropriate to produce some sort of critique of the article
to shed light on some of the criticisms that it had received.

The following question came up on comp.databases.oracle.server
today, so I took a few minutes to answer it - and thought
I would offer my comments to the rest of the list for review. 
Since the question was about the paragraph on buffer busy
waits, I have dissected just that paragraph.




Don Burleson wrote in message
<[EMAIL PROTECTED]>...
>Rich Niemiec, president of IOUG writes in Oracle magazine (page 100,
>Jan 2003):
>
>Buffer Busy - "This is a wait for a buffer that is being used in an
>unshareable way or is being read into the buffer cache.  . . .  wait
>is on a segment header. If this is the case, increase the freelist
>groups or increase the pctused to pctfree gap."
>
>I was always under the impression (from Oracle Support) that:
>
>1 - An instance is only able to attach to one freelist group, and
>multiple freelists groups are only for OPS/RAC systems.
>
>2 - The best way to reduce segment header contention is to add
>multiple freelists, not freelist groups.
>
>Has anyone ever tried multiple freelists groups or increasing the
>PCTUSED-PCTFREE "gap" top reduce segment header contention?




I had to read the full text to check if there was
any omission in your extract that might explain
the oddity:

Quoted text is at the margin, commentary indented:



4. Buffer Busy. This is a wait for a buffer that is being used in
an unshareable way or is being read into the buffer cache.

Sloppy wording, but technically not wrong, however
(a) there are ways that a buffer can be used in an
unsharable way that are not BBWs (e.g. write complete
waits - although the newest versions of Oracle bypass
this one).  (b) grammar - if you eliminate the middle clause,
you get "a buffer that ... is being read into the buffer
cache"  - data blocks are read into the buffer cache, the
buffers are already there. (c) if a block is being read
into the buffer cache, the buffer IS being used in an
unsharable way, so the 'or' would be better as 'e.g.'

Buffer busy waits should not be greater than 1 percent.

One percent of what ?  Physical reads, consistent gets,
consistent gets plus current gets, consistent gets plus
current gets plus buffer is pinned count ?

If my buffer busy waits are much less than one percent
of (say) my consistent gets, should I dismiss the issue -
even if all those waits are for segment headers ?  Should
I dismiss the issue if the wait time is significant ?


Check the Buffer Wait Statistics section (or V$WAITSTAT)
to find out if the wait is on a segment header. If this is the
case, increase the freelist groups or increase the pctused
to pctfree gap.

Step one for segment headers is to examine the freelists,
not the freelist groups.  There are side-effects to freelist
groups that you do not want to introduce if the problem can
 be addressed through freelists.

WHEN does increasing the pctused to pctfree gap help ?  And
should this be done by increasing the PCTFREE or decreasing
the PCTUSED - or perhaps by changing both in the same direction
but by different amounts.   This comment displays the worst
aspect of the 'quick tip' psychology - it seems to be designed to
show that the author has some deep insight into subtle mechanics,
but in the absence of an explanation the comment could encourage
the novice DBA  to do something inappropriate.


If the wait is on an undo header, you can
address this by adding rollback segments;

I can agree with that - on the other hand, if the wait time
is not significant, this might increase I/O activity and help
to overload the I/O subsystem - so I might advise caution,
and I might advise reducing the size of the rollback segments
at the same time.

if it's on an undo
block, you need to reduce the data density on the table
driving this consistent read

This addresses the issue of one user trying to read
an undo block whilst another user is modifying it -
which could happen when one set of processes needs
to read data in consistent mode VERY shortly after
something else has changed it AND the undo blocks
containing the required undo are still the most current
undo blocks and are still subject to change.  Data density
is not really the issue.  (Of course, you might ask how
you find out which table is

Re:

David,

The very term MATERIALIZED VIEW means the data is created. In this case you
have a segment called EMP in your local database. Users, when they select
from EMP, will only see data that has been placed there; they will not see
the remote database EMP table. When the MV is refreshed the changes are
propagated across to your local DB.

HTH.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 10:30 AM


> If I use Replication such as:
>
> create materialized view EMP
> storage (...)
> tablespace ...
> refresh fast
> start with sysdate next sysdate+1
> as
> select * from emp@remote_connect;
>
> 1) I am bringing the new emp data over from the remote_connect database?
>
> 2) This is a materialized view with  a local base table.  When my user
comes
> in and selects from emp how does he get the new data?  Does Oracle join
the
> local base table and emp table?  Does it access the view?  Or does Oracle
> actually copy the new data into the emp table from the view and local base
> table?
>
> thanks
>
> David Ehresmann.
>
> -Original Message-
> Sent: Friday, January 17, 2003 4:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> an incremental export does not export just the new rows but ALL the
> data in the table. It will, however, only export if there has been a
> change to the table, thus the "incremental"
>
>
> --- Krishna Kakatur <[EMAIL PROTECTED]> wrote:
> > How about using incremental exports/ imports?
> >
> > HTH, Krishna
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, January 16, 2003 11:19 AM
> >
> >
> > > Use the query= feature of export. This will work if there is a
> > timestamp
> > > column where you can determine which are the 'new' records.
> > >
> > > -Original Message-
> > > Sent: Thursday, January 16, 2003 11:49 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > how about, database link
> > >
> > > -Original Message-
> > > Sent: 17 January 2003 01:46
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > replication
> > >
> > > -Original Message-
> > > Sent: quinta-feira, 16 de Janeiro de 2003 15:09
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > List,
> > >
> > > I have to move data on a regular basis between two instances of
> > 8.1.7 on
> > > two different UNIX servers.  The schema is exactly the same.  There
> > are
> > 543
> > > tables to be "refreshed".  It is only the "new data" on one of the
> > servers
> > > to move to the other.  What is the best and easiest way to do this?
> > >
> > > thanks,
> > >
> > > David Ehresmann
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Ehresmann, David
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services
> > >
> > -
> > > 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.net
> > > --
> > > Author: Paulo Gomes
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services
> > >
> > -
> > > 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.net
> > > --
> > > Author: Sinardy Xing
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services
> > >
> > -
> > > 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 offi

RE: Select magazine

2003-01-17 Thread John Kanagaraj

Dan,

> We also had a contribution on SLAs from the DBA Goddess of 
> the list. It's
> great to see the list members in print!

Not forgetting to mention the two contributing Editors as well as the
Asia-Pacific Tech Editor in this list! Now where are all your articles for
submission, y'all? (Just a throwback to Jared's call for articles sometime
back in this list :)

I think it is fair to say that this list has collected a ton of excellent
people, with recognized experts, authors (and authors-to-be [Cary!]),
editors, etc. and is probably a _very_ powerful force when viewed
collectively. 

And all of us can find a formal voice to Oracle through IOUG (which has
matured into a truly international organization). [And that's a hint for
those sitting on the fence about attending the upcoming IOUG Live! 2003]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

Robert,

What if the RMAN incremental facility is used and the blocks get corrupted
in an unchanged space? Will RMAN then identify the corruption?

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 10:39 AM


> No need to do any of this if you are using RMAN. With each backup, RMAN
> checks each block backed up for any corruption. Corruption will be
reported
> and you
> can opt to allow a certain amount of it or none.
>
> Rf
>
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (it's everywhere that I am!)
> Author of several books you can find on Amazon.com!
>
>
>
> -Original Message-
> Sent: Friday, January 17, 2003 8:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I would do all three.  A good backup stategy is only good if you read all
> your data all the time.  You can have corrupt data that doesn't get read
and
> doesn't cause a problem for weeks, month, years.  By that time you have no
> backup that does not contain corrupt data.  Export to a null file to speed
> things up a little, just keep the log file.  DBVerify is very useful.
>
> R.Smith
>
> -Original Message-
> Sent: Friday, January 17, 2003 7:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> >I am considering the appropriate way to do database
> >corruption prevention.
> >
> >Should I use  one or more of the following as a
> >proactive measure ?
> >  a) Export
> >  b) DBVerify
> >  c) Analyze table  validate structure
> >cascade
> >
> >Any advice ?
> >
> >Thanks,
> >
> >PH
> >
>
> Pui Ho,
>
>The only way you can be 'proactive' concerning corruption is to have a
> sound backup strategy - if you really feel nervous about your hardware,
> first change it, and then use archive logging and the rest; export is a
bad
> solution, because it will be long to restore. By definition, a corruption
> doesn't give any warning (it's even worth than earthquakes). If you want
to
> be very reactive, set something to regularly scan your alert.log file.
>
> Regards,
>
> Stephane Faroult
> Oriole
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroul
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited.  Please let me know
> immediately by return e-mail if you have received this message by mistake,
> then delete the e-mail message. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
> --
> Author: Freeman Robert - IL
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

Re: from Non-Archive-Mode to Archive-Mode




Raj,
 
I'm afraid I don't understand. Was that 
incorrect in some way? The alert log will contain information when the redo 
logs switch, e.g.
 
Thread 1 advanced 
to log sequence 38451  Current log# 1 seq# 38451 mem# 0: 
/x12/oradata/IDW1/redo01a.dbf  Current log# 1 seq# 38451 mem# 1: 
/x22/oradata/IDW1/redo01rba.dbfFri Jan 17 17:46:49 2003Completed 
checkpoint up to RBA [0x9633.2.10], SCN: 0x.4f7c86d7Completed checkpoint 
up to RBA [0x9632.2.10], SCN: 0x.4f7c86d5Fri Jan 17 17:46:50 
2003Beginning log switch checkpoint up to RBA [0x9634.2.10], SCN: 
0x.4f7c86d9Thread 1 advanced to log sequence 38452  Current 
log# 3 seq# 38452 mem# 0: /x12/oradata/IDW1/redo03a.dbf  Current log# 3 
seq# 38452 mem# 1: /x22/oradata/IDW1/redo03b.dbf
This will help identify the frequency of 
log switch and an indicator to the amount of redo generated. The question was 
how to estimate the amount of archive log generation and that was one way. So, 
is that wrong? Please do correct me if you think so. Of course the information 
can be readily obtained from v$log_history; but then again, that's another way, 
not the only way.
 
Arup
 
- Original Message - 
From: <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 1:25 PM
Subject: Re: from Non-Archive-Mode to 
Archive-Mode
> > Arup,> > From your past replies to the list, 
I am surprised to hear you say this.> "If you have placed the init.ora 
parameter log_checkpoints_to_alert set to> TRUE, then your alert log file 
will have lines when the redo log group> switch fom one to the 
other."> > Regards> Raj> > > > 
> 
    
> 
    
"Arup 
Nanda"    
> 
    
    > 
    
tmail.com>   
cc:    
> 
    
Sent by: 
Subject: Re: from Non-Archive-Mode to 
Archive-Mode 
> 
    
root@fatcity.   
> 
    
com 
> 
    
> 
    
> 
    
January 
17, 
> 
    
2003 09:35 
AM   
> 
    
Please  
> 
    
respond 
to  
> 
    
ORACLE-L    
> 
    
> 
    
> > > > > Murat,> > The 
estimate of amount of space for archive logs come from your redo log> 
switch. If you have placed the init.ora parameter 
log_checkpoints_to_alert> set to TRUE, then your alert log file will have 
lines when the redo log> group switch fom one to the other. That will 
give you a rough idea of the> time it takes to fill up a redo log. If you 
are using archiving, the redo> log has to be written to disk. In any one 
given day, you can then calculate> the archive log generation.> 
> Then comes how you want to back it up and clean up the space. If you 
have a> process running that will scan for archive logs; back them to 
tape and then> delete it, then you have to figure out how often this 
process runs and how> much archive log stays on the disk before getting 
deleted.> > Changing the log mode of the tablespace level does not 
change teh redo log> genration in most cases. If you define a tablespace 
or an object as> nologging, only a few operations like ALTER TABLE .. 
PARTITION, ALTER INDEX> REBUILD, direct load are not logged, all others 
are. And in any case the> system tables are always logged.> 
> HTH.> > Arup> > - Original Message 
-> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> Sent: 
Friday, January 17, 2003 5:08 AM> > > > Hi,> 
>> >   how can I 
calculate/estimate the extra disk space I'll need if I> > change the 
log mode from non-

Re: Moving tables from one tablespace to another tablespace

And, therefore...?

In case of long, array inserts are NOT performed in import. A record is
committed as soon as it's inserted. Imagine a multi-thousand row table that
issues a commit after each row; your log buffers will be flushed so
frequently that you will experience severe log buffer related waits. COPY
lets you do in chunks by specifying COPYCOMMIT, not for each row. That was
the point. In import specifying COMMIT=Y does a commit after each row (in
case of LONGs), a frequency impossible to control.

Your excerpt from the doc simply reiterated what I mentioned. So are you
merely reinforcing the post with an extract from the docs or proving it
wrong?

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 12:44 PM


> "It lets you control the commit frequency; something impossible in
> export/import."
>
>
>
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch02
> .htm#40480
>
> COMMIT
> Default: N
>
> Specifies whether Import should commit after each array insert. By
default,
> Import commits only after loading each table, and Import performs a
rollback
> when an error occurs, before continuing with the next object.
>
> If a table has nested table columns or attributes, the contents of the
> nested tables are imported as separate tables. Therefore, the contents of
> the nested tables are always committed in a transaction distinct from the
> transaction used to commit the outer table.
>
> If COMMIT=N and a table is partitioned, each partition and subpartition in
> the Export file is imported in a separate transaction.
>
> Specifying COMMIT=Y prevents rollback segments from growing inordinately
> large and improves the performance of large imports. Specifying COMMIT=Y
is
> advisable if the table has a uniqueness constraint. If the import is
> restarted, any rows that have already been imported are rejected with a
> nonfatal error.
>
> If a table does not have a uniqueness constraint, Import could produce
> duplicate rows when you reimport the data.
>
> For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, DATE, or type
> columns, array inserts are not done. If COMMIT=Y, Import commits these
> tables after each row.
>
>
> -Original Message-
> Sent: Friday, January 17, 2003 8:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> You could use COPY command. Create a new table exactly as the old table in
> the new tablespace from the DDL scripts. Then use the COPY command to
insert
> rows. It lets you control the commit frequency; something impossible in
> export/import.
>
> HTH.
>
> Arup
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: quest shareplex

2003-01-17 Thread Khedr, Waleed

I'm sure you know Oracle has a new product "Oracle Streams" that does the
same:

http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server
.920/a96571/strmover.htm#43906

Waleed

-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L


I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).


Anyone enlighten me.

thanks, joe


Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

1998 UK Oracle Users Group conference papers

2003-01-17 Thread Jeremiah Wilton

Hopefully this should be the last of these requests.

I am looking for anyone with program materials or whitepapers,
especially the CD ROM from the 1998 UK Oracle Users Group conference.
I am searching for a paper called "An artistic look at tuning very
large Oracle8 databases" by Meghraj Thakkar.

If you have any such materials that you would be willng to share,
please contact me off the list.

[EMAIL PROTECTED]

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



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: iAS 903 902 install

2003-01-17 Thread mkb

Hi Barb,

Don't know if the following helps any but I went
through an install of this beast a few months back. 
Here are my notes:

hth
mohammed

> -Original Message-
> From: mkb [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: A DBA looks at OAS
> 
> No books or tips.  Just my recent experience
*trying*
> to install 9iAS R2 (I hope that's what you meant
when
> you wrote OAS).
> 
> I downloaded 9iAS J2EE and Web Cache for Solaris and
> HP-UX.
> 
> Oracle recommends about 1GB ram, 1GB swap and lots
of
> free disk space.  Anyway, my target Solaris box had
> 500MB swap, 256MB ram and a 400 MhZ SparcII CPU. 
Not
> the ideal platform.  On the HP-UX box, I had 3GB
ram,
> a 2 CPU L class machine, lots of swap and lots of
> disk.
> 
> In any case, what I learned is that root privs are
> vital.  Had them on the Solaris box but not on the
> HP-UX machine.  The installs in both cases where
> fairly standard.  I had ran through them quite a few
> times on both servers.  On Solaris becuase of
resource
> issues and HP-UX because of root permission issues.
> 
> There are two types of installs.  A mid-tier (less
> config, easier, fewer components) and an
> infrastructure (more config, more components, needs
a
> database repoistory).  I did the mid-tier install in
> both cases.
> 
> Make sure you have JDK 1.3 or later installed.
> 
> Before the install for mid-tier in particular,
export
> ORACLE_SID=iasdb even if you do not intend to use a
> repository or have a database.
> 
> I created a separate ORACLE_HOME for my install.
> 
> Also, Oracle recommends that you use hostnames, so
> naming methods should reflect hostname.com instead
of
> 123.45.67.8.  
> 
> During the install, you will be asked for a password
> for the Eterprise Manager website.  NOTE IT DOWN!!! 
> You'll need it to start and stop the EM website. 
> Oracle recommends that you start and stop services
via
> the EM website and not the command line and I'll go
> along with this since I had trouble shutting down
> services via the command line (sometime it worked
and
> sometime it did'nt).
> 
> Also, during the install when prompted to run the
> root.sh script, run as root since this script starts
> the Apache httpd daemons.  These need to be started
as
> root.  It does a bunch of other config things
aswell. 
> See root.sh.  This is vital since after the install
is
> complete, the installer then configures the
components
> such web cache, OC4J components, Apache config etc. 
> This is the problem I was having on HP-UX, late in
the
> day, govt client, sysadmin has left the building.
> 
> Ok, after the install has completed and started all
> the services (hoepfully), you need to apply all
> relevant patches.  For the mid tier install, install
> the patch in the following order:
> 
> 9.0.1.3 patch set
> RDBMS bundled patch
> Oracle Internet Directory path
> Oracle HTTP server patch
> 
> You'll see this in the install notes for the patch. 
> Note that the RDBMS bundled patch is slightly
> different on HP-UX versus Solaris.  Just read the
> instructions carefully if you are on HP-UX.  Solaris
> was a little easier.
> 
> After the patch, you can login to the EM website at
> http://myhostname.com:1810.  If the website does not
> come up, you can start it from the prompt using
emctl
> start|stop|status.  Stopping requires password which
> was entered earlier during install.  Password can
also
> be changed using emctl set password .
> 
> Using the website, you can/start stop other services
> such as web cache, BC4J, OC4J containers etc.
> 
> The default website can be accessed (hopefully) at
> http://myhostname.com:
> 
> Also, you can start|stop the httpd daemons from the
> command line from $ORACLE_HOME/dcm/bin/dcmctl
> start|stop -ct ohs if the EM website is inaccessible
> for some reason.  Again, Oracle recommends that you
do
> all admin through EM the website.
> 
> Similarly, web cache can be started/stopped from the
> prompt by webcachectl start|stop|status.
> 
> Finally, just a couple days ago, we seemed to have
> trouble starting 9iAS.  Seems like some log files
had
> their ownership changed.  Don't know how this
> happened.  My guess is some sort of bug.  The way I
> tracked this is tailing the logs while trying to
start
> the server.  Since I could'nt get the EM website up,
I
> had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct
ohs.
> 
> Useful logs were:
> $ORACLE_HOME/opmn/logs/ons.log and ipm.log
> $ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
> and of cource
> $ORACLE_HOME/Apache/Apache/logs/error_log and
> access_log
> 

--- Jeff Herrick <[EMAIL PROTECTED]> wrote:
> 
> Barb,
> 
> I've been deploying forms over the web since OAS
> 4.07 and I had
> Oracle WebServer experience going back to version 2.
> What I found
> was that knowing all of that stuff made it worse for
> trying to
> figure out 9IAS Rel 2 (9.03). What further
> complicates it (web
> forms that is) i

Re: Limiting user connections with DBA Studio

I agree with Kirti. Why prevent them from using DBA Studio? If you have
given them the privilege, then they can easily connect through sql plus or
some other tool, not necessarily through DBA Studio. So it's better to
control their actions through proper grants.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 2:50 PM

> But the fundamental question is why prevent them.
> What damage are they causing?
> Control their actions via proper permissions.
> If OEM installation is against Company policy (or "they did not ask the
Oracle DBA Group"), then the problem  should be addressed via other
administrative procedures.
>
> - Kirti
>
> > [EMAIL PROTECTED] wrote:
> >
> > Some of our users installed OEM on their local PC's.  They connect to
> > the database through DBA Studio.
> >
> > Is there any way to prevent DBA Studio connections to the server?  I
> > am thinking of using on_logon trigger but no clue how to catch the
> > connection.
> >
> > Any suggestions?
> >
> > Rao
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Select magazine

Thanks, Kirti.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 1:08 PM


> And also an article about Summary Table Mgmt from Arup Nanda :)
>
> Kudos to all !!
>
> - Kirti
>
> -Original Message-
> Sent: Friday, January 17, 2003 9:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We also had a contribution on SLAs from the DBA Goddess of the list. It's
> great to see the list members in print!
>
> -Original Message-
> Sent: Friday, January 17, 2003 7:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Speaking of Select, cudo's to Jared for the article on Perl in the recent
> issue.
>  I gave it the once over last night & then marked it for a more detailed
> read.
> Just might have to learn it!!
>
> Dick Goulet
>
> Reply Separator
> Author: "Ferenc Home" <[EMAIL PROTECTED]>
> Date:   1/16/2003 4:09 PM
>
> Hi Tony
>
> Nice to see you up on the list again.
>
> I take it Select magazine is still going ? Who do I contact for
advertising
> ? and rates ?
>
> Thanks. Regards :
>
> Ferenc Mantfeld
> Melbourne.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ferenc Home
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
> --
> Author: Fink, Dan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: trying to order date chronologically


Sebastian,

I dont know if I understood this right, for this seems to be quite a simple
task. Or maybe I am overlooking something very obvious.

Select to_char('date field','MMDD') from Mytable
order by 1

Unless you dont want the date field displayed in that format in your
report, but still want it sorted in the fashion described above, in which
case :

column sortbydate noprint
Select to_char('date_field','MMDD') sortbydate, Date_field
from Mytable
order by 1

Hope I got this right.

Raj




   
  
"DiFelice, 
  
Sebastian"To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Subject: trying to order date 
chronologically  
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
January 17, 2003   
  
04:14 PM   
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Is there a way to order the result set of a query by date chronologically?
For example, I run a usage report for customers either monthly, quarterly,
semi annual or annually.  I need to return the result set chronologically
by
month and I cannot seem to find a way to do it.
Thanks for any help!

Sebastian DiFelice
Database Administrator
Thomson Corporation
Intelligence Data
(617) 856-1587


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Limiting user connections with DBA Studio

2003-01-17 Thread Todd Carlson

Title: RE: Database Verification









You should kill the previous DBA too. ;-)

 



Todd



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 17, 2003
2:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Limiting user
connections with DBA Studio

 



Todd,





 





The previous DBA has
granted them almost all the privileges except DBA privilege.  Now, when we
tried to take away this SELECT_CATALOG_ROLE, then, these specific users started
raising alarms.





 





So, what we are planning
is to kill their session the moment we find that they are using DBA
Studio. 





 





Rao





-Original Message-
From: Todd Carlson
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003
2:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Limiting user
connections with DBA Studio

They can’t use it
unless they can select from the data dictionary views. For example, if they
don’t the SELECT_CATALOG_ROLE role or DBA privs in 8.1.7 they can not use
DBA Studio.

 



Todd



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 17, 2003
11:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: Limiting user connections
with DBA Studio

 



Some of our
users installed OEM on their local PC's.  They connect to the database
through DBA Studio.





 





Is there
any way to prevent DBA Studio connections to the server?  I am thinking of
using on_logon trigger but no clue how to catch the connection.





 





Any
suggestions?





 





Rao

RE: Calculating new PCTFREE and PCTUSED !!!!!1

2003-01-17 Thread Charlie_Mengler


What I've done, is I have some PL/SQL code which looks for chained rows.
When the number of chained rows exceeds 5% it proceeds to unchain the rows.
Upon completion it increases the PCTFREE by 5% & decrease PCTUSED by 5%.
This process continues until they reach values which don't induce chaining.
This process runs once a month after our month-end processing completes.



   
 
  DENNIS WILLIAMS  
 
  
  UCH.COM> cc: 
 
  Sent by: Subject:  RE: Calculating new PCTFREE 
and PCTUSED !1 
  [EMAIL PROTECTED] 
 
   
 
   
 
  01/17/2003 01:04 
 
  PM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Reddy - No I have not used that script. But most of Don's stuff is quite
good. I thought it might illuminate some issues for you. Sorry if it didn't
help.
   The PCTFREE and PCTUSED parameters mainly need tweaked when your data is
volatile, when existing rows are updated with additional data. Is your data
very volatile?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, January 17, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Have you used the script ??

I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .

here is the script:

- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set pages ;
set feedback off;

spool pctused.lst;

define spare_rows = 2;

define blksz = 4096; ( I used 8192 )

select
' alter table '||owner||'.'||table_name||
' pctused '||least(round(100-((&spare_rows*avg_row_len)/(&blksz/10))),95)||
' '||
' pctfree '||greatest(round((&spare_rows*avg_row_len)/(&blksz/10)),5)||
';'
from
dba_tables
where
avg_row_len > 1
and
avg_row_len < 2000
and
table_name not in
(select table_name from dba_tab_columns b
where
data_type in ('RAW','LONG RAW')
)
order by owner, table_name
;

spool off;

Sample o/p:  alter table .TSFDETAIL pctused 95  pctfree 5;

And previous value for PCTFREE is 20  and the chained rows are 1054757 in
that table..



Does anyone have good idea to calculate PCTFREE would like to share with me
???


I need help !!!

Thanks
Madhu



-Original Message-
Sent: Wednesday, January 15, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L


Madhu
   Here is a good article that discusses the various aspects:
http://www.dba-oracle.com/art_pctfree.htm

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, January 15, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I have found some of the tables are heavily chained in one of the database
.
I want to fix them by exp and imp, but before that I would like to have a
formula or some better method to identify the new PCTFREE and PCTUSED for
each individual table.

Many of you have might have done this in the past , would you pl share your
ideas on this ??

Thanks in advance,
Madhu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

RE: Calculating new PCTFREE and PCTUSED !!!!!1

2003-01-17 Thread Reddy, Madhusudana

Dennis,

My database is of size 960 Gig for now and its a heavy OLTP with high DML
activity on tables , we are observing some ORA-00600 errors these days due
to chained rows in the tables . Also we all know chained rows cause
performance issues . I wanted to fix this ASAP and also would like to alter
the PCTFREE , so I want some ideas from all of you to find out a proper
value ..

Thanks
Madhu



-Original Message-
Sent: Friday, January 17, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L


Reddy - No I have not used that script. But most of Don's stuff is quite
good. I thought it might illuminate some issues for you. Sorry if it didn't
help.
   The PCTFREE and PCTUSED parameters mainly need tweaked when your data is
volatile, when existing rows are updated with additional data. Is your data
very volatile?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, January 17, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Have you used the script ??

I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .

here is the script:

- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set pages ;
set feedback off;

spool pctused.lst;

define spare_rows = 2;

define blksz = 4096; ( I used 8192 )

select
' alter table '||owner||'.'||table_name||
' pctused '||least(round(100-((&spare_rows*avg_row_len)/(&blksz/10))),95)||
' '||
' pctfree '||greatest(round((&spare_rows*avg_row_len)/(&blksz/10)),5)||
';'
from
dba_tables
where
avg_row_len > 1
and
avg_row_len < 2000
and
table_name not in
(select table_name from dba_tab_columns b
where
data_type in ('RAW','LONG RAW')
)
order by owner, table_name
;

spool off;

Sample o/p:  alter table .TSFDETAIL pctused 95  pctfree 5;

And previous value for PCTFREE is 20  and the chained rows are 1054757 in
that table..



Does anyone have good idea to calculate PCTFREE would like to share with me
???


I need help !!!

Thanks
Madhu



-Original Message-
Sent: Wednesday, January 15, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L


Madhu
   Here is a good article that discusses the various aspects:
http://www.dba-oracle.com/art_pctfree.htm

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 15, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I have found some of the tables are heavily chained in one of the database .
I want to fix them by exp and imp, but before that I would like to have a
formula or some better method to identify the new PCTFREE and PCTUSED for
each individual table. 

Many of you have might have done this in the past , would you pl share your
ideas on this ??

Thanks in advance,
Madhu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 8

Re: quest shareplex

2003-01-17 Thread Jonathan Lewis


Since the redo log contains only details about
object id, row location, and changed values , how
do you  derive a table-name and key value for
the SQL to be applied ?


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

England__January 21/23
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 17 January 2003 19:25


>I was going to keep quite...  but here goes. :)
>-
>
>Yes, of course I'll be glad to help.
>
>Basically...
>
>Log Based replication for Oracle.  A capture process continually
reads the
>online redo logs and parses out information based on a list of tables
you
>provide.  The raw redo log data is then converted into standard
Oracle SQL,
>and using OCI calls is posted to target database(s).  The target(s)
are
>fully open and available, so you can do peer-to-peer, reporting,
failover,
>DR, upgrades, migrations...
>
>No SQL*Net, no Streams, no AQs, no triggers, no OAR.
>
>It's a pretty broad product,  so if you need more info, just let me
know.
>
>Nick
>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: What gets written to redo on a rollback?

2003-01-17 Thread Jonathan Lewis


On an ordinary insert, you get a redo record for
the row, and the undo (rollback) for that row.
You also get a similar record for each index
that has to be updated because of the new row.

Similarly, an update or delete will generate one
redo record for the table, and one redo record
for each index affected.

However if you do an array insert Oracle can
optimise the undo and redo so that a single
record (of undo and redo) can cover a block's
worth of changes to the table.   But when
you insert (say) 100 rows into a single block at
the end of the table generating a single redo
record, the 100 entries for a matching index could
be scattered  far and wide across that index and
result in 100 separate redo records.

Since there is a lot of overhead in the undo and
redo records, the difference in packing for table
and index rows for different circumstances
MIGHT explain why you find significant variations
in the apparent number of records in a redo log
file when you use logminer to decode it.



Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

England__January 21/23
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 16 January 2003 21:29


>I recently had a situation where a process went down and Oracle
had to roll back the transaction. The original transaction did around
60,000 inserts and/or updates. When Oracle did its rollback, it
generated many redo logs in a short period of time, but there seems to
be a wide variety of volume per redo log. I used Logminer to check
what was written to these logs during the rollback. Some of them had
1500 - 2000 records written to them and others had as few as 1 or 2
records written. These, for the most part, were the same types of
records (for example, delete records to roll back the effects of an
insert). Why the disparity? It seems like in many cases, a lot of redo
log is wasted. The reason I am asking is that so many logs were
generated, it filled up my archive log directory before my script
could run to clean them out. Anybody have an explanation?
>
>
>Bill Carle


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Minutes Since Midnight 2000

Hey what can I say, I am a ksh bigot :)  

-Original Message-
Sent: Friday, January 17, 2003 2:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]

any more, a system without perl is hardly a system at all.

it's kind of like a system without a shell.

Jared

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Anyone storing their documents in the database with

2003-01-17 Thread DENNIS WILLIAMS

Arn - I don't know if this will help, but since I don't see where you've
received any replies, you might take a look at a new Oracle9i feature,
Database Workspace Management.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, January 16, 2003 10:34 PM
To: Multiple recipients of list ORACLE-L


This is a question that runs right up alongside the "RTFM" answer, but I
have not gleaned this from the Oracle documentation.

I have been able to successfully store a range of documents (Word, Excel,
etc) in the database, using Intermedia and the ORDDoc object type and
adapting the Photo Album demo JSP application that Oracle supplies.
Equally, I have been able to retrieve them via the browser and either open
them with a plug-in or save them locally.

My problem now is that of maintaining them - change control, I guess.  Now,
when a document is retrieved from the database, it's only a copy, and thus
changes to the copy need to be reloaded into the database, overwriting the
current version.

At this point, it appears I would need to build a versioning application
that allows documents to be checked out, making it obvious to the user that
changes to the local copy will *NOT* automatically be reflected in the
database version, and later checked back in, updating the database version
to match the local copy.

Is this correct, or have I completely missed something a whole lot simpler?

How are others handling updates to documents stored in the database?

Thanx for any advice!

Regards,

Arn.



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: ORA-24333

2003-01-17 Thread Stephane Faroult

> Adriano Freire wrote:
> 
> Anybody know thats ORA
> ORA-24333?
> 
> look:
> oerr ora 24333
> 24333, 0, "zero iteration count"
> // *Cause:  An iteration count of zero was specified for the statement
> // *Action: Specify the number of times this statement must be
> executed
> When thats issue occur?
> 
> thanks
> 
> Adriano

I presume that it may be a call to OCIExecute() for something which is
no SELECT. ANiteration count of 0 is only valid for SELECT statements.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Calculating new PCTFREE and PCTUSED !!!!!1

2003-01-17 Thread DENNIS WILLIAMS

Reddy - No I have not used that script. But most of Don's stuff is quite
good. I thought it might illuminate some issues for you. Sorry if it didn't
help.
   The PCTFREE and PCTUSED parameters mainly need tweaked when your data is
volatile, when existing rows are updated with additional data. Is your data
very volatile?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, January 17, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L


Dennis,

Have you used the script ??

I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .

here is the script:

- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set pages ;
set feedback off;

spool pctused.lst;

define spare_rows = 2;

define blksz = 4096; ( I used 8192 )

select
' alter table '||owner||'.'||table_name||
' pctused '||least(round(100-((&spare_rows*avg_row_len)/(&blksz/10))),95)||
' '||
' pctfree '||greatest(round((&spare_rows*avg_row_len)/(&blksz/10)),5)||
';'
from
dba_tables
where
avg_row_len > 1
and
avg_row_len < 2000
and
table_name not in
(select table_name from dba_tab_columns b
where
data_type in ('RAW','LONG RAW')
)
order by owner, table_name
;

spool off;

Sample o/p:  alter table .TSFDETAIL pctused 95  pctfree 5;

And previous value for PCTFREE is 20  and the chained rows are 1054757 in
that table..



Does anyone have good idea to calculate PCTFREE would like to share with me
???


I need help !!!

Thanks
Madhu



-Original Message-
Sent: Wednesday, January 15, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L


Madhu
   Here is a good article that discusses the various aspects:
http://www.dba-oracle.com/art_pctfree.htm

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 15, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I have found some of the tables are heavily chained in one of the database .
I want to fix them by exp and imp, but before that I would like to have a
formula or some better method to identify the new PCTFREE and PCTUSED for
each individual table. 

Many of you have might have done this in the past , would you pl share your
ideas on this ??

Thanks in advance,
Madhu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Minutes Since Midnight 2000

any more, a system without perl is hardly a system at all.

it's kind of like a system without a shell.

Jared





"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/17/2003 11:50 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Minutes Since Midnight 2000


Yeah that would work if I want to use the database but I try to write 
things
in such a way that I can use them in other places and share them with 
other
non-DBA types, thus the reason I am not using Perl or GNU date.  Oracle-L
has some very good *nix scripters so that is why I posted it here, I get
faster better responses then many of the *nix lists.  Thanks for 
suggestion.

- E

-Original Message-
Sent: Friday, January 17, 2003 1:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Just idea, how about:

SQL> select 24*60*(sysdate - to_date('00-00-00-01-01-2000', 
'SS-MI-HH24-DD-MM-') ) from dual;

24*60*(SYSDATE-TO_DATE('00-00-00-01-01-2000','SS-MI-HH24-DD-MM-'))
--
1602151.58

You can spool this result to a file and then use  "cat | awk" to read the 
number back to your script.

HTH.

Guang



_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

trying to order date chronologically

2003-01-17 Thread DiFelice, Sebastian

Is there a way to order the result set of a query by date chronologically?
For example, I run a usage report for customers either monthly, quarterly,
semi annual or annually.  I need to return the result set chronologically by
month and I cannot seem to find a way to do it.
Thanks for any help!

Sebastian DiFelice
Database Administrator
Thomson Corporation
Intelligence Data
(617) 856-1587


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Caught YAPPing


Thank You for your response Cary.  You say "The important thing is that you
have to segment your transactions into different lists". I did convey
something similar to the requestor. I have now put the ball back in their
court, by telling them to identify some crucial functions or precise
statements that they would need to monitor as such. I dont expect to hear
back from them.

Anyways, this is a request from the management, and they like to see things
in graphs with spikes, and ratios. I got a crude way to do this for now. I
am presently capturing some baseline, acceptable wait times for some of the
key wait events. I then plan to utilize statspack to take snapshots every
hour, and code for scripts to query the underlying tables. If anything
exceeds the accepted values, shoot out alerts. Then, I plan to use the
statsviewer tool (http://www.geocities.com/alexdabr/spstd.html)

Thank you for your insight. I look forward to the book.

Raj




   
   
"Cary Millsap" 
   

otsos.com> cc: 
   
Sent by:   Subject: RE: Caught YAPPing 
   
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
January 17,
   
2003 01:50 PM  
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Raj,

You can of course compute the average any list of numbers. However, if
your list contains data from fundamentally different types of data, then
your average will be meaningless. Example:

A = {Response times for program 'a'} = {20:58.13, 42:19.28, 34:11.23}
B = {Response times for program 'b'} = {00:00.79, 00:00.42, 00:00.65}

Then we have:

Mean(A) = 1,949.547 seconds
Mean(B) = 0.620 seconds
Mean(A union B) =   975.083 seconds

So the real question is "does Mean(A union B) really mean anything?" The
answer is no, because A and B come from radically different
distributions. If you want to see some real problems here, imagine what
happens when B has 15,000 elements in it per day and A has 20 per day.
What does the combined average tell you? Nothing much, really, except
for contrivances like...

* "If on consecutive days, Count(A) = Count(B), but Mean(A union B)
changed dramatically, then something interesting has happened."

This type of phenomenon is an important part of the reason why any
method that uses count-based ratios (i.e., "hit ratios") to tune a
database is an unreliable method.

On the other hand, if you're recording response times for only a single
particular type of transaction (e.g., one list only for A, and another
list only for B), then the averages (Mean(A) and Mean(B)) should be
extremely instructive. The important thing is that you have to segment
your transactions into different lists.

For response times, the criterion for splitting a list like "A union B"
into separate lists like "A" and "B" is that the data in each individual
list should fit the so-called "exponential distribution". To figure out
whether a given list fits that distribution, you can either dust off
your old statistics books, or you can wait until about June and use the
Perl code that'll be supplied in the "Optimizing Response Time" book
(O'Reilly) I'm working on.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L

Hello Everyone,

Is there anything, called an "Average Response Time" for an Oracle
dat

RE: Limiting user connections with DBA Studio

2003-01-17 Thread maheswara.rao

Title: RE: Database Verification



Todd,
 
The 
previous DBA has granted them almost all the privileges except DBA 
privilege.  Now, when we tried to take away this SELECT_CATALOG_ROLE, then, 
these specific users started raising alarms.
 
So, 
what we are planning is to kill their session the moment we find that they are 
using DBA Studio. 
 
Rao

  -Original Message-From: Todd Carlson 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003 2:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Limiting user connections with DBA Studio
  
  They can’t use it 
  unless they can select from the data dictionary views. For example, if they 
  don’t the SELECT_CATALOG_ROLE role or DBA privs in 
  8.1.7 they can not use DBA Studio.
   
  
  Todd
   
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of 
  [EMAIL PROTECTED]Sent: Friday, January 17, 2003 11:09 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: 
  Limiting user connections with DBA Studio
   
  
  Some of 
  our users installed OEM on their local PC's.  They connect to the 
  database through DBA Studio.
  
   
  
  Is there 
  any way to prevent DBA Studio connections to the server?  I am thinking 
  of using on_logon trigger but no clue how to catch the 
  connection.
  
   
  
  Any 
  suggestions?
  
   
  
  Rao

RE: Minutes Since Midnight 2000

Yeah that would work if I want to use the database but I try to write things
in such a way that I can use them in other places and share them with other
non-DBA types, thus the reason I am not using Perl or GNU date.  Oracle-L
has some very good *nix scripters so that is why I posted it here, I get
faster better responses then many of the *nix lists.  Thanks for suggestion.

- E

-Original Message-
Sent: Friday, January 17, 2003 1:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Just idea, how about:

SQL> select 24*60*(sysdate - to_date('00-00-00-01-01-2000', 
'SS-MI-HH24-DD-MM-') ) from dual;

24*60*(SYSDATE-TO_DATE('00-00-00-01-01-2000','SS-MI-HH24-DD-MM-'))
--
1602151.58

You can spool this result to a file and then use  "cat | awk" to read the 
number back to your script.

HTH.

Guang



_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OT: HOTSOS Symposium

2003-01-17 Thread groups


Hi Larry,

  I am attending. Wonder who else on the list is attending. 

Regards,
Denny

Quoting Larry Elkins <[EMAIL PROTECTED]>:

> Listers,
> 
> Just curious if anyone from the list will be going to the HOTSOS
> Symposium
> in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good,
> but
> don't know yet if I will be able to tear away from work to attend. I'm
> already in Dallas so travel isn't the difficulty -- just finding the
> time is
> the trick.
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Limiting user connections with DBA Studio

Title: RE: Database Verification



They 
may have 'select any table' privilege :) 
 
- 
Kirti
 
-Original Message-From: Todd Carlson 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003 1:10 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Limiting user connections with DBA Studio

They can’t use it 
unless they can select from the data dictionary views. For example, if they 
don’t the SELECT_CATALOG_ROLE role or DBA privs in 
8.1.7 they can not use DBA Studio.
 

Todd
 
-Original 
Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On 
Behalf Of [EMAIL PROTECTED]Sent: Friday, January 17, 2003 11:09 
AMTo: Multiple recipients of 
list ORACLE-LSubject: Limiting 
user connections with DBA Studio
 

Some of 
our users installed OEM on their local PC's.  They connect to the database 
through DBA Studio.

 

Is there 
any way to prevent DBA Studio connections to the server?  I am thinking of 
using on_logon trigger but no clue how to catch the 
connection.

 

Any 
suggestions?

 

Rao

ORA-24333

2003-01-17 Thread Adriano Freire




Anybody know thats ORA
ORA-24333?
 
look:
oerr ora 2433324333, 0, "zero iteration 
count"// *Cause:  An iteration count of zero was specified for the 
statement// *Action: Specify the number of times this statement must be 
executed
When thats issue occur?
 
thanks
 
Adriano

Minutes Since Midnight 2000

2003-01-17 Thread Guang Mei

Just idea, how about:

SQL> select 24*60*(sysdate - to_date('00-00-00-01-01-2000', 
'SS-MI-HH24-DD-MM-') ) from dual;

24*60*(SYSDATE-TO_DATE('00-00-00-01-01-2000','SS-MI-HH24-DD-MM-'))
--
   1602151.58

You can spool this result to a file and then use  "cat | awk" to read the 
number back to your script.

HTH.

Guang

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Post, Ethan
Sent: Friday, January 17, 2003 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Minutes Since Midnight 2000


I have a very clunky way of calculating the # of minutes in shell since
2000.  This allows me to write the value to a variable and then do the math
later in a script to figure out how long a job ran, an alert has been
trigger etc...For those of you working in shell you know date math is not 
so
easy (without GNU date).  This is the simplest method I have found, I would
just like the function below to look a bit cleaner.

function Minutes {
   # Funky function I use to calculate the number of minutes since 2000
   MIN_YEAR=$( date +"%Y" )
   MIN_YEAR=$( expr ${MIN_YEAR} - 2000 )
   MIN_YEAR=$( expr ${MIN_YEAR} \* 525600 )
   MIN_DAYS=$( date +"%j" )
   MIN_DAYS=$( expr "${MIN_DAYS}" - 1 )
   MIN_DAYS=$( expr "${MIN_DAYS}" \* 1440 )
   MIN_HOURS=$( date +"%H" )
   MIN_HOURS=$( expr "${MIN_HOURS}" \* 60 )
   MIN_MINS=$( date +"%M" )
   MIN_TOTAL=$(( ${MIN_YEAR} + ${MIN_DAYS} + ${MIN_HOURS} + ${MIN_MINS} ))
   print ${MIN_TOTAL}
}

I am sure there is a more elegant way of doing this, anyone care to share
thier ideas/improvments/solutions?

Thanks,
Ethan

Perl is not an option Jared ;)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
  INET: [EMAIL PROTECTED]








_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Limiting user connections with DBA Studio

But the fundamental question is why prevent them. 
What damage are they causing? 
Control their actions via proper permissions. 
If OEM installation is against Company policy (or "they did not ask the Oracle DBA 
Group"), then the problem  should be addressed via other administrative procedures. 

- Kirti 

> [EMAIL PROTECTED] wrote:
> 
> Some of our users installed OEM on their local PC's.  They connect to
> the database through DBA Studio.
> 
> Is there any way to prevent DBA Studio connections to the server?  I
> am thinking of using on_logon trigger but no clue how to catch the
> connection.
> 
> Any suggestions?
> 
> Rao

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Limiting user connections with DBA Studio

2003-01-17 Thread Todd Carlson

Title: RE: Database Verification









They can’t use it unless they can
select from the data dictionary views. For example, if they don’t the
SELECT_CATALOG_ROLE role or DBA privs in 8.1.7 they
can not use DBA Studio.

 



Todd



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 17, 2003
11:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: Limiting user connections
with DBA Studio

 



Some of our users
installed OEM on their local PC's.  They connect to the database through
DBA Studio.





 





Is there any way to
prevent DBA Studio connections to the server?  I am thinking of using
on_logon trigger but no clue how to catch the connection.





 





Any suggestions?





 





Rao

RE: Calculating new PCTFREE and PCTUSED !!!!!1

2003-01-17 Thread Reddy, Madhusudana

Dennis,

Have you used the script ??

I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .

here is the script:

- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set pages ;
set feedback off;

spool pctused.lst;

define spare_rows = 2;

define blksz = 4096; ( I used 8192 )

select
' alter table '||owner||'.'||table_name||
' pctused '||least(round(100-((&spare_rows*avg_row_len)/(&blksz/10))),95)||
' '||
' pctfree '||greatest(round((&spare_rows*avg_row_len)/(&blksz/10)),5)||
';'
from
dba_tables
where
avg_row_len > 1
and
avg_row_len < 2000
and
table_name not in
(select table_name from dba_tab_columns b
where
data_type in ('RAW','LONG RAW')
)
order by owner, table_name
;

spool off;

Sample o/p:  alter table .TSFDETAIL pctused 95  pctfree 5;

And previous value for PCTFREE is 20  and the chained rows are 1054757 in
that table..



Does anyone have good idea to calculate PCTFREE would like to share with me
???


I need help !!!

Thanks
Madhu



-Original Message-
Sent: Wednesday, January 15, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L


Madhu
   Here is a good article that discusses the various aspects:
http://www.dba-oracle.com/art_pctfree.htm

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 15, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I have found some of the tables are heavily chained in one of the database .
I want to fix them by exp and imp, but before that I would like to have a
formula or some better method to identify the new PCTFREE and PCTUSED for
each individual table. 

Many of you have might have done this in the past , would you pl share your
ideas on this ??

Thanks in advance,
Madhu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: quest shareplex

2003-01-17 Thread Nick Wagner

Title: RE: quest shareplex





I was going to keep quite...  but here goes. :) 
-


Yes, of course I'll be glad to help.   


Basically... 


Log Based replication for Oracle.  A capture process continually reads the online redo logs and parses out information based on a list of tables you provide.  The raw redo log data is then converted into standard Oracle SQL, and using OCI calls is posted to target database(s).  The target(s) are fully open and available, so you can do peer-to-peer, reporting, failover, DR, upgrades, migrations... 

No SQL*Net, no Streams, no AQs, no triggers, no OAR.  


It's a pretty broad product,  so if you need more info, just let me know.


Nick


-Original Message-
From: Richard Ji [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: quest shareplex



Quest Shareplex is a replication software.


Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it.  Right Nick? :)


-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L



I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).



Anyone enlighten me.


thanks, joe



Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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 Silent Installs and Response files...

2003-01-17 Thread Rodrigues, Bryan

Greg,
 
If you are upgrading to Oracle 8.1.7.4 on a hp-ux server without an X-term
and trying to use silent install to get around it, don't do it. A DBA I work
with was trying to do it and ran into issues. I researched it on metalink
and found a thread that listed 3 bugs associated with this situation. 
 Silent Install from TELNET Session Gives Error: "DISPLAY NOT
SET" 

 Runinstaller Expects DISPLAY Variable to be Set for Silent
Install 

 OUI Installer Requires an X-DISPLAY to Connect to even in
Silent Mode 

I have not tried it in other situations, but be aware of this one.
 
Bryan Rodrigues
Elcom, Inc.
DBA

-Original Message-
Sent: Friday, January 17, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L


Hey guys-
Have any of you all messed around with the silent install/response files?
I'm looking for tips, advice, do's, don'ts,etc,etc  
 
TIA

Greg Loughmiller 
Sr Manager - Enterprise Data Architecture 
gloughmiller (IPS) 
678.893.3217 (office) 

 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Silent Installs and Response files...

2003-01-17 Thread Joseph S Testa

I'd have to agree w/Jared, its more like vaporware ;)

joe


> I've heard rumors of people getting it to work.
> 
> Some have claimed they have.
> 
> When asked to share their response files, I received nothing.
> 
> I once spent several hours attempting to setup a working
> response file.  No joy.
> 
> It's in the same class as bigfoot: several sightings, but the
> only photos are faked.
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Loughmiller, Greg" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  01/17/2003 06:24 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L 
> cc: 
> Subject:Oracle Silent Installs and Response files...
> 
> 
> Hey guys-
> Have any of you all messed around with the silent install/response 
files? 
> I'm looking for tips, advice, do's, don'ts,etc,etc 
>  
> TIA
> Greg Loughmiller 
> Sr Manager - Enterprise Data Architecture 
> gloughmiller (IPS) 
> 678.893.3217 (office) 
>  
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).
> 
> 

Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: temp space


Chris,

Add the following in your init.ora. event = "1652 trace name errorstack
level 3".  And check the user dump destination after u encounter the error.

In case, downtime is not an option, or you cannot set it at the individual
session levels , another way of doing it is by coding for a servererror on
database trigger, and then maybe, use dbms_system.ksdwrt to write the error
details in the alert log. I leave it to you to figure out the rest.

Hope this helps.

Raj





   

Chris Stephens 


ffina.com>  cc:

Sent by:Subject: temp space

[EMAIL PROTECTED]   

   

   

January 17, 2003   

09:54 AM   

Please respond 

to ORACLE-L

   

   





anyone know how to identify the session that caused a ORA-1652?


-thank you







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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: from Non-Archive-Mode to Archive-Mode


Arup,

>From your past replies to the list, I am surprised to hear you say this.
"If you have placed the init.ora parameter log_checkpoints_to_alert set to
TRUE, then your alert log file will have lines when the redo log group
switch fom one to the other."

Regards
Raj




   
 
"Arup Nanda"   
 

tmail.com>   cc:   
 
Sent by: Subject: Re: from Non-Archive-Mode to 
Archive-Mode 
root@fatcity.  
 
com
 
   
 
   
 
January 17,
 
2003 09:35 AM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




Murat,

The estimate of amount of space for archive logs come from your redo log
switch. If you have placed the init.ora parameter log_checkpoints_to_alert
set to TRUE, then your alert log file will have lines when the redo log
group switch fom one to the other. That will give you a rough idea of the
time it takes to fill up a redo log. If you are using archiving, the redo
log has to be written to disk. In any one given day, you can then calculate
the archive log generation.

Then comes how you want to back it up and clean up the space. If you have a
process running that will scan for archive logs; back them to tape and then
delete it, then you have to figure out how often this process runs and how
much archive log stays on the disk before getting deleted.

Changing the log mode of the tablespace level does not change teh redo log
genration in most cases. If you define a tablespace or an object as
nologging, only a few operations like ALTER TABLE .. PARTITION, ALTER INDEX
REBUILD, direct load are not logged, all others are. And in any case the
system tables are always logged.

HTH.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 5:08 AM


> Hi,
>
>   how can I calculate/estimate the extra disk space I'll need if I
> change the log mode from non-archive-mode to archive-mode. I want to
change
> the log mode of all my objects. Do I need to do this one-by-one or is it
> enough if I change the log mode of my tablesapces?
>
> Thanks in advance
>
> Murat
>
>
>
> --
> Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda
ozel
> haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen
mesaji
> geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet
Hizmetleri
> Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic
bir
> hukuksal sorumlulugu kabul etmez.
>
> This  e-mail  communication  is intended for the private use of the
persons
> named  above.  If  you  received  this message in error, please
immediately
> notify  the  sender  and  delete  it  from  your  system.  Rt.Net
Internet
> Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal
responsibility
> for the contents of this message.
> --
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MURAT BALKAS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 wa

RE: What gets written to redo on a rollback?

Bill,
A rollback will generate redo, so that it can be recovered. If a
system crashed during a rollback, the database must be able to recover to
the point at which the rollback had terminated. Since a rollback is applying
the undo records (think opposite actions), it is modifying data, so the
modification must be written.
As to why the logs are different sizes, do you by chance have it set
to perform log switchs at regular intervals? What else is in the redo logs?
Are there other records, perhaps related to space management?

Dan Fink

-Original Message-
Sent: Thursday, January 16, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L


I recently had a situation where a process went down and Oracle had to
roll back the transaction. The original transaction did around 60,000
inserts and/or updates. When Oracle did its rollback, it generated many redo
logs in a short period of time, but there seems to be a wide variety of
volume per redo log. I used Logminer to check what was written to these logs
during the rollback. Some of them had 1500 - 2000 records written to them
and others had as few as 1 or 2 records written. These, for the most part,
were the same types of records (for example, delete records to roll back the
effects of an insert). Why the disparity? It seems like in many cases, a lot
of redo log is wasted. The reason I am asking is that so many logs were
generated, it filled up my archive log directory before my script could run
to clean them out. Anybody have an explanation?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Caught YAPPing

2003-01-17 Thread Cary Millsap

Raj,

You can of course compute the average any list of numbers. However, if
your list contains data from fundamentally different types of data, then
your average will be meaningless. Example:

A = {Response times for program 'a'} = {20:58.13, 42:19.28, 34:11.23}
B = {Response times for program 'b'} = {00:00.79, 00:00.42, 00:00.65}

Then we have:

Mean(A) = 1,949.547 seconds
Mean(B) = 0.620 seconds
Mean(A union B) =   975.083 seconds

So the real question is "does Mean(A union B) really mean anything?" The
answer is no, because A and B come from radically different
distributions. If you want to see some real problems here, imagine what
happens when B has 15,000 elements in it per day and A has 20 per day.
What does the combined average tell you? Nothing much, really, except
for contrivances like...

* "If on consecutive days, Count(A) = Count(B), but Mean(A union B)
changed dramatically, then something interesting has happened."

This type of phenomenon is an important part of the reason why any
method that uses count-based ratios (i.e., "hit ratios") to tune a
database is an unreliable method.

On the other hand, if you're recording response times for only a single
particular type of transaction (e.g., one list only for A, and another
list only for B), then the averages (Mean(A) and Mean(B)) should be
extremely instructive. The important thing is that you have to segment
your transactions into different lists.

For response times, the criterion for splitting a list like "A union B"
into separate lists like "A" and "B" is that the data in each individual
list should fit the so-called "exponential distribution". To figure out
whether a given list fits that distribution, you can either dust off
your old statistics books, or you can wait until about June and use the
Perl code that'll be supplied in the "Optimizing Response Time" book
(O'Reilly) I'm working on.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L

Hello Everyone,

Is there anything, called an "Average Response Time" for an Oracle
database?  I got a request from one of the application owners as under :

< Snip>
If I can get a log of AVERAGE response time for 1/2 hour periods
starting
at 9am and running thru 5 pm I would be in heaven.   If I cannot get
this,
what would be of similar help.  Here is an example of what I would like
to
see, say, for today:
Time  Average Response time
9-9:30 2.3 sec
9:30-10  3.0 sec
10-10:303.3 sec
10:30-113.3 sec
11-11:304.5 sec
and so on (one report for each day)

When we get to 10 seconds we have trouble.  If we have spikes we can try
to
figure out why.  ALso, the cost of the above would be a factor.   We
have
NO money for this.


How can I get this from system or session wait tables or v$sysstat? Any
ideas?

Regards
Raj

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Catastrophic Failure Message on Windows 2K2 Server

2003-01-17 Thread Joe Dean









We are running into an issue here and I wanted to check to
see if anyone has encountered it.

 

We are getting a Windows Event Viewer message stating an
Oracle “Catastrophic Failure”. 
It seems to be centered around the Oracle
Services for Microsoft Transaction Server component.

I am running 9i release 1.

 

Any ideas?

 

---

Joe Dean - OCA, MCP, FCNP

Database Consultant

CRISNet by MEGG Associates

 

[EMAIL PROTECTED]

RE: Limiting user connections with DBA Studio

2003-01-17 Thread Mercadante, Thomas F

Title: RE: Database Verification



Rao,
 
why?  why prevent them from using a 
tool?
 
do 
they have privs to do anything?  if so, then you have bigger 
problems.  
 
the 
tool is never the issue.  the issue is what database account they are using 
to connect with.  if they have privs to change objects, then the tool does 
not matter - they can learn to do it using sqlplus.
 
take 
away dba privs from them, or change the password.  and give them a 
developers account.
 
hope 
this helps.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003 
  12:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Limiting user connections with DBA Studio
  Some 
  of our users installed OEM on their local PC's.  They connect to the 
  database through DBA Studio.
   
  Is 
  there any way to prevent DBA Studio connections to the server?  I am 
  thinking of using on_logon trigger but no clue how to catch the 
  connection.
   
  Any 
  suggestions?
   
  Rao

Re: Limiting user connections with DBA Studio

2003-01-17 Thread Stephane Faroult

> [EMAIL PROTECTED] wrote:
> 
> Some of our users installed OEM on their local PC's.  They connect to
> the database through DBA Studio.
> 
> Is there any way to prevent DBA Studio connections to the server?  I
> am thinking of using on_logon trigger but no clue how to catch the
> connection.
> 
> Any suggestions?
> 
> Rao

Rao,

  Check (in V$SESSION) whether DBA Studio sets something in the MODULE
column (SQL*Plus does it, TOAD does it, what I write does it, usually
:-)). I have often used this in triggers to authorize some operations
through some specific programs exclusively (or by cheating under
SQL*Plus) - you just have to call dbme_application_info.read_module.
However (sorry, I have not checked it) it is highly likely that the
on_logon trigger may fire before MODULE is set, since you must be
connected to call dbms_application_info.set_module. If it is set later,
you may use some killer job which checks from time to time and kills
session. Not very elegant, you cannot guarantee that users will not have
the time to do anything, but ...
Something which may be worth exploring, too, is whether DBA Studio makes
use of PRODUCT_USER_PROFILE.
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Installer does not run on Win 2k Service Pack 3

Installing via terminal services doesn't work because
it is actually a remote session.  A term services session
is not on the console, much like using telnet or ssh.

Jared





"Stephen Evans" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/17/2003 08:14 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Installer does not run on Win 2k Service Pack 3



this sounds weird, 

but i heard that installs will not work via terminal services for 8.1.7 

good luck, 

steve 





[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
01/16/2003 09:08 AM 
Please respond to ORACLE-L 

To:Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> 
cc: 
Subject:Installer does not run on Win 2k Service Pack 3



Hi DBAs,

Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?.
When I tried installing 8.1.6 and 8.1.7 the installer does not start.
Oracle 9.x installs fine.
I do not know if it related to SP3 or not as I was able to install on
similar server with SP 2.

Thanks
Rick

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Select magazine

And also an article about Summary Table Mgmt from Arup Nanda :) 

Kudos to all !! 

- Kirti 

-Original Message-
Sent: Friday, January 17, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


We also had a contribution on SLAs from the DBA Goddess of the list. It's
great to see the list members in print!

-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L


Speaking of Select, cudo's to Jared for the article on Perl in the recent
issue.
 I gave it the once over last night & then marked it for a more detailed
read. 
Just might have to learn it!!

Dick Goulet

Reply Separator
Author: "Ferenc Home" <[EMAIL PROTECTED]>
Date:   1/16/2003 4:09 PM

Hi Tony

Nice to see you up on the list again.

I take it Select magazine is still going ? Who do I contact for advertising
? and rates ?

Thanks. Regards :

Ferenc Mantfeld
Melbourne.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: quest shareplex

2003-01-17 Thread Paula_Stankus

Title: RE: quest shareplex





It allows for master to master replication.  My understanding is that Oracle's Data Guard now does the same thing.  Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle.  I understand that Data Guard now does the same thing.  It is a quest product and you can find more info at www.quest.com plus quest has a number of saved online webcasts and some involve shareplex.  Good luck.  Having experience with it it is somewhat of a bear to configure and work in any specific environment/database - at least in recent past versions.  

-Original Message-
From: Joseph S Testa [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: quest shareplex



I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).



Anyone enlighten me.


thanks, joe



Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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: iAS 903 902 install

2003-01-17 Thread Jeff Herrick

Barb,

I've been deploying forms over the web since OAS 4.07 and I had
Oracle WebServer experience going back to version 2. What I found
was that knowing all of that stuff made it worse for trying to
figure out 9IAS Rel 2 (9.03). What further complicates it (web
forms that is) is that if you read the documents on Metalink
regarding the forms listener 'Servlet' implementation then you
will be lost trying to set it up using 9.0.3

9IAS Rel 2 uses OC4J (Oracle Container 4 Java) to run the forms
listener servlet so most of the config is done for you already.
Your point of contact with the app server is the

IAS_HOME\forms90\server\formsweb.cfg

file which contains most of the variables that I used to hand-code
in the static html JInitiator file. What you need to do to get a
form up is

1) install the 9IAS Rel2 Infrastructure in its own home
2) intall the 9IAS Rel2 BI Forms and Reports install in its own home
3) install Forms9i/Reports9i in its own home
4) add a section called 'barb' to the IAS_HOME (not the infrastructure
   or forms home) \forms90\server\formsweb.cfg like the following

[barb]
form=your_main_menu.fmx
separateFrame=True
lookandfeel=Generic
otherparams=others parms your forms might need

5) Add your forms path to the FORMS90_PATH variable in the
   file IAS_HOME\forms90\server\default.env

6) bring up the IAS instance in the OEM brower and stop and
   start the BI_FORMS OC4J instance

7) point your browser at
   http://yourserver:yourport/forms90/f90servlet?config=barb

   and your form should come up

Note all of the port numbers that the install assigns. On a fresh
install I got port=1810 for the OEM console and port=7778 for the
first website.

In comparison to OAS/OWS it's easy, that's why I say that knowing
the earlier architectures can be even more confusing  =8-)

HTH

Jeff Herrick

On Fri, 17 Jan 2003, Barbara Baker wrote:

> List:
> I'm touching iAS for the first time ever.  I don't
> understand even basic stuff about it.
>
> The install I have includes 9.0.2 and 9.0.3.  The
> install says "9.0.3 is the first J2EE 1.3 compatible
> release of Oracle9iAS.  ..blah blah..  Oracle9iAS
> 9.0.3 contains only the J2EE and Web Cache
> Installation Type of Oracle9iAS and is compatible with
> Oracle9iAS 9.0.2 infrastructures for clustering,
> management, and security."
>
> Do I need to install 9.0.2 and then install 9.0.3 on
> top of it to get everyting I need?
>
> We're currently in an evaluation phase.  Developers
> want iAS to deploy forms, portal, and build apps with
> java.
>
> I have 9.0.3 installed, but don't really understand
> what I have, and we're not able to launch a form.
>
> Thanks for any help!
> (This is the most frustrating, confusing product I've
> ever seen)
> Barb
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Barbara Baker
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

"Imp.exe" and "Exp.exe"

2003-01-17 Thread Breno A. K. Magnago

I need two files (Imp.exe and exp.exe) for Oracle 8.1.5 on
Windows NT 4.0.
If someone have. Please send for me.

Thanks.
-- 
Breno A. K. Magnago   mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Breno A. K. Magnago
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: from Non-Archive-Mode to Archive-Mode

2003-01-17 Thread Adams, Matthew (GECP, MABG, 088130)

Title: RE: from Non-Archive-Mode to Archive-Mode





I personally use the following SQL to 
get a very rough estimate of how much 
archive space I'm going to need per day.


select (num_logs*bytes )/(1024*1024) "Megs per Day"
  from (select ceil(avg(count(*))) num_logs from v$log_history lh
 group by trunc(lh.first_time)),
   (select avg(bytes) bytes from v$log)
/



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: from Non-Archive-Mode to Archive-Mode




It depends on how much data is changed in the database.  If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup).  Look in the alert log to see how many
log switches occur.  I think this will give you a reasonable estimate of how
much archiving will occur.


-Original Message-
Sent: Friday, January 17, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L


Hi,


  how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?


Thanks in advance


Murat




--
Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda ozel
haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet  Hizmetleri
Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.


This  e-mail  communication  is intended for the private use of the persons
named  above.  If  you  received  this message in error, please immediately
notify  the  sender  and  delete  it  from  your  system.  Rt.Net  Internet
Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal responsibility
for the contents of this message.
--




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


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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: Moving tables from one tablespace to another tablespace

"It lets you control the commit frequency; something impossible in
export/import."


http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch02
.htm#40480

COMMIT
Default: N 

Specifies whether Import should commit after each array insert. By default,
Import commits only after loading each table, and Import performs a rollback
when an error occurs, before continuing with the next object. 

If a table has nested table columns or attributes, the contents of the
nested tables are imported as separate tables. Therefore, the contents of
the nested tables are always committed in a transaction distinct from the
transaction used to commit the outer table. 

If COMMIT=N and a table is partitioned, each partition and subpartition in
the Export file is imported in a separate transaction. 

Specifying COMMIT=Y prevents rollback segments from growing inordinately
large and improves the performance of large imports. Specifying COMMIT=Y is
advisable if the table has a uniqueness constraint. If the import is
restarted, any rows that have already been imported are rejected with a
nonfatal error. 

If a table does not have a uniqueness constraint, Import could produce
duplicate rows when you reimport the data. 

For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, DATE, or type
columns, array inserts are not done. If COMMIT=Y, Import commits these
tables after each row. 


-Original Message-
Sent: Friday, January 17, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L


You could use COPY command. Create a new table exactly as the old table in
the new tablespace from the DDL scripts. Then use the COPY command to insert
rows. It lets you control the commit frequency; something impossible in
export/import.

HTH.

Arup

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Minutes Since Midnight 2000

I have a very clunky way of calculating the # of minutes in shell since
2000.  This allows me to write the value to a variable and then do the math
later in a script to figure out how long a job ran, an alert has been
trigger etc...For those of you working in shell you know date math is not so
easy (without GNU date).  This is the simplest method I have found, I would
just like the function below to look a bit cleaner.

function Minutes {
   # Funky function I use to calculate the number of minutes since 2000
   MIN_YEAR=$( date +"%Y" )
   MIN_YEAR=$( expr ${MIN_YEAR} - 2000 )
   MIN_YEAR=$( expr ${MIN_YEAR} \* 525600 )
   MIN_DAYS=$( date +"%j" )
   MIN_DAYS=$( expr "${MIN_DAYS}" - 1 )
   MIN_DAYS=$( expr "${MIN_DAYS}" \* 1440 )
   MIN_HOURS=$( date +"%H" )
   MIN_HOURS=$( expr "${MIN_HOURS}" \* 60 )
   MIN_MINS=$( date +"%M" )
   MIN_TOTAL=$(( ${MIN_YEAR} + ${MIN_DAYS} + ${MIN_HOURS} + ${MIN_MINS} ))
   print ${MIN_TOTAL}
}

I am sure there is a more elegant way of doing this, anyone care to share
thier ideas/improvments/solutions?

Thanks,
Ethan

Perl is not an option Jared ;)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OT: HOTSOS Symposium

It's a maybe for me.

Waiting for the execs to finalize our budget.

Jared






"Larry Elkins" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/16/2003 04:19 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:OT: HOTSOS Symposium


Listers,

Just curious if anyone from the list will be going to the HOTSOS Symposium
in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good, but
don't know yet if I will be able to tear away from work to attend. I'm
already in Dallas so travel isn't the difficulty -- just finding the time 
is
the trick.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: incremental export

...incremental exports/imports are depreciated in 9i


They weren't worth much to start with.  ;)

Jared





Freeman Robert - IL <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/17/2003 05:53 AM
 Please respond to ORACLE-L

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


Plus incremental exports/imports are depreciated in 9i and, though I'm not
sure,
will probably go away in 10i.

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Friday, January 17, 2003 4:54 AM
To: Multiple recipients of list ORACLE-L


an incremental export does not export just the new rows but ALL the
data in the table. It will, however, only export if there has been a
change to the table, thus the "incremental"


--- Krishna Kakatur <[EMAIL PROTECTED]> wrote:
> How about using incremental exports/ imports?
> 
> HTH, Krishna
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 16, 2003 11:19 AM
> 
> 
> > Use the query= feature of export. This will work if there is a
> timestamp
> > column where you can determine which are the 'new' records.
> >
> > -Original Message-
> > Sent: Thursday, January 16, 2003 11:49 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > how about, database link
> >
> > -Original Message-
> > Sent: 17 January 2003 01:46
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > replication
> >
> > -Original Message-
> > Sent: quinta-feira, 16 de Janeiro de 2003 15:09
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > List,
> >
> > I have to move data on a regular basis between two instances of 
> 8.1.7 on
> > two different UNIX servers.  The schema is exactly the same.  There
> are
> 543
> > tables to be "refreshed".  It is only the "new data" on one of the
> servers
> > to move to the other.  What is the best and easiest way to do this?
> >
> > thanks,
> >
> > David Ehresmann
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ehresmann, David
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Sinardy Xing
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Fink, Dan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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

Limiting user connections with DBA Studio

2003-01-17 Thread maheswara.rao

Title: RE: Database Verification



Some 
of our users installed OEM on their local PC's.  They connect to the 
database through DBA Studio.
 
Is 
there any way to prevent DBA Studio connections to the server?  I am 
thinking of using on_logon trigger but no clue how to catch the 
connection.
 
Any 
suggestions?
 
Rao

Positive comments

Though you might like to see these comments from
a relative newcomer to the list:

-
I only came across this list a month or so ago and i can't tell you how 
much i've learned. 
this list has honestly renewed my interest in the profession and instead 
of just getting 
the job done, I suddenly have a sincere interest in doing things to the 
best of my ability.
-

Jared

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: iAS 903 902 install

2003-01-17 Thread Brian Dunbar

Sympathies are in order.  Prior to September, 2002 I'd never touched the
pesky thing.  $WORK send me to the 9iAS (R2) course, after which of course
it was decided we'd stick with R1 until the Fat Lady sings.  I'm still
groping, trying to figure out why the consultants and developers set things
up the way they did.

Things I've learned the hard way

-Metalink < http://metalink.oracle.com/> is your friend.  It can be like
trying to sip from a firehose at times, however.

-Oracle 'likes' fully qualified domain names, and doesn't seem to be aware
of this mysterious thing called 'DNS'.

- You will never, ever be able to make any changes in an installed 9iAS
server without bringing the house of cards down.  Don't even think of trying
to move directories and symlink to them.

-Oracle, as a company, doesn't like system administrators.  Why else make
such a wanked product that defies Best Practices for admin and is so
entrenched you can't eradicate it with dynamite?

-Everything is, or will be, a database, even stuff that isn't or shouldn't
ever be.  See above.

Brian

-Original Message-
Sent: Friday, January 17, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L


List:
I'm touching iAS for the first time ever.  I don't
understand even basic stuff about it.

The install I have includes 9.0.2 and 9.0.3.  The
install says "9.0.3 is the first J2EE 1.3 compatible
release of Oracle9iAS.  ..blah blah..  Oracle9iAS
9.0.3 contains only the J2EE and Web Cache
Installation Type of Oracle9iAS and is compatible with
Oracle9iAS 9.0.2 infrastructures for clustering,
management, and security."

Do I need to install 9.0.2 and then install 9.0.3 on
top of it to get everyting I need?

We're currently in an evaluation phase.  Developers
want iAS to deploy forms, portal, and build apps with
java.

I have 9.0.3 installed, but don't really understand
what I have, and we're not able to launch a form.

Thanks for any help!
(This is the most frustrating, confusing product I've
ever seen)
Barb


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Brian Dunbar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Alter table monitoring ... impact on performance??

That's the one I had in mind.

It was from Steve.

Jared





"Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/16/2003 03:59 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Alter table monitoring ... impact on performance??


>From Steve Adam's July 2000 newsletter 
>(http://www.ixora.com.au/newsletter/2000_07.htm, line spacing below is mine):

"
Despite the potential for improved statistics gathering, many DBAs have
not yet adopted modification monitoring. 


One of the concerns that people have is that the monitoring might have a 
significant performance overhead.
In fact, this is not the case. 


The modification counts are maintained in
an efficient hash table is the SGA, and are updated without the protection
of a latch (although the structure of the hash table itself is protected
by the hash table modification latch). Even in heavy OLTP environments,
the cost of maintaining the modification counts is likely to be less than
1% of additional CPU usage. However, because of the latch-free nature of
the feature, the modification counts are not guaranteed to be accurate.
Another source of potential inaccuracy is that if a transaction is rolled
back, its changes to the modification counts are not rolled back as well.
These inaccuracies have been allowed by Oracle to keep the performance
overhead of this feature minimal. Therefore, you can use modification
monitoring with confidence that it will not affect performance
significantly, while giving you a very helpful indication of which tables
may have stale statistics. 
"

HTH,
Bruce Reardon

-Original Message-
Sent: Friday, 17 January 2003 10:26 AM

I've seen mention a of negligible performance hit for this.

It was from someone I trust, but I can't recall just who that  was.

Jared

---


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: v$Views and d$Tables

Not a problem... 
I have not bought your book yet... :(
And I *would* expect more & useful information in your book, than just 'describes' ;)  

- Kirti 

-Original Message-
Sent: Friday, January 17, 2003 10:11 AM
To: Multiple recipients of list ORACLE-L

so does Oracle9i DBA 101 and it explains them too

I'm so ashamed, it won't happen again

--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> http://tahiti.oracle.com
> Look in Database Reference Guide. 
> Or if you have Rich Niemiec's book (Performance Tuning Tips &
> Techniques... etc..) there are a number of pages showing the output
> from 'describe' of many of such views. 
>  
> - Kirti 
>  
> -Original Message-
> Sent: Friday, January 17, 2003 1:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello all,
>  
> Could anyone of you give me a list of v$views and d$tables  and
> their description... ?
> I am not able to log-in to dba ...i don't have access to it...
> or any links/documents where i can find them..
>  
> Thanks and Regards,
> Santosh
>  
> 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread M Rafiq

Robert,

Surprising


Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com

When did you join TUSC? It looks that all guru's are joining TUSC.

Regards

Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 17 Jan 2003 07:39:52 -0800

No need to do any of this if you are using RMAN. With each backup, RMAN
checks each block backed up for any corruption. Corruption will be reported
and you
can opt to allow a certain amount of it or none.

Rf

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Friday, January 17, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


I would do all three.  A good backup stategy is only good if you read all
your data all the time.  You can have corrupt data that doesn't get read and
doesn't cause a problem for weeks, month, years.  By that time you have no
backup that does not contain corrupt data.  Export to a null file to speed
things up a little, just keep the log file.  DBVerify is very useful.

R.Smith

-Original Message-
Sent: Friday, January 17, 2003 7:59 AM
To: Multiple recipients of list ORACLE-L


>I am considering the appropriate way to do database
>corruption prevention.
>
>Should I use  one or more of the following as a
>proactive measure ?
>  a) Export
>  b) DBVerify
>  c) Analyze table  validate structure
>cascade
>
>Any advice ?
>
>Thanks,
>
>PH
>

Pui Ho,

   The only way you can be 'proactive' concerning corruption is to have a
sound backup strategy - if you really feel nervous about your hardware,
first change it, and then use archive logging and the rest; export is a bad
solution, because it will be long to restore. By definition, a corruption
doesn't give any warning (it's even worth than earthquakes). If you want to
be very reactive, set something to regularly scan your alert.log file.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).


_
MSN 8: advanced junk mail protection and 2 months FREE*. 
http://join.msn.com/?page=features/junkmail

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 nam

Re: Oracle Silent Installs and Response files...

I've heard rumors of people getting it to work.

Some have claimed they have.

When asked to share their response files, I received nothing.

I once spent several hours attempting to setup a working
response file.  No joy.

It's in the same class as bigfoot: several sightings, but the
only photos are faked.

Jared






"Loughmiller, Greg" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/17/2003 06:24 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle Silent Installs and Response files...


Hey guys-
Have any of you all messed around with the silent install/response files? 
I'm looking for tips, advice, do's, don'ts,etc,etc 
 
TIA
Greg Loughmiller 
Sr Manager - Enterprise Data Architecture 
gloughmiller (IPS) 
678.893.3217 (office) 
 


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: quest shareplex

2003-01-17 Thread Richard Ji

Quest Shareplex is a replication software.

Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it.  Right Nick? :)

-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L


I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).


Anyone enlighten me.

thanks, joe


Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MAX Length of Name for Table / Index ?

Darn !!  
The cut & paste ate up a few chars in that 'create table' line. 
But you get the picture ;) 
- Kirti 

-Original Message-
Sent: Friday, January 17, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L



1) 
SVRMGR> create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
 *
ORA-00972: identifier is too long
SVRMGR> !oerr ora 972
00972, 0, "identifier is too long"
// *Cause:  An identifier with more than 30 characters was specified.
// *Action:  Specify at most 30 characters.
SVRMGR> 

You can try this test for an Index ;) 

2)
Larry & the gang decided that ;) 

- Kirti  

-Original Message-
Sent: Friday, January 17, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L



What is the MAX possible Length of of Name for Table / Index ?

Why ?

Thanks

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

also send the HELP command for other information (like subscribing).



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: from Non-Archive-Mode to Archive-Mode

2003-01-17 Thread Stephen Lee


It depends on how much data is changed in the database.  If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup).  Look in the alert log to see how many
log switches occur.  I think this will give you a reasonable estimate of how
much archiving will occur.

-Original Message-
Sent: Friday, January 17, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L

Hi,

  how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?

Thanks in advance

Murat



--
Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda ozel
haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet  Hizmetleri
Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.

This  e-mail  communication  is intended for the private use of the persons
named  above.  If  you  received  this message in error, please immediately
notify  the  sender  and  delete  it  from  your  system.  Rt.Net  Internet
Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal responsibility
for the contents of this message.
--



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Select magazine

We also had a contribution on SLAs from the DBA Goddess of the list. It's
great to see the list members in print!

-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L


Speaking of Select, cudo's to Jared for the article on Perl in the recent
issue.
 I gave it the once over last night & then marked it for a more detailed
read. 
Just might have to learn it!!

Dick Goulet

Reply Separator
Author: "Ferenc Home" <[EMAIL PROTECTED]>
Date:   1/16/2003 4:09 PM

Hi Tony

Nice to see you up on the list again.

I take it Select magazine is still going ? Who do I contact for advertising
? and rates ?

Thanks. Regards :

Ferenc Mantfeld
Melbourne.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: v$Views and d$Tables

2003-01-17 Thread Rachel Carmichael

so does Oracle9i DBA 101 and it explains them too

I'm so ashamed, it won't happen again

--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> http://tahiti.oracle.com
> Look in Database Reference Guide. 
> Or if you have Rich Niemiec's book (Performance Tuning Tips &
> Techniques... etc..) there are a number of pages showing the output
> from 'describe' of many of such views. 
>  
> - Kirti 
>  
> -Original Message-
> Sent: Friday, January 17, 2003 1:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello all,
>  
> Could anyone of you give me a list of v$views and d$tables  and
> their description... ?
> I am not able to log-in to dba ...i don't have access to it...
> or any links/documents where i can find them..
>  
> Thanks and Regards,
> Santosh
>  
> 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Moving tables from one tablespace to another tablespace

You could use COPY command. Create a new table exactly as the old table in
the new tablespace from the DDL scripts. Then use the COPY command to insert
rows. It lets you control the commit frequency; something impossible in
export/import.

HTH.

Arup


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 2:33 AM


> Hi
>
> I need to move some tables from one tablespace to another. I started doing
> it using
>
> alter table tablename move tablespace new_tablespace;
>
> this is working fine!!. My problem is it's not working with the table
which
> are having long columns.
>
> I know work arround for this  exp.. drop and create .. then imp.
>
> There is any other way round for this..
>
> thanks in advance
>
> Banarasi Babu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: BanarasiBabu Tippa
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

quest shareplex

2003-01-17 Thread Joseph S Testa

I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).


Anyone enlighten me.

thanks, joe


Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: [Q] SMON take too much time to clean up?

2003-01-17 Thread O'Neill, Sean

>>From: "dist cash" <[EMAIL PROTECTED]>
>> Date: Wed, 15 Jan 2003 07:23:54 -0500
>> Subject: [Q] SMON take too much time to clean up?
>>
>>we have ORACLE 8.1.7 on NT server and this erver only run ORACLE
>>application.  Sometime the server will have 100% CPU usage form 20 minutes
>>to couple hours.  In that time No one can login or do anything.  We guess
>>the problem come from SMON, but all of the tablespaces pct_increase is 0
>>(except SYSTEM).  The only thing I can guess is SMON clean the Temporary
>>Tablespace (our temporary tablespace define as dicrionary Temporary
>>temporary tablespace).  Does their has way to reduce or avoid this
>>problem?

If you have not already looked at the following MetaLink Doc's might be of
use/interest re above:

164768.1
116236.1
61997.1
118883.1
76438.1

HTH,
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Stephen Lee


If I recall correctly, RMAN checks for corruption.

-Original Message-
 
I am considering the appropriate way to do database corruption prevention.

Should I use  one or more of the following as a proactive measure ?
  a) Export  
  b) DBVerify  
  c) Analyze table  validate structure cascade 

Any advice ?

Thanks,

PH



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Mercadante, Thomas F

Use Rman.

Rman automatically detects and reports corrupt blocks.

right Robert?  :)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, January 17, 2003 7:28 AM
To: Multiple recipients of list ORACLE-L


I am considering the appropriate way to do database corruption prevention.

Should I use  one or more of the following as a proactive measure ?
  a) Export  
  b) DBVerify  
  c) Analyze table  validate structure cascade 

Any advice ?

Thanks,

PH


___
i-Urban Free 60MB Email Box, register NOW http://www.i-urban.com.hk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pui Ho Chan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 9i on windows

2003-01-17 Thread Joe Armstrong-Champ

We are thinking of upgrading some of our windows databases (NT 4) to 9i.
We may be upgrading the OS to w2k also. The databases are small
applications and don't require much maintenance. 

What are people's experience with 9i (9.0.1 and 9.2) on windows? We are
mostly concerned with the stability of the releases. I have heard that
9.0.1 has lots of bugs. Does anyone know if this is true? What about
9.2? 

Thanks. 
Joe Armstrong-Champ 
DBA 
Tufts University 
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Armstrong-Champ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database tracking

2003-01-17 Thread Orr, Steve

Title: RE: Database tracking

Yes.
Stay tuned... about 2-3 months.

-Original Message-From: Leonard, George
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003
2:24 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database tracking

Are you willing to
share the solution with us ?

George

George
Leonard
Oracle
Database Administrator
Dimension
Data (Pty) Ltd
(Reg.
No. 1987/006597/07)
Cell:
(+27) 82 655 2466
Tel: (+27
11) 575 0573
Fax: (+27
11) 576 0573
E-mail:[EMAIL PROTECTED]
Web:
http://www.didata.co.za
You
Have The Obligation to Inform One Honestly of the risk, And As a
Person
You
Are Committed to Educate Yourself to the Total Risk In Any
Activity!
Once
Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or
Injure Themselves as They See Fit!
-Original
Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 18:55
PMTo:
Multiple recipients of list
ORACLE-LSubject: RE: Database
tracking
I concur with the recommendation to use STATSPACK but
you might want to augment it. I take STATSPACK snapshots every 15 minutes and
if there's a performance problem caused by a few bad queries I can usually
isolate the offenders. But constant fined-grained STATSPACK snapshots can be a
lot of overhead so you may want something more lightweight.

I've developed a DBA web app which queries V$SYSSTAT
and V$SYSTEM_EVENT every minute. I assume regular queries on these tables do
not impact system performance enough to worry about. I record the result sets
from these queries outside of Oracle in a very light weight RRDTool "round
robin database." (RRDTool is free, http://people.ee.ethz.ch/~oetiker/webtools/rrdtool/.) From
this I can produce 55 graphs on demand for 5 different time spans: daily;
weekly; monthly; quarterly; and yearly. Of course damagement loves
graphs/pictures. The storage needed for one plus year's worth of minute to
minute V$SYSSTAT/V$SYSTEM_EVENT query data only comes to 3.2MB for each
database instance being monitored. A cool thing to do is produce a graph with
a visually obvious spike in some V$SYSTEM_EVENT wait statistic at say 3:15PM
yesterday then correlate that graphic spike to a specific problem query as
recorded in STATSPACK. It provides nice "smoking gun" incriminating evidence
to be used for putting duhvelopers on trial.
Steve Orr Bozeman, MT
-Original Message- From: Terrian, Tom (Contractor) (DAASC)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15,
2003 12:52 PM To:
Multiple recipients of list ORACLE-L Subject: RE: Database tracking

Ok, thanks
-Original Message- Sent: Wednesday, January 15, 2003 2:10
PM To: Multiple
recipients of list ORACLE-L
Tom - I'll provide an example of what we do and maybe
it will give you some ideas. On one database, the users have identified a
certain process that has marginal performance at best, and when anything gets
out of whack it gets bad real fast. So the developers have added a logging
feature in the application. When the user hits "submit", that is logged, along
with the username and other relevant data. When the results are returned to the
user, that is also logged. Now we have a measurement from the user's perspective.
This has allowed us to detect problems a number of times before they were
serious. When the users have complained about intolerable performance it has given
us some actual numbers to review (rather than opinions or impressions).
I
think you have a good idea, but if possible you should go
end-to-end, rather than just the database. I would go with
STATSPACK snapshots if you just want to look at the server. That gives you an overall
server status, while a single query may not detect a lot of severe problems.

Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]
-Original Message- Sent: Wednesday, January 15, 2003 11:54
AM To: Multiple
recipients of list ORACLE-L
All, I would like to track the performance of my
production databases by running the same SQL statement against each database every 5
minutes or so and recording the results. For example:
sql> set timing
on; sql>
select count(*) from dba_tables; That was I would know if they are getting faster or
slower over time. As anyone already done this? Would there be a good SQL
statement to use? Thanks, Tom Terrian

RE: HOTSOS Symposium

Title: RE: HOTSOS Symposium



I will be there, looking forward to meeting you, won't be staying at the 
hotel since I live in Dallas.

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 
  2003 10:29 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: HOTSOS Symposium
  Larry, 
  I'll be there ... 
  Raj 
  -Original Message- From: Larry 
  Elkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 7:19 PM To: 
  Multiple recipients of list ORACLE-L Subject: OT: 
  HOTSOS Symposium 
  Listers, 
  Just curious if anyone from the list will be going to the 
  HOTSOS Symposium in Dallas on 2/9 thru 2/12? It sounds 
  like it should be pretty good, but don't know yet if I 
  will be able to tear away from work to attend. I'm already in Dallas so travel isn't the difficulty -- just finding the 
  time is the trick. 
  Regards, 
  Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Larry Elkins   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  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).

iAS 903 902 install

2003-01-17 Thread Barbara Baker

List:
I'm touching iAS for the first time ever.  I don't
understand even basic stuff about it.

The install I have includes 9.0.2 and 9.0.3.  The
install says "9.0.3 is the first J2EE 1.3 compatible
release of Oracle9iAS.  ..blah blah..  Oracle9iAS
9.0.3 contains only the J2EE and Web Cache
Installation Type of Oracle9iAS and is compatible with
Oracle9iAS 9.0.2 infrastructures for clustering,
management, and security."

Do I need to install 9.0.2 and then install 9.0.3 on
top of it to get everyting I need?

We're currently in an evaluation phase.  Developers
want iAS to deploy forms, portal, and build apps with
java.

I have 9.0.3 installed, but don't really understand
what I have, and we're not able to launch a form.

Thanks for any help!
(This is the most frustrating, confusing product I've
ever seen)
Barb


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OT: HOTSOS Symposium

2003-01-17 Thread Charlie_Mengler


I'm signed up & am looking forward to attending it!



   
 
  "Larry Elkins"   
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  t>   cc: 
 
  Sent by: Subject:  OT: HOTSOS Symposium  
 
  [EMAIL PROTECTED] 
 
   
 
   
 
  01/16/2003 04:19 
 
  PM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Listers,

Just curious if anyone from the list will be going to the HOTSOS Symposium
in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good, but
don't know yet if I will be able to tear away from work to attend. I'm
already in Dallas so travel isn't the difficulty -- just finding the time
is
the trick.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MAX Length of Name for Table / Index ?

2003-01-17 Thread M Rafiq


'A234567890123456789012345678901234567890'

The table name should not exceed 30 Characters...

Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 17 Jan 2003 06:58:57 -0800

The why is related to the data dictionary...

-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L



1)
SVRMGR> create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
 *
ORA-00972: identifier is too long
SVRMGR> !oerr ora 972
00972, 0, "identifier is too long"
// *Cause:  An identifier with more than 30 characters was specified.
// *Action:  Specify at most 30 characters.
SVRMGR>

You can try this test for an Index ;)

2)
Larry & the gang decided that ;)

- Kirti

-Original Message-
Sent: Friday, January 17, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L



What is the MAX possible Length of of Name for Table / Index ?

Why ?

Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).


_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Koivu, Lisa

Title: RE: Database Verification





FWIW:


The other answers have been correct as to what to do to check for corruption. 


As far as preventing it??  I don't know of a way you can PREVENT it from happening.  When it happens, it's usually something out of your hands (bad hardware, glitch in OS, etc.)  

Maybe the best way to prevent it is to research corruption fully when it happens and ensure that whatever it is that caused it never happens again.  Complete testing before upgrades (if you have the luxury of a complete testing environment) would be prudent. 

Comes down to, you have to trust your OS and your hardware.  What choice do you have??  


Have a great weekend, everyone.


Lisa Koivu
Wanton Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063




-Original Message-
From: Pui Ho Chan [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 7:28 AM
To: Multiple recipients of list ORACLE-L
Subject: Database Verification



I am considering the appropriate way to do database corruption prevention.


Should I use  one or more of the following as a proactive measure ?
  a) Export  
  b) DBVerify  
  c) Analyze table  validate structure cascade 


Any advice ?


Thanks,


PH



___
i-Urban Free 60MB Email Box, register NOW http://www.i-urban.com.hk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pui Ho Chan
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
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:

2003-01-17 Thread Ehresmann, David

If I use Replication such as:

create materialized view EMP
storage (...)
tablespace ...
refresh fast
start with sysdate next sysdate+1
as
select * from emp@remote_connect;

1) I am bringing the new emp data over from the remote_connect database?

2) This is a materialized view with  a local base table.  When my user comes
in and selects from emp how does he get the new data?  Does Oracle join the
local base table and emp table?  Does it access the view?  Or does Oracle
actually copy the new data into the emp table from the view and local base
table?

thanks

David Ehresmann.

-Original Message-
Sent: Friday, January 17, 2003 4:54 AM
To: Multiple recipients of list ORACLE-L


an incremental export does not export just the new rows but ALL the
data in the table. It will, however, only export if there has been a
change to the table, thus the "incremental"


--- Krishna Kakatur <[EMAIL PROTECTED]> wrote:
> How about using incremental exports/ imports?
> 
> HTH, Krishna
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 16, 2003 11:19 AM
> 
> 
> > Use the query= feature of export. This will work if there is a
> timestamp
> > column where you can determine which are the 'new' records.
> >
> > -Original Message-
> > Sent: Thursday, January 16, 2003 11:49 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > how about, database link
> >
> > -Original Message-
> > Sent: 17 January 2003 01:46
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > replication
> >
> > -Original Message-
> > Sent: quinta-feira, 16 de Janeiro de 2003 15:09
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > List,
> >
> > I have to move data on a regular basis between two instances of 
> 8.1.7 on
> > two different UNIX servers.  The schema is exactly the same.  There
> are
> 543
> > tables to be "refreshed".  It is only the "new data" on one of the
> servers
> > to move to the other.  What is the best and easiest way to do this?
> >
> > thanks,
> >
> > David Ehresmann
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ehresmann, David
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Paulo Gomes
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Sinardy Xing
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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.net
> > --
> > Author: Fink, Dan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > 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

Re: MAX Length of of Name for Table / Index ?

They are 30 characters, each.

Why? Well, there has to be some limit on the length. 30 seems an ok number.
While designing the table names, anything more than 30 chars seems a bit
difficult to digest. But then again, Oracle should have given the option to
use a longer name, too. Particularly in indexes this seems a tad bit small.
In 10i, it may be more.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 6:58 AM


>
> What is the MAX possible Length of of Name for Table / Index ?
>
> Why ?
>
> Thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: VIVEK_SHARMA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

Pui Ho,
Stephane raises a good point, unfortunately, many operations groups
stop at the backup. It is not the responsibility of operations to backup the
database/system. It is the responsibility of operations to recover the
database/system. There are many stories of backups that execute flawlessly,
but they cannot be used to recover. An untested backup strategy is an
invalid backup strategy.
As for the corruption, export and dbverify each have
advantages/disadvantages. 
Export performs a full table scan on each table in the exported
schema. However, it does not export SYS objects and it does not read the
indexes. It may/may not read rollback segments. 
Dbverify reads the header and footer of each block in the datafile.
As I recall (from the Internals seminar 3 years ago), it does not read the
bytes in between, so a corruption may be missed. It also may report
incorrectly, if the block it is verifying is written at the same time.

To guard against corruption, do 3 things. 
1) Have a solid and tested recovery process
2) Run periodic exports (send output to /dev/null)
3) Run dbv on live datafiles (during slow times) and backup files
(if kept on disk)

Dan Fink

-Original Message-
Sent: Friday, January 17, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L


>I am considering the appropriate way to do database
>corruption prevention.
>
>Should I use  one or more of the following as a
>proactive measure ?
>  a) Export  
>  b) DBVerify  
>  c) Analyze table  validate structure
>cascade 
>
>Any advice ?
>
>Thanks,
>
>PH
>

Pui Ho,

   The only way you can be 'proactive' concerning corruption is to have a
sound backup strategy - if you really feel nervous about your hardware,
first change it, and then use archive logging and the rest; export is a bad
solution, because it will be long to restore. By definition, a corruption
doesn't give any warning (it's even worth than earthquakes). If you want to
be very reactive, set something to regularly scan your alert.log file.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Installer does not run on Win 2k Service Pack 3

2003-01-17 Thread Stephen Evans


this sounds weird,

but i heard that installs will not work via terminal services for 8.1.7

good luck,

steve








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/16/2003 09:08 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Installer does not run on Win 2k Service Pack 3


Hi DBAs,

Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?.
When I tried installing 8.1.6 and 8.1.7 the installer does not start.
Oracle 9.x installs fine.
I do not know if it related to SP3 or not as I was able to install on
similar server with SP 2.

Thanks
Rick

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Freeman Robert - IL

No need to do any of this if you are using RMAN. With each backup, RMAN
checks each block backed up for any corruption. Corruption will be reported
and you
can opt to allow a certain amount of it or none.

Rf

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Friday, January 17, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


I would do all three.  A good backup stategy is only good if you read all
your data all the time.  You can have corrupt data that doesn't get read and
doesn't cause a problem for weeks, month, years.  By that time you have no
backup that does not contain corrupt data.  Export to a null file to speed
things up a little, just keep the log file.  DBVerify is very useful.

R.Smith

-Original Message-
Sent: Friday, January 17, 2003 7:59 AM
To: Multiple recipients of list ORACLE-L


>I am considering the appropriate way to do database
>corruption prevention.
>
>Should I use  one or more of the following as a
>proactive measure ?
>  a) Export  
>  b) DBVerify  
>  c) Analyze table  validate structure
>cascade
>
>Any advice ?
>
>Thanks,
>
>PH
>

Pui Ho,

   The only way you can be 'proactive' concerning corruption is to have a
sound backup strategy - if you really feel nervous about your hardware,
first change it, and then use archive logging and the rest; export is a bad
solution, because it will be long to restore. By definition, a corruption
doesn't give any warning (it's even worth than earthquakes). If you want to
be very reactive, set something to regularly scan your alert.log file.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification

2003-01-17 Thread Smith, Ron L.

We had a corrupt index block which caused an ORA-600 which was not noticed
and eventually brought down the database.
We do lots of checks now.  (d) All of the above.

R. Smith

-Original Message-
Sent: Friday, January 17, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


(d) All of the above

i) Export to /dev/null will go through all the fields of all the tables, all
the rows, but will not scan indexes
ii) Dbverify will scan for block corruptions but not logical corruptions.
iii) Analyze will check for table-index logical corruption.

Practically, you could just do an export to /dev/null and make sure the
table data is correct. Index can be rebuilt, so it's not as important.

HTH.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 7:28 AM


> I am considering the appropriate way to do database corruption 
> prevention.
>
> Should I use  one or more of the following as a proactive measure ?
>   a) Export
>   b) DBVerify
>   c) Analyze table  validate structure cascade
>
> Any advice ?
>
> Thanks,
>
> PH
>
>
> ___
> i-Urban Free 60MB Email Box, register NOW http://www.i-urban.com.hk
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pui Ho Chan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Silent Installs and Response files...

2003-01-17 Thread Loughmiller, Greg




Hey 
guys-
Have any of you all 
messed around with the silent install/response files?  I'm looking for 
tips, advice, do's, don'ts,etc,etc  
 
TIA
Greg Loughmiller 
Sr Manager - Enterprise 
Data Architecture gloughmiller (IPS) 678.893.3217 (office)

Re:from Non-Archive-Mode to Archive-Mode

2003-01-17 Thread dgoulet

Murat,

Whether your in archive log or no archive log mode is a database wide thing.
It is not set at the tablespace or object level.  As for how much disk will you
need, connect to the database with svrmgrl or SQL*Plus as sys and issue the
"archive log list" command.  Take the oldest online log sequence number,
multiple by your online redo log size and divide by the number of days since you
created the instance.  That should provide you with the average amount of redo
you produce per day.  Now to be on the safe side, I'd acquire twice that much
disk, just in case.

Dick Goulet

Reply Separator
Author: "MURAT BALKAS" <[EMAIL PROTECTED]>
Date:   1/17/2003 2:08 AM

Hi,

  how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?

Thanks in advance

Murat



--
Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda ozel
haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet  Hizmetleri
Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.

This  e-mail  communication  is intended for the private use of the persons
named  above.  If  you  received  this message in error, please immediately
notify  the  sender  and  delete  it  from  your  system.  Rt.Net  Internet
Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal responsibility
for the contents of this message.
--



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification


Just use RMAN to backup your databases. It will warn you about corruptions.

Raj




   
   
"Stephane  
   
Faroult"   To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
 Subject: RE: Database Verification  
   
Sent by:   
   
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
January 17,
   
2003 08:59 AM  
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




>I am considering the appropriate way to do database
>corruption prevention.
>
>Should I use  one or more of the following as a
>proactive measure ?
>  a) Export
>  b) DBVerify
>  c) Analyze table  validate structure
>cascade
>
>Any advice ?
>
>Thanks,
>
>PH
>

Pui Ho,

   The only way you can be 'proactive' concerning corruption is to have a
sound backup strategy - if you really feel nervous about your hardware,
first change it, and then use archive logging and the rest; export is a bad
solution, because it will be long to restore. By definition, a corruption
doesn't give any warning (it's even worth than earthquakes). If you want to
be very reactive, set something to regularly scan your alert.log file.

Regards,

Stephane Faroult
Oriole



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

temp space

2003-01-17 Thread Chris Stephens

Title: temp space





anyone know how to identify the session that caused a ORA-1652?


-thank you

RE: RMAN backup - basic Qs

Also, RMAN can do incremental backups, copying only the blocks that changed since last 
backup. More about all this in Oracle Manuals and in Robert's book.  

- Kirti 

-Original Message-
Sent: Thursday, January 16, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


Maria - Definitely faster. Often hot backups can generate additional redo.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, January 16, 2003 9:24 PM
To: Multiple recipients of list ORACLE-L


does this make RMAN hot backups faster or slower than when backing up file
in
backup mode?

[EMAIL PROTECTED] wrote:

> To better answer the original question, my understanding of this
difference
> is as under:
>
> Why do you put the tablespace in backup mode during normal hot backups
> without RMAN? This is to avoid backing up "split blocks". Say, you have a
> database with a block size of 16K. And that a block is in the process of
> being backed up, with reads happening in chunks of say, 512 bytes.  Assume
> a user transaction updates this block while the backup is in progress.
This
> could result in an inconsistent version of the block being backed up, or
> what is called as "split blocks".  Putting a tablespace in backup mode, is
> primarily, a flag which tells Oracle to copy the entire block into the
redo
> stream, and not just the changed vectors or deltas, which it would have
> done otherwise. This is so that, in case of recovery, the entire block can
> be read from the redo stream, and applied. Hence, this results in an
> increase in the redo size during normal hot backups.
>
> RMAN however, does not place the tablespaces in hot backup mode.  They use
> the same read consistency mechanism used by the SQL statements. Hence, no
> excessive redo is generated.
>
> Hope this helps.
>
> Raj
>
> Original Message-
> Sent: Thursday, January 16, 2003 1:54 PM
> To: Multiple recipients of list ORACLE-L
>
> Rman uses the same construct to get the right data in a hot backup as
> sqlplus, the SCN of the database. It reduces excess redo because you don't
> have to put the datafile in backup mode with a begin backup and take it
out
>
> with and end backup.
>
> HTH,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 16, 2003 12:35 PM
>
> >
> > Is Excessive Redo Generated during RMAN OPEN Database backup using
backup
>
> sets as happens in case of HOT Backup ?
> >
> > If NOT , Why ?
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: VIVEK_SHARMA
> >   INET: [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> 


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: [Q] SMON take too much time to clean up?

2003-01-17 Thread Surendra . Tirumala

That was the first check I did. And all my temp tablespaces are of
"TEMPORARY" type only.
I did lot of reasearch on metalink and I found there are some issues with
8.1.7 in this regard. I got this suggestion from metalink only.

-Original Message-
Sent: Thursday, January 16, 2003 4:52 PM
To: Multiple recipients of list ORACLE-L


If your temp tablespace is set up as temporary, you don't want to 'clean it
up'. The point of a temp tablespace is to reuse existing, but inactive,
blocks in the sort segment.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L


I do have my pctfree set to 0 for all my tablespaces. But I observe my temp
ts filled up at times   and continue to be in that status even if I don't
have any active transactions using the temp. I wake up the SMON by issuing
the following to do the cleanup. And I have 8.1.7 running.

alter tablespace temp default storage (pctincrease 0)

Thanks,
Suren

-Original Message-
Sent: Wednesday, January 15, 2003 7:55 AM
To: Multiple recipients of list ORACLE-L




we have ORACLE 8.1.7 on NT server and this erver only run ORACLE
application.  Sometime the server will have 100% CPU usage form 20 minutes
to couple hours.  In that time No one can login or do anything.  We guess
the problem come from SMON, but all of the tablespaces pct_increase is 0
(except SYSTEM).  The only thing I can guess is SMON clean the Temporary
Tablespace (our temporary tablespace define as dicrionary Temporary
temporary tablespace).  Does their has way to reduce or avoid this
problem?


Thanks.





_
The new MSN 8 is here: Try it free* for 2 months 
http://join.msn.com/?page=dept/dialup

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MAX Length of Name for Table / Index ?

The why is related to the data dictionary...

-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L



1) 
SVRMGR> create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
 *
ORA-00972: identifier is too long
SVRMGR> !oerr ora 972
00972, 0, "identifier is too long"
// *Cause:  An identifier with more than 30 characters was specified.
// *Action:  Specify at most 30 characters.
SVRMGR> 

You can try this test for an Index ;) 

2)
Larry & the gang decided that ;) 

- Kirti  

-Original Message-
Sent: Friday, January 17, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L



What is the MAX possible Length of of Name for Table / Index ?

Why ?

Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 9i new features survey

We use the automated PGA space management, automated MTTR managemsnt,
segment level stats, ausotmatic undo, automatic segment space management and
list partitioning features predominantly; and they work like a charm.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 5:44 PM


> Hi lister:
>
> Just want to know how well you adopt those 9i new features.
> (if you are already 9i)
> and what's your recommendations about those new features.
> (any pros and cons)
>
> TIA
>
> --DJ
> ITResource
>
> ==
>
> Oracle9i Database Release 1: New Features
>
> ANSI ISO SQL Support In Oracle9i
> Automatic Segment Free Space Management
> Automatic Undo Management
> Bitmap Join Indexes
> Data Guard
> Export And Import Enhancements In Oracle9i
> Flashback Query
> High Availability Enhancements in Oracle9i
> Index Organized Table (IOT) Enhancements in Oracle9i
> Index Skip Scanning
> LOB Enhancements In Oracle9i
> Logminer Enhancements In Oracle9i
> Memory Management In Oracle9i
> Metadata API
> Multiple Block Sizes
> Oracle Managed Files
> Partitioning Enhancements In Oracle9i
> Performance Enhancements In Oracle9i
> Persistent Initialization Parameters
> Real Application Clusters
> Recovery Enhancements In Oracle9i
> Recovery Manager (RMAN) Enhancements In Oracle9i
> Resource Manager Enhancements In Oracle9i
> Resumable Space Allocation
> Scalable Session Management
> Security Enhancements In Oracle9i
> SQL New Features In Oracle9i
> Workspace Management In Oracle9i
> Advanced Queuing In Oracle9i
> External Tables
> Heterogeneous Services
>
> Oracle9i Database Release 2: New Features
> Export BLOB Contents Using UTL_FILE
> DBMS_XPLAN
> Parse XML Documents
> Renaming Columns And Constraints
> UTL_FILE Enhancements
>
>
>
>
>
>
>
>
> _
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: David Jones
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Verification