Naveen,
The
column does have nulls and this was the problem. Thanks for the insight.
Thanks
Siddharth Haldankar
Zensar
Technologies Ltd.
Cisco
Systems Inc.
(Offshore
Development Center)
#
: 091 020 4128394
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original
What about books with basic development perspective?
Not sure what you mean by that.
Do you mean development with Perl?
Or just development in general?
If development in general, you can't go wrong with
'Code Complete' by Steve McConnell, Microsoft Press.
This is the best programming book
Syed,
Oracle accesses blocks in one of two modes, current or consistent.
A 'db block get' is a current mode get. That is, it's the most up-to-date
copy of the data in that block, as it is right now, or currently. There
can only be one current copy of a block in the buffer cache at any time.
Db
Can anyone tell me whats wrong
with the explain plan below this update is running for quite long time.
Even without a single full-table access
Thank you in advance!
UPDATE STATEMENT Optimizer=CHOOSE (Cost=83
Card=4893 Bytes=327831)
UPDATE OF CCM_DEBIT_TBL
SEQUENCE OF
Mark I know you from the metalink.
Thank you for your detailed explanation.
Syed
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 11:24 AM
Syed,
Oracle accesses blocks in one of two modes, current or consistent.
A 'db
Hi All
What is the location for InstallActions.log ?
Thanks and Regards
B S Pradhan
Venu,
Do your 10046 tracing and run it through tkprof of the Hotsos Profiler and you'll know
exactly why your query is taking so long.
Regards,
Gudmundur
Can anyone tell me whats wrong
with the explain plan below#8230; this update is running for quite long time#8230;.
Even without a single
Ian,
I think retention policy is new in 9i.
I purge my repository of backups that are older than 90 days (because our
tape systems rotates and reuses tapes after that time) using the change
backuppiece 330783 delete; command. I run a sql script againts the rman
repository looking for pieces
We have a new manager that wants his group to use OEM for development
access, as an alternative to Toad. He has requested a special Oracle userid
with the following grants:
SELECT_CATALOG_ROLE
SELECT ANY DICTIONARY
SELECT ANY TABLE
Does this seem reasonable for OEM? The manager is
Mladen,
The equivalent of nsswitch.conf on Win2K is the hosts file in
winnt\system32\drivers\etc. You'd probably say: the /etc directory in M$
Windoze? Somewhat of a resemblance to the UNIX naming convention. You'd
be surprise to find a services file just like the one found in /etc
directory of
Jared,
I don't yet have a service to
monitor the service that moniters the service monitor.
Is this a tongue twister of some sort? ;-)
I totally understand where you are coming
from. Windoze seems to always have difficulty bringing and keeping services up.
I presented this as a
Dennis,
select any table has to be a big no no ... anyone can select from sys.link$. But I
am still trying how OEM can be used for _development_?? what am I missing? As for
One of our groups hired a new consultant and he (claimed to have DBA background)
immediately shot off an email saying he
Folks -
Some months ago there were exchanges on the optimum way to check that an
instance was alive.
I have searched, hunted and generally scavenged for these exchanges, but
without luck.
Can anyone give me the subject line, and I can turn again to the archive?
thanks,
peter
edinburgh
Thomas,
You are right it's new in 9i
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Sent: Thursday, December 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Ian,
I think retention policy is new in 9i.
I purge my repository of backups that are older
Title: DB link to standby
On standby database server, you can connect to / as sysdba and query
fixed tables/views. Is it possible to create a database link which connects
to sysdba user to query the fixed tables/view?
I tried, but getting following error
ORA-02068: following severe error from
Actually, because relational database conform to the rules of set theory,
I find it preferable to use MINUS wherever possible. Oracle optimizer
is trained to spot set operations and they usually generate sort/merge
or hash based execution plan, while NOT IN and NOT EXIST can generate
NL plan,
Wouldn't this allow viewing DBA_USERS?
I haven't tried this myself, but it seems that I could set up another oracle
instance, create a user identified by values, then create database link.
-Original Message-
We have a new manager that wants his group to use OEM for development
The question is where do you want to go today?
Actually, the question is, Where do you want to go tomorrow?
Consult the crystal ball when it comes to career planning. Fixing VCR's
may match one's skill set but such service won't be needed much when
robots can stamp out new R/W DVD's for $10 a
Hi Peter,
I remember the thread, but couldn't remember the subject line at all..
Having had this discussion countless times in the past, here's what I would
opt for:
The best way to make sure that an instance is alive and running would be to
do a full connection to that instance, and run a
We do a heartbeat at fixed intervals ... a heartbeat consists of
1. logging in
2. inserting sysdate into a table.
3. sleeping for 3 seconds.
4. performing current_sysdate-sysdate_from_table
5. rollback
6. exit with output from step 4.
If the output from step 4 is excessive ( 5 or 6 seconds),
btw, a straight not in without a hash_aj, tends to get hideous bench marks.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/12/18 Thu AM 09:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any known problems using NOT IN ?
Actually, because relational
uhh... thats not exactly true. oracle is a bastardization of set theory.
there are alot of cases where 'not exists' and 'not in'(if doing a hash anti-join' are
much superior to minus.
here are some generalizations.
1. not in with a hash_aj is the best if
-- your sub-query is significantly
Raj - Thanks for your reply. Were this a consultant, my reply would mirror
yours, and maybe not so diplomatically.
But basically I manage these databases on behalf of this manager, so when
he asks for read-only access, I can't really refuse. And I think he is
pretty competent as a DBA. He says
DB link to standbyFirst, I don't understandby why connect to a not open standby.
Second, maybe this also works for you, like:
[EMAIL PROTECTED] oracle]$ sqlplus internal/[EMAIL PROTECTED] @test.sql
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 18 23:59:20 2003
(c) Copyright 2000 Oracle
I am trying through php to do select username from v$session
I keep getting Parse error: parse error, unexpected $end in c:\program
files\apache group\Apache2\htdocs\actusers.php on line 23
Can anybody help so i can escape the $ char please as this is driving me
mental
Cheers
Dennis,
I think you are probably ok with this. But the best way to do this is to
create an Oracle account, grant what he asks, and start OEM using that
account. Try and change things and see what happens. Then you will know
for sure what the impact is.
Good Luck!
Tom Mercadante
Oracle
Did you connect to the target database first? I know this is a simple thing
but sometimes we forget.
Regards,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
MacGregor, Ian A.
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple
Make a sure your other db you want to link is not going down:(
- Original Message -
DATE: Thu, 18 Dec 2003 05:59:33
From: Ashish Sahasrabudhe [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Cc:
On standby database server, you can connect to "/
--_=_NextPart_001_01C3C583.D0824CB6
Content-Type: text/plain
hey everyone ...
The developers are loading blobs over database links. One of the 24 subsets
of data is failing with the following error:
ORA-1652: unable to extend temp segment by 512 in tablespace SYSTEM
The subset that
On Wed, 17 Dec 2003, Viktor wrote:
Let's take this topic into a more concrete scenario. New boss, company
reorg, cross-training is enforced and now DBA'S's are going to be split
into development groups. Need to learn Perl(looking forward to it
actually!!!) and Java. Books, web sites, docs -
This was true even for 6i after about patchset 6, IIRC. Many notes on metalink
concerning this.
In a nutshell..
1. install VNC
2. start a vnc server at a specific screen address, such as 11
3. add a export DISPLAY=host:11 to the .profile of the reports server.
4. go have a beer.
Ron Thomas
Are you sure they are not loading blobs into SYSTEM tablespace?
Guang
-Original Message-
Sands, Robyn
Sent: Thursday, December 18, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
This message is in MIME format. Since your mail reader does not understand
this format, some or all
I would say OEM for dbas only. To difficult to manage for developers.
Dangerous. Too much low level stuff for managers and developers to poke
around with.
OEM is not really a development tool.
2 cents
-Original Message-
Sent: Thursday, December 18, 2003 8:24 AM
To: Multiple
Mark,
That is perhaps the most concise and easy to understand
explanation of current mode vs. consistent mode that I have
yet seen.
Thanks for posting it.
Jared
Bobak, Mark [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/17/2003 11:24 PM
Please respond to ORACLE-L
To:
The universally accepted escape character is \.
Have you tried that?
Craig Richards [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/18/2003 08:14 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT PHP and
Thanks. I was having a bout of insomnia last night, so I'm just
glad it came out sounding coherent! ;-)
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003
12:54 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: db block
Mark, Raj -
Thank you both for coming back on that request of mine so promptly - I feel
that I have a surfeit of riches!
peter
edinburgh
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
--_=_NextPart_001_01C3C594.461C3ED6
Content-Type: text/plain
No, they weren't loading into the SYSTEM tablespace. Turned out that the
AQUSER account had SYSTEM as a temp space in one of the two instances.
Didn't think to check AQUSER when I checked the settings for the users
running the
Hi Group,
Can any body explain that on Windows/UNIX what is
the size of the block that is read at 1 time and how can we alighn or size
oracle db_block_size such that it gives optimal performance ?
Regards,
Akshay
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
Saira
I think you have to decide what your goal is. Then you need to
decide how to best accomplish that goal. One tool that can lead you
toward a goal is self-study. I have used that tool many times myself.
However, with
your goals should tie into the job market. you might absolutely love Pascal
programming, but I dont recommend studying it.
Right now(and I dont know how it will fluctuate), there is far, far, far more demand
for Software Engineers who specialize in Java or .Net. Far, far, far, more than people
Hello:
I'm trying to figure out the new 9i outer joins.
I can get a single table outer join working without any issues. But seem to
keep getting errors when trying to do a two table outer join. I know it is
just something with my syntax. Could anyone provide a quick sample, thanks
in
select a.emp,
b.ValueA
c.ValueB
From base_table A
RIGHT OUTER JOIN child_Table1 B ON b.emp = a.emp
RIGHT OUTER JOIN child_Table2 C ON c.emp = a.emp
-Original Message-
Sent: Thursday, December 18, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Thanks, for the example script. I had already reached the conclusion that change
backuppiece ... was needed, but
hadn't yet figured how to query for the proper pieces.
Ian MacGregor
Stanford linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 18,
Ryan - Excellent points. I well know the feeling of being tied to Oracle's
future. As to Oracle pricing itself out of the market, I would like to make
three points:
- Pricing is one of the quickest things a vendor can change once it
becomes convinced this is hurting it. On the other hand, I've
Its like:
$p_param=
SELECT * FROM v\$parameter order by name;
--
Joe Frohne
Rawson Oaks Consulting, Remote Oracle Admins
http://www.rawsonoaks.com
[EMAIL PROTECTED] or [EMAIL PROTECTED]
Oak Creek, WI, USA
I am trying through php to do select username from v$session
I keep getting Parse
my biggest concern is the model for development has been changed. The model now is do
most development with software engineers and have only a small number of database
people. this means less pure oracle jobs.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/18 Thu PM 02:59:26 EST
To:
Hi,
I newly setup master to master replication : I followed the steps. It is 9i so no need to run catrep:
1) Create replication administrator repadmin
2) Grant privileges and register repadminas propagator and receiver
3) Create public database links, private database link in repadmin.
4)
Take a look at the results below. Look especially at the
error message. I had to laugh when I read that. Hey, Oracle
is telling me it got what it expected, so what's the
problem, right? grin
Bonus points if you can tell me why the query failed.
SQL SELECT FROM_TZ(SYSTIMESTAMP,'-5:00') FROM dual;
Ryan --
I agree with a lot of what you said, but there are points that I really must
disagree on. Firstly, you should *always* study what you love, but know
that there are varying degrees of applicability to your chosen field, and
certain areas will always be more lucrative than others.
Anybody having problems with Oracle DB hanging up on AIX 5L using JSF2?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jerome Roa
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Could the problem be a difference of type? TIMESTAMP vs. TIMESTAMP WITH
TIME ZONE
The SYSTIMESTAMP function has the return type of TIMESTAMP WITH TIME ZONE.
The FROM_TZ function says that it converts a TIMESTAMP to a TIMESTAMP WITH
TIME ZONE.
Given that I don't use timestamps much, this is only
Raj, Thomas, Brad, Bill, anyone I forgot - I feel better about the situation
now. Thanks for letting me run this issue past you.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 18, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L
Thursday, December 18, 2003, 4:04:32 PM, Clark, Tommy R ([EMAIL PROTECTED]) wrote:
CTR Could the problem be a difference of type? TIMESTAMP vs. TIMESTAMP WITH
CTR TIME ZONE
Bingo! Tommy, you get the prize, only there is no prize,
except perhaps for that warm-fuzzy feeling you get when you
solve a
I agree with Ryan. Pure Oracle jobs aren't hot as they used to be. We are going throughthisright now.Theyare planning to bring in a bunch of new developers and splitting a few DBA's into dev. groups, which means we'll become more likesoftware engineers (who can also do DBA stuff). There will be
I agree with Ryan. Pure Oracle jobs aren't hot as they used to be. We are going throughthisright now.Theyare planning to bring in a bunch of new developers and splitting a few DBA's into dev. groups, which means we'll become more likesoftware engineers (who can also do DBA stuff). There will be
BTW, NOT IN and NOT EXIST are not synonyms like IN and EXISTS. It
will give different results is most scenarios.
Asktom site has great examples.
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
btw, a straight not
do you have temporary tablespace set for that user?
-Original Message-
Guang Mei
Sent: Thursday, December 18, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Are you sure they are not loading blobs into SYSTEM tablespace?
Guang
-Original Message-
Sands, Robyn
Sent:
without knowing the requirement,index,statistics it is very hard to
tell.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Venu GopalSent:
Thursday, December 18, 2003 5:29 AMTo: Multiple recipients of list
ORACLE-LSubject: SQL tuning...
59 matches
Mail list logo