On Friday 15 June 2001 15:47, Don Granaman wrote:
> Can anyone stop this spam? This isn't the first time for "OraStaff"!
Sorry, we don't consider it spam here. These ads are posted for
new position, and only reposted weekly if not filled. Many of
us consider this a service, especially the way
I can top that one! My first real Oracle job was at a company that was
trying to convert from being a mainframe service bureau to becoming an open
systems software vendor - when Oracle and open systems were near heresy in
the business world. Only one other person and myself in the entire company
Thank for your help..
I will ask my customer to dd for me later on..
currently I don't have any unix system in front of me ,can you find it for
me the command ?
to transfer EBCDIC to Ascii.
-Original Message-
Sent: Saturday, June 16, 2001 12:25 PM
To: Multiple recipients of list ORACLE-
Raymond
EBCDIC is the format few mainframe computer uses. Unix systems typically uses ASCII. I am not sure about the type of the file, but you may have to convert the file from EBCDIC to ASCII to make any meaning ful use of the file. You could use dd command for this conversion..
dd if=inp
No indexes on foreign key.
still the same result.
rgds
amar
-Original Message-
Sent: Monday, June 11, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L
overhead?...soluti
Jared has a point. Is there an index on the foreign key?
Another minor detail: You should of course never upd
Hi Raymond,
EBCDIC= Extended Binary-Coded Decimal Interchange Code. A format developed
by IBM a long time ago to represent characters as numbers for the computers.
This format is mainly used by Mainframe computers (those big monster
computers in that cold room with a combination lock on the door
Hei Dawn ..
It look like your second loop did't have any parameter pass ? becoz for the
1 main loop
main loop is c_dri_apc_paid_history ,
second loop is c_ap_invoice_interface ,
you suppose to parse parameter for the main loop to your second loop ,
instead of joining ap.ap_invoices_interfac
what is EBCDIC format
I have a customer from IBM DB2 mainframe going to pass data to my oracle
system for matching of record ,what they told me is the tape is in EBCDIC
format ? I don't have any experience on these format ? can anyone please
explain /guildline on these ?
Raymond fall asleep in
Hello Rohan..
after reading through your reply in the list , what is the these loadrunner
do ??my company is searching for a testing tools for bulk testing of data
.Is this loadrunner doing the function which I needed ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: R
www.pricewatch.com
133MHz 512Mb DIMM $62
Was about to order 4 more of them but I think I am going to just get a u80
instead of putting more money into my Intel box.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
but my 088 only holds 640k, bill told me that is all I would ever need.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 7:36 PM
To: Multiple recipient
Michael,
We use RMAN on RAW with EDM (EMC) backups, without any problem. When using
RMAN, it will take care of all blocks that are being changed while the backup is
going on. Also as EDM interfaces with the Tape library, RMAN will write directly
to the Tape . Have this set up on about 15 database
because $61 doesnt do any good with a laptop that will only hold 192M :)
joe
Christopher Spence wrote:
>
> When you can buy 512Mb for $61 on the net, who cares :)
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Orac
we used raw devices for years... And never had a problem with hot backups
and restores...
I question the need to skip the fist block of the raw device.. We never did
that... Even in a parallel server mode as well
Greg
-Original Message-
Sent: Friday, June 15, 2001 7:10 PM
To: Multiple
>In Oracle, you will get an "inconsistent"
>image of the data file, but that is true
>with any "manual" hot backup - cpio, tar,
>cp, etc. It is not a problem - iff the
>tablespace(s) are in backup mode.
>(Wasn't there something about this on the OCP exam?)
This is exactly the reason why O
Thanks Gary, that was comforting to know
Satish>>> [EMAIL PROTECTED] 06/15/01 01:11PM
>>>
Satish,
I have a client that has been
doing it for a few months now without any problem. D2K 1.6 is based on a
7.3 client, so I installed it in a separate ORACLE_HOME than the 8.1 client they
use f
Where can I find it that cheap? - E
-Original Message-
Sent: Friday, June 15, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
When you can buy 512Mb for $61 on the net, who cares :)
"Walking on water and developing software from a specification are easy if
both are frozen."
Chri
log file sync includes the time it takes to post the LGWR process as well as
the time it takes to flush the buffer down to the datafile.
log file parallel write is only the time it takes to write out the log
information to disk.
So in short, log file parallel waits shows delay in IO to actuall
Hi.
I know that this one went around recently, but would anyone care to share
experiences with the NetApp Filer in conjunction with Oracle on NT/W2K,
Linux [any distribution ;)] and Solaris?
In the meantime, I am rtfm'ing their literature, while upgrading a client
database from 8.1.6 to 8.1.7 th
That is 512 M Bits not Bytes = 512/8 = 64MB.
Regards,
Waleed
-Original Message-
Sent: Friday, June 15, 2001 8:06 PM
To: Multiple recipients of list ORACLE-L
Where can I find it that cheap? - E
-Original Message-
Sent: Friday, June 15, 2001 3:12 PM
To: Multiple recipients of l
I have extensive, but aging, experience with hot backups of raw devices on
active systems - on Solaris, AIX, HP-UX, and a handful of other Unix
variants - and some significant experience with OPS on Sun Cluster.
"dd" works, but certainly isn't "the easiest way" - or the fastest! For one
thing it
I agree as long you put the TS in backup mode.
Also I'm not sure about skipping the header block!
Regards,
Waleed
-Original Message-
Sent: Friday, June 15, 2001 6:42 PM
To: Multiple recipients of list ORACLE-L
How would this be any different than reading a file system
when write act
Can anyone stop this spam? This isn't the first time for "OraStaff"!
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 8:25 AM
Oracle Financials DBA responsible for the replication of Oracle Financ
How would this be any different than reading a file system
when write activity is taking place? It doesn't matter
if it's the OS or Oracle managing the disk, block can and
will be split during a hot backup.
I think your sysadmins need to reconsider.
And if I'm all wet on this, someone will be
Cause it isn't mySQL :)
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 5:41 PM
To: Multiple recipients of list ORACLE-L
Can you let's know how how
I think that 192 MB makes sense - as MS definitely wants 128 MB just to get
Windows 2000 Pro up.
Services like "Remote Registry Service" and "License Logging" need lots of
RAM. :)
(enabled by default)
So do "SubSeven" and "BackOrifice2000".
-Original Message-
Sent: Friday, June 15, 2001
When you can buy 512Mb for $61 on the net, who cares :)
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 6:00 PM
To: Multiple recipients of list ORACLE
Woozers
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 5:02 PM
To: Multiple recipients of list ORACLE-L
>From Linux release notes:
http://otn.oracl
Thanks for the link! I feel something is wrong with the number (500M).
This is for HP:
The following requirements must be met in order to perform a typical
Oracle9i software installation.
Memory: A minimum of 256 MB of RAM is required to install Oracle9i
Server. A minimum of 256 MB is required
A minimum of 128M on the client??!! Who do they think they are?? Microsoft?
-Original Message-
Sent: Friday, June 15, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
>From Linux release notes:
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf
The following re
Can you let's know how how it will go for you?
I don't know why would Oracle require 500M of memory to run?
-Original Message-
Sent: Friday, June 15, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
i've got 256M, dont run SUSE but will attempt it on rh 7.1 this weekend.
joe
We've installed Reports 6i and Forms 6i in our Sun Solaris 2.7 machine,
with Oracle 8.1.6. We were told that we needed to apply patch #3 to be
able to install the reports and forms 6i version on Solaris 7.
After installing both, reports and forms 6i, and after applying the patch
we installed the
I know 256Mb is the min on solaris, (although I have seen them run on
128Mb), not sure on linux.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 4:21
How about oradim and server manager?
-Original Message-
Sent: Friday, June 15, 2001 5:02 PM
To: Multiple recipients of list ORACLE-L
Trying to connect using INTERNAL via SQLPLUS.
Platform is Solaris 2.6, Oracle 9i. Logged in as oracle user. Oracle user
is a member of the dba group an
As of 8.1.6. Before that, you needed to rebuild the table.
Gary Kirsh
Next Extent, Inc.
-Original Message-
Sent: Friday, June 15, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L
You can do an alter table TABLENAME storage freelists N
- Original Message -
To: "Multiple re
Nope. LMT's can help reduce the free space fragmentation at tablespace
level. But row and block level fragmentation will need reorgs. So, proper
configuration of db block size, pctfree and pctused becomes important to
minimize such fragmentation. Even if you had set decent storage initially,
it ca
Thanks Kirti.
I had already found 1029850.6 and was reading through it. It recommended
setting freelists to the maximum number of concurrent processses performing
simultaneous inserts to the table. Thanks for the tip on not setting it to
more than 2x #of CPUs.
And thank you very much for 76644
>Roles created by a user never go away. They are not attached
>to the user.
Just keep in mind that the role is automatically assigned to the user who
created it. And this can land you in a *bit* of a problem when you import
that user in another database and bump into MAX_ENABLED_ROLES (which
de
> Number of pages has absolutely no bearring on a good book.
Yes it does. I don't like ones with too many! ;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
S
Oracle Performance Tuning 101 by Gaja Krishna Vaidyanatha and Kirtikumar
Deshpande
>From: Anthony Hogan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Increasing Freelists?
>Date: Fri, 15 Jun 2001 12:01:04 -0800
>
>wh
not in 8i -- you can adjust freelists on the fly
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Increasing Freelists?
>Date: Fri, 15 Jun 2001 12:01:05 -0800
>
>The table must be dropped, yes.
>
>De
Trying to connect using INTERNAL via SQLPLUS.
Platform is Solaris 2.6, Oracle 9i. Logged in as oracle user. Oracle user
is a member of the dba group and CONNECT INTERNAL works fine in 8i.
See following error message for 9i:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
-Origi
>From Linux release notes:
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf
The following requirements must be met to perform a typical Oracle9i
software installation.
Memory: A minimum of 512 MB of is required to install Oracle9i
Server.
A minimum of 512 MB is required to
Reorgs needed not only for space fragmentation but also for block
fragmentation.
Would be interesting to know if anybody has a good automated(scripts) system
to decide for which objects block reorg is needed.
Alex Hillman
-Original Message-
Sent: Friday, June 15, 2001 4:16 PM
To: Multipl
Hi Mogens,
>I think SQL*Net was called SQL*Star or something, at least
>with version 5?
SQL*Star, as I remember it was SQL*Net + OpenGateway (or something like
that). It was basically SQL*Net to other DBMS. (And there were three types
of DBMS's - Hierarchical, something else, and that new-fangl
You can do an alter table TABLENAME storage freelists N
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 4:01 PM
> The table must be dropped, yes.
>
> Default for table is 1 freelist, 2 for indexes.
>
> This is not scientific
It's gone. And for SYS logins, you must login as "SYS as sysdba" or "SYS as
sysoper".
The threat of internal going away has been around for a long time. It looks
like they finally acted upon it.
Defry
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
You just reminded me - when I was in one of the early grades I was given a
punishment and had to write 50 lines ("I will not ... in class"). I was pretty
scared, pretty embarrassed, went home used a ruler and drew 50 (more or less)
straight lines and handed that in, but I don't remember what h
> Do you use a DBA account? Is there a better way?
Actually I use "connect / as sysdba" for startup and shutdown. That is
probably considered to be connecting as SYS, although I'm not sure if it
exactly the same as "connect sys/".
Since I'm not actually connecting with the SYS account/password
i've got 256M, dont run SUSE but will attempt it on rh 7.1
this weekend.
joe
>>> [EMAIL PROTECTED] 06/15/01 04:20PM
>>>Can any of you just confirm that Oracle 9i requires 500M of
memory on Linux?Thank,Waleed-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com--
Author: Khedr,
The table must be dropped, yes.
Default for table is 1 freelist, 2 for indexes.
This is not scientific ( both because there are no
data to support it in your post and I have no hard
perf data of my own ) but freelists are small and
easily/rapidly maintained. Unless you have some
sort of "niche
On Fri, 15 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->Watch out, Bill. Some of our co-listies are
->going to ask you to cook that rat in your apron.
->
->Just your apron.
no, those things don't happen to me.;-) i'm not that lucky.;-)
--
Bill "Shrek" Thater Certifiable ORA
Hi Jay,
If the table(s) need(s) to support multiple concurrent insert operations
from multiple transactions and you are seeing a lot of buffer waits then
adjusting freelists may help you. Setting it up to a max of twice the number
of CPUs should work (provided that the number of CPUs is not tool
Can any of you just confirm that Oracle 9i requires 500M of memory on Linux?
Thank,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californi
I know what I wrote... and worded it thusly deliberately
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Digestive
>Date: Fri, 15 Jun 2001 11:00:58 -0800
>
>most important word in your sentence: "o
what is the name of the book by Gaja that you are referring to ?
-Original Message-
Sent: Friday, June 15, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
We've been load testing an application that will be allowing customers to
enter their email information through the web. The
Satish,
I have a client that has been
doing it for a few months now without any problem. D2K 1.6 is based on a
7.3 client, so I installed it in a separate ORACLE_HOME than the 8.1 client they
use for everything else, and they are coexisting peaceably.
Gary Kirsh
Next Extent,
Inc
Is it the same old rumor or it could be confirmed 100%?
-Original Message-
Sent: Friday, June 15, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Well you will have alot of scripts to change, internal is gone in 9i.
"Walking on water and developing software from a specification a
All,
Oracle's party line has for a while been that for the most
part reorgs aren't necessary anymore, right? Assuming storage
initially has been set decently? Are reorgs very common in
these parts?
Also, even according to those who find reorgs still necessary,
they should completely go away with
Help!
I have a stored procedure that I can't get to work. The purpose of this
procedure is to take one file that has detail records and insert a distinct
header into one table, assign an unique_id, then insert into another table
all the detail lines associated with that header record and add a l
What error are you getting?
a quick look shows:
last i checked no need to do close on cursor using for i in
cursor_name.
Since you're not explicity opening, no need to explicity
close.
Joe
>>> [EMAIL PROTECTED] 06/15/01 03:37PM
>>>Help!I have a stored procedure that I can't get
Watch out, Bill. Some of our co-listies are
going to ask you to cook that rat in your apron.
Just your apron.
-Original Message-
Sent: Friday, June 15, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
On Fri, 15 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->De
Ah, you take me for a fool! It's in one file per instance!
And the Rman job is one file per machine - shared by all instances!
thank you, thank you, hat tipping, hat tipping. crowd roaring.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, June 15, 2001
We have parallel server running on on a Sun Cluster 2.2 and we are looking
for the easiest way to perform hot backups. Now, I know that you have to
use the "dd" command and skip the header at the beginning. Everything I
read on metalink indicates that you can use basically the same paradigm as a
On Fri, 15 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->Dear Clarice,
->
->ROFL!!!
->
->Yikes! Now I've got enemies at supersecret govt labs, now!
->
->Besides, we've never met! How do you know that, sans speedo, you
->wouldn't lose your lunch (poached Mastodon loins, gently
At least you got certified!
-Original Message-
Sent: Friday, June 15, 2001 2:49 PM
To: Multiple recipients of list ORACLE-L
I remember when I was in 10th grade, and we had an assignment to write a
paper that was to be three pages "double spaced".
I didn't know what double spaced meant
We've been load testing an application that will be allowing customers to
enter their email information through the web. The loadrunner application
was experiencing periodic freezing after which it would go back to normal.
Reviewing the statspack information I saw a high number of buffer busy wai
I think i need to remind you ladies that
there is a Hannibal Lector component
to this macabre image.
:)
-Original Message-
Sent: Thursday, June 14, 2001 7:17 PM
To: Multiple recipients of list ORACLE-L
Woo hoo! Count me in ;)
-- Anita
--- "Fisher, Julie" <[EMAIL PROTECTED]> wrote:
Well you will have alot of scripts to change, internal is gone in 9i.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 2:41 PM
To: Multiple recipients
Back to the mastodons and loincloths, eh?
-Original Message-
Sent: Thursday, June 14, 2001 2:04 PM
To: Multiple recipients of list ORACLE-L
uh uh, I'm not contributing to that fund, I want to see him lose that Speedo
>From: "Norrell, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROT
Dear Clarice,
ROFL!!!
Yikes! Now I've got enemies at supersecret govt labs, now!
Besides, we've never met! How do you know that, sans speedo, you
wouldn't lose your lunch (poached Mastodon loins, gently seared
with fava beans, served with a fine Chianti)?
- Ross
-Original Message
> Number of pages has absolutely no bearring on a good book.
Does the number of pages have a bearing on how well the database is
administered?? ;)
Hey, it's Friday and I always say "Weak humor is better than no humor at
all."
Mike "If I wasn't laughing, I'd be crying" Hand
Polaroid Corp.
--
Pl
You caught me at the perfect time. We are new customers of Quest's
LiveReorg for our 350GB SAP Oracle database. We run on AIX 4.3.3 and Oracle
8.0.4.3. We have an extremely transactional database (200,000+ transactions
per day), so a LiveReorg is really a task. I just reorg'd a 33GB table w
inter process communications between groups of parallel query server
processes.
often found in parallel ==> serial or parallel ==> parallel operations.
-Original Message-
Sent: Thursday, June 14, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Does anyone know what causes wai
most important word in your sentence: "other"
heh
-Original Message-
Sent: Thursday, June 14, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
was that you I saw wandering by then? I wondered who the other human was :)
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMA
I remember when I was in 10th
grade, and we had an assignment to write a paper that was to be three pages
"double spaced".
I didn't know what double
spaced meant (and, being a boy, was too stupid to ask - no comments from the
smart women out there) that I typed it with double
spaces
Number of pages has absolutely no bearring on a good book.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 15, 2001 11:06 AM
To: Multiple recipients of list O
Greg,
I was told by Oracle Support when I started using Rman under version 8.0 to
use SYS or INTERNAL, as it is "better".
Between you and me, "better" is quite subjective. But, I wrote scripts that
connect as INTERNAL, and it has been working fine ever since, so I did not
re-visit it.
Do you u
I also could not get it to link. I started down a similar path that you did. I
am going to wait now until the UNIX Admins apply the required patches.
-Original Message-
Sent: Friday, June 15, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
Techne
Tom & All:
I have it 'mostly
Couldn't you write a procedure that this user can run which accomplishes
this task? This way the user wouldn't need to be granted any system privs,
just execute permission on the procedure.
Just my $0.02,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTEC
We are curently upgrading from 8.1.6 to 8.1.7.
We have currently done it successfully on our test and
development machines and are doing it on the
production machine this weekend.
We did not use the ODMA as we could use the manual
process from our client machines.
We have solaris 2.7
The steps
We use LiveReorg here and have had a few problems. When it works, it works
very well and when it breaks it can hose your database. It does invalidate
some objects and you will need to manually recompile them if you don't tell
it to do it for you. Since some objects are invalidated because of
de
Hmmm...that's interesting, since on bookpool.com you can pay less for a book
with next day delivery then you will at Amazon or B&N. And Rachel still
gets her 20 cents for every book...(grin)
-Original Message-
Sent: Thursday, June 14, 2001 9:46 PM
To: Multiple recipients of list ORACLE-L
absolutely ... i just had the same case ...
1/ user one can always export his/her own schema ...
2/ GRANT BECOME USER to user2
3/ user2 can now import user1's export
warning ... if user1 has dba privileges then user2 cannot import
hth
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Comme
only when you write magazine articles or short stories. :)
>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: Working from home
>Date: Fri, 15 Jun 2001 08:31:12 -0800
>
>so then if you use a REAL
We have parallel server running on on a Sun Cluster 2.2 and we are looking
for the easiest way to perform hot backups. Now, I know that you have to
use the "dd" command and skip the header at the beginning. Everything I
read on metalink indicates that you can use basically the same paradigm as a
http://www.computerworld.com/storyba/0,4125,NAV47_STO61402,00.html
Quote "Every year, we lower our prices, and we sell more software," Ellison
said. "This is, in fact, a price reduction from [the power-unit model]." For
some configurations, according to figures posted on Oracle's online store,
th
I agree with Jesse.
Although Live Reorg would be a great tool, it was extremely COST INTENSIVE.
I would love to be able to reorg tables with essentially no down time but,
so far, the cost does not outweigh the benefit.
The nice thing with Space Manager is that it will create your DB scripts for
Lets not get into how we divied up time . otherwise I will be here for
days !!
We had to account for each 15 minute block . and THAT was when we were
working in the office ! Our time sheets took, on average, about 2 hours out
of each 2 week period to prepare.
In my new job, they have
According to my information (as of yesterday) from Osborne, all ordered
copies have been shipped to the wholesalers for more than a week or so. But
not all retailers get their copies from the same wholesaler. So, some may
already be shipping, some may have run out of what they received and some
Space Manager is an "offline" tool -- It creates a script that will create a
new table, populate it, and replace the old table with it, and during this
time the table is not accessible.
Live Reorg only has a "very short" window where the table is locked -- Quest
says a few seconds -- while the ta
Sun Sparc Solaris 2.6/8
Oracle DB 8.0.6, 8.0.5
Oracle Apps 11.0.3
My client and I are currently planning on re-orging some of our database -
say about 90G out of a 120G database (2 schemas). We've identified 3
tools and are seeking feedback on the pros/cons of each option.
anyone?
Als
One of my favorites is divying up how I spent my time each week. If a
project has a problem and I spend 4 hours researching it before solving it,
that is 4 hours to the project. But if I happened across that problem during
my normal reading and research (i.e. this group or other web sites) that is
I would make sort_area_retained_size = your average sort size. Otherwize
your sorts which are executed in memory will dump result after sorting into
temp tablespace and then server process will read it from there to return
rows. Sort allocate memory in chunks of 8K, so you should worry only in cas
Well, you could always set synonyms so they wouldn't notice. I typically
make SYS off limits by making the password inaccessible. IDENTIFIED BY
VALUES 'no way';
Henry
-Original Message-
Sent: Friday, June 15, 2001 5:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I generally u
Hello,
First of all, let's notice that:
- number of means AMOUNT
- ratio means SPEED
- time means TIME
If you don't encounter time related events such as waits, CPU usages, It
doesn't make sense What the values of AMOUNT and SPEED are.
In you case, startting from parse count is not correc
Tom,
Why do you use SYS exclusively for startup and shutdown, since your DBA priv
account could also accomplish this?
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (85
Hi everybody!
I have this numbers for "parses":
1402684 parse count (hard)
9766294 parse count (total)
14,36 % of my parses are hard
My database it's up since more than two days, with 943249 cumulative logons
(oltp). The problem is two months ago the percentage of hard parses was
about 12%.
Tom & All:
I have it 'mostly installed'...kinda like being 'mostly dead' (from The
Princess Bride). The files downloaded OK. I think my PC unzipped them
during the download, though, because when I ftp'ed them to the HP machine
they were not in gzip format. I went right to the 'cpio' step and i
Rajaram
Look at inline comments
Rajaram <[EMAIL PROTECTED]> on 06/15/2001 12:16:08
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA)
Hi,
Thanks Witold for the info. I have some more Q's.
1 - 100 of 154 matches
Mail list logo
