In a previous job I had to deal with this issue. WinNT 4.0 on a dual
processor Dell box with 24G of RAID. I had specified RAID 0 + 1 but
someone knew better and got it with RAID 5 (5 is obviously better than
0). The SA wouldn't or couldn't reconfigure and the job needed to get
done.
It was
Thanks for the enlightenment. What is the performance difference, from an
Oracle database standpoint, between RAID 0+1 and RAID 1+0?
Unfortunately one cannot change the configuration on Government Furnished
Equipment without a bit of a hassle. In a more perfect world, of course,
but in real
Of course first you need some royalties!!
LOL
Rachel
Carmichael To: Multiple
Check with your tax advisor again or get a new tax advisor. I don't
remember the exact details but you MUST show some tax-able profit for a
certain number of years out of every so many years (eg, 1 year out of the
last 4 - I'm not sure that those are the right numbers) or the IRS will
decide
The unkindest uncut of all - the Dedican uncut.
LOL
Bowes,
Chris To: Multiple
I guess that we'll let the IRS sort this one out. Your friend is probably
right and I was probably overly emphatic when I said that you MUST show a
profit sometime. But I would rather not leave it up to the IRS to decide
whether it is a business or a hobby.
Appearances to the contrary, Canada is a separate country with their own
tax laws.
However, the tax dodge that you mention is common here too.
Here's a really good one -- become a Certified FAA Ground Instructor. You
teach people how to pass the FAA ground exam. Since it's not life
She was from the Tammy Fae school of makeup application. Big hair too.
Charles
Wolfe
Yes. It does. But, as someone pointed out earlier, as an individual it's
only partially deductible. If you're a business then it is an expense that
can be offset against income (and thus is 100% deductible). If you're not
already a DBA (or at least in an IT field) then it's probably not
I'm currently engaged in trying to join two databases that were split. The
databases are supposed to be twin images of each other but, of course,
they're not.
But you may be taking a different route. WIll any objects in database A be
twinned in database B? Do you have lookup tables that will
So, would that be irrational or imaginary?
BTW - I once made a mistake on a blackboard demonstration and ended up
presenting Newton's Macroscope instead of Newton's Microscope. Turns out
the math works as well for infinitudes as for infinitesimals. (g)
for it. I was a treasurer for a NFP, and we always made a (modest)
profit. We just paid like normal taxpayers.
They also taxed you for income that was outside your stated reason for
being.
tday6 said:
2. You can never make a profit.
Tom Mercadante
Oracle Certified Professional
-Original Message
OK. You need to manually create a new controlfile. It requires great
attention to detail. Syntax and an example can be found at
http://hojohn.photo.net/ora81/DOC/server.815/a67779/ch4f.htm#20116
Scroll down to CREATE CONTROLFILE.
You must list all members of all redo log file groups after
Index blocks remain when all the leaves are gone. It's late and I'm late
for going home but basically, you deleted rows from the table. The index
removes those pointers but does not otherwise reorganize itself. After you
do a major DML on a table, rebuild the index.
Here's an example:
select table_name||column_name, count(table_name||column_name) from
sys.dba_tab_columns
group by table_name||column_name
Chris Rezek
Set the tablespace to some reasonable INITIAL and NEXT that accommodates
all the objects with less than 100 extents per object. Let all the objects
in the tablespace inherit their storage parameters from the tablespace.
You will never have any fragmentation of the tablespace and will not need
to
Yup. VM/CMS on IBM mainframes would do the same.
Scott Canaan
[EMAIL PROTECTED]To:
I'll give this a whack though I suspect that there are people who could do
a better job.
The Windows registry is the conceptual equivalent of the UNIX environmental
variables.
ORACLE_SID, ORACLE_HOME, etc can be found under
HK_LOCAL_MACHINE\Software\Oracle.
You can change these using REGEDIT;
LOL
A neighbor of mine had an original IBM PC, 64K RAM, 160Kbyte single-sided
floppy, and the cassette port on the back so you could hook up a cassette
recorder/play for data storage and retrieval, BASIC on EPROM. He wondered
if the Smithsonian was interested. An old college classmate happened
Are you using the OEM that came with 8.1.6? I have a dim memory that the
JAVA executable that powers that version of OEM had a flaw that could
consume 100% of the CPU. Personally, I don't use OEM versions after 8.1.5.
HTH
I like to know if it is possible, from an on-login trigger, to fire an
applet on the client machine that will open a browser window and direct
that to a particular URL? It doesn't necessarily have to be an applet,
just any mechanism that will automatically direct the client to a
particular URL,
What I've heard is that Larry E. is having a hissy fit and Oracle is
removing all the Sun's that they own, except that Sun is still their
initial development platform.
Christopher
A quick and dirty answer from my background in program management.
Document what your current code does and how it does it so that in case it
doesn't work someone else can easily find your mistake. If they want to
add new functionality to your code, your documentation should guide them in
how
LOL
I haven't done COBOL programming since 1978 but if I remember correctly:
In the file definition section.
01 or 02 would correspond to a table;
The stuff indented below it (10's I think) would correspond to columns.
PIC(99.99) means a numeric field with two positions to the right of the
Here's a script (for Oracle 8) that will show you exactly how much space a
given table uses, as opposed to how much space its extents have reserved.
It takes one parameter, the name of the table being looked at. It can take
a long time to run so I'm not sure if that counts as efficient. If you
I agree completely with Lisa. Several years ago I had a chance to talk
with an Oracle tester in IBM's benchmark lab. They had a one table/one
tablespace/one datafile layout, mostly for recoverability. Once you
document it fully (and name it logically) administration is not that
difficult.
For
Been there, done that. An installation manual comes from Oracle with the
software. Follow it exactly. Do not use an installation manual for a
different platform or a different version of Oracle. Every one of them is
slightly different and just enough different to mess up your installation.
Can you run the same code when you connect with SQLPlus?
Harvinder Singh
I'd definitely go with the partitioning. The only question that I'd have
is whether I would make the partition large enough to satisfy a single
user's query or small enough that it could reside in the SGA. I guess that
that depends on how many users are querying at one time. Just off the top
Many years ago I worked for a telco that had a bad day in the stock market.
They had written off $500 M of analogue switching equipment, acquired a
major competitor, and the chairman had announced that he was thinking of
retiring. The stock went into free-fall, loosing 50% of it's value in one
I love it when the cattle guard is just painted lines on the road. When
they talk about free range cattle (at least in Wyoming), they mean it. I
had to dodge around a bull once who was very interested in why I was
approaching his harem. Actually, he wasn't interested in me so much as my
Volvo
I haven't tired it but I think that I read on this list about a week ago
that dispite the file extension, these files do not need to be
uncompressed. They are not compressed to begin with.
HP has not cut you off from the internet ... yet.
Walthour, Jon
(GEAE,To: Multiple
Who audits auditors?
Ron Thomas
rthomas@hypeTo: Multiple recipients of list ORACLE-L
DO you have a cup holder on your car's dashboard? I only have one on my
computer!!
Ron Rogers
SET DIGEST-L ORACLE?
Scott Shafer
sknd100@yahoTo: Multiple recipients of list ORACLE-L
Light plane pilots know all about the H.E.R.E. (Human Element Range
Extender), for when your plane can fly longer than you can.
Robertson Lee
IRS used to use flat files on IBM mainframes circa 1992. Don't know if
their Modernization effort ever succeeded. They were trying to move it
to Oracle 7 running on NCR Pentium 60's. Don't ask why. There was a
Congressional inquiry.
One point that should be made. When you move data from
I'm interested in the cutover point. Our snapshots are set up with FORCE,
which allows Oracle to choose between a FAST or a COMPLETE. But at what
point does Oracle decide that it will be faster to do the complete? Does
Oracle need to have the tables analyzed so that it has some statistics to
gologin.sql
Here's an example from Oracle:
--
-- $Header: /plus/v3/spam/precious/files/ACTIVE/glogin.sql,v 1.6
1995/07/25 02:33:26 cjones Exp $
-- Copyright (c) Oracle Corporation 1988, 1994, 1995. All Rights
Reserved.
--
-- SQL*Plus Global Login startup file.
--
-- This is the global
Put a blank line at the end of your script. I don't know why it does that
but that's the fix.
Farnsworth,
Try something like
select a.col1||a.col2, b.col3||b.col4 from table1 a, table2 b
where a.col1||a.col2 = b.col3||b.col4 (+))
WHERE b.col3||b.col4 IS NULL;
I think that works.
If your listener.ora file is OK and you've just lost the service then go to
the C: prompt and type LSNRCTL START. This will fail,but it will have
created the service. You can then go start the service and set it up for
autostart from the SERVICES panel on the CONTROL PANEL.
Silly, but it's
I think that he has a much more serious problem than setting the SID. If I
understand the situation the Oracle Service (the instance) is not starting
because the ORACLE_HOME parameter in the registry is messed up (probably as
part of the upgrade).
Try clicking START, PROGRAMS, ORACLE FOR WIN2K
Check and see if your J disk is full. On your Win2k desktop, find the My
Computer icon. Right click and choose explore. Find the J drive and
right click; choose properties. If the disk is full, that's your
problem.
On the other hand, a J drive could be a network mounted drive. If it is,
I've done this in the past:
Install 8.1.7 and create a database (same SID as your current database).
Create the same tablespaces and users as your current database. Export
your old database and import it into your new database. Be sure to use the
same level client software for the export and
It's called a text editor.
Peter.McLarty
@mincom.com To: Multiple recipients of list
I'm not sure which is best but here are my observations;
Solaris - kernel patches take effect without a re-boot. This is Oracle's
development environment (It'd be a hoot if Oracle developed their software
in a Win95 environment!!).
HP-UX - This used to be the Oracle Corp's production
Not an easy question.
Set up a folder (directory) on the NT server called STUDENTS. Set your
utl_file_dir parameter to that folder. From the server's SERVICES panel,
stop and start the instance (so the parameter will take effect). Under
STUDENTS, create folders for each of your students and
I'm assuming that you're creating a 9i database on the new machine when you
install Oracle.
I find it useful to pre-create the tablespaces (and users) on the new
database, rather than let the import do that. This gives you more control
over where datafiles end up and do some clearup on
I'm sure that everyone is sending you their version of this:
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername format a8
Create a view where you select the case-insensitive columns with
upper(col-name), then create a public synonym on the view. The application
will see the table through the view.
One thing to consider is country codes. I have seen many applications
where two character country codes have been crammed into the STATE_CDS
table. Usually the two character state abbreviation is the primary key,
but that means that some smaller countries end up with abbreviations that
have no
Does the table inventory.company exist?
Abdul Aleem
dmitTo: Multiple recipients
--THANKSGIVING_LOAD.SQL
--T. Day, SAI, 21-NOV-01
--Run on WORLD.UNIVERSE using schema with DEITY role
declare
cursor c_thanksgiving is
select
PERSON_ID /* NOT SSN -- generated by sequence generator
(Jared) */
,RELATION
,CONDITION
from YOUR.LIFE@WORLD where RELATION
If they're just renaming the disks where the datafiles reside, then the
backup controlfile is the way to go.
However, if they're renaming the disk where the Oracle Home resides, then
you need to go edit the registry. Be sure and make a backup of the
registry before you start the edit.
Unasked,
OK. Here's what I do in that situation:
Here's the main driver
-- disable foreign keys on parent_table.column
alter table CHILD1 disable constraint FK1;
alter table CHILD2 disable constraint FK2;
--run the detail_update.sql for each pair of values, ie, the current value
and the
-- value that
Double letters, eg., AA, BB
mohammed
bhatti To: Multiple recipients of list
There's no point in mirroring control files on the same disk. Control
files should be mirrored across disks. That way, if one disk crashes you
can get a copy of the current control file from another disk (or just drop
that control file from your init.ora file). Control files are small and
have
Let's see if I can remember a summary of our last discussion on this.
RAID 10 (mirror then stripe) is the way to go unless it's a decision
support database (mostly read only) in which case RAID 5 takes fewer
platters.
If you have enough spindles, I personally would treat them as disks and go
Oracle's thoughts on the matter can be found at:
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
Ruth
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
Harvinder
Singh
It's not an Oracle vs Access problem, it's a UNIX vs Windows problem. UNIX
is case sensitive. Oracle is also when you are talking about literal
strings (as well it should be if you're talking about literals). Vendor
doesn't know how to check for different cases and does shoddy work.
Actually, Oracle uses OPS internally on their e-mail system. For that
reason (Larry likes his mail fresh every morning) the OPS gets patches and
bug fixes with a very high priority. I used to have to install them.
Oracle runs it on HP-UX HA (High Availability). It's expensive but it
performs
I don't think that size has much to do with it. You can have lots of data
but if it's all in a few tables then it doesn't qualify as a datawarehouse
(IMHO).
My short take on this is that a datawarehouse is a OLTP database with
de-normalized data that supports a DSS application.
--
Please see
I'm not sure that I understand the question. Is it:
A. Under max load the RAID does not perform up to its specs?
or
B. Oracle does not stress the RAID enough for it to reach its max
performance.
If A, then have the RAID vendor fix whatever the problem is.
If B, then good for you. You
I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server
shortly. The 7.3.4 is so that we have an accurate version of the old
database which is being migrated to 8.1.6 (which explains the 8.1.6).
I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before
8.1.6.
Use the REUSE option on the CREATE TABLESPACE command.
Ken Janusz
ken.janusz To:
This is my whoison.sql - not mine but I don't remember where I got it.
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername
As someone else suggested, I have always used the internal drives for
vendor software. I can always re-install it from the original medium.
Other than that, temporary files, downloads, system swap space -- things
that I really don't care if I have a copy of.
I'd guess that the database was shut down with a shutdown abort and smon is
busy recovering.
Sajid Iqbal
Oracle 8.1.6.0
We're trying to recreate our snapshots. We used the syntax 'CREATE
SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018.
Everyone's gone for Christmas with their office's locked (documentation
inside!) and the internet connection is down. So 'R'ing TFM is out of
There were other problems which were masquerading as a refresh problem.
Merry Christmas and Happy New Year to all.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
I agree with the column naming comments. I would find it hard to
over-emphasize the need for a column naming convention that allows you to
know what table a column belongs to, whether it's a primary or foreign key,
and ,if it's a foreign key, then what the name of the base table and column
are.
Last Java project that I worked on (about 1 year ago), the Java thin client
was not robust enough to handle more than two or three connections
simultaneously. More than that and the threads got twisted. Client
application would hang waiting for a response from the database. The
database had
I was just the DBA, not the JAVA developer, but --
We had a Database server using JDBC to talk to an application server. The
application was written in Java and used Java thin client to talk to the
client (endusers). The endusers had any Java compliant browser. No
applets (security issues --
Nope. I don't. It was over a year ago so (being wildly optimistic) I
expect that flaw was fixed.
Kimberly
I don't remember export supporting queries. Why don't you create a temp
table or tables, eg. create table t_linemto as select * from linemto where
PROJ_CODE='CF-804', and then export the temp tables?
I won't comment on what I think about Oracle as a company. However, the
fact that Beta was technically superior to VHS and sold at a cheaper price
did not save it from a series of bad marketing decisions. Today people
don't even remember that VCR's used to come in two separate and
incompatible
When I connected I got:
OWS-05101: Execution failed due to Oracle error -6550
Oops! Maybe they have the wrong character set.
Grabowy,
SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM 101;
Deen Dayal
ddayal
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.
I don't want to.
Tried using a synonym but that didn't work.
Tried using create database link linkname connect to userid identified by
password
using ' (DESCRIPTION =(ADDRESS_LIST =
I knew that there was a simple answer but was having a senior moment. The
error messages didn't help any either.
I can't help but ask myself why they made TRUE the default.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
TO get around the 8.x-7.x database link I wrote:
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type,
Just a guess, but have you checked the firewall settings?
Rusnak,
George A. To:
I've seen this done also on a Java project. My understanding was that it
had to do more with the way an object oriented programmer's mind worked
than with any code efficiency.
I agree with Ixora's criticism of SAME; however, I think that Oracle is
justified in offering a solution that will provide adequate performance for
those DBA's who don't understand RAID. That some DBA's don't understand
RAID is evidenced by the inevitable response to read up on OFA and the 22
So what is the basis for the case by case judgement. I'm not being flip -
I really want to know.
From the discussion so far it appears that the pros for PL/SQL procedures
are:
Uniform access method to the database for all applications
Processing done on the more robust server machine
Where the business use of the data is such that the applications' selects
can be satisfied by querying a known number of partitions (less than all
partitions). Also where data can be archived partition-wise. Generally
this means time sensitive data. I don't see much benefit to partitioning
Only when they don't know the words.
Mohan, Ross
MohanR To: Multiple recipients of
You can reverse engineer with the evaluation copy of ERWin 4.0. I have
Designer but don't (can't) use it since it chokes when trying to reverse
engineer the entire database. I can do it a table at a time but it takes
forever. Don't like it one bit. Much prefer ERWin.
HTH
--
Please see the
SSN's are not recycled.
From the SSA OIG's testimony on SSN use and misuse before congress -
The SSN is a unique identifier
I'm no fan of Designer, but here's how:
Start Designer 6i
Log into your Repository database and select (or create) your workarea.
Click on Design Editor
Choose Server Model
Select a container
Choose the Run the Design Capture utility
Give Designer the username, password, and connect string for
I've been using PKZip GUI for years and never have had a problem.
Jack C.
Applewhite To:
My comments are interleaved:
Lissa
Lieberum To: Multiple recipients of list
Obviously you don't know Boeing Travel. The way it works is:
8 hours flying time to Hawaii.
230 hours layover (with per diem).
12 hours flying time to Sydney.
And if you schedule your flight to Hawaii for wheels up before 6am, then
you get a full per-diem for that day too.
What's your ORACLE_SID set to? Did you add your new database to your
listener? You didn't say how you created the second database.
DBAtracker
Try putting the word
spatial
in double quotes.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
On UTL_FILE, I've never had much luck using network mounted files.
Igor Neyman
ineyman
1. Run, don't walk, to monster.com.
2. Update and print resume
3. Enjoy vacation (hopefully brief)
Nothing good is going to come of the warehouse
Don dondealy
1 - 100 of 181 matches
Mail list logo