this right now and the SYSDATE+1
parameter says, Then run this again at this same time tomorrow.
Jon Walthour
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, August 27, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I schedule a pl/sql job, I want this to happen
Utilities
manual says that a full export exports the entire database. So, I'm almost certain
that includes SYS.
Jon Walthour
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
a.userid=b.superid
group by a.userid, a.superid) y
where x.userid = y.userid(+)
order by 1, 2;
Jon Walthour
From: Seema Singh [EMAIL PROTECTED]
Date: 2001/08/22 Wed AM 09:00:28 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: sql query
Hi
One table has
Raja:
You will know you have freelist contention if you have a significant
buffer busy waits ratio (5%).
Jon Walthour
-Original Message-
Luthra
Sent: Monday, August 20, 2001 11:45 PM
To: Multiple recipients of list ORACLE-L
Hello folks,
How do I come to know
Check out the Oracle 8i Administrator's Guide, look at the chapter entitled: Using
LogMiner to Analyze Online and Archived Redo Logs.
Jon Walthour
From: Aldi Barco [EMAIL PROTECTED]
Date: 2001/08/21 Tue AM 11:41:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject
No. Just because you have a high bbw ratio, that doesn't indicate strictly a freelist
problem. However, having problems with freelists often results in a high bbw ratio.
Jon Walthour
From: Johnson Poovathummoottil [EMAIL PROTECTED]
Date: 2001/08/21 Tue AM 11:21:02 EDT
To: Multiple
in the where clause, the IN says any teachers that are in any of these subjects.
Since there are two subjects in the IN set and at least 2 teachers have to teach each
subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise.
Jon Walthour
From: [EMAIL PROTECTED]
Date: 2001/08
Create another user with select privileges only on the objects in the app's schema.
Give that one to them and then change the password on the original app id so they
won't be able to use that one anymore.
Jon Walthour
From: Larry Hahn [EMAIL PROTECTED]
Date: 2001/08/21 Tue AM 11:21:04 EDT
it in
an .ini file that the app decrypted and used to log into the database.
That way, the users couldn't use the ODBC connection with that userid
outside of the app. That may not be an option for you here, but that's
about all I can think of as an alternative.
Jon Walthour
-Original Message-
Sent
Simple. Put them in a batch file:
@echo off
set env1 = One
set env2 = Two
set oracle_sid = mydb
...
Then reference like normal
C:\ echo %oracle_sid%
mydb
Jon Walthour
From: [EMAIL PROTECTED]
Date: 2001/08/20 Mon PM 02:36:36 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
Rich:
Please let me know if the problem goes away for you with any of the patches or if the
only real fix is to go to 9i.
Jon Walthour
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2001/08/20 Mon PM 01:32:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: WARNING
you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
. I use an 8.1.7 client to connect to db's version 7.1.6 and up all
the time. No problem. You just can't go the other way and expect to do
anything and everything (i.e., if you use a 7.x client to connect to an
8i database, don't expect to be able to work with LOBs).
Jon Walthour
--
Please see
-
COL1
VARCHAR2(30)COL_LOB
LONG
SQL alter table
test_lob modify col_lob clob;alter table test_lob modify col_lob
clob
*ERROR at line 1:ORA-22858: invalid alteration of
datatype
Thanks,
Jon
Walthour
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
the
sorted result set.
For more information on this topic, take a look at Steve Adams' website
http://www.ixora.com.au.
Jon Walthour
-Original Message-
Alex
Sent: Friday, August 17, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
Are you sure enough to post an answer?
Alex Hillman
= 'sort_segment_locks'));
Jon Walthour
-Original Message-
Alex
Sent: Friday, August 17, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
star
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network
. You edit that script to include on the files
you're recovering and use it to bring up the database.
Jon Walthour
From: Kumanan Balasundaram [EMAIL PROTECTED]
Date: 2001/08/17 Fri AM 07:55:29 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Recovering WITHOUT
Uma:
From what I've seen and used myself, SuSE seem to be officially endorsed distro. I've
heard of people installing on RedHat, but I've also heard (especially concerning 9i)
that it is a pain in the a__ to get working--if at all.
Jon Walthour
From: Rao, UmaSankara S (CAP) [EMAIL
to apply archive redo logs of the DB?
If so, that will be great.
Thanks
Kumanan
-Original Message-
From: Jon Walthour [SMTP:[EMAIL PROTECTED]]
Sent: 17 August 2001 14:16
To: Multiple recipients of list ORACLE-L
Subject:Re: Recovering WITHOUT tablespaces
If you can't modify the structure to add a timestamp column or add a
trigger to insert a timestamp into another table, there's no way I know
of to track it. Oracle doesn't track this sort of thing on its own; you
need some sort of timestamp field.
Jon Walthour
-Original Message-
Bronfin
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Delete the directory structure under C:\Program Files\Oracle, as well. That's where
Oracle keeps the inventory information (among other things).
Jon Walthour
From: Christopher Spence [EMAIL PROTECTED]
Date: 2001/08/16 Thu PM 01:28:15 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
:MI:SS') AS
call_time
, -1 AS incr
FROM calls)));
Jon Walthour
From: Lord, David - CS [EMAIL PROTECTED]
Date: 2001/08/15 Wed AM 11:01:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: An SQL
for the log buffer of 4 * db_block_size. This
rounding up is reflected in v$sga, but not in v$sgastat.
Jon
Walthour
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Saurabh SharmaSent:
Tuesday, August 14, 2001 6:46 AMTo: Multiple recipients
. Download the patch for your particular platform.
Simple as that.
Jon Walthour
From: Rukmini Devi [EMAIL PROTECTED]
Date: 2001/08/14 Tue AM 08:11:43 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Downloading patch from metalink
Hi All,
I want to download
Sean:
Use the shorter 8.3 directory name. You can get it with the dir /x command. Then you
could do something like:
t:\oracle\output\system~1\free_space.log
Jon Walthour
From: O'Neill, Sean [EMAIL PROTECTED]
Date: 2001/08/14 Tue AM 10:15:23 EDT
To: Multiple recipients of list ORACLE-L
AND rn.usn = t.xidusn
AND s.sid = m.sid;
HTH,
Jon Walthour
-Original Message-
Shrinivas (MED, Keane)
Sent: Monday, August 13, 2001 4:36 AM
To: Multiple recipients of list ORACLE-L
HI dba's
can anybody tell me
from which tables can i find whether my statement is generating
rollback
Ron:
All I can find on it is that it's an Oracle 8 parameter used to provide
Oracle 7 dictionary accessibility. Not much, I know.
Jon Walthour
-Original Message-
L.
Sent: Monday, August 13, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Does anyone have any experience
periencing bbw's. If anyone knows
of any way, please let me know as I would love to know.
Regards,
Jon Walthour, BSCDCincinnati,
Ohio-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of
chao_pingSent: Saturday, August 11, 2001 9:30 AMTo: Multiple recipient
FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
Srinivas:
How about this:
select sid
, serial#
from sys.v_$session
where (sysdate-logon_time) = (30/(24*60));
This will give you a list of all the sessions that have been connected for 30 minutes
or less.
HTH
Jon Walthour
From: Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED
Uma:
This is a restriction of DBMS_OUTPUT. It can only output a line of up to 255
characters. To fix it, you'll need to break up the output into multiple lines or use
DBMS_OUTPUT.PUT instead of DBMS_OUTPUT.PUT_LINE to concatonate several pieces together
into one line.
HTH!
Jon Walthour
where name = 'physical reads')
, (select to_number(value) as db_block_gets
from sys.v_$sysstat
where name = 'db block gets');
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, August 04, 2001 12:20 PM
of the DEFAULT STORAGE clause of the temporary tablespace in
which you are sorting.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, August 04, 2001 4:55 PM
Hi Friends,
When Iam rebuilding my index and clearing TEMP tablespace
That you have to do on your own by analyzing the tables and indexes after
the import is finished.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 4:37 PM
What about generating statistics?
Mike Hand
)group by asset_num;
Hope this helps.
Jon Walthour
- Original Message -
From:
Helen rwulfjeq
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 01, 2001 5:12
PM
Subject: Your ideas will be helpful
Hello, all:
I'm import data from schema1
will not uninstall
itself. List, please correct me if I'm mistaken here.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 7:41 AM
Andrea asked about removing NT services.
What about Oracle homes? The Oracle Universal
Title: Help, processes won't die
Ivan:
The problem is that there is no way to "wake up"
PMON. PMON is cleaning up and rolling back all uncommitted transactions every 3
minutes and this isn't configurable. If this is 8i, you could have used alter
session ... kill session immediate, although
and would require recovery of the database and transactions
could be lost. I would not recommend a shutdown abort except as a last
resort.
Hope this helps.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 3:06 PM
and
SQL*Loader.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 3:31 PM
Dear DBAs
is there any tool available to import table from SQL 2000 server To
Oracle
8.5 online or by other way.
Mitchell
Raja:
Let me put my two cents into the idea bin. How about:
select decode(sign(num-1),-1,'0' || to_char(num), to_char(num)) as num
from t1;
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 1:10 AM
Hello all
Sinardy:
The SYSTEM tablespace is created with the CREATE DATABASE statement. Its
datafile is the file set out in the DATAFILE portion of the statement.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 28, 2001 12:20 AM
Prasad:
If you have access to MetaLink, see Note 1054736.6 How Do Indexes Become
Index Unusable? If you don't, let me know and I'll copy the article for
you.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 28, 2001 1:45
assistant gets done with all the setup and offers to either create the db
or save off the scripts for running later, save the scripts then edit the
initSID.ora to make sure the MTS_DISPATCHERS parameter isn't there. Then run the
scripts yourself and you shouldn't have that problem.
Jon Walthour
that rbs as well. However, if you're
running it at night, wouldn't your activity level be lower and
thus the odds of getting another transaction in the same rbs
be much lower as well?
Just my 2 cents.
Jon Walthour
--- Original Message ---
From: prasad maganti [EMAIL PROTECTED]
To: Multiple recipients
with any of 'em.
Jon Walthour
--- Original Message ---
From: Larry Elkins [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/27/01 12:41:20 PM
Mark,
Thanks for running the test. I would be interested if anyone
could test on
the latest version of 8.1.7
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Is it possible that under 7.3.2 the optimizer was rule-based (I don't know
when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or
FIRST_ROWS or ALL_ROWS?
Also, is there anyway you could move to 8.1.6 and take advantage of the
CURSOR_SHARING parameter?
Jon Walthour
- Original
Alex:
I run catparr.sql as part of every database creation I do because
it provides views that help with performance tuning, such v$bh
for buffer cache data. The tables the script creates keep track
of the status of all SGA blocks, too.
Jon Walthour
--- Original Message ---
From: Hillman
George:
I think you need to do a fromuser/touser export/import here.
Jon Walthour
--- Original Message ---
From: Rusnak, George A. [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/26/01 1:50:41 PM
Hi Group,
Please explain what I am doing wrong.
1
(+)
AND l.id1 = la.lockid(+)
AND l.type = 'UL';
Thanks, everyone, for your continued help through this forum.
Jon Walthour
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
, but cancelled.
This allows most system resources to be released while still allowing the
cursor to be reused if need be. There is currently no view that ill provide
this information as to how many cursors are really open and in use (i.e.,
open and not cancelled).
Hope this helps.
Jon Walthour
Add the computer in the MMC (Microsoft Management Console) and then you can
control whatever you want (if you're an Administrator).
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 7:05 AM
Hi all,
Has anybody
Andrea:
Open up your .sql file in notepad or the like and put a carriage
return after the last line so you, in effect, have a final blank
line.
Jon Walthour
--- Original Message ---
From: Quaglio Andrea [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/24
this helps.
Jon Walthour
--- Original Message ---
From: Gene Gurevich [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/24/01 11:56:29 AM
Hi all:
I am trying to tune some queries. I ran them all in
one stream (in sequence) and then ran them in several
(up to 64
there to add something, not
to detract from it.
Just my two cents.
Jon Walthour
--- Original Message ---
From: Grabowy, Chris [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/24/01 2:40:24 PM
Hmmm...when the spec is changed because of some business
Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
dbms_utility.analyze_database() and then
dbms_utility.analyze_schema('SYS','DELETE') to remove SYS's stats. What
about one of those?
Jon Walthour
- Original Message
, but
I've seen installation programs mark all their DLL's read-only for
protection.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 4:45 PM
Hi,
I am trying to install patch 8.1.6.3.0 on WIN 2 and i am
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
'
order by table_name;
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 5:25 AM
hi dba's
i need to give select permission to scott user on all
v$ tables.
is there any role for that. or should i grant the
selection
SVRMGRL is more primitive than SQL*Plus and doesn't
have all the formatting capabilities that SQL*Plus does. So, there are no SET
commands in SVRMGRL. Why can't you do the query in SQL*Plus just as
well?
Jon Walthour
- Original Message -
From:
Saurabh
Sharma
), then there's no
way to know other than knowing what parameters are different between the two
init.ora files and querying sys.v_$parameter to check those differences.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 5:20 AM
hi
Listers:
Is it appropriate to be sending one's resume to the mailing list
(especially as an attachment)? I don't think so, but have not
heard much to that effect thus far. So, maybe it is. Can someone
please enlighten me?
Jon Walthour
--- Original Message ---
From: C.S.Venkata Subramanian
John:
To get yesterday's, simply subtract 1 from sysdate ... like this:
select sysdate-1 as yesterday
from dual;
Jon Walthour
--- Original Message ---
From: John Dunn [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/23/01 7:35:53 AM
Anyone know how
Jenny, et. al.
I'm right there with you on this. I don't have a problem with
someone announcing, Hey, I'm looking for a job. Anybody know
of positions in blah-blah? What I don't care for the resume
attachments and would just ask if it could be discontinued in
the future.
Jon Walthour
Try this:
select sum(value) as open_cursors
from sys.v_$sesstat s
, sys.v_$statname n
where s.statistic# = n.statistic#
and n.name = 'opened cursors current';
Jon Walthour
--- Original Message ---
From: Szecsy Tamas [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
for finding the init.ora.
Jon Walthour
--- Original Message ---
From: Rodd Holman [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/23/01 9:20:54 AM
This won't tell you of aditional config files (referenced using
ifile=
in
you init file) but it will tell you
Sounds like you may be on Windows NT? If that's so, is your ID a member of
the ORA_DBA group? If not, add it to the group and reboot the server.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 3:57 PM
I keep
Easy. Log in to sqlplus or svrmgrl and run the following query:
select *
from v$version;
The first line will tell you what version of Oracle you are running.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 22, 2001 12:16
-at-a-time when,
in point of fact, it is much more complex.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 6:30 PM
Jeremiah is right. Depending on the version of the database this is an
imaginary problem.
I have
I think this site should provide you with what you need:
http://www.redhat.com/support/manuals/RHL-6.2-Manual/ref-guide/ch-dualboot.h
tml
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 7:05 AM
Hello listers
.
Sometimes it will also look, as another lister has pointed out, as if Oracle
is always going to the biggest datafile in the tablespace.
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 11:45 AM
What do you mean
Personally, for tuning, I would suggest "Oracle
Performance Tuning Tips and Techniques" by Richard Niemac, et. al. In the DBA
arena, I've never really found a good book that I could wholeheartedly recommend
(sorry, Rachael, I'venot gotten around to readingyour book
yet).
Jo
sys.dba_clusters
WHERE owner = 'SCOTT'
ORDER BY 1
, 2;
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 11:45 AM
hi dba's
how to find out a users all objects+the tablespaces
in which they reside.
i
Prasad:
Have you run an explain plan on the the query on tab2 to see what Oracle is
doing?
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 12:15 PM
Hi dbas
we have a situation here. can anybody tell me
why
Yes, you can make any tablespace a locally-managed tablespace except SYSTEM.
What they're saying, I think, is that you can't set up temporary tablespaces
and shouldn't set up rollback segments with the AUTOALLOCATE allocation
management.
Jon Walthour
- Original Message -
To: Multiple
that if it isn't a
necessary patch, don't apply it in fear of breaking something else. What do
you think?
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 1:26 PM
Hi
Actually, it's called dynamic service registration and you need
both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter
defined in the init.ora. Then, when the instance starts up, it
will register the services it supports with the listener(s).
Jon Walthour
--- Original Message
multiple listener address to register with. For example:
LOCAL_LISTENER = (ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=db01.acme.com)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=db02.acme.com)(PORT=1521))(ADDRESS=(PROTOCOL=TC
P)(HOST=db03.acme.com)(PORT=1521)))
Jon Walthour
- Original Message
Steven:
To log on as INTERNAL in svrmgrl on NT, the user must be a member
of the ORA_DBA group, not the Administrators group. Is the user
in question a member of the ORA_DBA group?
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Steven
your SQLPATH environment variable.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Daemen, Remco [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/17/01 10:06:16 AM
How about trying c:\mypath\mysql.sql ? Note
Eca:
A great place to start would be bstat/estat or stats pack. After that, I'd
pick up Richard Niemac's book on Performance Tuning. Then, I'd round that
off with a look at Steve Adams' website http://www.ixora.com.au when you're
ready for it (it's pretty advanced).
--
Jon Walthour, OCDBA
For clarification, a query to SYS.DBA_DEPENDENCIES works all
the way back to 7.1.6.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
From: Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
Helen:
Try reducing your SHMMAX kernel parameter to under 4GB and see
if that works.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Helen rwulfjeq [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/12/01
it.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Nicholas Tufar [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/12/01 12:01:36 PM
On Thu, 12 Jul 2001, kommareddy sreenivasa wrote:
will a ddl statement
on NT/2000 is from within the
database.
Hope this helps.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Seema Singh [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/12/01 2:40:58 PM
Hi
How to check Oracle
, or (2) increase the amount
of available shared memory by increasing the value of the initialization
parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
Hope this helps.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: John Dunn [EMAIL
Chris:
That's odd because you're not supposed to be able to see this
error message. Why don't you turn on tracing and do what you
were doing again. Then see what the trace file yields in terms
of more information.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
Ron:
If you mean, Can the alert log be renamed for archiving purposes
while the db is up? the answer is yes. Oracle will just recreate
the alert log the next time it needs to write an entry to it.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message
)) || ' minute(s) and ' || TO_CHAR(ROUND(MOD(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60, 1) * 60, 1)) || ' seconds.'
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Sajid Iqbal [EMAIL PROTECTED]
To: Multiple recipients
In short, I don't. I use local resolution (as our ONS is frequently down and
unreliable) and none of my aliases have domain names attached to them. In my
sqlnet.ora, the entries about default domain, etc. are all commented out.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati
for a histogram. Again,
a good candidate is also one that is used in a where clause of
a commonly-used query as a literal predicate.
Hope this helps.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Tom:
It's a wait that indicates that the Parallel Query slave is waiting
for something to do. You can ignore it.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Terrian, Tom [EMAIL PROTECTED] wrote:
After looking at the top waits in my databases, I
see PX Idle
for data in indexed columns
that are used in where clauses as literal predicates where the data is not
evenly distributed in the column. These generally make good candidates for
histograms.
Hope this makes sense.
--
Jon Walthour, OCDBA
Oracle DBA
Cincinnati, Ohio
- Original Message
of right now. See if either of these ideas work for
you.
--
Jon Walthour, OCDBA
Oracle DBA
Cincinnati, Ohio
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 07, 2001 9:40 PM
Hi DBA's:
We just moved some instances from an HP K220
to do it
now IMHO is that, according to Oracle, RULE is going to be desupported in
the near future. CHOOSE will soon be the default.
Anyone with more experience than I here, please chime in.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--
Please see the official ORACLE
can't give you an hard empirical evidence,
just anecdotal evidence that, when properly used, histograms
do seem to have dramatic impacts.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Terrian, Tom [EMAIL PROTECTED]
To: Multiple recipients
Raghu:
After you're done with the rebuild, you should be about to run:
ALTER DATABASE database name
DATAFILE 'filename' OFFLINE DROP;
Then go out to the OS and delete the file.
HTH.
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Raghu
Rick:
No. There is no alter synonym command in SQL (none that I can find or know
of, at least). The way you describe is the only way to do it.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Can't you go to $ORACLE_HOME/dbs and see where the symbolic link is
pointing? ... or am I not grasping the full extent of the question?
--
Jon Walthour
Oracle DBA
Computer Horizons
Cincinnati, Ohio
From: Deshpande, Kirti [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego
1 - 100 of 111 matches
Mail list logo