Hi Saira,
maybe temp tablespace isn't large enough.
did you try what the doctor suggests?
Did you enlarge the temp seg?
8-))
hth,
Guido
[EMAIL PROTECTED] 27.07. 05.54
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means
People should not play with the SYS schema, period. No ifs, no buts,
it just isn't done. You are on your own, pal. If I were your employer,
you would have hit the road by now. Whatever application that Maximo
thing is, creating objects owned by SYS is simply not acceptable.
It's guys like you that
Check the block sizes. That part of the argument might still stand.
On 2003.07.27 02:24, Saira Somani wrote:
We are using 32-bit on 5L. I don't think Oracle 8.1.7
is compatible with 64-bit AIX kernel.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Your 1652 error means the following:
01652, 0,
This view is part of the upgrade script provided by the Vendor
(duh):
I've been DBA'ing for 7 years in DB2 and Oracle and messing
around with a SYS view is obviously not done- .
I was looking for some proper advise as Ive never seen anything
like it before.
Sam
- Original Message
May not necessarily mean TEMP tablespace... Check all of your tablespaces
for available free space, that is contiguous freespace.
-Original Message-
Guido Konsolke
Sent: Sunday, July 27, 2003 3:04 AM
To: Multiple recipients of list ORACLE-L
Hi Saira,
maybe temp tablespace isn't large
There is a 64 bit version of Oracle 8.1.7 for AIX available. Check your
$ORACLE_HOME/lib directory. If you have a lib64 or lib32 directory, then
you have the 64bit version.
RWB
As suggested, we checked all the tablespaces.
TEMP space was increased from 2GB to 4GB and then to
6GB.
We ended up bouncing the Oracle instance each time
TEMP filled up because we really had nothing to lose.
After doing this 3 maybe 4 times, we ran the same
scenario in the application and this
Sam
Well, sometimes ya just gotta tell the vendor NO. I would start by
explaining to the people in your organization and the vendor why this is a
very bad idea, totally unsupported by Oracle. If due to the local politics
this isn't feasible, make sure you keep this application on its own
Short form of my question:
How can I enable a Role for a User within a database trigger (owned by another Schema) on a table owned by yet another Schema?
- The M's I've RTF'd indicate that a trigger (and any procedure it calls) can never execute with Invoker's Rights.
- I can't find a way to
Jack,
Question - why do you want to use System triggers
to change roles? I don't see how you can define an event for this trigger to be
fired. If the event is the updating of record in USERS table, who updates it?
Obviously not the user himeself; then the whole system becomes insecure to
This is probably too kludgy or simple-minded, or non-maintainable, but is it
technically possible?
1) Create a series of views that subset
the actual tables, according to the rules
you've got about who the viewer is what
year(s) they've selected in the Users table.
2) Redefine
If you have been a DBA for 7 years, then you know the procedure:
Go to V$SESSION_WAIT and see what are you waiting for. You'll get file
and block (P1 P2), so you can locate the segment. Do explain plan and
see how this segment is used. In my experience, it's usually an index used to
retrieve the
Hmm... absolutely no responses.
Perhaps a bit of clarification is in order.
I'm interested in comments only on the content.
This was a write as a you go paper and decidely
not publishable as is. If it seems worthwhile, I will
rewrite into something a little more acceptable than
the very
Thanks, I'll do that if I hit the problem again..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 1:54 AM
I own the list, that is, the logical entity.
Bruce Bergman is owner of the ISP, fatcity.com, and
the sysadmin
Hi!
I have a suggestion as well:
Tempfiles are sparse files in unix, that is you can use alter tablespace
command to add or resize the files even to 100G if you want, but they don't
actually use much space on disk. When you start writing to this file, OS
tries to allocate more real space to it
Hi!
How did you check that temp ts was filling up? From v$temp_space_header?
Could it be that some execution plans have changed that huge sorts (of
cartesian joins) are done instead of index scans etc..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Technically possible, but prpbably not practical.
You have to create several views for each of the users; possible - but may
become unmaintainable. FGAC may be a btter maintanable option, IMHO.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list
Sam:
The proper advice is not to do it. Also, warn the vendor that what they are
doing will possibly void the support contract with Oracle for any of their
customers that use their softwarre. Ask Oracle about it to get their
opinion, but I'm sure they will tell you that if you alter the Data
Hi!
This is probably too kludgy or simple-minded, or non-maintainable, but is
it technically possible?
1) Create a series of views that subset
the actual tables, according to the rules
you've got about who the viewer is what
year(s) they've selected in the Users table.
2)
Hi DBAs,
I am very new to data warehouse and I am looking for bullet list, URLs,
etc. that list what are the essential data warehousing requirements
that needs identifying. I know you obviously have to understand the
business prior to identifying requirements. I assume some of the
I am not an expert on Oracle Apps, but those session environment variables
are probably application context attributes I mentioned earlier. They can
also be implemented by a package global variable; but there is no security
in that; the user will be able to set the variable in anyway he wants.
Hi!
Yep, security wise this solution was not good, Apps uses acutally
dbms_application_info.set_client_info procedure (which sets client_info
column i v$session). That's quite old mechanism, but yeah, one could set
anything for it's value (although IIRC, Apps user had to execute it through
1)for temp usage check v$sort_usage while application/job running. It is
some code which may be resulting in cartesian join using hash join.
2) check for parallel degree in tables or indexes (dba_tables or
dba_indexes) 'select table_name,degree from dba_tables where degree 1; or
same for
Arup,
Thanks for your reply. As I said in my memo, I really want the User's Role to be changed from within a Trigger on a table, not a System Trigger. Actually, it doesn't matter, since no database trigger can be defined with Invoker's Rights. That means that any trigger in which I issue execute
Hello list ,
Performance tuning docs say that : To enable the caching of session
cursors you must set the initialization parameter set
session_cached_cursors. You can also enable it dynamically with alter
session set
But neither of the following works on 9.2.0.1.0 enterprise edition (win32)
Rick - Check out http://www.ralphkimball.com. He has written articles for
years on this topic and has them posted on his web site. His books are also
great.
One thing that is different from the normal applications is the user
participation. If you develop a payroll application, for example,
Jack,
After theclarification, my recommendation actually
holds more ground - I hope you can see that in the explanation here. Creating
views are not practical due to the number of users and year combinations
involved. Since you are using FGAC, that is precisely you should
do.
you wrote
Thanks, Chao Zhu.
Since the query column in user_mviews is long data type, when I select
query from user_mview, I can only see part of select statement. Even set
linesize doesn't help.
One more, what I want is to compare two select statements in querie
column. But with query long data type, I
Hi Tanel,
thanks a lot for your wonderful explanation.
sorry to pester u you again with my doubts on
the first day of the week.
My only doubt is:
1.After analyzing the index,CBO doesn't read the index because
it is costlier in terms of I/O and other resources.
2.But
David,
search at www.orafaq.net
though late , hope i helped u.
Jp.
26-07-2003 20:34:25, Ehresmann, David [EMAIL PROTECTED] wrote:
How do I search the archives of this list?
thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
use set long 4000 or whatever instead of set linesize and try.
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sun, 27 Jul 2003 18:19:24 -0800
Thanks, Chao Zhu.
Since the query column in user_mviews is long data type, when I select
query from
Guys,
SET AUTOTRACE works fine on the Database server machine.
the database server ENV is 9.2.0.3/Win2k AS - With SP3.
SQLconnect cti/cti;
SQLset autot trace
SQL
whereas when i try the same from a different machine,i get the error below.
{ this client machine has 9.2.0.2/Win2K server - with SP3
Didn't get a change to read it yet,
but if it makes you feel better,
I REALLY DID bookmark it to read later,
when I thought it might apply to me.
Currently in the big blue world
(Oracle on the mainframe) and Veritas is just
a pleasant memory :-(
Babette
-Original Message-
Jared Still
Ok I will go one better and say I actually did have a look at it at first
glance it looked a bit like my first effort of dealing with RMAN, and
Veritas, I will have a better look now I am back in the office and see if
i can add some useful comment.
Cheers
--
I saved the article but not having too much experience with the database
duplication using RMAN, I have no comment to make. I can send you the document
in the PDF format, instead of DOC. OpenOffice 1.1 has that possibility
On 2003.07.27 23:54, Babette Turner-Underwood wrote:
Didn't get a
In continuation of my previous mail :
just now i upgraded the cleint to 9.2.0.3 ,
and tried it once again. IT WORKS
i simply wonder why ?!
is this a bug in 9.2.0.2 ?*!#$#*
Thanks and Regards,
Jp.
28-07-2003 12:49:24, Prem Khanna J [EMAIL PROTECTED] wrote:
Guys,
SET AUTOTRACE
dear list, can anyone please point me to a simple
example of select * from emp; query
and the output displayed in xml (using a simple
stylesheet) ...
we have not beenable to locatethis on
the net...
TIA
-Rahul
Hi
Rahul,
Have a
look at http://otn.oracle.com/tech/xmland
also 'Oracle Application Developers Guide - XML'. There is a utility called XSQL
which does this for you. Here's an example of that utility cut from the above
mentioned guide (for 8i):
declare
queryCtx DBMS_XMLquery.ctxType;
Rahul,
i read an example for the same in the last edition of Oramag.
turning a few pages of it might help u.
Jp.
28-07-2003 15:09:24, rahul sharma [EMAIL PROTECTED] wrote:
Date:Sun, 27 Jul 2003 22:09:24 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I havent got original Subject e-mail as it is on my home PC.
Firstly let me just say how I like to use this list. As I am completely
different time zone to you guys i.e. I am Brit living in Middle East,
also our weekends are thu/fri - by the time I read posted questions
they are usually well
40 matches
Mail list logo
