I would use:
(Bselect server, count(*) from v$session group by server;
(B
(BThat way you'll see how many sessions are using shared servers how many
(Bare forced to be dedicated. (you can have dedicated connections in MTS as
(Bwell).
(B
(BOtherwise, you can check views v$mts, v$dispatcher,
Hi!
How do I delete Java classes from a schema?
I have a script that queries user_objects and genereates drop table, drop
synonym etc. statements.
After the script is run, there are still java classes left in the schema. I
can use Enterprise Manager to drop them, but I would want to do it
use drop java class ;
Use quotation marks and case-sensitive class names.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:09 AM
Hi!
How do I delete Java classes from a schema?
I have a script that
Hi there all.
How can I find the sid of the current session,
I got a pl/sql procedure that needs to do a select from v$session_event
but only want to do it for it's own session so I need to know this for
the where clause ?
George
__
George Leonard
select sid from v$mystat
where rownum2
/
Kind Regards
Suhen Pather
IT Software Specialist
Land +27 12 680 3282
Cell +27 82 562 3124
email [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 02, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
Hi there all.
How can
George,
u can get it from v$mystat.
REgards,
Jp.
02-12-2003 16:44:25, George Leonard [EMAIL PROTECTED] wrote:
Hi there all.
How can I find the sid of the current session,
I got a pl/sql procedure that needs to do a select from v$session_event
but only want to do it for it's own session so I
V$mystat, to what would you join this to understand the
values/statistics, v$session_event?
George
__
George Leonard
Oracle Database Administrator
Professional Services (Oracle Business Unit)
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell:
Title: RE: Finding SID of current session
You can use also this approach:
select * from v$session_event
where sid = (select sid from v$session where audsid = userenv('SESSIONID'))
Regards, Joze
-Original Message-
From: George Leonard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Tanel ,
(B
(Bv$mts, v$dispatcher, v$shared_server all have a record each.
(B
(Bbut:
(BSQL select server, count(*) from v$session group by server;
(Bthis query says that all conn are dedicated.
(Bbut the tnsnames.ora in the client (webserver) doesn't enforce for a dedicated conn.
(B
Hi,
my question is about the same, but more general. How can i force Oracle to use my
prefered way of explain plan and not use CBO's. I mean, apart from stored outlines, it
somehow seems to complicated. I would like to say what order and join types it should
use. But, try as I might, I many
What is complicated about stored outlines? If you don't like those you
can always go back to the RBO.
Gudmundur
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Wartiak Rastislav
Sent: 2. desember 2003 08:44
To: Multiple recipients of list ORACLE-L
Hi!
Low _row_cache_cursors might be causing
someof softparsesyou have, especially with Apps where we have
lots of complex PL/SQL and really lots of different objects.
Maybe you should increase your _row_cache_cursors
parameter, but check
At 01:44 AM 12/2/2003, Wartiak Rastislav wrote:
my question is about the same, but more general. How can i force Oracle to
use my prefered way of explain plan and not use CBO's. I mean, apart from
stored outlines, it somehow seems to complicated. I would like to say what
order and join types
One of the column in a new table can be ename - varchar2(20) or hase_code_ename -
number(11) Hash Code generated by JAVA.
We are going to create non-unique index on this column as one frequent query will have
where clause on this column only. Choice is either varchar2(20) or number(11).
1.
Tanel List,
(B
(BSQL select name,network,status, from v$dispatcher;
(B
(BNAME: D000
(BNETWORK : (ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1027))
(BSTATUS : WAIT
(B
(Bmy listener.ora doesn't have an entry for this and LSNRCTL STATUS
(Bdoesn't show that it's
Use "lsnrctl services" to see which services have been registered with your
(Blistener.
(BYour dispatcher hasn't probably registered it's services with listener.
(BTry "alter system register".
(BIf you still don't see any "shared" services (handler=dispatcher) under
(Blsnrctl services, then
If we are talking about two sql only, maybe you can use stored outline.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:34 AM
Hi, list friends:
We are using partition to archive history data in
What's the objection to using stored outlines? That's the
Oracle-provided mechanism for forcing queries to use a particular
plan.
The problem is that I have to first analyze tables with real data for CBO to create
plan I find useful (like using specific indexes etc.) and then to store it.
AFAIK RBO cannot be used for partitioned tables, not talking about the fact that RBO
might not be supported in future versions.
What is complicated about stored outlines? If you don't like those
you can always go back to the RBO.
Gudmundur
-Original Message-
From: [EMAIL
Don't worry about dispacther's address, they ought to be running on
(Bdifferent ports than listener anyway.
(BDon't use lsnrctl status for checkin services, lsnrctl services is for that.
(B
(BYes, in Oracle you can directly connect to your dispatcher as well if you
(Bwant to (some people have
Jonathan,
I've understood that when cursor_space_for_time is true, then unpin is only
done when cursor is closed, thus there's no need for pinning/unpinning for
every execution of a cursor. This should reduce hits on library cache
latches since pinning is not done so often?
Hermant,
I've
Correct. The point is that stored outlines can be viewed as a tool for
those who like the predictability of the RBO. When the RBO is no
longer available, the best way I know of to force the CBO to use your
plan is stored outlines.
Gudmundur
-Original Message-
From: [EMAIL PROTECTED]
I'm do not think stored outline/hints is the answer. Part of the problem is
the partitions are of different sizes and the optimizer needs to know and
handle them (partitions) differently. In Oracle7 partitioned views, each
partition was explained separately, but this was gone with Oracle8 onwards.
I agree, but still you have load data, analyze tables, check explain plan that this is
what you actually wanted and store outline.
rw
Correct. The point is that stored outlines can be viewed as
a tool for
those who like the predictability of the RBO. When the RBO is no
longer available,
When partitioning key is not a part of the index and you are querying whole table,
then it is faster to scan one big index than many smaller ones. The difference is
something like log rows to partcount*log (rows/partcount).
BTW, local indexes are the only way to go -- I've never
understood
i think this is possible. any docs on how to set this up with suggested methods?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
You just set up shared servers on your environment and include
(SERVER=DEDICATED) in those clients tnsnames entries CONNECT_DATA sections
who want to use dedicated servers.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 02,
Ryan,
I am doing this. In our Tnsnames.ora file, I have two entries - one for
dedicated and one for shared. The application needs to use the correct
tnsnames.ora connection for the type of connection that they want.
Optionally, you can do the same thing using either ora names or ora ldap.
Same
Hello List,
The Company I work for is planning to go the Active Directory route. Does
anyone know of any issues with the following versions of Oracle 7.3.x.x and
8.1.7.x.x?
Regards
Denham Eva
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denham Eva
INET: [EMAIL
This may help ...
(B
(Bselect server from v$session where audsid = USERENV ('SESSIONID') ;
(B
(BThanks,
(B
(BNick Khimani
(B--
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B--
(BAuthor: Nikhil Khimani
(B INET: [EMAIL PROTECTED]
(B
(BFat City Network Services
Hi!
When you delete a partition, naturally it's statistics get deleted as well.
Now when you add another partition, it is initially without statistics,
which means CBO has either to use default statistics or depending on
optimizer_dynamic_sampling parameters value to read few blocks from your
Title: Message
I am reading this
late, but please congratulate him for me. That's really an
honor.
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, November 21,
2003 7:35 AMTo: Multiple recipients of
what if you have a web based architecture? is there a way to have 9iAS decide which
connection to use?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/12/02 Tue AM 07:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: running both shared server and dedicated
You have to have two tnsnames entries in your iAS installation, one for
shared, one for dedicated. Depending on which tnsnames entry you use in your
app, the corresponding server is used.
If using JDBC thin drivers (no oracle client installation nor
tnsnames.ora)... there might be some parameter
Hmm. Yes, I think I need to look at _row_cache_cursors.
I do have a number of objects being pinned but rather than using the
$AD_TOP scripts I use queries
on V$DB_OBJECT_CACHE to identify frequenty executed
procedures.
Hemant
At 12:54 AM 02-12-03 -0800, you wrote:
Hi!
Low _row_cache_cursors
Hi guys
Have a request here. My management wants to know the advantage of using
dblink instead of odbc.
Does anyone have any ideas on this?
Regards
PG
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paulo Gomes
INET: [EMAIL PROTECTED]
Fat City Network Services
No, you don't.
You could use dbms_stats to create (without analyzing) your statistics
(if you know, what kind of data you'll be getting), and then store
outline.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Wartiak Rastislav
Sent: Tuesday, December 02, 2003 7:15 AM
To:
Title: Message
Tanel,
Where
can one get the $AD_TOP scripts?
Thanks.
Abraham Guerra
-Original Message-From: Hemant K Chitale
[mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003
8:54 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: SESSION_CACHED_CURSORS -- RE: Parse
Let me note that I used listener status to figure out services
because the output of stat is more compact and easier to read.
Of course, one should always use services to look see how services
are configured.
On 12/02/2003 04:59:25 AM, Tanel Poder wrote:
Don't worry about dispacther's address,
That was my understanding, too. The problem with unpinning only at
the specific close is that smon cannot free shared pool memory belonging
to the cursor if the cursor is pinned, so the shared pool usage skyrockets.
The only way to circumvent the problem is to set CURSOR_SHARING to FORCE.
That
Can't compare apples and oranges.
ODBC is for client-database connections, dblink is for database-database
connections.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Paulo Gomes
Sent: Tuesday, December 02, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Hi guys
Have
Prem, MTS configuration requires cooperation of two peaces
of software: RDBMS and listener. It's not enough to check
the database configuration, you should also check listener.ora
and tnsnames.ora
On 12/02/2003 03:39:26 AM, Prem Khanna J wrote:
Tanel ,
v$mts, v$dispatcher, v$shared_server
Sure it is but ... As the manager asked and even if I did say that there
would be no Oracle Paper on this ...
Thanks a lot.
Regards
PG
-Mensagem original-
De: Igor Neyman [mailto:[EMAIL PROTECTED]
Enviada: terça-feira, 2 de Dezembro de 2003 15:55
Para: Multiple recipients of list
Title: Anyone run into this strange ORA-00904 error ??
We started having a weird problem that looks like some kind of data dictionary corruption.
My first choice is to run catalog / catproc. This did nothing to resolve the problem.
Why am I able to describe an object, but get ORA-00904
Title: Message
Would
an export/drop/import work for you?
Abraham
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Tuesday,
December 02, 2003 10:34 AMTo: Multiple recipients of list
ORACLE-LSubject: Anyone run into this strange ORA-00904 error
??
We
Title: Anyone run into this strange ORA-00904 error ??
What happens if you select 1 or 'X' from the
table?
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 02, 2003 6:34
PM
Subject: Anyone
Babette,
Can you list the describe of the whole table?
Daniel FInk
[EMAIL PROTECTED] wrote:
We started having a weird problem that
looks like some kind of data dictionary corruption.
My first choice is to run catalog /
catproc. This did nothing to resolve the problem.
Why am I able to describe
Did you check grants on the table?
This happens sometimes, with some oracle versions,
in the following situation:
step1: user1 creates tab1 and
grants all to user2. (without grant option)
step2: user2 creates view1 based on tab1
and grants all to user3.
Now, when user3 tries to
Mladen,
I don't think it's SMON who is coalescing free memory extents. I'm not
entirely sure here, but I think if any server process explicitly frees a
freeable chunk, then the 16-byte header of immediate next chunk is checked,
if this is also free both chunks are coalesced and header of next
what causes memory fragmentation errors? should oracle be able to go to the LRU and
start kicking stuff out of memory if there isnt enough space?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/12/02 Tue PM 12:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:
It this a view ?
--
Denny Koovakattu
Quoting Tanel Poder [EMAIL PROTECTED]:
Anyone run into this strange ORA-00904 error ??What happens if you select 1
or 'X' from the table?
Tanel.
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Steve Adams talks about AST's which are blast from the VMS past.
More exactly, AST used to stand for Asynchronous System Trap,
and was processed in a similar way like signals on the unix.
The CPU IPL was elevated to AST delivery level (IPL 2) and
AST was queued on the target process entry. When
Tks, Sami
I will try it.
Eriovaldo
-- Mensagem original ---
De : [EMAIL PROTECTED]
Para: Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
Cc :
Data: Mon, 01 Dec 2003 18:19:25 -0800
Assunto : RE: XML Sctructure
You can generate DTD
It's not being the case. I would really, really like to
know how does Oracle implement AST's?
There's no such thing you won't find from Ixora:
http://www.ixora.com.au/q+a/misc.htm
Search for AST :)
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel
Babette,
Version? Are you doing this through sqlplus and if so, is the client
installation a different version than the db?
Rachel
--- [EMAIL PROTECTED] wrote:
We started having a weird problem that looks like some kind of data
dictionary corruption.
My first choice is to run catalog /
i believe column privileges are only for dml. views are supposed to filter out columns
for selects. i could be wrong.
From: Krishna Kakatur [EMAIL PROTECTED]
Date: 2003/12/02 Tue PM 12:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Anyone run into this
Notes in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see
The biggest problem with hints is that you cannot
specify a full set - in particular there is no effective
way to handling unnesting of subqueries.
For simple cases, you can put the tables in the
main query in the 'correct' order and use the
ORDERED hint, then name the indexes and
join
I've just bought a new Windows XP machine,
Got all the latest downloads on the O/S.
Installed a firewall.
Got Norton Anti-virus loaded and up to date.
Which bit of code is stopping me from getting
to Metalink and the Oracle websites ? The
pages no longer exist according to my M/S IE.
Regards
I was the guy who asked that question long time ago, but I'm not sure
how exactly are sockets used. Socket is, essentially, a pipe. You must
have someone reading and someone writing it. That is not exactly what I'd
call an AST.
On 12/02/2003 01:39:28 PM, Tanel Poder wrote:
It's not being the
Firewall seems like the most likely culprit.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Tuesday, December 02, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
I believe
select sid from v$session where audsid = USERENV( 'SESSIONID' );
is a universal way to determine one's current internal SID based on the
sessionid returned by userenv.
Adam
George Leonard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/01/2003 11:44 PM
Please respond to
I have to admit that I wasn't thinking about replying
to your comment when I sent this email. However,
I think you are correct - there is an effect of extra
items not being releasable from the shared pool
when cursor_space_for_time is true. (From memory
of one of Steve's seminars, it is the Heap
Hi,
We need storage solution for Oracle database because we store a lot of tiff
images and pdf files with the database, which storage solution are you using
or which one you will recommend?
Thanks,
Jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Liu, Jack
Universal, and works with 7.3.4 - which is still in common
use - but is deprecated in favour of:
select sid from v$session where audsid =
sys_context('USERENV', 'SESSIONID' );
which still doesn't help if you have several SYS sessions
running, as the sessionID for SYS is
Reading Cary's book I understand that c and e are
measured via different system calls (haven't truss'ed
[well tusc'ed] them yet - I am on HP-UX 11.11), but
would anybody know what the reasonable upper limit of
c-e might be?
I am looking at the trace file where c is more than
two orders of
I'd say IE and firewall too ... I use Mozilla Firebird ... it is set to open
different tabs instead of windows ... Maybe you want to tweak XP built in firewall and
open ports 80 (http),443 (https).
Raj
I couldn't resist: it must be Windows XP.
On 12/02/2003 02:54:30 PM, Jonathan Lewis wrote:
I've just bought a new Windows XP machine,
Got all the latest downloads on the O/S.
Installed a firewall.
Got Norton Anti-virus loaded and up to date.
Which bit of code is stopping me from getting
Liu, Jack wrote:
Hi,
We need storage solution for Oracle database because we store a lot of tiff
images and pdf files with the database, which storage solution are you using
or which one you will recommend?
Thanks,
Jack
Depending on your budget, I recommend a Hitachi SAN. Fast, 24/7 uptime
Yep, could be the firewall, if the site gives not found error.
Another thing that you might hit is that Metalink requires cookies to be
enabled, maybe in XP's internet explorer they're disabled by default.
Tanel.
Firewall seems like the most likely culprit.
Rich
Rich Jesse
Hi!
I haven't read Cary's book yet (although it's already waiting on my
bookshelf), but I think CPU time c is measured in timeslice steps (100ms)
and elapsed time e is taken from system timer or smth like that. Others will
know better :)
Tanel.
- Original Message -
To: Multiple
If you got one concurrent user reading these files, go with internal IDE
disks.
If you got 10 concurrent users, go with EMC Symmetrix
(You didn't give us any more information to be more exact...)
Btw, in some cases, when you have lot's of data, of which only a little part
is used actively,
Hi Jack,
Any BAARF-compliant solution will do.
Look at www.baarf.com
At 12:34 2-12-03 -0800, you wrote:
Hi,
We need storage solution for Oracle database because we store a lot of tiff
images and pdf files with the database, which storage solution are you using
or which one you will recommend?
Is this a multiple choice question? My money is on the firewall. You can
test this by trying to go to well known web sites like microsoft.com and
dell.com. Who is the firewall's vendor? You need to enable the feature
that allows full access to sites. Go to grc.com to check the firewall to
They may be a bit more comparable than that.
a dblink can utilise ODBC (via HS ODBC) to connect to non-Oracle databases (or to
Oracle databases if you really wanted to).
ODBC can be used by client but also by server via HSODBC.
ODBC can also be used by a non Oracle server (eg SQL Server) to
Just wait till we post Jesper Haure's RAID-4/5 simulator, where a
home-written XOR function plus a table with column A = disk A, etc... It
should be ready RSN.
Mogens
Carel-Jan Engel wrote:
Hi Jack,
Any BAARF-compliant solution will do.
Look at www.baarf.com
At 12:34 2-12-03 -0800, you
In Oracle 9, Oracle tries to measure times in microseconds (as opposed to
centiseconds pre-9). However, many Systems only slice time far coarser than
that so Oracle has to fake it to some degree and that faking may be
different between cpu time and elapsed time. Take your cpu times for
See once again an advantage of windows. It won't let you rm an in use
file
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of zhu chao
Sent: 02 December 2003 05:34
To: Multiple recipients of list ORACLE-L
Subject: Re: Where are my trace
On your platform, c is measured in centiseconds (10,000 microseconds)
whilst e has a notional accuracy to the microsecond. So the extremes
are to be expected.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
Make sure you also allow destination port 53 UDP/TCP for DNS requests. Even if you can
talk HTTP[S] on ports 80 and 443, you won't get very far if you can't lookup an IP
address for a domain name.
-- Dan Hanks
On Tue, 2 Dec 2003, Jonathan Lewis wrote:
I've just bought a new Windows XP
I'd be highly, highly suspicious of the cpu time c.
1. You should be able to verify (roughly the elapsed time) of the
statement, if by no other means than running in sqlplus with timing on.
2. 3 statements with *exactly* the same cpu time - all in very very
round numbers. Seems unlikely to me.
Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files?
I have databases here that are at 8.1.7.4, but the files are not there.
9i has them, but none of the 8i databases.
Thanks,
Jared
PS. Metalink was no help for this. Neither was google.
Good to see you wasting time productively...
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: 02 December 2003 21:45
To: Multiple recipients of list ORACLE-L
Subject: Re: Which storage solution is good or you will
Title: Message
1
database instance, 2 nearly identical schemas. What's the best sanctioned way to
copy stats, (including histograms), from one schema to
another?
me reads Jonathan's description and blushes/me
So it'll be a *feature* and not a bug then. IIRC e comes from POSIX
gettimeofday calls on all platforms except Windows -- where it looks
like GetTickCount. If this is true then the accuracy of e will be
limited by the accuracy of gettimeofday.
It won't let you read it, either.
Niall Litchfield [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/02/2003 01:59 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Where are my trace files going?
See once
What
platform are you on? All my 8.1.7.4 databases on Solaris have it.
Perhaps the missing files platform/port specific?
-Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, December 02, 2003
5:20 PMTo: Multiple recipients of list
Jared:
You can't find it in Oracle8i? Probably because Oracle8i does not have
dbms_support. I believe it was introduced in Oracle 9i Release 1.
RWB
Reginald W. Bailey
IBM Global
I have it in 8i:
[EMAIL PROTECTED] [/home/admin/oracle]sqlplus / as sysdba
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 2 17:56:01 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the
Title: Message
I have run into this problem in the past in two different
situations. The first is where there is a reserved word somewhere that you
managed to sneak through somehow... the second is where there is an internal
view created for some reason that barfs... e.g.,
Hi Gurus,
Could someone shed some light on the following tkprof output.
To get 0 record it is aking more than 11 seconds. Also I see huge difference
between CPU time and elapsed time even though the system is not so busy(It is a
test machine. very low load on it). If you say it is waiting on
dbms_stats is the only sanctioned way to do it.
Orr, Steve wrote:
1 database instance, 2 nearly identical schemas. What's the best
sanctioned way to copy stats, (including histograms), from one schema
to another?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
I see the schema import/export procedures in the package but they just import/export
the stats for a particular schema into or out of the dictionary. There's no procedure
to copy stats from one schema to another within the dictionary... At least that's my
understanding from reading the docs.
Although I'm sure that someone (ChangeGroup in Denmark, Abase in Finland)
would like to tell you about Cassandra:
http://www.abase.fi/products_cassandra.php?lang=e (a GUI interface (+ more)
to dbms_stats (sort of)).
:o)
Michael Garfield Sørensen, CeDeT
- Original Message -
To:
Title: RE: dbms_support on 8i
Jared,
Files are the same in 7.3.4 and 9.2.0. You can use any of this in 8.1.7. Oracle Corp. did not ship those files with 8.1.7, you can ask Oracle Support to get it.
Alex.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Jared
I have dbmssupp.sql in rdbms/admin of my HP11 8.1.7.4
t
-Original Message-
Sent: Wednesday, 3 December 2003 6:20 am
To: Multiple recipients of list ORACLE-L
Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb
files?
I have databases here that are at
Is this Oracle 7? From a world-renowned source I've heard that Oracle 7
contains less KLOC than RAID-F microcode, so simulation might be even
faster than the real stuff, although with slighly less capacity I'm afraid
Carel-Jan
At 13:44 2-12-03 -0800, you wrote:
Just wait till we post Jesper
No, they are unfortunately not the same. Try using the 9.2 dbmssupp.plb file on 8i.
I don't have the files on Solaris 8.1.7.2, Win2k 8.1.7.4 or Linux 8.1.7.4.
Guess I'll check with support.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/02/2003 03:54 PM
Please respond to ORACLE-L
I'm trying to determine when execution of DDL via
DBMS_REPCAT.EXECUTE_DDL completes successfully on all master sites.
I'm not sure how the DDL is propagated, but it doesn't appear to be via
the replication administrator's scheduled jobs: I've removed the
dbms_defer_sys.push job (via
Steve, I've done this: first export the source schema's stats from the
dictionary into a user table, then import from that user table into the
dictionary for the target schema. (Use CREATE_STAT_TABLE to create the
user table.)
Paul Baumgartel
--- Orr, Steve [EMAIL PROTECTED] wrote:
I see the
1 - 100 of 124 matches
Mail list logo