Title: RE: 10i
No... Green button is only for sure on sql navigator.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.
~ Jerry
Jared,
It's rather simple. If you follow the rules of third normal form you have a
table with a certain number of rows, a second with a certain number of rows for each
row in the first table. Obviously the second table needs more space than the first.
Now if you use Dictionary
Look for the files named somehing like ora_p00*.trc in your BACKGROUND_DUMP_DEST
directory. If the errors are ora-0600 or ora-7445, contact oracle support. The most
likely thing that is happening is that parallel query servers are running out of
stack. May be you should decrease sort/hash area
Tim,
First, i would like to thank U a million.
It was a real GOOD explanation.
I don't know why should you apologize for helping me.
I should be thankful to u for helping me in time.
GREAT to have guys like u in this list.
Knowing is GOOD.
but making others know it , is GREAT.
thanx for your
I think the problem is skip_unusable... isn't an init.ora parameter. At
least it wasn't in earlier versions. You can set it at session level
'alter session set skip_unusable_indexes...'. I ended up adding it to a
logon trigger to make it affect all sessions.
HTH.
-Original Message-
Is that the green button that once pushed makes the database unbreakable?
-Original Message-
Sent: Friday, May 30, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L
who promoted you to traffic cop?
this is the only way I'm able to hear about the new green gui button.
yes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Munish Bajaj,
If you want your OS users to log into your
database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracles
default is OPS$. If your OS user account is JOE. Oracle looks at this account
as OPS$JOE. The
Or, is it the green button next to the text Order Oracle Management
Services on the Oracle website? ;)
-Original Message-
Dave
Sent: 30 May 2003 14:35
To: Multiple recipients of list ORACLE-L
Is that the green button that once pushed makes the database unbreakable?
-Original
Please don't unsubscribe. There are tons of lurkers like myself who tune in
to drink from the fount of knowlege that gets poured out here. The best way
to learn this stuff is to listen to these gurus in the informal world of this
list.
Rodd Holman
[EMAIL PROTECTED]
On Friday 30 May 2003
Jeremiah,
Where do you get 128Gb?
For 2000 users that is ~65M per user, which
seems like an excessive estimate.
While I probably wouldn't want to run 2k users
on a single Windows server, I think you could
do it for test purposes.
Use orastack to reduce the memory per thread to 500k,
set
These are awesome suggestions .. thanks.
Creating a local index on accounts - I can do this.
Call_id ='0' it is the number zero and considered a lead row. This row is duped and filled in with a real call_id when a call is placed. Eventually this row with call_id are removed in the archiving
Title: RE: 10i
[ Press Big Green Button ]
sqlplus /nolog
sql connect / as sysdba
connected
sql alter system 'immediate big green button, level push';
Button Pushed.
Connecting to internet www.bgb.oracle.internal.com/action="">
Connected and data pushed to the server.
Disconnected.
Hi Group,
I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).
Expecting ur help.
Thanx For All,
Senthil.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
INET: [EMAIL
This is off topic as far as oracle goes, however we are all interested
in storing and querying data. Here is a pdf on how Google is doing it.
Apparently they are using 15000 comodity class pcs in cluster
architecture.
It dosnt look like they are using Oracle, but seems to be a file based
Title: RE: is this DBA's only mailing list? THANKS
Ajay,
So, (using your words), if your knowledge is nil, wouldn't it be nice idea to _start_ learning?
Granted there are more questions related to database server compared to Oracle Forms/Reports on this list, but trust me, there are some
Hi Dick,
What do you consider to be a large number of extents in a LMT ? At what
point do you consider performance and manageability to be such that you sigh
gee, I wish I had fewer extents ? What do you consider to be the ideal
number of extents for a segment in a DMT vs. LMT that makes DMT so
Santosh,
First off, you can make a file level backup of the directories
in the following 2 situations:
1) your database is shutdown. Be sure to backup *all* directories
where your datafiles are located.
2) use a hot backup script. There are lots of these available.
Check www.orafaq.com,
Thursday, May 29, 2003, 6:00:49 PM, Bob wrote:
BM Thanks for answering my question. I diddnt realise you could
BM querry colums ahead of the current line.
As I recall, it took me a long time to realize that too.
It may help to realize that everything you type between
double-quotes (those
Richard,
My troubles come mainly form PeopleSoft and some in-house created
applications. I'll use the in-house applications as the example since their simpler.
Our CIM system has tables that contain very few rows of data, like the
identification information for each
Doh!!
The problem is whether there is statistics on the table or not.
It's that RBO/CBO issue.
This feature (skip unusable indexes) needs stats.
To confirm it, I ran the following test on AIX 4.3.3 (should get same results on AIX
5L)
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit
Hi List,
Originally, Our next generate directory group use sequence # to generate
a unique key. (we can't use emplid or social s # as key, since students
doesn't have emplid and some foreign students doesn't have ssn). That
works fine until the policy changed, they need to publish the unique key
Senthil
I hope you get a reply. But I have searched for the same and I don't
think anyone will go to the trouble of creating a really good exam, then
giving it away for free. As we discussed yesterday on this list, Couchman is
a good author to use, and even he has a few glitches. But when you
As well as using orastack, go a few steps further and tune the SGA to
buggery (make it lean but keen) and set as high a pga_aggregate_target as
possible and you might make it (depending on what the 2000 users are doing
and depending on how many of them are doing what they're doing
concurrently).
Good old corporate politics here. So some of this is just fishing to see to
if anyone knows of anything that has changed from 8.1.7.4 to 9.2.0.3 with
online index creation ... OR ... has there been a change made in the
application (unbeknownst to us) that will crash into an online index
So what is wrong with having the SLOTS table occupy several hundred
extents? If it grows to 500MB it will occupy 1000 extents, so what. If it
were to grow into GB I'd probably make the extents 1MB and swallow the
wasted .5M in the CELL extent - what is half a meg when you're in the GB.
As for
Sorry Munish, I misinterpreted your question. But Jared's suggestion is
a good one. You can use orastack to set parameters to maximize memory
use for your test database. And too, 128Gb sounds like a pretty large
number for 2000 users!
Julio
-Original Message-
Sent: Friday, May 30, 2003
The whole point of ULMT is that you simply don't need to think about this
stuff anymore. It may not seem comfortable at first if your brain has the
multiple extents are bad circuitry wired into it, but it really shouldn't
matter if you have gazillions of uniformly-sized extents. The test I
Folks,
We're headed into the Storage Area Network(SAN) world and have been hearing
from two primary vendors, HP and EMC, on how they recommend setting things up. Now
without letting the cat out of the bag I'd appreciate hearing how those of you who are
on either an EMC or HP SAN and
Wow.
Maybe someone on the list has the time and motive to construct a test to
determine how many extents for a segment in a ULMT are bad. My guess from
some tests we did a couple of years ago is that it will take hundreds of
thousands of extents before even DROP performance will suffer. And I
I think you're missing the point of the last message. What's wrong with
multiple extents if the extent size is a multiple of a multiblock read?
What's wrong with having two tablespaces? I'd definitely suggest reading
How to Stop Defragmenting and Start Living: The Definitive Word on
Title: RE: randomly generate unique key
12:38:08 SQL SELECT SYS_GUID() FROM DUAL;
SYS_GUID()
BEE5518CD34A8048E033800135428048
12:39:20 SQL
supposed to be pretty unique ... http://tinyurl.com/d28a
Raj
i read some oracle documentation that recommends you keep the number of extents below
1024.
do you feel that this is inaccurate in an LMT? What if Im stuck with dictionary
tablespacse and am not allowed to change? Does it matter? I do keep all my extents
uniform. I thought there were issuse
Steve,
I'm not sure I'd call all of the functionality that has been added over the
years worth it. Way too many of them have caused more trouble than their worth, like
descending indexes. And given the drivel that I've seen from many a third party
vendor in the past (PeopleSoft and
Bug.
Has been resolved by
_table_lookup_prefetch_size=0
_multi_join_key_table_lookup=FALSE
credits to Jamadagni, Rajendra.
Thanks a lot for all your help.
Vadim
-Original Message-
Sent: Wednesday, May 28, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
Mark,
No chance
How about writing an eulogy now for ORA-600 [ 12235 ]: Oracle process has
no purpose in life?
Joe Testa
Joan
Okay, a coworker has experience in this area and provided an education on
this that may benefit me some day. He wants 50% royalty.
- Add a check digit to your existing number. This will be an easy solution
for you, not requiring much change. The extra digit will foil someone just
trying to
There's an optional db package called dbms_random that you can use to get
random numbers. Dig it:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=77326.1
There's also a sql function (in 9i only?) called sys_guid() that returns a
globally unique
What Oracle documentation would that be?
At 09:39 AM 5/30/2003 -0800, you wrote:
i read some oracle documentation that recommends you keep the number of
extents below 1024.
do you feel that this is inaccurate in an LMT? What if Im stuck with
dictionary tablespacse and am not allowed to change?
Additional downside item:
* Queries against DBA_EXTENTS will take a bit longer to return.
- Kirti
--- Cary Millsap [EMAIL PROTECTED] wrote:
Wow.
Maybe someone on the list has the time and motive to construct a test to
determine how many extents for a segment in a ULMT are bad. My
Hi,
We had a project where i have to install mysql on linux. My only experiece so far is
with oracle on sun/ibm unix.
Can someone point me to document/book/web site that explains mysql/linux combination?
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Is it a bug or a feature?
Waleed
-Original Message-
Sent: Friday, May 30, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Bug.
Has been resolved by
_table_lookup_prefetch_size=0
_multi_join_key_table_lookup=FALSE
credits to Jamadagni, Rajendra.
Thanks a lot for all your
One way to get around this issue is to continue to use the sequence and
concatenate some random numbers. The random generated number could look
something like this sequence.nextval||to_char(sysdate,'DDDS').
Mark
-Original Message-
Sent: Friday, May 30, 2003 8:45 AM
To: Multiple
Munish - Don't forget to change the init.ora parameter PROCESSES greater
than 2000. I didn't see where anyone mentioned that.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 30, 2003 4:15 AM
To: Multiple recipients of list
All,
Does anybody know how to, instead of printing ERD diagrams to a printer, to
send the output to an electronic file, preferrably something like a PDF or
HTML format?
I find it pretty amazing that we only have one option here - to print it on
paper.
I know somebody figured this out once by
helpdesk
I don't see where anyone responded. If you look up reverse key index in
the documentation, it says something about if you have a column where most
of the values have leading values that are close. Reverse key will help the
btree of the index be more balanced. That helps on queries. And
I was talking to some colleagues and they did the following tests. I was wondering if
anyone else had similiar results or maybe they just didnt do it properly.
They are using standard SQLLOADER. No direct path inserts and doing some SQL data
manipulation of the files. They found the following:
Walter - This is a common question about RMAN. The Oracle response has been
not a significant amount. I haven't noticed anything, but haven't
specifically tried to measure it. As I mentioned, there are only a few
commands going B - A and some status information going A - B. The actual
backup
Title: RE: Bulk collect got truncated? RESOLVED
Sorry, can't take the whole credit ... but if you are giving the credit for looking it up first on the Metablick, sure, I'll take it.
Raj
Rajendra dot Jamadagni at
Jared - Excellent point. My understanding is that the RMAN catalog must run
on an Oracle version equal or greater than the target instances. Has anyone
found this requirement to be a big pain? I am looking to configuring RMAN on
another set of servers, but they are Oracle 9.2 and my current RMAN
Ethan - Is this a technical issue or a licensing issue?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 30, 2003 12:30 AM
To: Multiple recipients of list ORACLE-L
From the Oracle C++ Call Interface Programmer's Guide
The How To Stop Defragmenting... paper says it in section 2.1.4.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]
Sent:
The Linux Database Bible from Hungry Minds inc. ISBN 0-7645-4641-4 $49.99US
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, May 30, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L
Hi,
We had a project where i have to install mysql on
I have seen this when I have created a logon trigger which activates trace
but the owner of the trigger did not have ALTER SESSION granted directly to
it (instead it was through a role). Sessions logging on ended up creating a
trace file but nothing was in it but TRACE DUMP CONTINUED FROM FILE
-
I'm not sure specifically about Designer 9i.
But in most ERD tools you could copy the diagram (Edit/SelectAll, then
Edit/Copy), and then paste it let's say into Word.
Then, you could save it in any format you wish.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mercadante,
Try the MySQL web site for starters. http://www.mysql.com/documentation/
Cheers,
Mark Stahlke
-Original Message-
Sent: Friday, May 30, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
Hi,
We had a project where i have to install mysql on linux. My only experiece
so far is with
Igor,
thanks, tried that. it works *some* of the time.
but for busy diagrams, things get truncated. I would have to re-draw
everything smaller to get it to fit.
thanks again.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 30, 2003 4:11 PM
To:
You can always print it to a file and then look at the file
with Ghostview or Aladdin.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 30, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
All,
Does anybody know how to,
To quote the paper:
Oracle supports an unlimited number of extents in a segment. The
performance for DML operations is largely independent
of the number of extents in the segment. However, certain DDL operations
such as dropping and truncating of segments are
sensitive to the number of extents.
See the below message from the Designer list.
(Also, if you've got acrobat distiller (a windows printer driver that
generates pdf files) consider using that.)
[EMAIL PROTECTED]
From: Peter Koletzke
Date: Mon, 03 Apr 2000 11:48:17 -0700
Dennis,
You are right. Nothing is free if t has a quality. Best option is to buy sts
question which cosr normally $99 but they also offer sometimes at 25-30%
discount. Alternately buy Daniels 9i new features comes with test question
CD. I rather suggest Senthil to buy sts eaxm questions and
You can initiate backups from any machine. Here is a cold backup script to
illustrate backing up from a database server connecting to a rman catalog on another
machine.
#!/bin/sh
ORACLE_HOME=/opt/oracle/dbserver/9.0.1
export ORACLE_HOME
ORACLE_SID=XXX
export ORACLE_SID
Wolfgang,
I agree. I wasn't arguing a point, but merely pointing out a possible
source of the information you had requested.
Have a weekend! :)
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
Title: RE: HELP URGENT RMAN FAILS - FILE?
Guys,
Running Oracle 8.1.7
RMAN with automated backups - no problem
Wish to recover
recovered controlfile from backup then issued following:
MAN run {execute script alloc_all_tapes;
restore database;
recover database noredo;
execute
Title: RE: HELP URGENT RMAN FAILS - FILE?
methinks resync - could I be write? I had taken a tablespace offline and had not resynched with catalog - kind of makes sense.
-Original Message-
From: Stankus, Paula G
Sent: Friday, May 30, 2003 5:34 PM
To: '[EMAIL PROTECTED]'
Subject:
hi there is this project that is going on for
archiving old data from oltp system that is older than
12 months and then purging them in the main db.
the tables that are to be archived are with long rows.
they cannot be converted to lobs since this is a third
party application. here is where the
how do you define older than 12 months??
are you using enterprise edition and is it feasible to use
partitioning?, if you partition on the field that defines older than
12 months, its easy enough to drop a partition(or exchange a partition
with a non-partitioned table, export that and drop
Title: RE: archiving data
I/O failure this week. Productional system restore/verified and backed up - fully operational once I/O subsystem rebuilt in 2.5 hours - required full restore because key datafiles corrupted - system, redos, control. Waiting for I/O took longest didn't see kids
For situations like this you have the COPY command of SQL*Plus.
Remember, it's a SQL*Plus comamnd like set, btitle, etc. not a sql command
you can embed inside a pl/sql block. You could create a table similar in
structure to main table and then polulate the data
SQL SET LONG 99
-- this is
Tom,
I've done this in the past by setting up a PostScript printer in windows,
and sending
the output to a file, then using the file to generate PDF's from
GhostScript.
HTH
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/30/2003 12:04 PM
Please respond to
Personally, I think the issue of tablespace fragmentation has always been
highly overrated.
I'll use one of our databases as an example. It's a 3rd party app, and
has had only a little
maintence on the extent sizes. When I catch one growing quickly, I will
increase the next_extent
size.
D'oh!
I was thinking 8i. My mind hasn't really gotten into 9i mode yet.
pga_aggregate_target is indeed the way to allocate PGA memory.
Jared
Richard Foote [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/30/2003 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients
Dennis,
My understanding of B*tree is that it is always balanced. Monotonically
increasing
keys will create a right hand index, but nonetheless balanced.
If wrong, I'm sure to be corrected. :)
Also, I don't believe the reverse key index will help queries any. I'm
guessing that under
Don't worry about the lid being off of 10i.
We will be doing an overview presentation of Oracle 13
this fall at the local user group. :-)
- Babette
-Original Message-
Thomas F
Sent: Friday, May 30, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
who promoted you to traffic cop?
Oracle 13? Probably nicknamed something like Jason is back version?
It would be appropriate to have such a presentation on Friday the 13th.
On 2003.05.30 23:09 Babette Turner-Underwood wrote:
Don't worry about the lid being off of 10i.
We will be doing an overview presentation of Oracle 13
this
UNLESS
Oracle decides to skip Oracle 10i and go directly to Oracle
11i.
They
did something similar to bring the numbers for Oracle
Database
and
Oracle Designer and Oracle Application Servers all up to 9i
(9iDB,
9iAS, Designer 9i. . . .)
After
all, they must have introduced enough new
Title: RE: Oracle Untested Infuriator
I
understand that in Oracle 11i, Oracle OEM will introduce
a new
"mauve" button to auto irritate the DBA.
You
can set this to be random or regular intervals
and
the annoyance levels are configurable ;-)
-
Babette
-Original Message-From:
You might enjoy knowing that OUI is not used
on the mainframe. Just old fashioned JCL and tapes
and CLISTs for Oracle 9.2
BUT for Oracle 10i, there are rumors that Oracle
will provide a CD that will be used for installation
that will use OUI
And you thought using the XServer stuff on
UNIX was
On Friday 30 May 2003 12:20, [EMAIL PROTECTED] wrote:
1. SQLLOADER with the SQL manipulation is much slower than
Direct Path SQLLOADER to a staging table, then insert,update, and delete to
the master table.
Sounds about right. It's been awhile since making heavy use
of SQL Loader, but DIRECT
True enough. I was making the assumption that RMAN would
be run from the client or backup server.
Of course that is not necessarily true.
Some third party tools may require it. NetBackup for instance
expects the RMAN script to run on the client, but I don't know
if that is strictly
Hi All,
They are at the moment offering 50% discount...
Here is an excerpt from one recent promotion..
SAVE 50% on all individually packaged Self Test Software test
prep products from 12:01 am, May 28, 2003 to midnight EDT on
May 31, 2003.
There will be no backdating or extensions on
Nope! - Oracle 10i will be the end of the world (as Oracle knows it at least
:) since we already have an Oracle 11i (aka Oracle Applications 11i - but
generally known in the ERP world as Oracle 11i or Apps 11i). Fyi - it
mutated from Apps 10.7 to Apps 11.0.x and now to Apps 11.5.x - the 'i'
After
long time ..
LOL .
;-)
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vladimir
BaracSent: Friday, May 30, 2003 2:35 PMTo: Multiple
recipients of list ORACLE-LSubject: Re: Parallel Query Server
died
Kool, now some cyber funeral
Assume an index on employee number. The number is assigned sequentially,
and as such, the rightmost index leaf block would always be used. A
possible hot block. A reverse key index can avoid this. Also, assume when
an employee retires or quits, the record is deleted. But the space freed
within
84 matches
Mail list logo