Hi,
I have a problem to set a JDBC connection as READ UNCOMMITED.
setTransactionI solation(Connec tion.TRANSACTIO N_READ_UNCOMMIT TED)
This is causing lots of blocking on tables
and update or insert doesn't work properly.
Does anyone have any idea what I'm missing here?
I asked i-net support and they suggested to call
setAutoCommit(f alse) after the above function
and it didn't work.
also suggested impltrans = true, and I changed that option on SQL
and it caused more blocking.
Thanks in advance for any info.
Jul 20 '05
24  4693 
Dave Hau wrote: Daniel, I think what rk is talking about is whether Oracle ever allows you
to read a block without *checking* its SCN, not just reading the SCN. Of
course, you're right - when you read a block, you read the SCN as well. But
he's talking about the extra step of checking the SCN against the SCN at the
beginning of the statement execution (for statement level read consistency)
or the SCN at the beginning of the transaction (for transaction level read
consistency) to determine if you need to roll back the block.
Regards,
Dave
The SCN is only checked in transactions where the data could have been
modified between the initiation of the transaction and when the cursor
gets to the rows. One example of the SCN being ignored is in read-only
tablespaces. Another would be when rows are intentionally locked with
SELECT FOR UPDATE.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)
"Daniel Morgan" <da******@x.was hington.edu> wrote The SCN is only checked in transactions where the data could have been
modified between the initiation of the transaction and when the cursor
gets to the rows. One example of the SCN being ignored is in read-only
tablespaces.
Do datas get moved to read-only tablespaces magically. If I have a workflow
table where rows only get inserted/updated for a short period of time,
and then remain static, it makes sense to use READ UNCOMMITTED when running
reports for anything other than the current activities.
I don't know how easy it is in oracle to move yesterday's data in a read-only
tablespace.
This is an impossible question to answer. Because you can not ever read
a block (in SQL Server verbiage page) without reading the SCN as it is
stored in the block.
What about comparing the SCN in data block with the SCN when the query
was initiated. As I see, unless it is a read only tablespace or SELECT
FOR UPDATE, it always does this SCN comparison. It is this SCN comparison
which I think is totally unnecessary when dealing with static data
as in the above example I gave.
rk-
rkusenet wrote: "Daniel Morgan" <da******@x.was hington.edu> wrote
The SCN is only checked in transactions where the data could have been
modified between the initiation of the transaction and when the cursor
gets to the rows. One example of the SCN being ignored is in read-only
tablespaces .
Do datas get moved to read-only tablespaces magically.
Can you ask a question without being belitteling, demeaning and/or
insulting? I'm serious: Because the answer to this questions is
blazingly obvious.
My contributions are an attempt to educate not some testosterone laden
internet contest. I invite you to reask your question with more
appropriate verbiage if you actually want an answer.
If not ... you win, I lose, you're the man.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)
"Daniel Morgan" <da******@x.was hington.edu> wrote Can you ask a question without being belitteling, demeaning and/or
insulting? I'm serious: Because the answer to this questions is
blazingly obvious.
My contributions are an attempt to educate not some testosterone laden
internet contest. I invite you to reask your question with more
appropriate verbiage if you actually want an answer.
I admit that the tone of my post was derisive and it was intentional.
Bcos I find you highly opinionated and the way u insult non oracle
products is offending. Be prepared to get offended if u offend others.
You find faults with all products and jump in to defend Oracle the moment
it is attacked, making ur bias too obvious. For e.g. you mentioned recently
that SQL Server is so bad that even a non tuned Oracle/Informix/DB2 can give
performance upto 9x times. Bah. I agree that SQLServer is not yet in the
class of Informix, but to say that it is way behind them is plain stupid.
Do u think some of the heavily used sites like BarnesAndNoble, Dell,Expedia
are stupid to use SQLServer. or Verizon Communications, Lucent etc.
check this: http://www.wintercorp.com/vldb/2003_...TenWinners.asp
You can disregard my question re: oracle read-only tablespace. At this time I
have no desire to learn about Oracle.
I sincerely offer my apology if I offended you and I hope that you will
also change your attitude towards non oracle products.
cheers.
rk-
rkusenet wrote: "Daniel Morgan" <da******@x.was hington.edu> wrote
Can you ask a question without being belitteling, demeaning and/or
insulting? I'm serious: Because the answer to this questions is
blazingly obvious.
My contributions are an attempt to educate not some testosterone laden
internet contest. I invite you to reask your question with more
appropriate verbiage if you actually want an answer.
I admit that the tone of my post was derisive and it was intentional.
Bcos I find you highly opinionated and the way u insult non oracle
products is offending. Be prepared to get offended if u offend others.
You find faults with all products and jump in to defend Oracle the moment
it is attacked, making ur bias too obvious. For e.g. you mentioned recently
that SQL Server is so bad that even a non tuned Oracle/Informix/DB2 can give
performance upto 9x times. Bah. I agree that SQLServer is not yet in the
class of Informix, but to say that it is way behind them is plain stupid.
Do u think some of the heavily used sites like BarnesAndNoble, Dell,Expedia
are stupid to use SQLServer. or Verizon Communications, Lucent etc.
check this: http://www.wintercorp.com/vldb/2003_...TenWinners.asp
You can disregard my question re: oracle read-only tablespace. At this time I
have no desire to learn about Oracle.
I sincerely offer my apology if I offended you and I hope that you will
also change your attitude towards non oracle products.
cheers.
rk-
I'm not in marketing and make no more money from Oracle than I do
from other RDBMS products. That I teach one at the U says more about
what the students want than anything else. And I have repeatedly pointed
out that different RDBMS products are different. I don't rush to defend
or attack any of them because I have no vested interest in any one of them.
If you insist on putting a value judgement on differences ... good
vs evil, white hat vs black hat, cowboys vs indians, that is your value
judgement ... not mine. And I'm not at all offended. I just don't choose
to play games that consist primarily of seeing who can have the most
testosterone shooting from their eyeballs.
As an educator I am surprised you have no interest in learning Oracle. I
make it a point to keep up my skills in SQL Server, DB2, and Informix.
Used to also keep current in Sybase and Teradata. Much of my consulting
work comes from helping people that don't know multiple products perform
migrations or make a product work in heterogenous environments. Guess I
should thank you for keeping my vacation plans on-track.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ollivier Robert |
last post by:
Hello,
I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9
system. The link succeeds but everytime I try to run php, I get a SEGV from
inside the libcnltsh.so library.
354 roberto@ausone:Build/php-4.3.2> ldd /opt/php4/bin/php
libsablot.so.0 => /usr/local/lib/libsablot.so.0
libstdc++.so.5 => /usr/local/lib/libstdc++.so.5
libm.so.1 => /usr/lib/libm.so.1
|
by: Richard Galli |
last post by:
I want viewers to compare state laws on a single subject.
Imagine a three-column table with a drop-down box on the top. A viewer
selects a state from the list, and that state's text fills the column below.
The viewer can select states from the drop down lists above the other two
columns as well. If the viewer selects only one, only one column fills. If
the viewer selects two states, two columns fill. Etc.
I could, if appropriate, have...
|
by: FreeStyle |
last post by:
Hi everybody,
I'm using phpMyAdmin 2.2.6 with EasyPHP v.1.6.0.0
I wrote a php script which uses a username (added in the mysql base with
phpMyAdmin).
This user has no privileges.
But in the script, I have the following request for the same username :
INSERT TO table (...) VALUES (....)
And it's working !!! The user can insert new rows with the php script to
the database and
he has no privileges. How it can be possible ?
|
by: Madhusudan Singh |
last post by:
Hi
I wonder if there is a clean way of using https with header() in PHP ? I am
using statements like header("Location: script.php?arg1=argvalue") to
transfer control in my application.
Thanks,
MS
|
by: lnxsimon |
last post by:
Hi,
i have a problem with a form. In my page there is the following code:
--------------------------------------------------------------------------------
<script language="javascript">
<!--
function Modulo() {
// Variabili associate ai campi del modulo
| | |
by: Andrew Crowe |
last post by:
Hi guys,
I've come across a rather strange, and very anoying problem.
On /some/ PHP sites that we're developing on 2 different servers, files that
are in the root of the website are unable to load files using relative paths
(they need to be given the full
"C:\Inetpub\wwwroot\website\www\folder\file.txt" rather then
"folder/file.txt"). However includes with relative paths still seem to work.
|
by: Curious Expatriate |
last post by:
Hi-
I'm completely stumped. I'm trying to write some code that will parse
a file and rewrite it with all URLs replaced by something else.
For example: if the file looks like this:
<b>click here</b><a href="http://www.cnn.com">click me</a>
... then the output should be this:
|
by: eric |
last post by:
Greetings!
I've installed Apache 2.0.xx and PHP 4.3.2. I want to use Ming as a module
to PHP. The instructions that came with Ming say to:
as a php module (unix)
download php_ming.so.gz
uncompress it and copy it to your php modules directory
(you can find your php module directory by running php-config
--extension-dir)
|
by: Susanne Klemm |
last post by:
Hello!
I am working with the XML-DOM-Extension. I want to change the content of a
variable in a XSL-Document. The following testscript works well.
$dom = domxml_open_file(getcwd()."/einzelnes_item.xsl")
$elements = $dom->get_elements_by_tagname("table")
echo count($elements)." Elements<br/>";
for ($i=0;$i<count($elements);$i++)
|
by: zelnaga |
last post by:
i'm connecting to the internet via a proxy, and am having problems
filling out forms... below is the code i have, and below that is the
http request i am trying to make it look like. they look the same to
me, but it isn't working, so i guess they aren't...
$proxy = fsockopen("tcp://someaddresshere", 80, $errno,
$errstr);
$temp = "somethingelse=blablabla";
fputs($proxy,"GET somesite HTTP/1.0\r\n");
fputs($proxy,"Accept: */*\r\n");
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
