Hi
Thanx all for reply. Tim my both the database are 8i but different
release
1)Target 8.1.5 on Solaris 8
2)Catalog db 8.1.6 on Win2k
will different O/S and different version be a problem
Pawan
-Original Message-
Sent: Monday, August 19, 2002 11:58 PM
To: Multiple recipients of list
use the concept of single login facility
rgds,
Ams.
-Original Message-
Michael
Sent: Tuesday, August 20, 2002 2:03 AM
To: Multiple recipients of list ORACLE-L
Just got back from vacation and have been
dragged into a working group on a problem
the users find unacceptable on one of
no need to use exit ...the for loop exits automatically...
rgds,
Ams.
-Original Message-
DBA
Sent: Monday, August 19, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L
i have a question how can I apply cursor attribute to non-cursor? what
should I put at ??? in the code.
Thanks
Hi,
While your EMC Standard volumes and BCVs are in synchronized mode (not split), both
Standard and BCV will be updated at the same time. So is better you split instantly
before you end backup your tablespaces. This will ensure your data files in BCV are
backup mode data files before you
Hi,
This problem/solution may be posted earlier, but would like to hear
a solution from you.
I have two table say TAB1 and TAB2. TAB2 is a detail of TAB1 table.
1. TAB1
Pk_key numnber(10)
AMTnumnber(14,2)
... More colums
Adar,
From what I understand and have seen it's not just at 4GB - it's EVERY 4GB.
So for example if your database extends from 3.8GB - 4.2GB it fail just as
it will extending from 7.8GB-8.2GB or 11.8GB - 12.2GB (for example).
It certainly DOESN'T mean that you can't use files larger than 4GB!
SQL*Net ships data (in TCP and BEQ) in packets of
2K (default TDU and SDU size, with a few exceptions on that for some platforms
and protocol adapters). If you selectto the client many large columns or
multiple rows (array fetch), this 2K is filled up quickly and SQL*net will send
the next
Hi All,
I'm using Oracle Apps 11.0.28 Database Version 8.0.5
When I query the Data using Application Forms I can view the data. When I see
the record information it shows me the view name which is in APPS schema.
When I query the view from SQL*PLUS or any other tool, it gives me 'NO ROWS
FOUND'
No, as long as the catalog is the highest version of Oracle. RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 2:34 AM
Hi
Thanx all for reply. Tim my both the database are 8i but different
release
1)Target 8.1.5 on
Any idea how to schedule the execution of a PL/SQL package? and if a certain
condition is acomplished to execute again (later in the night) the same
package until the same condition is not anymore fulfilled?
In PL/SQL not using a script for the operating system for example.
Ciprian MAFTEI
Can you help me?I have a query , where i join a big
partitioned table with 2 smaller tables using hash join and sort group by.I
want to use to read the big partitioned table with parallel-option to get better
performance.But i havn't any performance benefits running with parallel
or without
write a procedure (p1) to check the condition and based upon the condition
call packaged procedure (p.p2) from it.
use dbms_job to schedue the execution of procedure p1.
Atul
-Original Message-
Sent: Tuesday, August 20, 2002 6:03 PM
To: Multiple recipients of list ORACLE-L
Any idea
Hi!
Query
select name, isdefault, value from
v$parameter where name like '%log%'
gave me following
results...
NAME
ISDEFAULT VALUE-- -
---log_archive_dest_1
FALSE
I know how.
Ciprian MAFTEI
Telequote Network
Computer Systems Analyst
Any idea how to schedule the execution of a PL/SQL package? and if a
certain condition is acomplished to execute again (later in the
night) the same package until the same condition is not anymore fulfilled?
In
use PL/SQL table or temporary table
-Original Message-
Sent: Tuesday, August 20, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L
Hi,
This problem/solution may be posted earlier, but would like to hear
a solution from you.
I have two table say TAB1 and TAB2. TAB2 is a
I am not an Apps user but it sounds like that there might be a trigger
that doesn't allow you to see the table data through SQL PLUS to inhibit
the direct editing of tables. This I suppose is to stop editing that might
break referential integrity
Cheers
--
Yes, as long as they are in different Oracle_Homes.
Dick Goulet
Reply Separator
Author: Satish Iyer [EMAIL PROTECTED]
Date: 8/19/2002 1:38 PM
Is it possible to have SqlNet and Net8 installed
on the same client machine ?
The reson behind this is
Title: RE: how to schedule an execution in PL/SQL
hi!
i guess you should just have a look at the DBMS_JOB package!
i would start with reading the documentation of this standard
oracle package.
cheers
-dieter
-Original Message-
From: mac [mailto:[EMAIL PROTECTED]]
Sent:
Hi all,
Does anybody know how Oracle determines what extproc to use when
making an external call through a listener? I've got one working,
which is great, but nowhere in the listener or tnsnames is there
any kind of binding to a particular sid, other than to a HOME,
and the library def and c
VSD is only a clustered representation of LV
(logical volume) within IBM's LVM (logical volume manager). The reason you
can't get answers from IBM is because they wroteVSDs and
HSDsspecifically for Oracle and OPS only, so it is not "mainstream" AIX;
they really aren't familiar with it.
You can get away with the catalog database being a lower version than your
target databases. We run 8.0, 8.1 and 9i target databases but have an 8.1.7
catalog, inside the catalog we have RMAN80, RMAN81 and RMAN901 schemas. All
works fine.
-Original Message-
Sent: 20 August 2002 13:23
To:
Absolutely false. You can always reuse the space if you drop the
tablespace.
Thanks
!!
Rishi
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 19, 2002 8:48
PMTo: Multiple recipients of list ORACLE-LSubject:
Oracle OPS and IBM VSD
Once
Hi Nabba
One question : Is TAB2 empty and TAB1.AMT values are null or 0 before the
creation of the trigger ?
Kamel Benlatreche
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 20 août 2002 08:28
À : Multiple recipients of list ORACLE-L
Objet :
Naveen,
You should check the views that supply this data. They often check the
current context to make sure that the USERID matches the signon details.
That can make it difficult if you're not signed on.
The results you see via Applications forms can be derived from very
complicated joins.
Often
Check out the DBMS_JOB supplied plsql package
hth
connor
--- mac [EMAIL PROTECTED] wrote: Any idea how to
schedule the execution of a PL/SQL
package? and if a certain
condition is acomplished to execute again (later in
the night) the same
package until the same condition is not anymore
Thanks!!
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 7:04
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Oracle OPS and IBM VSD
VSD is only a clustered representation of LV
(logical volume) within IBM's LVM (logical volume
In order to implement Multi-Org, the views filter out rows on the basis of
ORG_ID.
Thus, AP_INVOICES is a view on AP_INVOICES_ALL with the WHERE clause
including a filter on ORG_ID.
Either query the AP_INVOICES_ALL table or use
DBMS_APPLICATION_INFO.SET_CLIENT_INFO
to set your ORG_ID.
You
Mike - I Checked the view query. The where query is quite complex but the
where clause looks pretty innocuous. It doesn't have any condition which
checks for username / application anywhere. Where else can the catch be?
Peter - What kind of trigger you are talking about? I haven't heard of a
Title: RE: Win2000/8.1.7.3.0/SQL
I think you are on to something Jared. We had this happen at a production site last year. For some reason, the site began reporting performance problems after upgrading from 7.3.4 to 8.1.6. I finally tracked it down to the fact that a majority of our tables
Anand:
This is one of four queries in a script I call my
'space_critical'
script. Every night, an automated process scans
all the DBs that
I am responsible for, and sends me an e-mailif
there is a problem,
such as not enough space in a tablespace for a table to
add an
anotherextent.
When
Yep, works ok. Best thing to do is check the compatibility matrix on
Metalink (73431.1).
So long as you have a valid combination of target, catalog db and catalog
schema then everything should be fine.
I think there are (were?) issues in restoring an 8.0.5 database using an 8.1
catalog schema,
I
dontthink any generic SQL query can do it. What you can do is write a
function which takes the SO_TRN_ID as an argument and returns the concatenated
string.
Then
you can use the function to get the string.
SELECT
function_name(SO_TRN_ID) as DESCRIPTION from dual;
HTH
Naveen
Yes you can,
create or replace type mystrtype is table of varchar2(100)
/
select cast(multiset(sod.description) as mystrtype)
from so_trn_detail sod
where ...
/
Just make sure that the type will be able to hold the max description. BTW
this works from 8i onwards ... You will have to parse
Jared:
The query is selecting from DBA_xxx views. The tables under
these views are some of the X$ tables, and tables like user$, ts$,
seg$, etc. I can verify that everything but the X$ tables have
a degree of 1. How can I check those X$ tables...or should I
decide to be content with a
Title: Message
I
think it also counts the recursive SQL statements issued
-Original Message-From: Terrian, Tom
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 9:08
PMTo: Multiple recipients of list ORACLE-LSubject:
Number of SQL stmts.
All,
I am trying to
Hi
Can anybody tell me what the track record has been for Oracle 9.2? Has it
been reliable and stable?
We have clients asking us about Oracle 9.2 and I would like to gather some
experience from the field on how reliable it has been.
Most of our clients are running Windows NT/2000, some are
Dennis,
Thanks for the note. Unfortunately the business decision has been
made, so I will need to just configure as best I can taking the note's
recommedations to heart.
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Tuesday, August 20, 2002
But have you done recovery? That is why you do backup and if you can't do
recovery it is useless. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 12:08 PM
I drew the short straw and have been testing RMAN for
Title: RE: Encryption of data
What about encrypting the entire tablespace? has
anybody tried this before?
Thanks,
Marul
- Original Message -
From:
Amar Kumar
Padhi
To: Multiple recipients of list ORACLE-L
Sent: Sunday, August 11, 2002 11:04
AM
Subject: RE:
Title: RE: Win2000/8.1.7.3.0/SQL
Dan:
When you did a 'select degree from dba_tables', did you get
'1'
or 'DEFAULT'? I get '1's for all my tables. Is
there someplace
else I should look?
Thanks,
Mike
-Original Message-From: Straub, Dan
[mailto:[EMAIL PROTECTED]]Sent: Tuesday,
Sam - We have been running it on 2 small production databases since July 10
and it hasn't given a single problem so far. You might also search MetaLink
for any reported errors.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 20, 2002
Thanx a lot Hemant.
The catch was that the particular view was selecting from, you guessed it,
other views which were filtering the rows!
Ya, my version is 11.0.3 only. But why is 11.0.28 getting hard-coded?
Naveen
-Original Message-
Sent: Tuesday, August 20, 2002 9:54 PM
To: Multiple
Thanks guys .
-Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 11:33 AM
From the oracle Metalink..
/*
Doc ID: Note:1036972.6
DATABASE
Type: SCRIPT
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date:
Title: Message
Thanks
Naveen. That makes sense. My dilemma is that I am trying to get a
ratio between the number of waits in v$system_event and the number of sql
statements issued. So, does anyone know if the TOTAL_WAITS field in the
V$SYSTEM_EVENT table includes wait generated by recursive
Hmm, that's usually been the problem when this has happened to me.
I'm out of ideas. It's possible that the view is based on further views and
the restriction is implemented in one of those views.
Hemant's point about ORG_ID is based on similar logic.
Cheers,
Mike Hately
-Original
Running it at a client site - stock standard basic
database running with some java and some
intermedia...no complaints whatsoever so far
hth
connor
--- Sam Bootsma [EMAIL PROTECTED] wrote: Hi
Can anybody tell me what the track record has been
for Oracle 9.2? Has it
been reliable and
Mike,
The message I replied to didn't include the SQL.
So, I found your original message and actually
looked at the SQL. :)
Make sure that your system tables have not
been analyzed, as the kernel still relies on RBO.
You can't change the degree on x$ tables, as they
are not actually tables.
Hi Everybody ,
One of my friend is looking for a oracle senior
developer /development lead job . He is expert in pl/sql programming and sound
knowledge of database design , jdbc connectivity .He alsoposses dba
and java skills . Do you guys know of any oracle opportunity which suits this
Sam,
The only problem I have come acroos is using SMU [ system managed undo ]
instead of rollback segments Check metalink under bug database
Dave Clarke.
Cisco Systems - Amsterdam
-Original Message-
Sent: Tuesday, August 20, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L
Hi
Tom,
How do you plan to use this ratio?
Jared
Terrian, Tom [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/20/2002 10:37 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Number of SQL stmts.
Michael,
Not that this has anything to do with your specific question...
but...looking at the SQL statement you posted, I don't think it needs the
table with the alias b. It already has the information from the inline
view. Also, the object's pctincrease isn't used in the calculation although
Title: RE: Win2000/8.1.7.3.0/SQL
Hi Mike,
I got 'DEFAULT'. After 'alter table ... noparallel', it was '1'.
From Metalink 66484.1:
(3) If any table in a query has a parallel degreee greater than one
(including the DEFAULT degree), Oracle uses the cost-based optimizer
for that
Good question Jared. I am currently storing data on my production databases in
a home grown metadata database (similar to the command center database that
Kevin Loney wrote about). That database stores information from each of the
production databases v$sysstat and v$system_event tables. Based
Title: Message
There
are Recursive Calls, User Calls and Execute Count. There is no definite
relationship between them.
I dont
think the ratio u r trying to find is possible. and even ifthere is a way
to fin the ratio, I don't think that will be useful
toyou.
Naveen
-Original
We have a client running OPS (no load balancing or transparent failover
enabled due to middle-tier software limitation) who is running into db
locking issues. Not sure they're related to OPS but pursuing that line of
thought.
Here's the basic scenario:
1) application (ours) access Oracle
Do you
know of any opportunity for a simlar person. All areas in US preferred. Yeah, he
will need H1 visa sponsorship. :-)
-Original Message-From: BigP
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002
11:27 PMTo: Multiple recipients of list ORACLE-LSubject:
oracle
Well, here's one way to do it.
This converts the data to hex before storing in Oracle.
Jared
#!/usr/bin/perl
use DBI qw(:sql_types);
use Crypt::TripleDES;
my ($DBname, $Uname, $Pword ) = ('MYDB','MYUSER','MYPASS');
my $DESpass = abcdefgh;
$dbh = DBI-connect(
Any indexes on these tables? what are the settings of PCTFREE , INITRANS on
these indexes?
Regards,
Waleed
-Original Message-
Sent: Tuesday, August 20, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
We have a client running OPS (no load balancing or transparent failover
Connecting with an earlier release client may work. But 9i has new
character set (AL16UTF16, for example). Earlier release client will not
understand the new character set. There are patches for some of the earlier
clients, if you can't upgrade client. Check Metalink.
HTH,
Gerardo
Dave - Can you post the bug number? I searched Metalink and couldn't find
any matches for 9.2. Is it possible that Oracle fixed the bugs by 9.2?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 20, 2002 12:57 PM
To: Multiple recipients of
Currently running 64-bit 9.2.0.1 on Solaris 2.8 on a development
environment.
So far so good. Stability/reliability of 9.2 will depend on which
options/features you are planning to use, however.
HTH,
Gerardo
-Original Message-
Sent: Tuesday, August 20, 2002 9:39 AM
To: Multiple
Title: RE: db locking quandry
We had a similar situation that ended up being a network setting issue. The server was showing blocking locks. It turned out to be that the client application was getting a network error. After the error it re-established the database connection and re-submitted
Title: RE: db locking quandry
Can
you point me to the note on MetaLink that had this TCP
setting?
thx
bill
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 2:15
PMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: db
A-ha! I knew it was casting that was getting me. On the way back from raw
to varchar2 the Oracle builtin will do NLS_LANG conversion.
THANKS, Jared! Does this mean I need to buy two of your books now? ;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Title: RE: Win2000/8.1.7.3.0/SQL
Dan:
I don't think this is the problem. See
query...
SQL select degree,
count(*) 2 from dba_tables 3 group by
degree;
DEGREE COUNT(*)--
--
1 2652
And I have not changed anything.
Thanks (and keep those ideas coming in, folks!),
Mike
Anjo,
On a related topic: I always wanted to know what the 'SQL*Net break/reset to
client' (or to dblink) means... There isn't much out there :(
John Kanagaraj
-Original Message-
Sent: Tuesday, August 20, 2002 2:13 AM
To: Multiple recipients of list ORACLE-L
SQL*Net ships data
What OS? What Oracle version?
Are you pinging?? (Waiting on one of the ops nodes for transactions on the
other node?)
Try running these pinging queries to see if there might be problems there:
ttitle left Ping Ratio
SELECT a.value cross, b.value physical, (a.value / b.value) * 100
FROM
Adrian,
that's good news!
thanks
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, August 20, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Yep, works ok. Best thing to do is check the compatibility matrix on
Metalink (73431.1).
So long as
Title: Message
Hi
Russ,
I'm
experiencing a very similar situation today. A batch job aborted last
night after it couldn't extend the rollback segment beyond 4GB, and I'm still
waiting for the rollback to complete. Before identifying that, my symptoms
were very similar to yours. Any DDL
that was a bug in release 1 but was fixed for release 2
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Dave - Can you post the bug number? I searched Metalink and couldn't
find
any matches for 9.2. Is it possible that Oracle fixed the bugs by
9.2?
Dennis Williams
DBA
Lifetouch, Inc.
Title: RE: Index move
There is no logic which says index on different
disk can give better performance . Instead spreading tables and indexes across
disks based on application can help in performance .
bp
- Original Message -
From:
Anjo Kolk
To: Multiple recipients of
Here's
an answer I posted to a similar question a few weeks ago.
HTH
Tony
Aponte
I hope this is not to late for you. Anyway, this questions
comes up often. Below is the solution to pivot rows for up to 12 values of
field1. Just adjust to fit your range of values.
HTH Tony Aponte Home
Jared:
I validated that there were no stats with this query:
SQL
SQL l
1 select owner, trunc(last_analyzed), count(*)
2 from dba_tables
3* group by owner, trunc(last_analyzed)
SQL /
OWNER TRUNC(LAS COUNT(*)
-- - --
Hi,
I had encountered this question 3 years ago. But, unfortunately I don't
remember the answer very well.
The answer for same ORACLE_HOME depends on the names of SQL*Net and NET8
files. If they are different, no problem. If same, use different
ORACLE_HOME.
As I said before, I'm not sure.
As far as I can tell from the Oracle store web page,
the Oracle Programmer product (pro*c, et al.) is only sold under
a named user license. If I buy, for example, licenses for
five named users, how am I supposed to enforce or prove to an
Oracle auditor that we only have five developers using
Title: RE: db locking quandry
thanks
- didn't realize this was windows only . . . we're all unix based . . . but the
thought of this being traced down to the network is gainging momentum (at least
in my mind)
-b
-Original Message-From: Aponte, Tony
[mailto:[EMAIL
Hi all,
Statspack report for a query is the following
Statspack report CCMP 8-Aug.
Buffer GetsExecutions Gets per Exec % Total
Hash Value
--- -- ---
2,396,079 61 39,280.016.6
2618625321
SELECT
Mike,
Just a thought - could you check DBA_TAB_COLUMNS too for LAST_ANALYZED in
the SYS schema?
John
1 select owner, trunc(last_analyzed), count(*)
2 from dba_tables
3* group by owner, trunc(last_analyzed)
SQL /
So I'm confident it's not analyzed SYS objects. But then I
Mike,
Ok...this is strange. The optimizer_mode is set to RULE, but if
I put a RULE hint into the SQL it runs OK. I tried increasing
This is almost clearly a case of the CBO being forced for whatever reason.
And there are many :( Cut and paste from the Fine Manual (Oracle 8i
Designing and
Beth,
You could also select the info from the SM$TS_USED or SM$TS_FREE table
as SYS.
the table desc is TABLESPACE_NAME, BYTES. You should see the bytes
change as the work progresses.
I got this tip from OWS when I saw chasing a SMON at 100%cpu after a
crash.
Ron
ROR mô¿ôm
[EMAIL PROTECTED]
create or replace mystrtype is table of varchar2(50)
/
select field1, cast(multiset(field2) as mystrtype)
from my_table
group by field1
/
HTH
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion
Russ,
Your high usage of RBS was due to the updates being done to the system data
dictionary. Since you were dropping a tablespace and contents the DDL
statements for the individual objects (tables and indexes) needs to be done
first, but I've a funny idea from practice that Oracle does not
John,
That event can happen for a couple of reasons, but the most common one is that
the serverside has returned an error for the client side for an operation.
The client side isn't really expecting it so the server sends a break/reset
to the client. That gives the client a change to resync.
No, the next version will be bug free.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 9.2 Stability Feedback Requested
Dave - Can you post the bug number? I
Solaris, Oracle 8.1.7
doubt pinging is the issue since all txn's against these tables go through a
single node, and the problem persisited even when all sessions were
consolidated into a single node.
-b
-Original Message-
Sent: Tuesday, August 20, 2002 3:58 PM
To: Multiple recipients of
The BEQ (or BEQueath) protocol adapter is only usable within the server, not
outside and is actually the best to use when you can. TCP/IP is the most often
used protocol outside of a server and in a client/server configuration. Setting
TDU and SDU to something other than 2K (the default) can in
Title: Message
Hi
Beth,
Sounds
similar, unfortunately. Thanks for the SQL. I'll keep it just in
case.
Good
luck with your situation.
Russ
-Original Message-From: Seefelt, Beth
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002
4:49 PMTo: Multiple recipients of list
Ian,
Interesting note on library priviledged if you have not noticed. With all
objects you can grant the create or create any privileges, but with libraries
it's create any only. Kinda dumb I think. One other thing, if your going to
use extproc's and for one reason or other can't set the
Could it be that you confuse the logical with physical reads ?
Anjo.
On Tuesday 20 August 2002 14:13, you wrote:
Hi all,
Statspack report for a query is the following
Statspack report CCMP 8-Aug.
Buffer GetsExecutions Gets per Exec % Total
Hash Value
---
Brooks, Russ would like to recall the message, drop tablespace including contents.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brooks, Russ
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Just out of interest, has the sequence got NOCACHE in these cases? Have
you tried with CACHE 30 or bigger and does the redo volume still present
a problem?
There may be an application reason mandating use of NOCACHE. Have you
checked it really is a valid reason?
Cheers,
John
In message
John:
I checked it out with this...
SQL select owner, trunc(last_analyzed), count(*)
2 from dba_tab_columns
3 group by owner, trunc(last_analyzed);
OWNER TRUNC(LAS COUNT(*)
-- - --
AURORA$JIS$UTILITY$
John:
That makes perfect sense in view of the fact that only the
/*+ RULE */ hint makes the query run. I'm not gonna try and
find the root cause any more; I've modified my queries and
I get answers again.
My Thanks to all who have helped me with this issue.
Cheers,
Mike
-Original
Title: Driver
Does anyone have the executable of the MDI odbc driver? One of the .dll files is MDMDI32.dll. I have contacted ViaServ and have been told that they no longer have this driver, but instead want me to upgrade to their new driver. I already have this driver and it does not work
Did you compare the explain plans between a database where it works and where is
doesn't. Anything interesting there?
-Original Message-
Sent: Tuesday, August 20, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L
John:
I checked it out with this...
SQL select owner,
Mike,
Just one more thing to check before you close this: Can you run a 10053
trace? This is a 'CBO trace' and should provide some interesting reading.
There was an excellent paper from Wolfgang Breitling on the 10053 at the
recent IOUG and should be available somewhere...
Inquiring minds want
Now you've piqued my curiosity again, too. I'm running it
without the hints and with a 10053 and we'll see what it says.
Tomorrow.
At the plantation...
No...no...that's a movie...
Cheers,
Mike
-Original Message-
Sent: Tuesday, August 20, 2002 5:09 PM
To: Multiple recipients of list
Brooks, Russ, your request to recall the message, drop tablespace
including contents has been DENIED.
Brooks, Russ wrote:
Brooks, Russ would like to recall the message, drop tablespace including contents.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe
Dick,
There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite toolset.
( vi, Perl and sqlplus for me :)
SAP types have it drummed into their heads that the only proper
way to do anything DBA work is via SAPDBA.
I refuse to use it,
Hi, ALL,
What is the difference between dbms_utility and dbms_stats in terms of
statistics gathering?
Any clues would be much appreciated.
Chuan
Unless otherwise stated, this e-mail does not represent the views of
TransACT Communications Pty Limited. This text and any attachments of
this
1 - 100 of 105 matches
Mail list logo
