I don't think - it will work. You won't get any error as well as it won't
shrink.
Any other inputs from others???
Rgds,
-Original Message-
Sent: Wednesday, January 30, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Hi,
Assume
INITIAL * MINEXTENT = 2M and also = OPTIM
Way to go ! I've updated FND_INSTALL_PROCESSES,
played around (updated) the restart files in
$APPL_TOP/admin//restart
etc.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Bellows, Bambi" <[EMAIL PROTECTED]> 30/01/2002 03:53 AM
Sent by: [EMAIL PROTECTED]
Please r
Hi,
Assume
INITIAL * MINEXTENT = 2M and also = OPTIMAL
Do you think
ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M;
will work ?
Thanks,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
INET: [EMAIL PROTECTED]
Fat City Network Se
list, sorry for this OT , but our development team is looking for
resources/links
on the web providing examples of sending/recieving data using winsock from
oralce forms..
i tried searching google, but could not find any code samples...!!
regards
Rahul
--
Please see the official ORACLE-L FAQ:
This sounds like a SQL feature that has not made it into
the PL/SQL engine as yet. There are a number of statistical
functions such as regr_slope and regr_intercept that work
in SQL, but not in PL/SQL.
They are supposed to be in PL/SQL as of 9i, though I haven't
checked myself.
One way to work
hi,
Oracle 8.1.6 supports the embedded CASE operator
in an SQL statement.
But when i use it inside cursor, it gives error
PLS-00103: Encountered the symbol "CASE" when expecting one of the
following:
e.g.
declare
cursor c is select ename ,
case when deptno = 10 then
'TEN'
Does anyone have any experience with integrating BMC's
Control-SA package with Oracle. My company is
implementing Control-SA to handle all user
administration across all platforms and I have been
tagged to be the Oracle subject matter expert on the
implementation team [lucky me ;) ]. I am supposed
This is almost certainly a Network related issue. The network is
misconfigured for "your application", I repeat "your application". This is
not that your application is bad in any way, its just that their network
doesn't like it.
What I suspect is happening is that you may be doing is crossing
hi all,
Is any body encountered following errors... this happening while I try to
migrate 8.1.7.2 database to 9.0.1
using manual upgradation or ODMA tool.
ALTER TABLE system.aq$_queues
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS
ORA-00600: inter
But, "offline" and "removed from the system" are two different things...
You are correct that your datafile is offline... That just means that it is
unavailable for use... But, it is still part of your database... The DROP
keyword does not mean that the datafile is removed from the system... I
Hello Jared et al,
The Oracle Reference Manual for 8i, "schematic diagram" has alter database
'' offline drop, so that's what I tried (as system).
The system came back, 'database altered', but a check of dba_data_files
shows that the datafile (#115) is still there. The dba_extents lists no rows
JoJo,
sorry -- but truncating does "delete" the data because as far as Oracle
is concerned, if you do a select count(*) from the table after a
delete, you will get 0 rows returned.
Cursors do not have anything to do with the location of the end of a
table, they are a programming construct
Rache
Barbara,
ODBC still uses Sqlnet as the transport, so you have to allow 1521 incoming, and all
TCP high ports out.
If allowing all tcp high ports out is not acceptable to the network guys, you can also
force the Oracle listener to use the same connection for both incoming and outgoing
traffic
JoJo,
you said
"being possibly unable to find the answer or having problems
deciphering the manual." You try to find it first on your own.
I will answer beginner questions all day. Most of my presentations are
on beginner stuff. But you have to at least make an effort to find it
yourself. You
Had you performed a resetlogs between the cold backup and your recovery?
What does "list incarnation of database" produce... It sounds to me like
you changed the database incarnation between your cold backup and now... If
that is the case, I think you can use the "reset database to incarnation
"
Lifted from another list.
Anyone here experienced this? This would seem to indicate that 9i
might be very happy with stateless protocols such as NFS.
Jared
---
I work with all Java developers, so I had no one to share this with, but I
was reall
I nominate Bambi as the best and wittiest writer on this list.
PB
__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baum
you don't. But if there are multiple changes to the row, and you want
to see what it looked like at a particular point in time, you could
just extract it from the audit table instead of having to trace it
back.
Unless you WANT to recreate rollback segment functionality and Oracle's
recovery proce
no you don't need two rows... but if you have multiple updates to the
row and want to see what it looked like at the beginning you'd have to
spend time tracing them all the way back. Unless you WANT to recreate
the rollback segment functionality?
this way, you have a before and after image right
Hi
I restored a a prevous cold backup of my database and am trying to take an
incremental level 0 backup with RMAN. But the backup fails with the
following error
RMAN-06004: ORACLE error from recovery catalog database:
RMAN-20011: target database incarnation is not current in recovery catalog
Wh
On Tuesday 29 January 2002 15:32, Sam Bootsma wrote:
> Hello,
>
> Most of our clients can run our application with very good performance, on
> both UNIX and Windows platforms. However, ...
>
* get some network stats for the various tests
* investigate SDU and TDU settings - set metalink note 7
No, RAISE re-raises the error.
Comment out or delete the RAISE and it will go away.
Jared
On Tuesday 29 January 2002 14:15, [EMAIL PROTECTED] wrote:
> Resending as it did not go thru the 1st time
> - Forwarded by Rick Cale/CORP/TeamHealth on 01/29/2002 05:17 PM -
>
>
You can't safely drop a datafile from the database.
When you say 'According to Oracle, I should be able to drop a datafile
at has no data written to it', do you have a reference where we can
see that. It does not sound familiar to me.
Per your situation, since you have the datafile offline, jus
Yechiel Adar,
We use option #2 (LOB segments in another tablespace). It allows faster
queries of the non-LOB data in the "main" table and gives us flexibility as
to storage parameters for the LOB segment(s). We also use interMedia Text
to index the LOB (CLOB, in our case) column and those index
HI
I trying to recover from loss of all
controlfiles and a datafile which was not backed up using RMAN
.
these are the steps i followed
>startup nomount
These are the RMAN commands
executed.
{allocate channel c1 type disk;restore
controlfile;sql 'alter database mount';resto
Hello,
Most of our clients can run our application with very good performance, on
both UNIX and Windows platforms. However, ...
One of our clients has installed our application on a HP 11 UNIX box and is
encountering intermittent, but severe slowdowns in certain areas of our
application. We to
Don't jump too fast. I write book reviews from time to
time for Oracle Magazine and others. If I were in a
waiting room with time to kill I might well be reading
one of my to-be-reviewed books, and DBA for Dummies
might be one of them.
On a slightly related note, I never bothered to take the
ROTFL!!
> Of course, back in my day, we had 1s and 0s, and we ate mice
> if we could
> catch them. That's why mice have strings attached to them.
> They look like
> cables, but actually they're just wires holding the mice in
> place in case
> there's ever a techfamine like in the old days.
WARNING! POSSIBLE REPOST! WARNING! POSSIBLE REPOST! WARNING!
Folks --
This bounced back to me... so you may have gotten it twice. If you did,
please delete this posting.
YOU HAVE BEEN WARNED! YOU HAVE BEEN WARNED! YOU HAVE BEEN WARNED!
Maks --
They are different. Edlin was a line e
Hello list,
Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel Server (OPS)
According to Oracle, I should be able to drop a datafile that has no data
written to it, but I can not. Neither DBA studio (the garbage can stays
'grayed'), nor the command line (alter tablespace, with the DROP claus
I can remember which version we had but we used to monitor our servers,
routers and VPN server and other than at times it became a bit vocal about
events it wsa none the less a very useful tool.
Like most open source things the manuals aren't all that helpful at times,
but I always found that
which makes ed the original so I suppose MS certainly didn't invent or
innovate this
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303
Barb,
I haven't tried this personally, but the following Metalink references should help:
On Metalink check out the following note:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=132729.1
This is the Technical Library "Connection Manager and Firewalls
Ok, some of you may recall that a few months ago I completly
banned off topic posts from this list. If it was not of a technical
nature, and not related to Oracle you couldn't post it.
Please stop this thread now, so I don't have ban off topic *again*,
and spend too much of my time monitoring t
multiple network cards
-Original Message-
Sent: Tuesday, January 29, 2002 11:36 AM
To: Multiple recipients of list ORACLE-L
Roy,
> with multiple interfaces
you mean multiple network cards? or multiple protocols?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
Well, since sed was in use while BG was still in high school...
Jared
On Tuesday 29 January 2002 13:27, Michael Kline wrote:
> I thought edlin was sort of a copy of "sed"... Which came first?
>
> Maks.
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Beh
Sorry for the OT post, but I cannot find this elsewhere.
We need to get connectivity from outside our firewall into an Oracle
database using ODBC.
Our network guy thinks there should be a port designation or something to
allow these odbc connects through.
I'm clueless.
Any ideas where we can loo
Thank you all for your kind replies, and I now definitely know the correct
answer to this.
Please let me reiterate that I am *not* yet an Oracle dba. I've only been
to one class so far, for crying out loud! Obviously it would be better for
me to just not post for a while, in any event.
No need
Resending as it did not go thru the 1st time
- Forwarded by Rick Cale/CORP/TeamHealth on 01/29/2002 05:17 PM -
Rick Cale
Sorry guys. As soon as I started reading the replies, I realized what I
left out.The developer needs:
select e.emp from emp e
where e.mgr is null
connect by prior mgr = emp
start with emp in ('Jesse','King');
...and still be able to tell the top-level (l
You should create a pure function that returns the
top parent. This would be a simple PL/SQL loop
that walks to the top of the tree for the given
Emp name. Performance might be less than brilliant
but that's the price you pay.
Once the function is in place -- call it TopParent() --
then you ju
Yeahas I replied to a kind gentleman who wrote me off-list, I think I
will simply refrain from posting at all, since this place is a bit touchy.
As I said, I'm totally a newbie (I just started my classes last week).
--JoJo
-Original Message-
Travis
Sent: Tuesday, January 29, 2002 1:
I strongly suggest you not experiment with this on your production database.
--Walt
-Original Message-
Sent: Tuesday, January 29, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
I'm a complete newbie, so I may be off-base here, but I believe that
truncating a table does not delet
Bill,
If the user does not have any role specifically assigned as the DEFAULT
role, then all newly assigned and existing roles are DEFAULT. You do not
have to do anything special to make them all DEFAULT.
On the other hand, if you have set any existing role as a DEFAULT (alter
user dummy default
And the funny(?) part is you can not rollback to recover it.
Just create, populate and truncate a test table and confirm (after reading
docs).
- Kirti
-Original Message-
Sent: Tuesday, January 29, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L
Yup, you need to read up on this
Title: Truncating the table
Actually, technically speaking is does not destroy any
data. It simply makes it unrecoverable because the high water mark has
been moved. That is why is completes so quickly as opposed to a
delete statement. To recover the unused space you need to "alter table
> bothered to look up the manual.." attitude that is most frustra
ting.
When
> you ask the format of a command (for example) to the list, you are
> potentionally asking 1000's of people the same question who will all
have
to
> spend the time to filter these questions - we are all busy people and
I
Thank you , I will look into the suggestions.
Srini
-Original Message-
Sent: Tuesday, January 29, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L
Srini,
1. You don't have to feel... go after v$system_event, v$session_event and
v$session_wait to find out what events and SQLs are co
Title: RE: adpatch question
Matt (and any others who are interested) -
My adpatch went
fine after tinkering under the hood except for one place where Oracle created a
table, populated it and blew away its max extents. Amusing, but lame. I can't speak for Oracle on this
one, but it lo
Jared,
How about renaming this list into 'DummyDBA'?:)
We know already about 'lazydba' list...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 3:10 PM
> LoL...
> So many opportu
I thought edlin was sort of a copy of "sed"... Which came first?
Maks.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice J
> Sent: Tuesday, January 29, 2002 2:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Microsoft pla
Title: RE: adpatch question
If he's not interested, I am. Please post a summary
upon completion.
Matt
Matt Adams - GE Appliances - [EMAIL PROTECTED]
"That is the top of the calibration target,
that is NOT in fact a monolith"
- NASA TV Commentator - 7/5/1997
> -Original Mess
Title: Truncating the table
That is incorrect JoJo. When a table is truncated,
all rows are removed. In addition this statement
does not generated Undo Blocks, and therefore cannot
be rolled back. Use with care.
The OracleX SQL Reference manual has more information
(where X is either 8,
'Truncate table' drops existing extents, and basically recreates table with
MINEXTENTS specified on table creation. That's how it 'empties space'.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, J
Im defending this - how did i get here ?
nevertheless - the mighty Mohan Ross speaks - I do read your e-mails (never
for oracle help) just too see if u can ever make me laugh- Im not actually
into camp humour though.
How ironic - I always imagined you as the type who dresses up as a mother
supe
Now, will someone tell me, if he is kidding, or is that a genuine serious
question ;-)
Raj
JoJo Al-Zawawi <[EMAIL PROTECTED]>@fatcity.com on 01/29/2002 03:16:07 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTEC
Tom,
Well, I didn't include a design with my post.
Audit tables always get their own PK in my book, along with
a datestamp recording the time of the change and column
indicating who made the change ( if that's available ).
The old value(s) is/are always in the audit table, the new
value is al
prepare for the flood
> -Original Message-
> From: JoJo Al-Zawawi [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 29, 2002 3:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RTFM questions (formally RE: PL/SQL)
>
>
> I'm a complete newbie, so I may be off-base her
Thanks
-Original Message-
Sent: Tuesday, January 29, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L
Bringing back 20,000 rows is not good in my shop. I recently tuned a SQL
(returned 14000 rows, and it is web-based appl) from running 15 minutes to
less than 15 seconds. The SQL
Ok folks, it's getting out of hand now.
Take it to the off topic list.
Jared
On Tuesday 29 January 2002 10:45, Sam Roberts wrote:
> To our resident Oracle Expert who just 6 months (July 26 2001) ago posted
> the following e-mail
>
>
> If I remember rightly, deleting rows from the table does NO
Yup, you need to read up on this one.
Truncating a table will indeed delete data.
Jared
On Tuesday 29 January 2002 12:16, JoJo Al-Zawawi wrote:
> I'm a complete newbie, so I may be off-base here, but I believe that
> truncating a table does not delete any data from the table. It moves the
> c
Hi All,
Just a funny little story, one day I was interviewing some consultants that
had been recommended by a rather large (nameless) consultancy. The administrative
assistant indicated that my next interviewee was in the waiting room. As
I approached the waiting room I looked throught the b
Hi JoJo,
This is incorrect. A truncate removes all data from the table and moves
the High Water Mark to the beginning of the table. Some internal's guru
might be able to tell you that the data is still there, but you can't get
to it, so it doesn't really matter. BTW , you can't issue a roll
Start with 'Oracle Performance Tuning 101', available at an
amazon.com near you.
Jared
On Tuesday 29 January 2002 09:10, [EMAIL PROTECTED] wrote:
> Hi Everyone
>
> Can anyone suggest me some very good book on Oracle Tunning. Please only
> mention those books which you think is really wo
hi
I trying to recover from loss of all
controlfiles and a datafile which was not backed up using RMAN
.
these are the steps i followed
>startup nomount
These are the RMAN commands executed.
{allocate channel c1 type disk;restore
controlfile;sql 'alter database mount';restore database;recove
Sergey,
> This has been running for about 4 hours now. I got an SQL
> trace file, and
> looked at the execution plans. So here's the deal. There's an
> interesting
> join condition "...where A.col1=B.col1.". However, A has
> a few hundred
> distinct values in that column, none of them bein
Srini,
1. You don't have to feel... go after v$system_event, v$session_event and
v$session_wait to find out what events and SQLs are contributing to
unnecessary waits and try to find out what can be done to resolve it. If you
think data retrieval is the problem, then info from these views will hel
LoL...
So many opportunities for writing books for all these dummy DBAs !!! LoL..
-Original Message-
Sent: Tuesday, January 29, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L
Kirti,
Good luck!.
Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro',
'9i Mast
Hi,
Is there a website, which keeps all the messages posted to this forum, which
can be accessed without subscribing to the forum?
Thanks
Shiv
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: PRASAD, SHIV
INET: [EMAIL PROTECTED]
Fat City Network Services-- (85
I'm a complete newbie, so I may be off-base here, but I believe that
truncating a table does not delete any data from the table. It moves the
cursor up, thereby closing up the "empty space" where data has previously
been deleted.
--JoJo
-Original Message-
Sent: Tuesday, January 29, 200
Bill,
Sure. They're call 'press releases'.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
> -Original Message-
> From: bill thater [SMTP:[EMAIL PROTECTED]]
>
> [EMAIL PROTECTED] wrote:
>
> >Okay ...
> >
> >does anyone know what are Microsoft's ow
Now you're getting into the realm of Temporal or Time-
Oriented Databases.
Suppose you want to know what change Fred made on
Tuesday. With your design, the audit row only
shows what the old value was, not what the new
value is. To find that, you have to find either
the current production ro
Hi, John,
Sorry 4 the delayed reply. Thanx 4 the help.
Best,
Sergey
-Original Message-
Sent: Friday, January 25, 2002 7:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait
Sergey,
My $0.02 below: (comments below and only for relevant stats, some of whi
Bringing back 20,000 rows is not good in my shop. I recently tuned a SQL
(returned 14000 rows, and it is web-based appl) from running 15 minutes to
less than 15 seconds. The SQL joining only two indexes. The only changed I
make was the index. The index had 2 keys before and I added the third o
DAMN!!
I'm sitting here since three hours trying to compile the beast with
mysql-Support. Libraries are forgotten in the makefiles or not in the
right order, it can't read it's data and after looking at the firewall's
log I start to cry. Yeah it's version 0.0.7b6. My tip: don't start at
friday wi
I think they wrote edlin, but that was years ago.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 53
Roy,
> with multiple interfaces
you mean multiple network cards? or multiple protocols?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 1:40 PM
> all,
>
> does anyone know whe
Hi Srini,
2000 dedicated connections? How much memory does the machine have? Is it
swapping at all? What is your sort_area_size, etc? How about the SGA?
Just some thoughts...
- Jerry
-Original Message-
Sent: Tuesday, January 29, 2002 1:36 PM
To: Multiple recipients of list ORACLE-L
John --
Thanks for the email back. Apps suck, and going under the hood is not for
the weak of stomach. Of course, I'm not... and, at this point, fighting a
fire is more fun than watching a heap of smoldering ashes. So, I did it. I
went under the hood, and found that the fnd_install_processes
Brian,
If I remember correctly Cognos will present data to the users only
after you have populated the catalogs of Cognos. The catalogs are
basiclly a table description only allowing the users to see certian
columns. Like a view. each user can have a different catalog depending
on the department
1. The bug .
2. The Blue Screen
3. The Regular Maintenance Release
-Original Message-
Sent: Tuesday, January 29, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
>Okay ...
>
>does anyone know what are Microsoft's own inventions?
>
they have i
Wow, if you put *that* much work into helping the DBA poor/oppressed,
you'd be the Mother Theresa of the list.
I have to say I've gotten FAR MORE out of Kevin Thomas' posts than
I'm likely to ever see out of your private little sniping corner of
the Arab Emirates. But I'll keep an open mind,
"Oracle performance tuning tips and techniques" by Richard Niemiec has a
lot of good examples and explainations to learn by. Currently the
majority of the books were written for 7.+ to 8i and will be marked down
soon as the new 9i books become available.
I do not have the "Tuning 101" that Bill me
I also note that Oracle9i for Dummies is now out, according to
http://www.dummies.com
-Original Message-
Sent: Tuesday, January 29, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
Will do..
- Kirti
-Original Message-
Sent: Tuesday, January 29, 2002 11:26 AM
To: Multip
Kirti,
Good luck!.
Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro',
'9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:).
I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to pay
for oracle classes/tests:)
Igor Neyman, OCP DBA
[EMAIL
Hi, Rich
This can be done:
select e.emp from emp e
where e.mgr is null
connect by prior mgr = emp
start with emp = 'Jesse';
HTH
Vadim
-Original Message-
Sent: Tuesday, January 29, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L
Hi,
On 8.1.7.2 (soon to be .3) on HP/UX 11.0, a
Hello all,
I wanted to know that if a client is looking for 3
years + experience in PL./SQL, what all they expect us to know. eg procedures
and functions should be on tips, knowledge of blah, blah etc.
Also if some says you should know Developer 2000,
eg Forms 5.0 and Reports 3.0 how much
Sorry, we have yet to monitor our databases with it. We're using it to
monitor our web servers and database servers, and to a lesser extent our EMC
boxes.
--Walt
-Original Message-
Sent: Tuesday, January 29, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L
Walt:
What database 's
Actually, and to MS's credit, they've had this in the works
for some time, as is mentioned in the article.
No doubt that iFS is cool, I've set it up for prototype purposes
and really liked it.
Making a RDBMS the underpinning foundation of your OS is
undoubtedly more complex than building a too
Nice Sleuthing, KD.
-Original Message-
Here you go...
.
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2447763926
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2447763927
-- Oops! The the smart
Mogens:
And to think I went to all the trouble to write a korn script for export
that
lets you specify tables to exclude, among other things. :)
List:
Please don't ask me for the script unless you are prepared to remove
the site dependencies and send me back the genericized script. :)
Jared
Silly me. I was assuming a properly designed database in which
all the PK's are generated. The PK never changes in such a database.
Jared
"Igor Neyman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/29/02 08:12 AM
Please respond to ORACLE-L
To: Multiple recipients of list
[EMAIL PROTECTED] wrote:
>Okay ...
>
>does anyone know what are Microsoft's own inventions?
>
they have inventions?
--
--
Bill "Shrek" Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program l
all,
does anyone know where I can find information on configuring Oracle to
listen for requests on a UNIX server with multiple interfaces? looking to
setup a failover if one network interface drops the other will carry the
load...
thank you in advance.
Roy
--
Author: Brian Haas
INET: [E
When posing a question to the list, there are a number of
pieces of information that are required:
The OS platform and version
The Oracle version
Other things that are relevant,
For instance, what does the function do? If it reads 10 million rows
from a table, I would expect it to be slow.
If
Bambi,
I wouldn't touch *anything* under the hood as far as Apps goes, esp. 11i.
Raise a TAR and let Oracle Support come back to you on this. I assume that
you are testing the upgrade and not actually doing it. These sort of things
should have been ironed out prior to the upgrade with lots of ite
Typically i bringing back about 20,000 rows and that too after filtering
first and joining with bigger tables.
Srini
-Original Message-
Sent: Tuesday, January 29, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
How many rows are you bringing back from a typical query, how good is
[EMAIL PROTECTED] wrote:
>Hi Everyone
>
>Can anyone suggest me some very good book on Oracle Tunning. Please only
>mention those books which you think is really worth purchasing
>
tunning 101 it's the only one you'll need because it not only
explains what to look at, but gives you a me
Would...
select emp, level from table_name connect by prior mgr=emp start with emp =
'Jesse';
work for you? It would look like...
Jesse 3
Urman 2
Sciarra 1
HTH
Tim
-Original Message-
Sent: Tuesday, January 29, 2002 12:20 PM
To: Multiple recipients of list ORACLE
Here you go...
1) Find the OSPID for the suspected user (other than pmon, smon and their
famiy)
select s.username, p.spid
from v$session s, v$process p
where s.paddr = p.addr;
2) Use oradebug to connect to that spid (here I have 26073, and the session
was tracing event 10046)
SVRMGR> oradebu
1 - 100 of 211 matches
Mail list logo