Dear :All
Well we did not buy any application packages.
Currently we are using open source product ...which
is Apache and Tomcat.
By the way, have anyone ever have more than 5 database
under a single server ? I heard that the best practice
is to have 1 database n 1 application in a single
Not quite true, in 3 tiers architecture, DB should last tier and application in middle
tier.
Well depend on your company budget and the size of everything and consideration of
high scalability system, and future upgrade.
Your manager, see everything from cost or license point of view, I believe
btw, Oracle 10g can add new servers to your database's tier like plug and play (same
OS).
This is what the guy at Oracle 10g seminar told me. He said what an administrator need
is Internet browser.
Sinardy
-Original Message-
Sent: 26 December 2003 15:14
To: '[EMAIL PROTECTED]'
Not
Thanks.
Regards,
B S Pradhan
-
On Fri, 26 Dec 2003 zhu chao wrote :
Hi,
To see why oracle choose FTS, alter session set events '10053 trace name context
forever,level 2';
You can do alter session to change index_adj and optimizer_index_caching to
change only
We have 13 databases (and instances) of approximately 17G each on a
RISC/6000. We have 6 database/instances on a Win2K box. Two of those are
in the 17G range but the rest are smaller. But it's not the disk size
that's important, it's the SGA size.
i believe tom kyte recommends putting them in one or a few instances and using VPD to
handle security. He claims it scales better. I believe its in his second book and on
his website.
However, Thomas is right. You really dont want 13 instances together for maintenance
reasons. Some may need
It suddenly popped into my head a couple days ago that there could be a
problem with the script (isn't it crazy what the subconscious mind does?).
Note that when it cd's to a new directory, it ASS-U-MEs that it can do that;
and then it calls the script again. I haven't verified if for sure
Im sure its a privilege issue.
1. I have 3 tables with two different owners
2. I want to create a materialized join view of these tables in a 3rd user account.
3. I altered the session to enable query rewrite and query_rewrite_integrity=trusted
4. I granted query rewrite enabled to every owner
Hello list I am using Oracle 9.2.0.1.0 ,
Consider the merge command :
merge into table1
using
on (column matching condition)
then
update set .
when not matched then
insert values ...;
Is there a restriction that the column specified in 'column matching
I figured it out.
I have another problem. I create my materialized view. I now want to write a query
that joins it to a transactional table. I want to use query rewrite. Problem is the
join is not on the primary key of either table.
Is it possible to enable query rewrite without that? I have
public synonym?
ryan_oracle
What is ITL ?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 24, 2003 4:59 PM
Just the previous version of the changed columns,
plus an overhead of about 80 bytes which relates
to ITLs, linked lists, operation descriptions
I figured it out. I need some help with query re-write. Im not sure its possible.
My materialized view joins 3 tables on the primary key/foreign key. I have a query
that would join that materialized view to a third transactional table, but that join
is not on any primary key or foreign key.
I
Warning: I have not actually used query rewrite in this way, so take this
with a grain of salt.
If you're joining the MV directly to a table, what is there to rewrite?
If you were joining the tables that make up the MV, and doing so
on the same key that was used to create the MV, and joining
my bad on the explanation.
I have 4 tables. 3 are non-transactional. These are joined in a primary key/foreign
key relationship. These are going in the materialized view.
I want to join my 4th table to my materialized view.
1. The application current has code that joins all 4 tables. I dont
ITL = Interested Transaction List
The entries are used for locking.
See the following articles on ITL
http://www.jlcomp.demon.co.uk/faq/locked_rows.html
http://www.ixora.com.au/q+a/0010/13133621.htm
Jared
Akshay Kumar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/26/2003 10:54 AM
Starting an upgrade project for 8i to 9i R2. How can I come up with a
reasonable starting value for the pga_aggregate_target
parameter?
Jeffrey
BeckstromDatabase AdministratorGreater Cleveland Regional Transit
Authority1240 W. 6th StreetCleveland, Ohio
44113
Hi,
Can I install oracle8i on Linux without using vncserver? Like set up the
display and run runInstaller.
thanks
-seema
_
Take advantage of our limited-time introductory offer for dial-up Internet
access.
Read the PGA section of the performance tuning manual.
It's pretty good, tuning the PGA is fairly simple.
If you are using statspack, the pga data will give you some good history.
I have some scripts I can share if you like, let me know.
Jared
Jeffrey Beckstrom [EMAIL PROTECTED]
Sent
Seema,
Why would you need vncserver to install Oracle? Are you trying to
install Oracle on the Linux box from a remote location?
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
-Original Message-
Seema Singh
Sent: Friday, December 26, 2003 3:04 PM
Jeffrey,
If you are simply looking at a conversion from 8i to 9iR2, and you're not
going to be implementing a bunch of new 9i features (that could affect PGA
usage), then it's probably reasonably straightforward. You can look at
'session pga memory' and 'session pga memory max' statistics in
Anyone have problems with pga_aggregate_target on
Solaris. Richard Foote wrote the following about HP-Unix.
Is there any way to give say 75% of pga_aggregate_target
to a single session? The reason I am asking this is -
sometimes we need to build an index as soon as possible
and the index creating is the only thing running and
other applications are stopped waiting for the index.
Thanks,
Roger
You might experiment with;
alter session set workarea_size_policy = manual;
Jared
Roger Xu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/26/2003 01:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Normally you can get extra tables involved
with an MV by creating a Dimension that
describes all the relationships between the
tables in the MV and the tables outside the
MV - but the only times I've done this, the
extra tables have always been at the parent
end of a parent/child link to a table
For special cases like that I would switch the
session back to a manual workarea policy and
set a suitable sort area.
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.
To be honest I'm not sure why such a feature is available!
I have not used it so I'm not really qualified enough to judge it.
But in my opinion, a session asks for memory because it needs memory.
So is it possible that a session is asking for memory that it does not
really need and it can
Waleed,
Please feel free to determine the answers to those questions. :)
Jared
Khedr, Waleed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/26/2003 03:39 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Are there any performance issues arising ? MM I have
no idea abt SGA . When i started installed the dbase i
just follow the default value.
JKEAN
--- Thomas Day [EMAIL PROTECTED] wrote:
We have 13 databases (and instances) of
approximately 17G each on a
RISC/6000. We have 6
Really hope that i won't screw up the database. If He
really did insist to have single instance, then up to
him to decide. I still have no authority to said no.
JKEAN
--- [EMAIL PROTECTED] wrote:
i believe tom kyte recommends putting them in one or
a few instances and using VPD to handle
Vivek - Sorry for the late reply, but I just returned from holiday and don't
see where anyone has replied to your posting.
My understanding is that your situation is exactly what Oracle has
anticipated with Std. vs. Enterprise. Oracle's goal is that all differences
be code-independent, so that
31 matches
Mail list logo
