Well at least here in the US, our women are smart enough to stay out of the
presidential meat grinder. But given the last twenty years of bone heads we've
elected, from RayGun to Bush Jr., I think I'll vote for a women even if she just
declares. I think we've had enough of guys who have their
Here's a script I wrote to list all the files associated with the database.
List, did I miss any?
___
break on today
column today noprint new_value xdate
select substr(to_char(sysdate,'fmMonth DD, HH:MI:SS P.M.'),1,35) today
from dual;
column name noprint new_value dbname
Has any one messed with
optimizer_index_cost_adj
on 8.1.7 ??
The default is 100, but my boss thinks 10 is a better value for Cost based Opmtzr..
doesn't make any sense to me.. why would reducing the cost of using an
optimizer make it more CBO or go faster.. what if its a large table?
Dear lister,
We are going to build 2 new production databases. Does the NLS_LANG
statement go in the create script or in the init.ora?
Thanks in advance,
Ruth B. Gramolini
ORACLE DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]
--
Please see the official
We have a purchased application with over 1,300 indexes.
Can someone suggest a method to monitor the system to
determine which indexes are actively being used over time? I'm assuming
that some are old/not necessary and would like to save the overhead
of maintaining them.
Oracle 8.0.6
Title: METABLINK on the Fritz?
Am I the only one having trouble roundabout 4pm EST?
Is there anyway to find out which indexes
are being used and which ones are not
being used for any given table?
Thanks in Advance
Alan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browning, Alan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Title: METABLINK on the Fritz?
u are not alone... i've been trying since
about 3:00 pm est... its crawling..
- Original Message -
From:
Mohan,
Ross
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 30, 2001 4:06
PM
Subject: METABLINK on the
Title: METABLINK on the Fritz?
Nah -
I usually get into some type of trouble roundabout 4pm EST.
David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED]
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 30, 2001 3:06
PMTo:
This parameter tells the optimizer how much weight to give to indexes when evaluating
a query. That's the short answer, it's really more complicated than that. A client I
have uses a value of 4 for this parameter. This was arrived at using the old fashion
method of changing the value and
Larry,
Yes, "alter system set job_queue_processes x". Regrettably there is no
such command for job_queue_interval.
Dick Goulet
Reply Separator
Author: Larry Taylor [EMAIL PROTECTED]
Date: 1/30/2001 1:25 PM
Hi folks,
Is there a way to set
On Tuesday 30 January 2001 23:47, [EMAIL PROTECTED] wrote:
run a query using explain plan
... and use sql trace
oli
-Original Message-
Alan
Sent: Tuesday, January 30, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Is there anyway to find out which indexes
are being
Hi
Sanjay,
The remarks section of
PLUSTRCE.SQL, under NOTES,
says:
...
This file must be run while logged-in as SYS.
I
tested this and got the same errors, when I executed PLUSTRCE.SQL and granted
the plustrace role as system.
It
worked fine when I did both again as sys.
I
hopes
sounds like LD_LIBRARY_PATH is not set, set it to $ORACLE_HOME/lib and
export it.
joe
Roy Ferguson wrote:
would anyone have an idea as to what would cause and how to fix the following
error message?:
ld.so.1: sqlplus: fatal: libclntsh.so.1.0: open failed: no such file or
directory
I
Hello,
I need help in writing a unix script to monitor the archive log file for archiving the
redologs.
The script needs to do the following:-
1. Read the parameter, log_archive_dest in the init.ora file
2. After it has the file name, need to know whether more data can written into the file
15 matches
Mail list logo