Title: RE: Imedia query optimization
Ranganath,
I have found that intermedia queries really bite the biggie without a hint. Read up on the hints /*+ FIRST_ROWS DOMAIN_INDEX_NO_SORT */
There is a chapter in the doco on tuning intermedia queries that discusses the reasons why these hints
Title: RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch
OMG is that FUNNY
I just woke everyone with my 'quiet' laugh !
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 11:51 AM
To: Multiple recipients of list
Title: RE: Taking your time when a crisis occurs
These are good points, but beware of the boss that thinks looking over your shoulder and asking questions helps. Either your supervisor trusts you or he/she doesn't. For me, having someone right behind me breaks my concentration and can make
more. I've had my gut full of it. :-)
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation
Original Message dated 5/7/01, 9:45:47 AM
Author: Koivu, Lisa
Title: RE: V$session
It's in v$process. Here's a script that displays it that I got off this list a while ago
set linesize 2000
column logon_time format a17
column username format a16
column unix_pid format a8
column machine format a20
column client_Program format a20
set pagesize 200
Title: RE: OFA and SAN - Why not group all db files on its own mount point?
Hi Mike,
If you are running EMC hardware, there are several utilities you can use to determine if EMC's cache is performing up to par. There are also utilities to alleviate any i/o contention that may appear if the
Hello all,
8.1.6.2 on HP/UX
11.0
Has anyone seen
something like this before? I can't rebuild the primary key - the error is
duplicate rows found. So I check the data (first listing) and see duplicate rows
via fts. When I give it a hint to use the primary key it shows
nothing. When I
Anyone else having
problems with Meta Stink today? I don't know how they expect us to get any
work done and use this piece of junk if it won't let me create and update TARs,
or, even yet, display the index page. LOVELY
Lisa
Rutland KoivuOracle
OK. Well I meant that, I read it now and it
sounds sarcastic.
Kimberly, really. Networking is so far over my
head. I didn't write the signature. I just have to use it.
Sorry...
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 26, 2001
Well,
my sysadmin wants to know what's so cool about it?
Kimberly I must apologize if my email makes your life
difficult.
-Original Message-From: Kimberly Smith
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 26,
2001 1:41 PMTo: Multiple recipients of list
Title: RE: ORA-04030
Hi Anton -
The error is exactly what it says it is. The OS is out of memory to allocate to this once process.
Are you using PL/SQL tables or anything that could go wild with memory in your PL/SQL scripts? I've had this happen before when I first started messing with
Title: RE: SQLTrace
Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them.
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL
Title: RE: ORA-04030
Hi Riyaj,
I think you are referring to the ORA-4031 error? 4031 refers to a fragmented SGA. 4030 is the OS.
Correct me if I am wrong.
qodd bar:/oracle/localoerr ora 4030
04030, 0, out of process memory when trying to allocate %s bytes (%s,%s)
// *Cause:
at your risk
Koivu, Lisa
lkoivu@qode. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: RE: SQLTrace
root@fatcity.
com
04/23/01
09:10 AM
Please
respond to
ORACLE-L
Dave, you can also set a command in the cron to chmod
Title: RE: PL/SQL-if-statement
Have you tried rpad() or lpad()?
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL PROTECTED]
NeoMedia
2201 Second St., Suite 600
Fort Myers, FL 33901,
Title: RE: More Metalink Venting - Cannot catch error 22
Yes, I have that problem too (no CSI). So much for the 'helpful' website. It took me five days to get through to the sales rep to figure out why our support agreement had lapsed. That was support's story when I called them. Still no
- is that Self
Certified Self Important datavbase Deity
or did you pass a special OCP exam for that ? ;-)
Q
Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 04/19/2001 11:40:54 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
Title: RE: Temporary Tablespace Design
Hi Chris,
Yes there may be 'rules' like this, but realistically who has 64GB to spend on disk space? I have one huge table similar to what you describe. My temp tablespace is 20GB only because I have the disk. Maybe you can take the route of
Good morning
everyone -
Has anyone
successfully installed and used the XML SQL (XSU) utility? I'm getting
this error and 1. there's nothing on Metalink that tells me exactly why I am
missing this resource/class or where to get it and 2. I'm pretty sure I
installed everything correctly -
Title: RE: Parallel index builds can crash
Hello Dick,
YOU ARE KIDDING. I've done this many times in the past and never encountered that type of behavior... I don't see what version/OS you are running? Was the table partitioned?
And, back by popular demand, is my highly overrated
Title: RE: Parallel index builds can crash
On a partitioned table? If you have a slave for each partition, how would this be wrong? Or, less slaves than partitions?
It was pounded into my head not to use parallel with non-partitioned tables because without partitions the slaves would not
Title: RE: killing a thread
I didn't see this in my $ORACLE_HOME/bin. Is this platform specific?
-Original Message-
From: C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:00 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: killing a thread
Hi
Dan,
are
you referencing public synonyms in your statement?
Lisa
Rutland KoivuOracle Database
Administrator[EMAIL PROTECTED]4850 N.
State Rd. 7, #G104
Ft.
Lauderdale, FL 33319
Phone:
954.484.3191
Yea
right! Someone in the office of our new parent company had too much time
on his hands...
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:47
PMTo: Multiple recipients of list ORACLE-LSubject: OT
RE: Select won't work for
associated with each log file are stored in the control file also, I believe. List, please correct me if I am wrong.
Lisa
-Original Message-
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 3:06 AM
To: 'Koivu, Lisa'; 'Oracle List I'
Subject: RE: identify which logs are need
Title: RE: INVALID Packages
Hi Paul,
If the person logs out logs back in, is the problem solved? Or if they try to execute a second time, does the problem go away?
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]
NeoMedia
2201 Second St., Suite 600
Fort Myers, FL
Title: RE: OT -- # tables in your db (was: Slow database)
Nope, Cherie wins. Before I left, I realized I had a database that had 19,000+ tables in it. There were a ridiculous number of schemas. Cherie, did you guys ever bust that database up into two?
-Original Message-
From: Alex
Title: RE: identify which logs are need to start recovery
Hi Rahul,
I'm not sure if there's a v$ view that will tell you, I remember looking for this myself.
However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found
Hello everyone
-
I'm
fiddling with CLOB code for the first time. I have to write a function
that will accept a long string of characters from an external application and
store it ina CLOB field.
Seems
to me that since the character data is coming from an outside application, the
only
, March 21, 2001 11:20 PM
To: Koivu, Lisa
Cc: Multiple recipients of list ORACLE-L
Subject: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
Ok, does someone one to define SRDF and BCV for
those of us that don't have any idea what you're
talking about?
Jared
On Wed, 21 Mar 2001, Koivu
automagically. Right Lisa?
[EMAIL PROTECTED] 03/21/01 11:17PM
Ok, does someone one to define SRDF and BCV for
those of us that don't have any idea what you're
talking about?
Jared
On Wed, 21 Mar 2001, Koivu, Lisa wrote:
Hi Yosi, how are you?
I can't exactly clarify your fish vs. potatoes, er
Title: RE: Re[2]: Couple of questions
Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE.
Yes, Gene, you
Title: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
Hi Yosi, how are you?
I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast,
Title: Device busy - HELP
Hello all,
HP/UX 11.0 w/EMC hardware
Well my trusty BCV's are BUSY. The script that runs every night executes fuser and kills any processes that may be attached to them. It failed last night due to something I did... well I cleaned it up this morning and I can't
Title: RE: 1/2 control file failure - will database halt?
Yea,
it worked for me... it was a small database
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 21, 2001 4:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
1/2
Title: RE: HINTS , how to add correctly
Also, as our esteemed colleagues on this list have pointed out in the past, deleting statistics and then analyzing can make a difference as well. Don't ask why.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite
You need
to create preferences and specify them in your create index statement.
This is all in the documentation, by the way. Also, this does not affect
your IOT storage parms. You will have to modify those separately or you
will blow maxextents as your index grows.
Here's
what mine look
Title: RE: number of Mb to add?
Joseph,
Well, do you really want to deal with a datafile that small, whether that's KB or bytes? What about when it extends beyond that extent? Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production
Title: rename database
Hello everyone -
Is it possible to rename a database without recreating the controlfile? I have a feeling it isn't, but can someone verify?
Thanks
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL
Title: RE: reset control, redo, logs etc
If your database was not shut down, it was not a cold backup.
If your tablespaces were not in backup mode, good luck. Everything will be out of sync.
I suggest taking a true cold backup before doing anything else if you want to save this database.
Am I
the only one who gets garbage out of this query? There's a mismatch on
v$statname. Which statistic are you suggesting to display, uga or pga
memory?
-Original Message-From: Bjorn Naessens
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001 5:15
AMTo: Multiple
:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 11:11 AM
To: [EMAIL PROTECTED]
Subject: RE: Redo logging with version 8.1.6.x
Hi.
Sorry for the lack of information.
Solaris 2.6
From v7.3.4 to v8.1.6
Thanks.
CN=Dan [EMAIL PROTECTED] on 02/19/2001 09:37:06 AM
Sent by: Koivu, Lisa
they will just remain idle.
I'm not sure about the degree 0, I was thinking it was the same as 1
(no parallelism) but I tried setting it in 8.1.7 and 8.0.5.2.1 to 0 and
I received an error message.
- Brian
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Hello all,
I've purposely got PQO off. But I
Title: RE: SELECT SKIP (Was: RE: Off Topic: Row Locking - Row Id)
Isn't this what you are referring to?
If you are not going to update the records, why lock them?
SQL select * from testcat for update nowait;
CATEGORY_ID PRODUCT_ID LAST_MOD_ DATA_SOURCE_ID
--- --
Title: Degree of Parallelism: 0?
Hello all,
I've purposely got PQO off. But I was shocked to see I've got some parallel query slaves out there. I checked to see which objects they are, listed below. I'm not concerned about the sys/system stuff, Im worried about CTX (my intermedia text
Matt,
have you tried replacing the IN statement with an EXISTS
statement?
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07,
2001 8:31 AMTo: Multiple recipients of list
ORACLE-LSubject: Sql Tuning help
I have been having
Title: RE: v$waitstat
Mitchell, in order to clear your waits you must bounce your database.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
Title: RE: Pondering Question of the Day-RESPECT
Gabriel, I agree. In the past it hasn't been us vs. them. It just has gotten worse in the last few months. Why can't we just all get along? Sure, it's quiet when I don't insist upon proper procedures.
I DID change the passwords, this morning,
501 - 548 of 548 matches
Mail list logo