accounts.
I can't recall if the default value is true or false, but
try setting it explicitly.
Jared
On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote:
Hi All,
The client machine is an NT machine and it belongs to a domain GALAXY
Oracle Db server is on Solaris.
client sqlnet.ora has
it explicitly.
Jared
On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote:
Hi All,
The client machine is an NT machine and it belongs to a domain GALAXY
Oracle Db server is on Solaris.
client sqlnet.ora has the following setting:
NAMES.DIRECTORY_PATH= (TNSNAMES
Hi All,
The client machine is an NT machine and it belongs to a domain GALAXY
Oracle Db server is on Solaris.
client sqlnet.ora has the following setting:
NAMES.DIRECTORY_PATH= (TNSNAMES)
LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log
USE_DEDICATED_SERVER=ON
Hi All,
I need some basic understanding of heap structure and its operation.
Can anybody give me some useful links in this respect?
Thank You
Regards,
B S Pradhan
sorry, the second query uses equality operator..
WHERE UPPER(col1) = 'xyz';
index hint is not helping.
regards,
B S Pradhan
--
On Thu, 08 Jan 2004 zions swordfish wrote :
hi, pradhan,
I don't see any kind of differences with your two queries, but
I suggest you to use
Hi All,
I have the query like:
SELECT *
FROM tab1
WHERE UPPER(col1) 'abc';
Obviously, the function based index i have is not hetting used because of the
ineqality.
When using
SELECT *
FROM tab1
WHERE UPPER(col1) 'abc';
index is getting used.
How can I possibly use index in the 1st case.
Hi All
Happy New Year
In my plsql program i am connecting to two remote DBs and using db_links
sequentially.
Sometimes if the first remote db is not available or there is some network problem
then it stays there for quite some time and then throws an error (which is captured in
exception
, an additional index
access
would decrease the query performance.
Daniel Fink
bhabani s pradhan wrote:
Hi All,
Merry Christmas to all
I have this interesting problem..
For this query index ind1 on (c1,c2) columns is getting
Hi,
Nice example and it should behave similarly in my case also. I have to research more..
Regards,
B S Pradhan
---
On Wed, 24 Dec 2003 zhu chao wrote :
Hi,
It cound be possible that without Hint, oracle will choose FTS for second SQL,
because with col3 clause, if using
will retrieve the ta.c1 column values
at the same
time, there is no need to use an index. In fact, an additional index
access
would decrease the query performance.
Daniel Fink
bhabani s pradhan wrote:
Hi All,
Merry Christmas to all
Hi All,
Merry Christmas to all.
I have this interesting problem..
For this query index ind1 on (c1,c2) columns is getting used.
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1';
(gives index ind1 range scan)
But for
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1'
AND ta.c3 = 'val2';
(gives FTS)
index
Hi All
What is the location for InstallActions.log ?
Thanks and Regards
B S Pradhan
Yes
Thanks a lot
regards
b s pradhan
On Sat, 13 Dec 2003 David Hau wrote :
The method you need is: OracleDatabaseMetaData.getDriverVersion()
Write a small Java program to call this method, or take a look at Metalink note
94091.1 or 73629.1 for sample code to get JDBC driver version.
Hi All
How can I findout what is the version of the jdbc driver installed with oracle client
install.
Thanks and Regards
B S Pradhan
Yes. It worked..
Thanks a lot
regards
b s pradhan
---
On Wed, 03 Dec 2003 Tanel Poder wrote :
Try archive log stop; and archive log start; after setting the parameters..
Tanel.
Hi All,
When I set log_archive_dest_2 to a valid local destination
Dynamically on
Hi All,
When I set log_archive_dest_2 to a valid local destination Dynamically on 8.1.7.0 it
is not generating the archive files..
It is generating the archive files on on log_archive_dest_1
I even tried with the following settings ..
1] both log_archive_dest_1 and log_archive_dest_2 made
Hi All
I have a few basic questions:
1] How Oracle knows that media recovery is needed
during STARTUP ? Is it based on mismatch of SCN or
ckpt# or anything else ? I understand, if the datafile
is missing then in Mount stage it throws error. Is
there any other situation where it throws media
Thanks for the information. The thumb rule and all will definitely help me in
modelling.
Thanks a Lot
Best Regards
B S Pradhan
On Wed, 22 Oct 2003 Michael Milligan wrote :
Hi Again,
What I do when a model is going to change is try to make it
when the table is
1] frequently accessed
2] relatively small
Regards
B S Pradhan
On Tue, 21 Oct 2003 Gunnar Berglund wrote :
Hi all,
when you would consider to put a table a cache...
rgds
gb
Want to chat instantly
Hi All
I have not done data modelling as a major task so far. Would like to know from where
can I make a good start. I have basic(conceptual) knowledge of ER-Diagram and
Normalization. But if anybody can give me some case studies/links etc.,
I see the responsibilities would include modelling
Hey Michael
I enjoyed your write-up.. especially a few db guys telling 'its relational because
they are related'... I have also heard about it and the fact is that SQL the language
for all the RDBMA is based on relational algebra and relational calcus and there in
maths a rwo-column structure
Thank you all for all the help/suggestion/links and information about data modelling.
Regards
B S Pradhan
---
On Tue, 21 Oct 2003 [EMAIL PROTECTED] wrote :
ive been told 'data modelling for mere mortals' is a good place to start.
From: bhabani s pradhan [EMAIL PROTECTED
Hi
consistent gets are when the SQL needs the data in consistent mode i.e not the current
data. SELECT statements contribute to consistent gets (read from the RBS). DML
normally contribute to db block gets, but say an UPDATE based on a search criterion --
will contribute to consistent gets.
Try this:
A shell script calling sql env to ANALYZE certain table. kill the process running the
shell script before it is done. You might get ora-00600 with argumrnt[1113]
Thanks
Pradhan
On Wed, 08 Oct 2003 Sinardy Xing wrote :
ora-600 may result your db
see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
and Regards
___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET
:[EMAIL PROTECTED]
On
Behalf Of bhabani s pradhan
Sent: Friday, September 12, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Bus Error (Urgent)
Hi All
I am able to connect to my database from a set of different
clients from different machines.
From one particular
process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space
Regards
--
On Sat, 13 Sep 2003 bhabani s pradhan
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list
to start the listener.
FYI, the
process was picld, an O/S process that is known to have a memory
leak.
Hope that helps...
Alan
Alan Aschenbrenner
Oracle DBA
IHS Group
[EMAIL PROTECTED]
bhabani s
pradhan To:
Multiple
. The
investigation should continue on the server.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 5:46 PM
To: Mladen Gogala
Subject: Re: RE: RE: RE: Bus Error (Urgent)
its a 2gig memory
.
Find interesting matches on Rediff Matchmaker !
Visit http://matchmaker.rediff.com?1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services
ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services
accessing the
database. Basic rule-of-thumb, the more concurrent users the
larger the
stripe size.
bhabani s
pradhan To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
bhabaniindiacc
happening ringtones here!
OR SMS: Top tone to 7333
Click here now:
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
!
OR SMS: Top tone to 7333
Click here now:
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
40 matches
Mail list logo