List,
Can anyone tell me on what version of Oracle database does fast full index scan first became available?
Jos
Yahoo! Mobile
- Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
I think you will find that the functionality of Context is now bundled up in
the Oracle product called Collaborative Suite. It is certainly available in
enterprise. Oracle do have this irritating habit of re-naming old
technology, and presenting it as the latest great thing...
peter
edinburgh
I'm fairly sure it was available in 7.3.3, although
you may have had to use the index_ffs hint to
make it work.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see
7.3 I think
--- Jos [EMAIL PROTECTED] wrote:
List,
Can anyone tell me on what version of Oracle
database does fast full index scan first became
available?
Jos
-
Yahoo! Mobile
- Exchange IMs with Messenger friends on your
Telstra or Vodafone
Oracle magazine is primarily a marketing magazine I think.
Like MCP Magazine or DB2 magazine.
I don't think it's intended to be a technical journal.
It's intended to be an exciting place to talk about new features and peddle
3rd party products through ads.
Is there a 3rd party magazine out
There is SELECT journal from IOUG !!
John K. and Jared S. are contributing editors.
From Oracle's Web site:
Oracle Magazine:
Oracle Magazine is the definitive source for information on the use and development
of Oracle products.
Profit Magazine:
Profit: Oracle's E-Business Magazine
Hi All,
As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if there is any
such group for SQL Server also.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
Fat City Network Services--
Sure, take SELECT for example - 100% pure Oracle technology - no marketing.
It's the journal of International Oracle Users Group.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 7:33 AM
Oracle magazine is primarily a
I find that the Oracle Scene magazine (the UKOUG's own magazine) is a
fantastic source for Oracle technical info. Jonathan Lewis, Peter Robson and
a host of other greats contribute to Scene as well (I LOVED Oracle
Trousers by the way Jonathan!! :D).
I'm not sure if this is distributed outside of
Title: RE: What to check?
David,
I'd check that they are using the same exact script on all three machines.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Nguyen, David M [SMTP:[EMAIL PROTECTED]
Someone
Title: OT - Oracle work in Tampa/Orlando, Florida.
Sorry for the off topic post.
Does anyone on the list live/work in Orlando/Tampa??
I am looking to make a move down to that area sometime in the near future. So I am obviously seeking any information anyone is willing to share about
Don't know how many, if any, of you are interested. I was at this conference
last year. It's small (nice because you get a lot better access to the
presenters), but very informative. I'm headed back to it again this year.
Dick Goulet
Thanks guys. That's exactly the kind of stuff I was looking for, and for
the same reasons you mentioned.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Friday, February
Anyone using DBArtisan? Any good/bad feedback about this product?
Someone in our office is looking at the Cross-Platform version that
works with Oracle, Sybase and MSSQL.
Thanks,
Suzy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Suzy Vordos
INET: [EMAIL
Teenu
Whenever I have an attach to invalid skgp shared ctx it just really frosts
me!
Seriously, I hope Oracle Support will be of some assistance. If this just
occurs once, you may consider ignoring it. Oracle Support may suggest a
patch. Since 8.1.6 is out of the support window, you may want to
Try this one out.
http://www.sswug.org/listservers.asp
Dave
-Original Message-
Sent: Monday, March 03, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
Hi All,
As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if there is any
such group for SQL Server also.
Should the databases be shutdown before the listener or the other way
around.
A DBA here (actually at Service Provider) believes that the listener has to
be shutdown before the databases in 8i according to some documentation (they
can't recall).
I am proposing:
Set Oracle 817 environment
You might try asking at http://www.sqlmag.com/forums/
[EMAIL PROTECTED] 03/03/03 08:09AM
Hi All,
As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if there is any
such group for SQL Server also.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ:
I need to create a view to
join 13 tables. The objective is to have one view that allows basic
queries on permit types (building, electrical, plumbing, signs,
mechanical). Each type of permit and it associated information is
stored in separate tables, and a column in each table
I believe it is the conventional method only...
do direct=y it screams that way...
Brian
-Original Message-
Sent: Monday, March 03, 2003 2:04 AM
To: Multiple recipients of list ORACLE-L
Please have a look at following note: 223399.1 having title
ALERT: EXPORT with large BUFFER can
We use it for Oracle with the thought of expanding it
to SQL Server and Sybase. It is good for basic DBA
tasks such as database monitoring, space utilization,
account information. Where it breaks down is anything
complex, Oracle 7.3 with the newer version, or 9i with
the older version. Also, be
A group like this one?
Not likely. :)
Jraed
On Monday 03 March 2003 06:09, Mandal, Ashoke wrote:
Hi All,
As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if
there is any such group for SQL Server also.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ:
Why do you/they think it matters, regardless of the documentation?
You can shut them down in any order you want. Users just get a
different error if the listener is up vs. when it is down.
Starting up, if services are registered via local_listener or
mts_dispatchers, the listener should be up
should be something here..
http://www.sqlmag.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 2:09 PM
Hi All,
As we have this Oracle user group([EMAIL PROTECTED]), I was wondering
if there is any such group for SQL Server
Title: RE: Is there any user group forum for SQL Server?
BTW GUYS,
Top page of latest SQL Server Magazine all about Connecting Oracle and SQL Server and working in an environment that has both - pretty interesting.
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL
Title: RE: 9i OCP Upgrade Exam - Again
Guys,
Sorry to post this again. However, finished OCP 8i and wish to study for 9i OCP. What is good materials - books, self-test exams? References. Don't have time or money to travel - going to IOUG however.
There might be some docs somewhere but the issues are not as much
technical as procedural. If you shut the database down, leave the
listener up, and bring the database backup there are no connection
problems except when the db is down. This implies that the instance and
the listener are
Finally got my issue Saturday.
Along these same lines, I was somewhat taken aback
by the first letter. The writer had disagreed with some
query method in a previous article, and submitted one
that he felt to be much better.
In the course of the letter he referred to the author's submission
as
Suzy,
We use it here, but only for Oracle.
I highly recommend it. It's very useful
for everyday tasks, for reverse-engineering
database objects, as well as other things.
The support has also been good.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Did a union of the rows across the tables
and the view works fine.
rhr
-Original Message-
From: Richmond, Robert
Sent: Monday, March 03, 2003 11:04
AM
To: Multiple recipients of list
ORACLE-L
Subject: view to join tables
I
need to create a view to join 13 tables. The
Title: RE: Is there any user group forum for SQL Server?
Jared,
STEP AWAY FROM THE KEYBOARD!
It's certainly a dangerous weapon when you can't even spell you're own name! ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Is there any user group forum for SQL Server?
That is the one I use - appears to be very useful. Also www.quest.com and SSWUG provide online seminars relating to SQL Server - quest depends on speaker and no fee, SSWUG useful but has fee.
-Original Message-
From:
David,
it just doesn't matter. why do you even feel the need to shut the listener
down?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 03, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Should the databases be shutdown before the listener
I ran into a problem yesterday afternoon. I had exported a
production database, via a full database export, and ftp'd it to another
machine to import it there and make that the new production machine. It
was a long import (about 8 hours) and about 2/3 through it, my network
connection was
hello to everybody
we tried oracle OID. it works fine. check it out, it's worthwhile.
btw.:afaik oracle names is deprecated and will be withdrawn (... ok somewhen).
pls fogive if i'm wrong about that, but i read it somewhere in the docu that comens
with 9i.
Apologies for any typing mistakes
Title: RE: Is there any user group forum for SQL Server?
From: Jared Still [mailto:[EMAIL PROTECTED]]
A group like this one?
Not likely. :)
Jraed
Given that you've misspelt yer own name, I'd not be too uppity ;-)
- Jerremy
Title: RE: Metalink Oracle Support Improving...
Kirti,
Unfortunately for us, our security experts won't allow that ... so we *walk* them through and give them reproducible test cases.
Raj
-
Rajendra dot Jamadagni at espn dot
Not to scare you but I think the 9i upgrade exam is the hardest of the
bunch. My book is a good start I'd like to think. I've seen mixed responses
on the Benjaman book, but it can't hurt.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/3/2003 10:04 AM
Guys,
Suzy:
We've been using it here for several years.
I love the product.
It does everything we need in that type of product.
'course, we're not exactly on the bleeding edge here
(most db's still at 7.3.4)
Barb
--- Suzy Vordos [EMAIL PROTECTED] wrote:
Anyone using DBArtisan? Any good/bad
If you don't call a marketing magazine a definitive technical source,
then it can't function as a marketing magazine. :)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 25-27 London
-Original
hey folks..
Hoping for
a little feedback and opinion please. Having a discussion with the development
group ...
The development
group is thinking that a VERY LARGE SGA would solve some of their I/O problems.
For example, they believe that a SGA consisting of over 8GB of db block buffers
Sometimes it does matter what is stopped rather than the order, but we
can't tell why the original poster was asking. It depends on your
environment. For example, one site I worked at had a separate listener
for every database in their environment. Their reasoning was they made
life easier for
My understanding was that ONAMES was removed from 9i and that they provided
some sort of wrapper that goes around OID to make it look like a names
server until you can covert all your clients. Can anyone confirm? I am not
running 9i on any of my servers yet.
--
Chuck
- Original Message -
Yep, had the same experience last week with Cognos
support. Pretty cool. Tool is called Webex I
believe.
Support can see what you do but can't take over your
workstation. It's like they have a looking glass on
your workstation but can only see open items on your
desktop.
mohammed
---
Tom,
It is for the server auto-start/auto-shutdown procedures run by root.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 09:04:11 -0800
now you know why I script everything and run it as a background job on
the database server itself. :)
That I know of, there is no way to restart an import... unless you have
primary key or unique constraints on all objects and you are will to do
ignore=y so that you get constraint errors on
There might be specific cases where you can, depending on constraints, etc.,
but in general, I don't think so.
Two approaches to keep it from being interrupted:
1. sh -c nohup imp option1=xxx option2=xxx etc
2. echo imp option1=xxx option2=xxx | at now
You might want to add some output
Not so much misspelling, as it is nuerons (sp?)
firing in the wrong order.
deraJ
Jeremy Pulcifer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/03/2003 09:36 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 08:19:06 -0800
Why do you/they think it matters, regardless of the documentation?
You can
This will help end-user performance *only* if a significant proportion of their
response time is presently consumed doing physical disk I/O
(e.g., either db file scattered read or db file sequential
read events).
Its possible that your strategy
might help, but in my estimation, its not
Nope. namectl, names, et al binaries are still there and functional at 9.2
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Jeremiah
I didn't really think it mattered for the shutdown. Though I know in Oracle
7 it did matter for the startup (we use MTS). Another DBA seemed to imply
that the sequence was important on shutdown of 8i.
So if in doubt I RTFM, suffer the metalink search and post to the list. As
usual,
Hi,
I'm a bit late on this thread.
Back in late 2000, we have evaluate query tools.
Brio came up on the short list but the client has chosen Business Objects
products.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514)
Just a personal comment, we run both Microsoft SQL databases and Oracle
databases about 60 servers in each. The organisation is project driven for
that read small independent kingdoms. The impression I have is that the
Windows 2000 operating system is fairly stable, especially when run on
We have SGA's as large as 22 Gb. I don't know that this solves any of the
inherent application problems, but it doesn't appear to cause any problems.
OS here is Tru64.
-Original Message-
One could suggest that they could cache some very large tables in the SGA;
but there seems to be
Title: RE: 9i OCP Upgrade Exam - Again
I have decided to go with your book and the self-test exams. I don't think I am interested in the Benjaman book. I remember you said that the upgrade was the most difficult - and I took note.
-Original Message-
From: Freeman Robert - IL
Just listened in:
Spawned some questions in my mind would like to
know:
-How do you independently verify AIO being used on
OS? Is Direct I/O preferred to AIO?
-If stuck with large disks and multiple heads and
Veritas VM - is it still worth not using SAME but to try to segment certain
Good luck. As way of disclosure, my book was never written to cover the
entire 9i Upgrade Exam. So, make sure that you use the exam objectvies to
shore up on missing areas.
Look me up at IOUG-A!
Good luck!
Robert
-Original Message-
To: Freeman Robert - IL; [EMAIL PROTECTED]; [EMAIL
Please start using STATSPACK now to gather and keep
statistics. You are certainly going to need "before" and "after"
statistics to analyze.
Some questions:
Why does the development group think that I/O is
the problem? Have they been gathering data? Have you seen
it? Do you concur
IIRC, the announcement was that Oracle Names was obsolescent in 9i,
which means it will be desupported completely in a later release.
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle
After reading the magazine at the UKOUG conference,
I checked purchasing Scene. It is 40 pounds a year (roughly $60 American
(IIRC)). It is excellent and worth the $. And it helps support a fellow user
group.
Mark Leith wrote:
I find that the Oracle
Title: RE: Metalink Oracle Support Improving...
Yes,
I understand, bur being paranoid is a constant state of mind here ...
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any
Dave,
that's kind of a different question.
in this case, as others have stated, the order of shutting things down does
not matter too much.
For practical purposes, I would shut the listener down first and then the
database - only because the database takes longer to shut down.
For startup, I
Does it work the way round? Should one call technical
magazine a definitive marketing source?
-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Magazine excels itself
I agree with Roberts about level of exam. His book covers new features.
Poula should buy Danial Benjamin's book as well as your book and STS
pratice test. In case of any clarification , Oracle Docs must be consulted
to understand the concept of new features clearly
Use OTN20 code to get
One additional consideration on this topic is the politics of the situation.
If your shop is one where development has undue influence on upper
management decisions (i.e. the tail wagging the dog), the politics might be
such that garbage is deployed and it's expected that the support people
(i.e.
I know of one system where it would have been
beneficial to have an 8GB buffer_pool_keep
(as you might guess, this was a specialised
telecomms system); but I think the general rule
should be to consider very large memory as a
requirement that has to be proved, rather than
an obvious easy option.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
One of my developers wants to share data between sessions inside a
package. Specifically he wants to set some sort of global variable in
a package that session 1 executes, and when sessions 2,3...n fire a
trigger he wants them to be able to read that
Title: RE: What to check?
All three machines having the same amount of CPUs and memory, and he uses the same script to run on three machines, some of tables containing hundred thousands of records. Below is a portion of his script. Is there a way to improve his SQL command?
@Dumptables.sql
It's a well known fault, digital interference - ask any support guy
they'll be sure to clock digit=finger.
I'd also like to apologise to anyone who got any of my work messages
stating that their message could not be scanned and therefore was the
spawn of satan (or some similar such wording :( ).
Title: RE: Sharing data between sessions
In Oracle all data is session specific ... even package data ... sessions share the package code.
1. Use a small table to share the data.
or
2. Use dbms_pipe to receive request and send out data ... this will act as a pseudo package header for all
Scott,
Try using screen. It is a piece of software using virtual tty 's.
I began using it in 1994 to avoid just such problems.
It gives you some unique capabilities. Start a process from
one client, goto another client, detach and re-attach there.
eg. start a job at home in a terminal
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC
System/6000: Version 2.3.4.0.0.
This afternoon, our users started getting the error message ORA-00018:
maximum number of sessions exceeded. As time went on, the number
of sessions was decreasing (as shown by the count of rows in
Paula - Since the scope of the 9i upgrade exam is so broad, you may want to
consider getting your hands on a copy of the class handout. This is what the
exam is taken from. Myself, I'm always paranoid about over-studying ;-)
-Original Message-
Sent: Monday, March 03, 2003 10:04 AM
To:
one
little piece of information..(considered critical
probably:-) )
There
isn't an opportunity to use statspack... The current application is running on
sybase:-)
I do
have other teams researching the questions you mention. its a real fun
project...
-Original Message-From:
Title: RE: 9i OCP Upgrade Exam - Again
I don't worry about knowing too much about Oracle. At the same time I am worried about maximizing my time as time has an opportunity cost - I have heard that the Benjamin book is incorrect in places. I think Robert's book, the self-tests and Metalink,
Title: RE: Sharing data between sessions
From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]
One of my developers wants to share data between sessions
inside a package. Specifically he wants to set some sort of
global variable in a package that session 1 executes, and
when sessions
Chuck,
Depending on the intensity with which they'd be using this form of
inter-process communication, using a table may be the easiest and fastest
implementation method.
Other possibilities include (depending on desired functionality):
* DBMS_PIPE package (i.e. semantics involve simple FIFO
FYI...
Even more useful than screen is vnc (www.tightvnc.com). It has some of
the same capabilities as screen, but it works like X-windows. Using VNC,
you can start an Oracle Installer session on your laptop, shut it down, go
home, and resume the session when you get where you are going. It is
List,
We
recently upgraded our Production system to 9i and gotburnt by these
bugs.
Installed Patch
List:2785282 [ Base Bug(s): 2442125 ]
Bug # 2808431WRONG RESULTS FOR PARALLEL QUERY WITH HASH AND INDEX
JOIN
Bug # 2783229 Base bug : 2442125 INCORRECT DATA RETURNED FROM DATABASE
WHEN
I don't recall if the V$RESOURCE_LIMIT view
existing in 7.3.4, but you might want to check. It is a better diagnostic
point for that particular resource...
The "init.ora" parameter SESSIONS is related to the
ORA-00018 error message, not any of the licensing parameters. Please use
SHOW
Paula - Here is a pretty good on-line reference. Not quite detailed enough
for the exam, but he explains things clearly.
http://www.oracle-base.com/Links/9inf.pdf
http://www.oracle-base.com/Links/9inf.pdf
One tip I picked up from my Oracle instructor is that most of the exam
questions seem to be
LOL.
This is actually the definition of a marketing white paper, isn't it?
It's a technical document rubbed in marketing stink. I suppose the end
result is that technical people won't read it because it smells like
marketing. The people who are normally susceptible to marketing *can't*
read it
Title: RE: Big SGA...
BINGO!!
The politics is definitely a key contributor to all projects here in this shop:-)
greg
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 03, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Subject:
List,
Has anybody noticed this behavior:
When you create a db with the DBCA in 9iRel2 for unix it does:
usernamedefaulttemporary
_
sys system temp
system
If all you need is tty (character based), then screen should work. If you need a full
GUI
environment, then check out vnc. I use this alot for those 5 hour Oracle Application
Installs.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. --
Sam - what does
SHOW PARAMETER SESSIONS show? Just in case you have another line in your
init.ora file. No, no that has never happened to me! Other than that, I
haven't encountered the problem you describe.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
For GUI, you can use VNC. Or screen utility. Both are
freely avaible.
Or script it and nohup the job on Unix.
Richard Ji
-Original Message-
Sent: Monday, March 03, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
I ran into a problem yesterday afternoon. I had exported a
Sybase, Schmybase, Oracle, Schmoracle -- the
concepts are still the same. Developers create tables and indexes and then
write SQL, thinking that the RDBMS is at fault if performance doesn't match
expectations.
They have to understand that the structures they
have created or the queries
I took this 4-5 months ago and passed with a 97%, so it's not
impossible. It was about twice as hard as any of the 8i tests. It
covers a huge amount of material, and it assumes you have knowledge of
many things that were NOT on the 8i certification objectives. I think I
studied about three weeks
I did the same thing last night to an 8.1.7.4 DB and the Default Tablespace
for SYSTEM was TOOLS but the Default Tablespace for SYS was SYSTEM this
is the way I would hope it would run on 9.2 as well.
-Original Message-
Sent: Monday, March 03, 2003 4:14 PM
To: Multiple recipients of
OK, after emphatically stating it doesn't matter, I thought of a
situation in which the order of shutting down could make a difference.
In this scenario, you first must be the kind of person who needlessly
insists on shutdown immediate (instead of abort). Second, you must
have a very heavy rate
db file scattered read and db file sequential read also end up as null
event in v$session_wait. But the funny thing is that it is correct in
v$session_event.
Anjo.
Jeremiah Wilton wrote:
Null event is the bane of ORACLE 9.X. It pops up uner any
circumstance that you really really need to
Jonathan,
I think you are right, it came out from 7.3. I was working on a 8.0.5 database running RBO and have to use index_ffs to force fast index scan when doing select count(*) on a big table.
Cheers,
Jos
Jonathan Lewis [EMAIL PROTECTED] wrote:
I'm fairly sure it was available in 7.3.3,
Suzy,
DB Artisan was originally written for Sybase, then MS SQL Server, Oracle and
UDB.
It is intuitive and easier to use than most tools for Production Support
(i.e. DDL extraction). When supporting multiple database platforms, the
one-stop shopping console is also a plus.
It used to be a
Hey group --
If I want to have the Reports runtime available, so that I can print and display
reports, do I need to install all of iAS or can I simply install the runtime only
portion?
I can't really find anything that says one way or the other. Most people say to
install all of iAS in
Pop quiz: Think of a parent with a spoiled child
who is making a scene in public. How do you quiet
the child? :-)
I'm not sure if the analogy works. Because with the
spoilt child case, you can in fact treat the symptom
AND solve the problem by throwing resources at it.
Once you have found
David,
That looks like a pretty basic script. There is no ordering, no functions,
nothing at all really except for some basic select statements (assuming
these are all tables and not views). I don't know what is in
dumptables.sql, but presumably it sets the linesize and pagesize and
defines the
Govind.Arumugam,
I also hit two bugs running 9i rac on linux 9.2.0.2.
The first bug is snapshot refresh cannot go on if the data volume is large ,
you have to drop and recreate the snapshot.
19:08:01 SQL 19:08:01 SQL 19:08:01 SQL BEGIN
1 - 100 of 102 matches
Mail list logo