Sure
THanks Omar
But I was looking for a
'non-file based' solution :)
Thanks anyway
On Mon, 07 Oct 2002 Omar Khalid wrote :
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then
Stéphane,
Thanks for response.
I have always discplined myself to use star schema and
never snowflake.
Would you mind asking why?
The Which one is easier to implement and easier ETL
? is not a good question as your data model should
not be design for the ETL procecess but only for the
Title: Message
Hi guys.
That Siebel note about
CBO that was asked for.
George
George
Leonard
Oracle Database
Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel:(+27 11) 575
0573
Fax:(+27 11) 576
0573
Evidently not...
SQL grant dba to blah identified by blah;
Grant succeeded.
SQL conn blah/blah
Connected.
SQL create table IOT ( x number primary key,
2 y char(100) ) organization index
3 including x overflow;
Table created.
SQL select segment_name from user_segments;
SEGMENT_NAME
Had it for ages - I think I put it together 'round
8.1.5 when dbms_stats was looking good, but still
didn't work at all well at the SCHEMA or DATABASE
levelwhich of course, is probably still the case
:-)
The main thing of course was being able to control the
sample size based on segment
Title: RE: Remember me? Oracle DBA veteran considering getting certifi
I expect that there are plenty of copies
still in circulation but to my knowledge coriolis is
no more shame, really, although the exam cram books tended to have
quite a few errors they were an excellent portable
Yes, you can change your listener.ora file permission up to 600 on the
server side. In a shell script you can then use encrypted password found
in listener.ora on line PASSWORDS_listener.
lsnrctl EOF
set password C6C144CF750E3CA5
stop
exit
EOF
If the password is not in the listener.ora file,
Qs log_checkpoint_interval - Is there any Upper Limit to Setting it's Value on Oracle
8.1.7 ?
NOTE - On a Hybrid 150 GB Database (Oracle 7.3.4) on setting increasing it's Value
from
4,70,000 to 10,00,000 we had faced a Huge performance problem had Scaled it Down
back
to 4,70,000
NOTE -
Its worthwhile noting that from 8.1, these parameters
are the not the same old when we hit the threshold,
do a full checkpoint. They more set a limit on how
out of date your datafiles are allowed to get, that
is, you end up with a changes dribbling out to the
files rather than the big checkpoint
log_checkpoint_interval is specified in number of OS Blocks. Depending upon
the size of ur OS Block it will force a checkpoint after that many number of
bytes written in the redo buffers.
Normally it should be a divisor of the redo log size, means for 500MB it
should be 1MB, 2MB, 5MB but not 7
Hi ALL!
I tried install Oracle9i (9.2.0.1) client on Windows 2000 server (sp2).
First screen (for installer) show up in grey color and after I press NEXT I get this:
Can't find bundle for base name OUIVersion locale.
This is first Oracle install on that box.
Any ideas?
Thanks.
Greg.
--
Please
Hi! DBAs,
If I modify the "Process" in init.ora after database
was created and running for quite a long while,
is it true that the maximum of the
process will increase as what i changed?
do i need to change anything?
init.ora will be used everytime the database start,
right?
or just for
Naveen
There was a Database-wide slowdown in execution of ALL Processes with 1000 user
processes
doing Mostly OLTP Operations .
We Reset the Value Back from 10,00,000 to 4,70,000 performance came back to Normal
We never tried such a Value in Oracle 8i version
NOTE - This was Done on a
INIT.ORA is looked up at the time of STARTUP only.
PROCESSES cannot be changed until the DB is bounced. To see whether a
particular parameter can be modified without bouncing the DB query the
V$PARAMETER view
Regards
Naveen
-Original Message-From: [EMAIL PROTECTED]
Yes, init.ora will be used every time database
starts.
And you need to do some RTFM.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
shuan.tay(PCI¾G¸R³Ô)
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, October 08, 2002 9:23
AM
Subject:
Doug Burns wrote a very informative paper on Decode, presented at an earlier
UK-OUG meeting. Its available from his web site:
http://doug.burns.tripod.com/decode.html
And the answer to the question posed below is 'yes'.
peter
edinburgh
-Original Message-
From: Droogendyk, Harry
I've installed 9.2.0.1 client on 2000 with a previous
8.0.6. client and both are working perfectly.
Gabriel
--- Greg Faktor [EMAIL PROTECTED] wrote:
Hi ALL!
I tried install Oracle9i (9.2.0.1) client on Windows
2000 server (sp2).
First screen (for installer) show up in grey color
and after
Title: Message
Yes,
the process parameter will be increased to the value you
changed.
The
Init.ora, parameter file, is used anytime you start your DB.
Probably you should check the parameters for the SGA.
Luck
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Title: RE: Remember me? Oracle DBA veteran considering getting certifi
Yes,
they were concise and just what was needed - there were some errors - really not
soo much in Mike Ault's. However, for one shot study guide -
great!
-Original Message-From: Bishop Lewis
[mailto:[EMAIL
Add a local disk to one of the machines and put your Rman catalog there.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 8:31 PM
List,
With all of the recent discussion and the forth coming books and
Grant,
Thanks for the short answer, is there anything in the long answer, that I
should warn the developer of?
Thanks,
Bryan
-Original Message-
Sent: Monday, October 07, 2002 8:53 PM
To: Multiple recipients of list ORACLE-L
threads?
Rodrigues, Bryan[SMTP:[EMAIL PROTECTED]] wrote:
Hi
Snowflake is often used because people still want to
normalize (and save some disk space !) which is not
the way to go to ease query.
If you do an hybrid data model, your loading will be
easier as you will have less problems to solve.
I agrre with you, the complexity comes from the number
of
The parameter will take effect only the next time you start the database
instance. Till then,
the instance will continue running with the value that was set when the
instance was last
started.
You can change init.ora parameters [except for DB_BLOCK_SIZE and DB_NAME]
after the
database has
Omar,
If what you mean is:
How do I send a value from sqlplus plus directly
to a variable in my shell environment?
You can't.
What you've done is the way it is usually done.
Another way to do it is to use the '|' korn shell mechanism.
e.g.
sqlplus -silent scott/tiger@$ORACLE_SID |
This
In 9i,
a new parameter file called SPFILE is introduced.
A
SPFILE enable you to self-tune the parameter values that are
recorded in the file. You can use
ALTER
SYSTEM parameter = value [ SCOPE=MEMORY|SPFILE|BOTH]
command
to
change the values of the dynamic instance parameters.
Thanks.
Hi,
I am installing Oracle 817 on a Window 2000 SP2 system. The install stops
with an O/S error starting service OracleORANT817Agent. The Application
Event Viewer message is OracleAgent failed to run auto-discovery script
nmiconf.tcl. Look in the nmiconf.log for more information. There is no
Thanks for everyone who replied!
by the way, why can't i get the mail that i
sent?
i used to receive what i sent.
regards
Has anybody tried
installing it? Any experiences/remarks/problems/rantings?
Any RH 8.0 comments
in general?
Actually Jared, you can by setting up a sqlplus coprocess and using unix
pipes. The routine below will get a parameter from the v$parameter table
using sqlplus.
Kevin
===
get_db_parm()
{
unset vRETURNED_PARM
unset vRESPONSE
typeset -u vPARM
Currently we have the following configuration.
E450
3 - 250 MHz processor
1 Gb Memory
3 - 9Gb 2 -18Gb disks
We are running Solaris 8 and Oracle 8.1.7.2.
We currently have 3 databases.
One is a catch all of smaller apps. Its current size is 2.5 Gb and will grow slowly at
maybe a half a
Kevin,
Thanks for the 'coprocess', I couldn't remember what it was called.
This is what I was describing in my previous email.
Jared
Kevin Lange [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2002 09:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list
I don't work with Oracle Reports but one of my co-workers does. His
problem --- TNS can't find the database.
He has three Oracle homes. I've copied the good tnsnames.ora to all of his
homes (I know about the NETWORK and NET80 directories).
It's Report 6i on a Win2K machine trying to connect
David - I don't see where anyone has posted a reply to your question, so
I'll try to at least give you some feedback. Will both machines be running
Unix? My gut feeling is that the HP can support many more users because it
will have better I/O. For databases, I/O is a rather critical performance
Just deny login if your trigger does not know the program.
Check the archives for example scripts for login triggers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 8:08 PM
Oups ! you're right.
Hello,
I successfully traced a long running session by using dbms_system.set_ev
procedure, and moved the trace file to somewhere else. However, when
I used the same command to re-trace the same session, I can't see the
trace file again. There was no error message. I tried to use oradebug
and
Alexandre
Stephane gave you an excellent reply. If you want to learn more about
these DW design issues, I would start by visiting
http://www.ralphkimball.com. He is one of the leading figures in the DW
field, and has copies of all his articles posted on his site. I would start
with the oldest
Yechiel,
this is a never-ending chase. security by attempting to control what
program is to be used is useless. it will always be broken - or the DBA
will always be stuck monitoring what is being used.
security based on Oracle Roles is the only good answer.
Tom Mercadante
Oracle Certified
If you are running a UNIX variant, then the Oracle server process which was
writing to the trace file probably still had a file handle open on it. On
some platforms, you can use the fuser command to verify this...
So, when you re-initiated tracing, it was still trying to use the existing
file
Hello Folks,
I carried out a test, whereby I had just one rollback segment online with a
block size of 2K, and then running updates against the database thru
different sessions without commiting any of them? As expected, it accepted
the first 21 transactions, and on the 22nd transaction, threw
make sure you also copy a good sqlnet.ora file. This file has you default domain, etc.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Tom,
The problem is that you moved the file.
Oracle will use the same file name, when you
stop/restart tracing, and in fact leaves the file
handle open until the session disconnects.
Moving the file disables the output.
Jared
Xie, Tom [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
(just kidding)
No more RBO as of 10i...
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=189702.1
10i? I haven't even upgraded to 9i yet because none of our vendors
have, either.
Rich
Rich Jesse System/Database
Don't move the file if you are on UNIX and the session is still running.
Just copy the file. The trace file is closed when the session ends.
Anjo.
Xie, Tom wrote:
Hello,
I successfully traced a long running session by using dbms_system.set_ev
procedure, and moved the trace file to
http://www.orsweb.com/downloads/source/440.html
I don't think this would prevent determined people from logging in though.
IP addresses, machine names and program names can all be spoofed.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
If the problem is not the sqlnet.ora, check if he has TNS_ADMIN set in any
of his ORACLE registry keys.
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Tuesday, October 08, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
make sure you also copy a good sqlnet.ora
How would I find out the exact SQL statement? I can locate the
SQL_ADDRESS from the v$session table but I do not know where to go from
there.
I am running a query via an OLAP tool (Cognos Impromptu) and it is
taking an excessive amount of time. I suppose it would also be a good
idea to find if
Ahhh I had not seen that part of the response. Well, now they have a
sample of just how complicated it can get.
-Original Message-
Sent: Tuesday, October 08, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
Kevin,
Thanks for the 'coprocess', I couldn't remember what it
Jared, Tim and Anjo,
Thanks for your help.
In fact, I stopped the tracing first, then cp the trace file to other
directory and rm it.
Also I can't trace other sessions now.
Tom
-Original Message-
Sent: Tuesday, October 08, 2002 12:41 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Title: RE: But I *want* to use RBO!
9i is also being de-supported soon ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
Title: RE: But I *want* to use RBO!
9i is
being desupported soon? you really must be joking.
At
least I hope you are.
Oracle, if it is moving this fast, is going to hurt themselves. We
can't move that fast.
Tom Mercadante Oracle Certified Professional
-Original Message-From:
select v$sql.sql_text
from v$sql, v$session
where v$sql.address = v$session.sql_address
and v$session.sid = sid;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 3:08 PM
How
Title: RE: But I *want* to use RBO!
Metalink Note: 201685.1
Product Details:Platform(s) Details:
Product: Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition
Product Version(s): 9.0.1 (9i)
Platform(s): ALL Platforms
Platform Version(s):
Title: RE: But I *want* to use RBO!
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
No more RBO as of 10i...
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT_id=189702.1
Does this mean Oracle is getting rid of their data
9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003.
-- yes in like 8 months
9.2, aka9ir2, ECS ends sep 30, 2005.
joe
Last I saw, version 9.0.1.x is scheduled to be desupported in June of '03.
I haven't seen any desupport date for Rev2 of 9i which is 9.2.0.1.
We've upgraded from 9.0.1 to 9.2.0 in order to avoid any issues with
desupport before we even get our product to market which we've been
developing on 9i.
Rajesh:
The header block of the rollback segment contains the transaction
table and this is roughly equal to the ITL in the data block headers.
And number of transaction slots depends on the block size and for a
2k Block size you get 21 slots.
The transaction slots in the rollback segments
So every few months my Lookout reminder pops up to remind me to check out what new
Oracle books have been released. I stumbled upon a new book called CodeNotes for
Oracle9i on Amazon.com, but the interesting part is that it is available in eBook
format. Here's the (probably broken) link...
It's dependant on block size, or at least it was the last time I checked,
which was a few years ago.
You can see the number of slots by doing a block dump the rollback
segment.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2002 11:34 AM
Please respond to ORACLE-L
Title: RE: But I *want* to use RBO!
9iR1 or 9.0.1 isscheduled to
be"de-supported" as of June 2003. No "extended support" (i.e.
possibly translates to "we'll take more of your money beyond what we're already
taking"?) will be offered, but "extended assistance" (i.e. possibly translates
to
Title: RE: But I *want* to use RBO!
The well-known problems with using CBO to query the
statistics-less data dictionary had been resolved in Oracle9i, as discussed in
an earlier thread on this list. Not sure how they fixed it, but I suspect
that Oracle is not throwing away the RBO code-base,
Wait a min... Apps isn't even certified on
9.2 yet!
April Wells Oracle DBA Keep yourself
well oiled with life, laughter, new ideas and action. Otherwise you will
rust out. _Anonymous
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002
Sorry if I did not phrase my question correctly. I do know that for a
database with block size 2K, the number of max transaction slots is 21.
When I was running my tests, I was expecting to see an Out of transaction
slots on the 22nd session. Instead Oracle tried to use the system rollback
Only 9.0.1 (June 30, 2003). There is no desupport notice for 9.2.
You'd be better off on 8.1.7, which is supported until Dec. 31, 2003.
"Mercadante, Thomas F" wrote:
9i
is being desupported soon? you really must be joking.At
least I hope you are.Oracle,
if it is moving this fast, is going to
Will 9i Release 2 be the final version for
9i?
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques Informatics
Branch | Direction de
l'informatique Maritimes Region,
DFO |
Good. Is anybody here ORacle12i
certified?
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 3:59
PMTo: Multiple recipients of list ORACLE-LSubject:
oracle 9i desupport dates
9.01, aka 9ir1 Error correction support(ECS) ends jun
I made a mistake. In fact, I can trace other sessions.
But I can't re-trace the session of which trace file
had been removed.
Is there any way that I can re-trace the session without
restarting the session?
Tom
-Original Message-
Sent: Tuesday, October 08, 2002 2:14 PM
To: Multiple
Looks
like, but 9202 will be coming out in about 4-5 days and 2903 is schedules for
Feb03.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is personal
and doesn't reflect that
Thanks Gopal for the info provided. I would want to know how I can simulate
this error? I did some tests but I got an Unable to use system rollback
segment for non system ... .
We had one of our applications report this in the application log. I am
trying to find out why?
Thanks
Raj
Rajesh,
Your database has probably only the system rollback segment. Oracle will
probably leave a slot open so in that rollback segment. Create an
additional rollback segment and you will probably see the error.
Anjo.
[EMAIL PROTECTED] wrote:
Sorry if I did not phrase my question
Yes. 9i
Release 2 is the final version of 9i. Thats why its desupport date is so much
further out.
Bill
Carle
ATT
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
-Original
Message-
From: Boivin, Patrice J
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002
Is that a new requirement for the OraStaff DBA position?
[EMAIL PROTECTED] 10/08/02 04:33PM
Good. Is anybody here ORacle12i certified?
-Original Message-
Sent: Tuesday, October 08, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
9.01, aka 9ir1 Error correction support(ECS)
Oracle 29? We are wy behind the upgrade curve. Yikes. ;-^)
On Tue, 2002-10-08 at 15:54, Jamadagni, Rajendra wrote:
... and 2903 is schedules for Feb03.
Raj
__
--
Rodd Holman
Enterprise Data Systems Engineer
Title: RE: oracle 9i Desupport dates
oops that's what happens when you are refreshing 3 databases on three machines.
Please read it as 9203 ... due out Feb/03.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
Certainly a lot of the recursive SQL I've seen in
traces is riddled with ORDERED, FIRST_ROWS or a long
explicit list (ala outline style) hints
You get the feeling it was:
- explain SQL under RBO
- not down plan
- craft hints to make sure it does it under CBO
Cheers
Connor
--- Tim Gorman
Anjo,
To simulate the ORA-1554, I tried the following, which I think, is along
the same lines you mention :
1. Created a database with block size 2K.
2. Created one rollback segment in the tablespace RBS.
3. Started 21 session all updating different tables, and not commiting.
4. v$rollstat at
Igor Neyman wrote:
select v$sql.sql_text
from v$sql, v$session
where v$sql.address = v$session.sql_address
and v$sql.hash_value = v$session.sql_hash_value
and v$session.sid = sid;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Regards,
Stephane Faroult
Oriole Software
--
Please see
Title: RE: oracle 9i Desupport dates
I figured as much, but with the rate at which Oracle is releasing new versions it just might be.
Rodd
On Tue, 2002-10-08 at 16:39, Jamadagni, Rajendra wrote:
oops that's what happens when you are refreshing 3 databases on three machines.
This is pure conjecture with a little bit of old 'knowledge' tossed in, but
it does explain the scenario. Any and all corrections to my
knowledge/reasoning are VERY welcome. I could test, but that would take too
long to provide the answer in a timely manner.
Explanation of test scenario:
I
Has anyone worked with 9i in combination with BLAST? Just looking for
feedback positive and/or negative.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric Richmon
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Rodrigues, Bryan[SMTP:[EMAIL PROTECTED]] wrote:
Grant,
Thanks for the short answer, is there anything in the long answer, that
I
should warn the developer of?
We had some nasty problems with early version 8 drivers with thread
safety, but I could never determine if this was our code or
But, Of
Course! They need all the time to get all the
bugs fixed. ;)
-
Kirti
-Original Message-From: Carle, William T (Bill), ALCAS
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 3:59
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
oracle 9i desupport
good question,. as it looks right now, yes.
joe
Boivin, Patrice J wrote:
Will 9i Release 2 be the final version for 9i?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Mladen, i've got a presentation in st louis on thu, probably this
weekend, i'll give it a whirl and let you know.
Joe
Gogala, Mladen wrote:
Has anybody tried installing it? Any
experiences/remarks/problems/rantings?
Any RH 8.0 comments in general?
--
Please see the official
Mladen, i've got a presentation in st louis on thu, probably this
weekend, i'll give it a whirl and let you know.
Joe
Gogala, Mladen wrote:
Has anybody tried installing it? Any
experiences/remarks/problems/rantings?
Any RH 8.0 comments in general?
--
Please see the official
Oracle only supports RH 7.1, SLES-7, RH Advanced Server 2.1. Right?
I understand Oracle is having problems supporting RH 7.1 but they won't
admit it to the general public. So even official RH 7.1 support could be
risky. ;-) Any rumors?
On another note, I've heard that RH Advanced Server 2.1
true officially, so i live on the bleeding edge when it comes to oracle :)
joe
Orr, Steve wrote:
Oracle only supports RH 7.1, SLES-7, RH Advanced Server 2.1. Right?
I understand Oracle is having problems supporting RH 7.1 but they won't
admit it to the general public. So even official RH 7.1
Title: RE: But I *want* to use RBO!
Not
sure about their Optimizer migration strategy. Would it be better if they
allow
us to define the constants for the Optimizer when there is no
statistics?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
88 matches
Mail list logo
