This was solved offline by examining the setup at one of my customers'
site which has the same configuration of VMS, Oracle and Perl as Barb
listed.
Barb changed the setting of user_dump_dest to point to the actual
directory that was defined in the hotsos.auth file. For some reason the
logical
Hi List,
The requirement is as follows:
DBNAME=PROD ( 'DBNAME' variable contains value 'PROD' )
LINE_PROD=100 ( 'LINE_PROD' variable contains value 100 )
Now I want to echo the LINE_PROD variable using DBNAME variable.
e.g
echo ${LINE_${DBNAME}} should return 100.
Is this possible and if
Hi list
I have a problem regardint PL/SQL Object Types. According to the fine
manual, it should be
possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I did
that, Object Type
compiles without complaints:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
Dear All,
Please suggest me some URL for the above subject ( Good document /
Presentation on Oracle wait events meaning , explanation , action to be
taken .).
Please do send me documents if any.
Thanks a lot.
Regards
Rajuveera
Raju,
just have a look at http://ixora.com.au/
Jp.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Veeraraju_Mareddi
Sent: Tuesday, July 15, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Good document / Presentation on Oracle
Title: RE: oracle last
select name, sal
from (select rownum rnum, name, sal
from emp
order by sal asc)
where rownum 4
/
???
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
if im reading your code right... looks like your overriding in an anonymous block. in
most OO languages overriding is done by a child class. i dont see any subclassing
here? didnt they add sub-types and 'extends' to 9.2?
btw, are you using object oriented design in your database? How efficient
Hi!
One of first thing I'd check when migrating from 7 to 8i, is settings for
optimizer_index_* parameters. And of course, your tablesindexes should be
analyzed (if not still explicitly using RBO).
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi
The anonnymous block at the bottom of my email is just a little test driver.
Basically, I don't use subtyping here. I just override the default
constructor.
If I don't implement a constructor at all, I would look like this:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
This is a shot in the dark, but try and delete (or rename)
Oracle_Home\sysman\config\omsconfig.properties
At 10:14 PM 7/14/2003 -0800, you wrote:
Hi Listers,
I had OEM repository on my database installed on my PC.
Accidentally I dropped the database. Now I have recreated the database.
But an
ok then i missed it. where is the overriding taking place? I saw a base constructor..
where was the 'override'?
From: Stefan Jahnke [EMAIL PROTECTED]
Date: 2003/07/15 Tue AM 08:30:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: AW: Object Types in PL/SQL
Hi
Hi
The default constructor is always there, even if you don't provide one.
So, if you declare and implement a constructor that has the same signature
as the default constructor (simply all the attributes as IN parameters,
returning SELF), you automatically override the default constructor.
That
Ron,
I have urgent question. Because I want to shutdown my database, I login as
oracle and execute dbshut. But later I found that the process is very slow
so I realize that I should type shutdown immediate. Then, I use control-D to
stop shutdown command. And I re-execute shutdown immediate. Now
- Original Message -
That is what I want to do. The object type compiles, but if I use it,
PL/SQL tells me that it finds more than one constructors with that
signature, which are the hidden default constructor and the one I
implemented (I think). Now, that leaves me clueless, since
Hi all,
anyone able to tell me, how to grant v$session select privileges to a user ?
grant select on v$session to xyuser*
ORA-02030: can only select from fixed tables/views
Cause:
The keyword FILE is required in this context.
Action:
Check syntax, insert keyword FILE as required,
Thanks Wolfgang,
The Solution provided by u was great and has worked.
Regards
Munish Bajaj
-Original Message-
Sent: Tuesday, July 15, 2003 18:00
To: Multiple recipients of list ORACLE-L
This is a shot in the dark, but try and delete (or rename)
Try
DBNAME=PROD
LINE_PROD=100
CMD=echo \$LINE_$DBNAME
echo $CMD
eval $CMD
Dilip [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
15/07/03 11:34
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT: unix
Title: RE: v$session question
grant select on sys.v_$session to xyuser
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
sorry, cut/copy/paste mismatch. I took the wrong error description.
again..
anyone able to tell me, how to grant v$session select privileges to a user ?
---
grant select on v$session to xyuser*
ORA-02030: can
then the guy is correct. that is a weakness in oracle's object oriented model. in c++
and java, you can override signatures. its different then overloading.
having to add an additional flag can be tedious in a large project. you might want to
open a TAR on this? Id like to see what the tech
v$session is a synonym.
all the v$ are really v_$. go to dba_views... see for yourself.
so grant on v_$. everyone gets nabbed by that one atleast once.
From: Foelz.Frank [EMAIL PROTECTED]
Date: 2003/07/15 Tue AM 09:59:31 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi,
This works in ksh:
DBNAME=PROD
LINE_PROD=500
OTHER=\${LINE_${DBNAME}}
eval echo $OTHER
Regards
Pete
[END]
-Original Message-
Sent: 15 July 2003 11:35
To: Multiple recipients of list ORACLE-L
Hi List,
The requirement is as follows:
DBNAME=PROD ( 'DBNAME'
GRANT SELECT ON V_$SESSION TO user;
Regards
Nigel Bishop
Snr. Oracle DBA
ioko
Tel DDI: +44 (0) 1904 435 458
Mobile: +44 (0) 7881 624 386
Fax: +44 (0) 1904 435 450
Email:[EMAIL PROTECTED]
www.ioko.com
-Original Message-
Sent: 15 July 2003 15:00
To: Multiple
that helped, tnx a lot !
Frank
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet am: Dienstag, 15. Juli 2003 16:15
An: Multiple recipients of list ORACLE-L
Betreff: Re: v$session question
v$session is a synonym.
all the v$ are really v_$. go to
Jared,
You came to the same conclusion I did. Since this is
the first perl script I have written for production I
still have a lot to learn. I was thinking that I had
missed something painfully obvious.
Thanks for the help. Hope all is well by you.
Pete
--- [EMAIL PROTECTED] wrote:
Pete,
Don,
A normal shutdown will wait for all of the users to complete there
work and shutdown when the users are off the system. A shutdown
immediate wait for the current transactions to complete and not allow
any more to start before shutting down. A shutdown abort does just
that, I stops all
There has been alot of literature stating that you will recieve performance
improvements by seperating indexes and tables across multiple I/O points.
Ie... you have a tables tablespace and an index tablespace. If you put them on
seperate hard drives, you will have less I/O contention.
Now Im
This doesn't answer your question directly, but if you aren't able to override the
constructor explicitly, you can probably create a static function that creates,
initializes returns a tVNR as you would like it.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension
I'm not Ron; but I'll take a stab at this.
The shutdown immediate is hanging probably because there are several
transactions that are rolling back. The database is not going to close till
all have rolled back completely.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of
I separate indexes and tables into different tablespaces for
maintenance purposes, not for performance, as there really is no
performance benefit if you are on a system with multiple users. At any
given time, many users will be doing queries that read the indexes and
many users will be doing
R,
Some of it depends on the disk storage. I have always followed the
time-proven method of organizing disks and placing indexes away from the
tables they belong to.
Our warehouse is using EMC external disk. What the warehouse architect did
was to stripe the EMC disks in such a way that all
Something else for people who are bored:
If I may ASS-U-ME that your ultimate goal is to have variables like:
LINE_THIS
LINE_THAT
LINE_THE_OTHER_THING
and you want to be able to change what is after the LINE part, if you have
genuine ksh93, and you like playing around with scripting stuff, then
Dear Friends,
I am going to unsubscribe from this list. It was a good journey towards
learning.
Thanks
Rajuveera
**
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may
never mind, 4 seconds after I sent the e-mail I saw the items listed on a
web page...
sigh.
Patrice.
-Original Message-
Sent: Tuesday, July 15, 2003 11:15 AM
To: '[EMAIL PROTECTED]'
Oracle used to sell databases options as add-ons to Oracle EE.
I went to the Oracle Store web site,
Oracle used to sell databases options as add-ons to Oracle EE.
I went to the Oracle Store web site, can't find any options listed anywhere.
Do Spatial, Advanced Security, and Transparent Gateways all come with the EE
license now?
That would be nice.
: )
Patrice.
--
Please see the official
Actually, there is a performance benefit, but is almost negligible.
Performance benefit comes from the fact that indexes are usually read
by using db_file_sequential_read, which is, as I was told by 3 or 4
wise men without any gifts, a single block read. Having vast majority
of I/O being short
I'll agree with Rachel's methodology and add another consideration.
Look at separating constraint indexes (primary keys, unique, perhaps even foreign
keys) from performance indexes. If you find resource constraints on backups
(time/disk), you can safely ignore the performance indexes. The
does anyoen disagree? Didnt this get started with the 'DBA Handbook' or was it a
different text?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/07/15 Tue AM 11:10:05 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: should you seperate indexes from
It's hot here. I wish I was at the beach and I feel like a rant.
oracle actually accesses indexes and tables serially
Is it just me or is this blindingly obvious?
You cannot access the table data until you have completed accessing the
index data
because the index data contains the location of
Steroids, weight lifting, and a flattop hair cut (orange or green). After
two years of this, try talking to the storage guys while holding a beer in
one hand and a Polish sausage in the other. If you can manage a good belch
during the conversation, even better.
(Are you a visual person?)
I disagree with the concept of recovery not including some indexes because
they can be rebuilt later. To me, that's like going to a gas station and
only filling the tank half-way because I can get more gas later. You are
saving small amounts of time up front, but will pay for it later on.
I
Interim Patch: 2878462
DATE: May 7, 2003
Platform Patch for : Microsoft Windows NT
Microsoft Windows 2000
Microsoft Windows XP
Product Version # : 2.2.0.18.0
Product Patched : UNIVERSAL INSTALLER
Patch Installation
I see a lot of "failed to archive " messages in
alert.log . But finally the log gets archived . Is it due overloaded archiver ?
this is from alert log.
ARC0: Beginning to archive log# 3 seq#
87568ARC0: Failed to archive log# 3 seq# 87568ARC0: Beginning to archive
log# 2 seq#
That's a big sale, something like your friendly neighborhood
Dodge sale. You can get Oracle Ram, with world's most powerful
V8 engine and $3000 cashback with 0.7 APR. All bells and whistles
like the Spatial Option, Transparent Gateways and Advanced Networking
are included.
Mladen Gogala
Oracle
For a given statements execution, running in serial, you will not find an
index and a table being accessed in parallel. Thus, there is no contention,
for a given statement, between the tables and indexes accessed by that
statement. Thus, one could argue the merits of not needing to seperate
if you keep a repository of all your indexes or have the create index statements on
files in the file system.. that would solve the memory problem.
oracle designer and erwin have these capabilities.
in some cases would it be better to recovery without indexes first so the users will
have some
Patrice,
The listing I have 09-06-2002, has separate prices for the options you
listed. Prices are for named users license and Processor license.
There might be a newer price list out but I haven't found it yet. The
prices I show are
EE 800/40,000
Spatial 200/10,000
Advanced Security 200/10,000
Tom,
I prefer to backup the whole database, but in some situations that I have
encountered, it is not possible. If you look at the ratio of backups to recoveries,
the savings can be substantial. As part of the backup/recovery documentation, the
scripts to rebuild (actually the physical
R,
My personal theory on where this started was benchmarking. Before the
Oracle Wait Interface was developed, about the only hard-core information
you could get on tuning came as a result of people running benchmarks. If
you benchmark a batch program by itself that uses an index to access a
Hi!
In some environments you just have to get some functions of database back
online ASAP and deal with other issues (like reporting performance or not
critical end users) later on.
OTOH, my experience with OLTP environments has shown that if you when you
lose performance indexes and try to use
- Original Message -
I must say that I haven't actually seen the benefits myself but my faith
is rock solid and I'll continue to separate data from indexes.
Don't want to debate faith... However, the technical side I can. ;)
The practice of separating indexes and tables into
Hi!
There's not just head movement involved, there is disk rotational latency as
well, and you have to cope with it whether even if your disk reading heads
are in the same place.
But more importantly, as Rachel already stated, that if you got multi-user
environment (as a usual Oracle environment
Rajuveera,
I hope that you find your continuing journey as a learning experince
as well.
Live long and prosper.
Ron mª¿ªm
[EMAIL PROTECTED] 07/15/03 11:10AM
Dear Friends,
I am going to unsubscribe from this list. It was a good journey
towards
learning.
Thanks
Rajuveera
It's hot here. I wish I was at the beach and I feel like an ant.
Hmmm.
During an indexed query on a single table the index will be
accessed, then the table, then the index,then the table,
then the index,then the table then the index,then the table.
Assuming you get 4 rows returned :)
thanks for the dis :)
My experience with these types of recovery scenarios has been that the
application *needs* the indexes that are being rebuilt. So user access is
s slow that I should not have allowed the users back until all the
indexes were rebuilt. The end result being that the
Hi all:
I'm testing a restore of a database file (tools TS).
The datafile is a raw device and I have link to that
raw evice in my links directory. Im running Oracle
9203 and UNIX 5l. And the problem I ran into is as
follows. If I drop the logical link , the rman
restores
the data as a datafile.
I may be way off base here, so any gurus please correct me with a gentle slap to the
back of the head...
Index and table access is not as simple as index entry..table row..index entry..table
row..etc. I just ran a quick test (which may not be represntative and is using the
primary key which
It's
due to Oracle using multiple archivers.
For
every one that fails, you will find an
another ARCX process that was already
working
on
it.
Using
sequence number 87568 from below as an
example, grep for that number in the alert log and see
for
yourself.
Matt
Matt Adams - GE
Is anyone putting datafiles on SAN storage?
Success? Horror?Tell me a story.
~
Tim Levatich, Database Administrator
Cornell Laboratory of Ornithology, 159 Sapsucker Woods Road, Ithaca, New
York 14850
[EMAIL PROTECTED]
Unfortunately, it's not just a problem with this product. Some Oracle
products like OEM can incorrectly populate TNSNAMES.ORA for you because of
course that's always the best thing to do (and isn't there another Oracle
product that requires it or am I confusing that with the semi-Intelligent
Hi!
During an indexed query on a single table the index will be
accessed, then the table, then the index,then the table,
then the index,then the table then the index,then the table.
Actually, if you think a little more, then you see that physical IO doesn't
occur like you described.
If
Yes and no. If I remember correctly (it's been a few months now), the lock
on the trace file is probably a shareable write lock (RMS). So you can
read/copy the file, but not open it for write/append. Changing the
requested access on the open of the file may solve this. Someone correct me
if
hi
is it possible to have a sga bigger than the rela
memory available?
suppose i have a 1gb ram can i start an instance with
sga 2gb. does virtual memeory play a part in this
memory allocation?
thanks
sai
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sai
Don't do it.
You should try to avoid paging.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Sai Selvaganesan
Sent: Tuesday, July 15, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
hi
is it possible to have a sga bigger than the rela
memory available?
suppose i
Yes.
Yes.
Not yet.
We're VERY I/O bound on our 6-way HP K570 and an AutoRAID (see BAARF) for
our ERP system running a hybrid (OLTP/reporting) 8.1.7.4 DB. We've tested
an IBM FastT900, a smallish box in the SAN world, with wonderful preliminary
results for us. I'm sure that the perf tuners
so there are benefits of splitting indexes and tables on different mount points in an
instance used for batch loads? such as a data publication model where you ingest
deltas?
any data on this?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/07/15 Tue PM 12:04:24 EDT
To: Multiple
Hrrr - as a wine-drinking, vegetarian, non-weightlifting new yawk
city boy, this explains why I never fit in with the storage crowd
However, to address the original idea about striping across lots of
disks, etc., you have to be very careful about how you configure your
storage volumes
I have them...
one of the things that I can tell you is that...
sometimes (at least here at work) the ports switches
fail and you lost your connectivity to your
filesystems...
it does not mean that your database goes down... just
have to reassign your LUNs to another SP processor and
that's
you will end up doing swap/paging .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 9:49 AM
hi
is it possible to have a sga bigger than the rela
memory available?
suppose i have a 1gb ram can i start an
why is it useful to seperate different i/o pattersn? such as multi-block reads and
single block reads?
From: Nuno Souto [EMAIL PROTECTED]
Date: 2003/07/15 Tue AM 11:59:23 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: should you seperate indexes from tables in
The thing that occurred to me a few years ago (as a result of a test
designed by Craig Shallahamer) is that what disks do gets very, very
complicated when you add users. On any system busy enough to have a
performance problem, the odds are usually slim that a disk is just sitting
there waiting for
R,
Just to avoid confusion, that wasn't what I meant by batch program
benchmarking.
Are you rebuilding indexes? I've seen some strong benefits when
rebuilding indexes of having the index and table on separate devices. But
then that is really easy for you to test.
Dennis Williams
DBA,
Hi everyone
I just answered a post on the server newsgroup from someone who wanted
to know if a privilege had been granted to a particular user including
mining through all of the roles granted hierarchically to roles etc. I
posted a reference to a PL/SQL script I have knocked up as an answer
Hundreds, nay, thousands put their datafiles on SAN. All love it. All
would trade their children for more SAN storage. None have ever had a
problem. :)
Seriously, though, some huge percentage of storage being configured
today is SAN and a big chunk of that is database storage. It by and
Hi, friends:
There is a project that migrate a 9.0.1.3 database on linux server to
9.2.0.3 on aix/p670 server, and I have some question about this project,
hope friends in the list can share your idears.
1.Shall I use AIX 5.1 or AIX 5.2?
According to pagev
if I can still find it. :) I know Kevin did say different disks
because I remember coming home from that presentation and trying to
explain to my data center people why I needed something like 17 disks
for my database.
my apologies over the years, people have made the assumption that
Hi, JL:
I think you need the multipathing solution for your platform. In a SAN
environment, there is more devices, so more chance that device fail. So you
need multiple path from host to storage. That means multipathing IO support,
like Veritas DMP or Sun AP or HP pvlinks or storage specific
Its all fine unless some jacka$$ starts pulling fiber cables w/o paying
attention, then the paths die, databases crash, etc.
joe
Matthew Zito wrote:
Hundreds, nay, thousands put their datafiles on SAN. All love it. All
would trade their children for more SAN storage. None have ever had a
I LOVE THIS LIST!
A few more personalities (GAJA, ARI, IAN .) opinions added to this discussion and
we could publish a paper on this thread alone.
Thank you GURUS
You are the ones that make monitoring this list worth more than anything !
Luis
-Original Message-
Sent: Tuesday,
Matt
Thanks so much for your posting. I especially appreciated your comment
try not to be too smart. Would you consider writing a book on the topic of
I/O Devices for the Oracle DBA? I would like to learn more, but don't know
where to begin.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch,
nice! and very usable, as I'm trying to mine through privileges and
tighten security here.
thanks much!
--- Pete Finnigan [EMAIL PROTECTED] wrote:
Hi everyone
I just answered a post on the server newsgroup from someone who
wanted
to know if a privilege had been granted to a particular user
Has any rolled their own SAN? We've got a bunch of stuff on EMC but
now we're looking to build our own fibre channel SAN and replace EMC NFS
with clustered file systems. (Of course Oracle is not on NFS.)
Disk may be cheap but vendor SAN boxes are not.
Steve Orr
Bozeman, MT
-Original
Jesse,
You could always get around this problem by obtaining an upto date
TNSNAMES.ORA on any Names-aware client using the 'namesctl dump_tnsnames'
command that will create/update the tnsnames.ora with the entries from Names
servers. I would suggest renaming the original tnsnames.ora _just_
surely i will not do it. but my question is whether it
is possible at all to do it.
will oracle when allocating shared memory space take
virtual memory into consideration or only real memory
into consideration.
thanks
sai
--- AK [EMAIL PROTECTED] wrote:
you will end up doing swap/paging .
If you can't find it, you can download it again from
http://www.hotsos.com/catalog. I *promise* I haven't cheated and edited the
document since the date that's published on its cover.
Lots of people at the time (~1992) were preaching to separate indexes and
data on different disks. The OFA gave
John Kanagaraj [EMAIL PROTECTED] wrote:
Jesse,You could always get around this problem by obtaining an upto dateTNSNAMES.ORA on any Names-aware client using the 'namesctl dump_tnsnames'command that will create/update the tnsnames.ora with the entries from Namesservers. I would suggest renaming the
I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some?
tia
M
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier.
Gadzoox!! www.gadzoox.com
-Original Message-
Sent: Tuesday, July 15, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
I have them...
one of the things that I can tell you is that...
sometimes (at least here at work) the ports switches
fail and you lost your connectivity to your
question #1: Do you realize that your DBA is a God, and you will obey
his/her edicts without question?
question #2: Are you aware of the daily offering of food/beer required to
keep in your God's (DBA's) good graces?
etc...
Scott Shafer
San Antonio, TX
210.581.6217
-Original
Oh I'm sure I have a copy at home, somewhere. I'm a packrat.
I was an almost brand-new DBA at the time, so I was on information
overload then, trying to learn Oracle and as as much as I could, all at
once (you try becoming the Oracle DBA without ever having seen Oracle
before!)
and yes, you do
John,
True, but the whole purpose is to get rid of those damned TNSNAMES.ora files
in the first place. I don't know about you, but the fun to tracing why a end user
can't get to the database because he has his own alias to the database buried in a
TNSNAMES.ora file is a real PAIN.
If it take only real mem in consideration why would pageing happen at all ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 11:19 AM
surely i will not do it. but my question is whether it
is possible at all to do it.
Hi Markus!
Here's a recipe that might help you (assuming your table is called MYTABLE:
1. create a sequence:
CREATE SEQUENCE MYTABLE_Sequence start with 1 increment by 1 nocycle nocache;
2. create an insert trigger
CREATE OR REPLACE
TRIGGER MYTABLE_Insert_Trigger
BEFORE INSERT ON
I've been in the same situation, I had to interview
the company's sysadmin, though I am not one. Here you
have a few points to start your list.
Regards
Gabriel
The candidate must provide knolwedge about (how to's):
1. Start and stop a solaris system, including several
levels of boot (1,2,3,
Sorry I meant Hi Martin
-Original Message-
Sent: Tuesday, July 15, 2003 8:59 PM
To: Multiple recipients of list ORACLE-L
Hi Markus!
Here's a recipe that might help you (assuming your table is called MYTABLE:
1. create a sequence:
CREATE SEQUENCE MYTABLE_Sequence start with 1
Okay, here are my favorites for senior candidates (I'm giving all my
secrets away...):
1) What is an inode? Bonus: What important piece of file information is
NOT stored in the inode?
2) What is priority paging and how does it work? (mildly dated, but
useful if they claim to have been around for
Eh - same problem with SCSI, except SCSI cables have the neat little
screws to make that harder. It's a good point, though - a SAN is a
network. For proper redundancy, you need two separate fabrics (read:
redundant paths from storage to host that pass through two different
switches, with the
These are nice questions. I'm not sure how I would identify if they are technical enough to handle the job though.[EMAIL PROTECTED] wrote:
question #1: Do you realize that your DBA is a God, and you will obeyhis/her edicts without question?question #2: Are you aware of the daily offering of
Well, you can run Oracle over Netapp NFS, which is far superior to EMC's
Celerra (their NFS product), except in a few niche features. By the
way, Netapp just released their FAS250 low-end filer - up to 1TB usable
in 3U, pretty speedy, and damn cheap.
Rolling your own SAN is certainly doable,
You only spend time on the technical stuff if they pass this round.
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: M.Godlewski [SMTP:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Interview
1 - 100 of 160 matches
Mail list logo