Title: RE: Backup Strategy
Gene is a sysadmin at heart. He hasn't been fully groomed and trained in the Data Base Arts. I think that's the main reason for his (unjustified) reluctance to TRUST something that works.
It's like physics. You see it every day, the math doesn't make 100% sense to
Title: RE: running catlog,catproc
You don't want anyone in the database when you are recreating the data dictionary.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Tatireddy, Shrinivas (MED, Keane) [SMTP:[EMAIL PROTECTED]]
Title: RE: Localy managed TBS
in dba_tablespaces, column extent_management
below is a script I use that has this bit of info included
-- snip
column ts_name format a15
select a.tablespace_name ts_name,extent_management lmt, mb_free, mb_total, pct_used
from
(
select
tablespace_name,
Title: RE:
Hi Chris,
Have you tried an inline view yet?
SELECT s.study_id, s.status, sp.status
from
(SELECT study_id, status
FROM s
WHERE study_id = 5014
) s,
sp
where s.study_id = sp.study_id(+)
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
Title: RE: Sqloader
Also, depending on what version you are on, you can have multiple INTO TABLE statements. See below from the 8.1.7 doco.
Using Multiple INTO TABLE Statements
Multiple INTO TABLE statements allow you to:
Load data into different tables
Extract multiple logical records
Title: How much data can SQL*Server hold?
Hello everyone,
Any of you using SQL*Server on fairly large databases? If so please email me directly.
I have a consulting company telling me they can run a 500GB+ database on SQL*Server with no problems and I'm pretty skeptical. What's the
criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 11
-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc).
I've been here 3 years, installed at least 30 new systems and have never
been in any of our computer rooms.
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 9:05 AM
Title: RE: Preventing user access
Hi Sean,
someone on the list, his or her name escapes me, suggested two listeners. One for the general users and one for dba's only. You want to kick your users out, bring down the general use listener. Clever and slick!
Lisa Koivu
Oracle Database
will run fine as it will be running locally to the server.
HTH
Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Wednesday, September 26, 2001 15:55
To: Multiple recipients of list ORACLE-L
Subject: RE: Physical access to servers
Title: RE: Datatype
Hi Ken,
Date is the name of the datatype.
It can be formatted in many different ways.
Like this, formatted into date and time.
(VIKING-SYSTEM)select to_char(sysdate,'dd-mon- hh24:Mi:ss') from dual;
TO_CHAR(SYSDATE,'DD-
25-sep-2001
Title: RE: Physical access to servers for maintenance
What's wrong with telnetting in?
-Original Message-
From: Steven Lembark [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Physical access to servers for
Title: RE: interesting floating point problem with oracle
Well... not on 8.1.7. It's fine here.
(VIKING-SYSTEM)select 62.323/62.323 from dual;
62.323/62.323
-
1
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
Title: RE: Physical access to servers for maintenance
Honestly Ron, installs are the only thing I can think of. We had our prod servers at a different location and believe me I avoided going up there whenever possible. Install was the only thing I had to go up there for.
I've been able to
Title: RE: TEMP Tablespace
Hi Connie,
Because there isn't anything stored in there (a segment) permanently. But when I look at my db (well, my horsing-around-and-breaking-stuff db) I see this. My temp tablespace is not permanent.
1 select segment_name from dba_segments
2* where
Title: RE: QUESTION ON RESTRICTING BULK COLLECT
Rajan,
For what it's worth I have never been able to get bulk collect to work on a large number of records restricting with recno. It was so painfully slow. I use it to bring small lookup tables into memory but I don't use it for
Title: RE: DBMS_SQL to Create views
Hi Kevin, this is kind of changing the topic... but why are you creating procedures as SYS?? Seems to me upgrades, patches, etc. would possibly endanger your procedure. I always thought of it as sys owning all the code that runs the database, data
Title: RE: EMC BCV Splits and Hot Backup mode.
Hi Glenn,
Are your arclogs redologs on the bcv?
Think of it in the same manner as a hot backup - what if there was a large data load going at the time of the split. There's no guarantee as to what data changes will make it on what mirror
Title: RE: Design Issue - Quick response appreciated
Rao,
The only way to tell is to autotrace or tkprof. I would strongly advise doing so because connect by is a performance killer. If you have to use it, be sure the query isn't doing anything unacceptable.
Lisa Koivu
Oracle Database
Title: RE: How TSPITR?
Seema this is a very involved topic and your question is very broad.
Have you read the documentation?
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: coalesce tablespace
Hi Dave,
No. temporary tablespaces provide a performance gain by not de-allocating extents. The next transaction that needs the temp tablespace can utilize extents that are already allocated, thus bypassing the overhead of allocating the extents.
That's the
Title: RE: 2nd DBA or ?
Another angle: when I left my last job, I was the only dba. They panicked and did everything they could to try to keep me. The result was they were left without a skilled dedicated dba, assigning my job responsibilities to a bda (big dumb a$$) who tried to learn it in
Title: RE: sizeiof table!!!
Here's a modification of one that I use
1 select
2 tablespace_name, MB_FREE, MB_TOTAL,mb_total-mb_free mb_used,
3 round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used
4 from
5 (select tablespace_name, trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024)
Title: RE: Subtract 1 month from current date
Hi Ron,
Here it is
(INV.WORLD-SYSTEM)select add_months(sysdate,-1) from dual;
ADD_MONTH
-
17-AUG-01
For conversions, etc. it's best to study the sql*plus doco. In fact I had to visit this exact chapter this morning to refresh my
Title: RE: EBU Question
Hi Jack,
I had to use it before. It's a MESS. Even the documentation and the notes on Metalink are wrong. Support gave me some internal documents that showed exactly how to create/update a repository. That was the only way I got it to work. I think your best option
Title: RE: What happens if you lose the alert log?
Bill,
IF the alert log suddenly disappears (you delete it), Oracle will create a new one without skipping a beat.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Carle,
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
John, I have to say that's a very interesting post. Two shops I've worked in utilizing an EMC Symmetrix claimed that there's no way you could ever end up with i/o problems and you shouldn't even consider it when creating a database on
Title: RE: USE_NL with or without ORDERED
Hi Ed,
how many records are in the tables?
Hash join is favored when there aren't so many records and there's enough memory to slam together the result set.
I think you aren't seeing typical behavior. Try this on much larger tables and see
Title: RE: Life: is that really OT?
Greg, you have a point. I don't fully agree with killing to retaliate.
However, if the US doesn't do anything about this, there's no guarantee this won't happen again. I went home yesterday because I was scared out of my pants, and I'm in Florida. No one
Title: RE: dbms_utility.compile_schema
What version are you on? It was hosed in 8.1.5.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Big Planet [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 1:11 PM
To:
Title: OT: Terrorist Acts and the media
Babette,
When I finally got a website (cnnfn) to come up yesterday morning, it did say initially that two planes hit each WTC tower. Maybe the media is hiding something.
Here's something scary: One of the suspects was suppossedly living in an
Title: RE: Any shareware/gnu ER diagramers out there?
Toad. www.toadsoft.com
Does everything you're asking for.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: John Lewis [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September
Title: RE: Hanging processes on NT
That's the problem. Should... It never worked for me (8.1.5, 8.1.6) and I had to write a script to take care of these types of connections.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From:
Title: FW: nvl not using index
BigPee,
Have you tried a function-based index yet? (8i) You'll need to grant query rewrite privilege to the user creating the index.
Lisa Koivu
Glorified Typist and DBA
Ft. Lauderdale, FL, USA
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL
Title: OT
I hope everyone on this list in the New York area is safe I am so scared.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
Title: RE: collections / records / index-by, etc - long, sorry
Thanks Prakash,
but can I use FORALL with this object? I don't think so. Correct me if I'm wrong.
Thank you
Lisa Koivu
Ft. Lauderdale, FL, USA
-Original Message-
From: Bala, Prakash [SMTP:[EMAIL PROTECTED]]
Sent:
Title: RE: v_$session HELP...
The background processes. I exclude these sessions when viewing activity in the database with my sessions script.
Lisa Koivu
Oracle Databug Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Sinardy [SMTP:[EMAIL PROTECTED]]
Title: RE: What's wrong with this query
Your hint is wrong. You have to tell it what index to use. example /*+ index (table_alias index_name) */
Remember hints, if they are wrong, will just be ignored.
Your execution plan seems OK. It's returning an awful lot of rows ...
Lisa Koivu
Title: RE: What's wrong with this query
Hi Anne,
Expected rows - my impression is the number of rows it will return. However, if you are using set autotrace traceonly explain, I don't know how it could know that. So take that number with a grain of salt.
Cardinality - number of distinct
Title: collections / records / index-by, etc - long, sorry
Good morning everyone,
well I finally have something to work on. Not being one to whip out shoddy code, I want to write my load scripts utilizing pl/sql tables and caching as much as I can, along with utilizing FORALL and BULK
Title: RE: outer join problem
Try inline views. They will solve your problem.
Lisa Koivu
I can't believe I work here.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Harvinder Singh [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 1:27 PM
To: Multiple
Title: RE: collections/PLSQL tables
Raj,
Well, you can limit the number of rows BULK COLLECT will return with the LIMIT keyword. Wouldn't that take care of the performance problem you refer to? And isn't it affected by the amount of free memory on the host? For insteance, there's very
Title: RE: collections/PLSQL tables
Really? The documentation says that when you use limit, you won't have to keep track of records you have already used and haven't already seen. But then again the documentation has been wrong before. I'll have to give it a try.
Thanks for your comments
Koivu, Lisa
lisa.koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
field.com cc:
Sent by: Subject: sql*loader datatype question
[EMAIL PROTECTED]
08/30/2001 12:33
PM
Please respond to
ORACLE-L
I'm hitting a wall here. I'm trying to load data
Title: RE: Stored Procedure Performance Problem --- Please Help
Where's your tkprof output? First step always is to trace.
-Original Message-
From: Viral Amin [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Stored
Title: sql*loader problems SOLVED
In case you are interested...
I found out what the problem was.. my numbers were padded with SPACES. Freaking mainframe...
So here's how I solved it, after I dumped the whole thing in a VARCHAR2(4000) and substring'd it:
FPS_ACC_HK_POINTS1
Title: RE: OPS$users
remote_login_passwordfile = exclusive
os_authent_prefix = OPS$
and create the user identified externally.
Lisa Koivu
-Original Message-
From: Bartolo, David [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 1:19 PM
To: Multiple recipients of list
Title: RE: OT RE: database consistency tools ?
If the DBA screams bloody murder and loses his or her mind,
does anybody hear?
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 3:07 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT
Title: RE: OT: football fan-hood
BLASPHEMY!
-Original Message-
From: Scott Shafer [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT: football fan-hood
Lisa's really a Dolphins phan in purple viking drag...
Title: RE: OT: football fan-hood
BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year.
Charge that $5 to my account. Sorry.
The short story is:
Grew up in MN... my whole family watched the Vikings... my grandfather
Title: RE: DB Monitoring
HI Vivek, off the top of my head:
Number of extents - any reaching huge numbers?
Tablespaces running out of room? Drives on the host filling up?
Any jobs that have been running over 24 hours?
Possible zombie processes?
Top 10 most resource-intensive queries. Can
Title: RE: financial problems with fatcity.com
THAT IS A FANTASTIC IDEA Oweson. If he places one person from this list he can sure afford it.
-Original Message-
From: Oweson Flynn [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 9:22 AM
To: Multiple recipients of list
Title: RE: !! Keeping the list alive
AMEN!
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: !! Keeping the list alive
no, those posts keep us underworked DBAs from
Title: RE: RE: financial problems with fatcity.com
Ross is that all you are contributing? Two cents?
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: financial problems
Title: RE: Tkprof output
Lee,
This query seems suspect
UPDATE VM_LIVE.SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE=1
WHERE
ACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2
because of this
call count cpu elapsed disk query current rows
--- -- -- -- --
Title: sql*loader datatype question
I'm hitting a wall here. I'm trying to load data into a large table. Two of the fields are phone numbers (10 digits). The database field is defined as number(10).
When I try to load these records, they err out with an error similar to below.
Record
Title: RE: 8.1.7 on W2K
Well, this may not be the absolutely correct way to do it... but this is what I did
write a batch script that does the oradim call to start services and instance
Put it in the batch scheduler and choose runtime as 'on system startup'
Hasn't failed me yet.
Lisa
]
- Original Message -
From: Koivu, Lisa mailto:[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 1:33 PM
Subject: sql*loader datatype question
I'm hitting a wall here. I'm trying to load data into a large table. Two
Title: RE: sql*loader datatype question
Well noo it's fixed-length and I think I'd end up with a big jumble, wouldn't I? No delims in the file.
-Original Message-
From: Bala, Prakash [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:48 PM
To: Multiple recipients of
Title: RE: sql*loader datatype question
Good explanation but no it's not
-Original Message-
From: Ron Rogers [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: sql*loader datatype question
Lisa,
Is the field
Title: RE: results of analyze
Ruth, do you mean tables other than dba_indexes, dba_tables, dba_ind_partitions, dba_tab_partitions, etc., etc??
Here's a good one. The dba I worked with (certified, no experience) tried to tell me that when you analyze it adds columns to the table. Yea,
Title: RE: 817 Intermedia on AIX
Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work.
Lisa Koivu
The Bootylicious DBA
Ft. Lauderdale, FL, USA
-Original Message-
Title: awk, sed, windoze, sql*loader, other fun stuff
Hello all,
I'm working on sql*loader scripts and I realize that I'd probably be DONE by now if I had awk and sed to use. Of course, as unix-deficient as I am, I don't have it. Does anyone know of a windows version of these utilities?
Title: OT: Lisa
Nothing wrong with combining a technical discussion with a bit of humor :) Tell me if I'm wrong !
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 4:12 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Lisa
I
Title: RE: How to loop call to SQL script in PL/SQL...
Denmark,
Every 5 seconds?? That's going to put an awful load on your database, dont'cha think? That's also going to be a very large file. We tried this a few months ago when jrun was acting suspect and we were getting a bunch of
Title: RE: Change parameter without restart db
Sinardy,
Look at v$parameter, at ISSYS_MODIFIABLE. If it is FALSE, you have to restart the db for the change to take effect.
Lisa Koivu
Gimme a PC and I'll Break It, Guaranteed and DBA
Ft. Lauderdale, FL, USA
-Original Message-
Title: RE: OT : kernel using 75% of CPU
OOOH yea. Looks like your machinie is awful darn busy !
Lisa Koivu
Certified MOnkey and DBA
Ft. Lauderdale, FL, USA
-Original Message-
From: Jerry C [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 4:01 PM
To: Multiple
Title: RE: Oracle Learning Network
Hey Yuval,
You shouldn't have to pay them to give them your opinion! Sound OFF!
Lisa Koivu
Certified MOnkey and DBA
Ft. Lauderdale, FL, USA
-Original Message-
From: Yuval Arnon [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 3:41 PM
Title: RE: Tablespace layout
Well Satar you didn't even read Cherie's email.
Way back before I took that db to the tablespace layout you refer to (straight out of HOw to Stop Defragmenting and Start Living white paper) I had created a separate tablespace for each partition. It was an awful
Title: RE: OT RE: RE: How do you audit a DBA?
C'mon. I'd vote for The Rock instead, along with all The Rock's witty comments. That would be awfully darn distracting, and you could be sure your DBA would get NOTHING done :)
Honestly, if there's a need to audit the dba, maybe he or she should
Title: OT: system trivia (groove/programming): DOS prompt/etc and choppy sound
Really? I thought it was only because my personal pc has so little memory. I run into that behavior with explorer and playing mp3's at the same time. This also becomes a problem when burning a cd or changing
Title: OT: Cobol Copybook format
Good morning everyone,
I have this messy document that is known as a copybook. I've been searching the web to help me understand what the appropriate way to translate this into a table is. If anyone has a link they are willing to share, or is willing to
Title: RE: ORA-10027 in ps/sql block
Rodd, can you post the code?
-Original Message-
From: Holman, Rodney [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-10027 in ps/sql block
I have a developer here who is
Title: ach_tran query
Hi Cherie,
Looks like parallel query kicked in. It usually throws some odd looking stuff in the explain plan.
HTH
Lisa
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 3:11 PM
To: Multiple recipients of list
Title: RE: Data Center monitoring
HELP
And get LOTS OF IT
Look at MC Service Guard to enhance availability. In addition, see if you can use some sort of storage solution that will minimize the occurrence of losing a disk.
Look at running backups in parallel, and practice recoveries in
Title: RE: Data Center monitoring
I agree. I have never seen a monitoring tool that worked better than your own tried-and-true trusty scripts.
-Original Message-
From: Stephen Andert [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 5:21 PM
To: Multiple recipients of list
Title: RE: database upgrade policy?
Don't upgrade unless there is a very good reason.
All of these are candidates
1. current oracle version is unstable
2. specific bug addressed by an upgrade/patch, as identified by support
3. need to utilize new feature
4. desupport date coming up.
If
Title: RE: linux Oracle -- best combination
Have you tried an index hint on the first query yet?
Have you tried NVL(cmm_id,101) = 101,
NVL(cust_id,101) = 101
NVL(Friendly_session_id,100) = 100
loc_to_utc(NVL(creation_date,21-jun-2001')) between your dates?
-Original Message-
Title: Apologies... linux Oracle
Sorry everyone, I know you were just discussing this recently.
What is the most stable combination of Oracle Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember.
Thank you
Lara Croft
Oracle Database
Title: RE: Freelist Contention - PQ slaves
I thought that parallel query slaves were smart enough to divide up the work between them so there was no overlap? What am I missing? Can you elaborate?
-Original Message-
From: Johnson Poovathummoottil [SMTP:[EMAIL PROTECTED]]
Sent:
Title: RE: How do they get the answer?
Ken, after reading through the quesiton and thinking it through I arrived at the answer they give. They are trying to trick you into choosing syntax error. You'll find questions similar to this on the exams.
Lara Croft.
Certified Tomb Raider and DBA.
... linux Oracle
SCO makes a version of Linux now?
Ed
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Apologies... linux Oracle
Sorry everyone, I know you were just
Title: RE: Index question ???
Andrea,
It is recommended, not required. Anytime the db needs to verify the fk constraint, if there isn't an index there to support it, a full table scan will happen. Performance killer.
What do you mean your indices disappeared? Can you elaborate?
Title: w2k db connections... shudder
OK. This question is posed to those who maintain applications Oracle on Windows 2000 servers.
What's the maximum number of connections you can feasibly support?
Has anyone implemented a windows 2000 cluster and had it reliably work?
I feel
Title: OT: DBA tasks
Ahem... the female DBA's save the database, save the world, flatten the evil people with her well-tuned martial arts skills, swims in icy cold water without showing one goose pimple on her Barbie-proportioned body, impresses the Diet Coke guy, and then tells him thanks
Title: RE: OT: DBA tasks
Nope, not yet. When (and if) that happens, the advertising companies and networks are going to scream bloody murder.
However, you can turn on a program, wait 10 minutes, and then watch the entire thing fast-forwarding thru all commercials. Super slick. by far the
PROTECTED]]
Sent: Monday, August 20, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT: DBA tasks
you go girl! :)
do I have to have Barbie-blond hair though? I'm thinking a nice, brilliant
red myself
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED
and adapter???
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT: DBA tasks
Nope, not yet. When (and if) that happens, the advertising companies and networks are going to scream
be in every TV. But most people just dont get it.
BTW, what is the stripped card and adapter???
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT: DBA tasks
Nope, not yet. When
Title: RE: UTLB/E stat
Joe, these are values to always be ignored, along with rdbms ipc message, sql*net message from client. Check out note 62161.1 on Metalink.
could you ask for a better answer ?!
Lisa Koivu
aka Lara Croft, DBA
Ft. Lauderdale, FL, USA
Also, From the Fine Manual
Title: RE: Recovery Question
But don't you end up with an incomplete recovery then?
AJ
-Original Message-
From: Peter Gram [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Recovery Question
Hi Kamel
You have
Title: RE: OT - Vaccines
YOU GUYS ARE SCARING ME OUT OF HAVING CHILDREN!
How on earth can a parent make the right decisions?? All the information flying around on the list is pretty unnerving. Sure the numbers may be very low but the #1 thing I worry about (and most other expectant parents)
Title: ops$/w2k/secure connections question
After much fiddling, I got ops$ (os authenticated) logons to work in my w2k db. However, I'm confused. I had to set REMOTE_OS_AUTHENT = TRUE in order for this to work. See snippet from doco below.
I'm doing this all locally. When I set
Title: RE: ops$/w2k/secure connections question
Thanks to Patrice, Paul and Eric for your responses. I guess I'm not all that concerned about it. It just seemed like it didn't quite make sense.
I remember reading that excerpt about Oracle Password Protocol in the 8.1.6 doco as well.
If
Title: RE: Speed up Truncate tables - rebuild index
Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this behavior.
Lisa
- rebuild index
Lisa,
I think Chris referred to 'alter table ... move',
in which case you need to rebuild indexes (ROWIDs changed).
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
- Original Message -
From: Koivu, Lisa mailto:[EMAIL
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Hi Rick,
I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am
)414-4627
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
- Original Message -
From: Koivu, Lisa mailto:[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 1:28 PM
Subject: RE: No TNSListner service after intall 8.1.7 on Win 2k
the platform-independent parts of Oracle's code, compiled for VOS on Intel.
Cheers,
g
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 6:22 PM
To: Multiple recipients of list ORACLE-L
Subject: I admit this is dumb. NT/W2K Services?
I'm
Title: RE: Speed up Truncate tables
Chuan,
You can use the 'REUSE STORAGE' clause of truncate table. That's a heck of a lot faster if you have a whole load of extents allocated to the table. What it does is mark the table as empty and keep all extents.
However, I have a feeling that if
301 - 400 of 548 matches
Mail list logo
