Nothing in v$transaction?
Does the query below return nothing as well?
select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
,t.used_urec
,t.log_io
,t.phy_io
,substr(sa.sql_text,1,200) txt
from v$session s,
Title: Message
Since the DB is 40GB, one 70GB drive will do. All
the OS, Oracle binaries as well as the DB should fit in nicely. And no BAARF
problemseither;-)
- Original Message -
From:
Matthew Zito
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August
Hi!
What about several insert /*+ APPEND NOLOGGING */ commands over database
link run in parallel? (Possibly over dedicated network). This is fast and is
easier (in case you don't hit any compatibility problems). If you happen to
be running on Windows for some reason, you could try to use named
Maybe your rollback is done in background, because
a session crashed orwas killed?
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 26, 2003 1:49
AM
Subject: no rollback ??
There is one log running process
You also might want to check
v$fast_start_transactions and v$fast_start_servers.I had a problem on
linux, where SMON (9.2.0.3) decided to roll back a large transaction in
parallel, but on linux (rhas21) the parallel execution didn't work too well and
the whole process stopped until I
One caveat strikes my mind when considering Direct Load... Due to the fact
that the buffer is constructed and written directly, the kernel can perform
INSERTs only *above* the HWM. If the rate at which you perform Direct
INSERTs is high (i.e. multiple runs in a day), then you may have an
Sobig -F does carry out spoofing , but Jared here is a question : either
which way (spoofed or not) wouldn't list-guru remove all attached binaries ?
Anyway I am not going to open any such mails.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday,
Title: Message
I thought the BANRD was over, after successfully
completed thebattle against non-redundant disks?
Tanel.
- Original Message -
From:
Binley
Lim
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 26, 2003 2:59
AM
Subject: Re: new
Title: DBAssist hangs
Hi list,
I installed 8.1.7 on RH AS 2.1, applied 8.1.7.4 patch, the glibc patch and when trying to create a
DB dbassist hangs.
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
Imran,
Try this script.
i have used it often.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Oops...it's Jared's script.
i was not knowing till now.
Jp.
26-08-2003 11:14:26, Prem Khanna J [EMAIL PROTECTED] wrote:
Imran,
Try this script.
i have used it often.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat
I think you can use your mail filter,
If Jared have this virus, soon you will see the entire Oracle-l will send this virus
to each other.
-Original Message-
Sent: 26 August 2003 01:40
To: Multiple recipients of list ORACLE-L
It is a virus, dump it.
VIRUS ALERT: New E-mail Worm
A
Hello everyone,
Env: Oracle 9.2.0.3, HP-UX B.11.00
We've got a logical standby running at the moment and at times it falls well behind of
the primary database. We're querying the view DBA_LOGSTDBY_PROGRESS to see view its
progress but this view is WOEFULLY slow! It can take anywhere up to 15
Spooling into a pipe file concurrently SQL Loading from the same is even faster as
the Loading Starts off even while the spool is underway i.e. being built . Both spool
Load Run concurrently . Also NO Disk space is consumed.
HTH
-Original Message-
Sent: Tuesday, August 26, 2003 1:35
Hello,
I don't understand very well the buffer_size parameter and how to use it.
with imp tool.
If I read the help:
BUFFER
Default: operating system-dependent
The integer specified for BUFFER is the size, in bytes, of the buffer
through which data rows are transferred.
BUFFER determines the
Hi!
Buffer parameter in imp sets the array size for doing inserts in imp's
oracle session.
Just put it buffer to a big value such is 4000 (40M) for example.
Otherwise, if your buffer is small, then commits occur too frequently -
after each array insert. You might want to set commit=n as
Although I haven't got into the technical details of 'The Grid' (and thanks
for this article - I shall read it), but nevertheless I have a haunting
sense of deja vu. Remember all the hype over distributed computing that
Oracle generated? Remember the key part client-server was of that? Remember
For what it's worth, Peter invited me to another of Chris Date's talks
earlier this year - and it was WELL WORTH the trip. Chris is a very good
speaker.. The last talk was almost the same as this one - Foundation
Matters, and a little on The Third Manifesto. Dropping ACID is a new one
though.
I
Guys,
...thought of buying a good book for linux system administration.
i came across the books below.
which one is good ?
1.Running Linux From O'Reilly
- By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar Kaufman
2.Linux Administration Handbook From Prentice Hall
- By
Remember the 'single instance' ?
- --- Original Message --- -
From: Robson, Peter [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 26 Aug 2003 01:49:27
Although I haven't got into the technical details
of 'The Grid' (and thanks
for this
Hi Friends,
I would like to know what is Data Entry in Oracle environment.
Is it a tool ?
Is it a language ?
What kind or resource or tool is it ?
Tks
Eriovaldo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eriovaldo Andrietta
INET:
Darn bleeding users
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Windows would be a wonderful OS, if people would just quit installing applications.
Solitaire runs.
;)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
INET:
It's food for tought.
On 2003.08.26 06:34, Eriovaldo Andrietta wrote:
Hi Friends,
I would like to know what is Data Entry in Oracle environment.
Is it a tool ?
Is it a language ?
What kind or resource or tool is it ?
Tks
Eriovaldo
--
Please see the official ORACLE-L FAQ:
Title: RE: dbms_application_info rewrite
it depends on what you want to do ... care to list (in steps) your plans ??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Title: RE: Performance Problem
'her' ??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
Title: Message
Has
anyone worked with this one?
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1123.htm#81357
Patrice.
Both are good but the second on your list is particularly useful for
admin work. In my opinion, the first is more of a getting your feet wet
kinda book but still useful as a reference.
Dwayne
Prem Khanna J wrote:
Guys,
...thought of buying a good book for linux system administration.
i
If nothing else, i'm getting about 50/day which means i must be on a
boatload of address books, they like me, they really like me,
bwahahahahaha.
joe
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the official ORACLE-L FAQ:
how different is it to administer oracle on different flavors of unix? Im running into
some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell.
is it just little syntax differences or is there alot more to it?
From: Dwayne Cox [EMAIL PROTECTED]
Date: 2003/08/26
Title: RE: virus info
50? They like me more... I had 250 between Friday at 2 pm and Monday at 6 am. Several appear to have even gotten through our virus scan and come to my mail box as complete attachments.
Gives you a warm fuzzy feeling
April Wells
Oracle DBA/Oracle Apps DBA
Title: 8.1.7 + redhat AS 2.1 = trouble
There may be the same issues as with 8.1.7 on RH 7.1 - look on Metalink
for those work arounds and try them on your AS 2.1.
Basically, it has to do with 8.1.7 expecting the standard C libraries
from RH 6.2 which were changed for RH 7.1 and
Red Hat Linux Networking and System Administration from Redhat press is
very good.
Fraser Talbot
M-I LLC
Database Administrator
Information Technology
832.295.2245
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 26, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Both
administering oracle is not really an issue cause sql*plus is sql*plus
regardless, now from the OS side, Solaris can be a pain to bring scripts
from other *nixes over to the sun world. I've written scripts that work
flawlessly on linux, port to HP, port to AIX all w/NO changes, move to
sun
Hello All
Im back from the trenches to post a quick request for
helpg
Ive setup onames on 2 servers and standard applications, (our app and
sqlplus) connect just fine, a problem situation manifests itself when:
1 users need to connect (add a database) to dba studio. They get a error
Wonderful.
I would like to add:
10.1.23.1) After explicitly instructing them not to, have an analyst
from the other side of the world call you at home, @ 3a.m., waking up
spouse and children in the process.
Brian
-Original Message-
Tanel Poder
Sent: Monday, August 25, 2003 6:29
Not just Sun - SCO Unixware puts it there too.
-Original Message-
Sent: Tuesday, August 26, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
administering oracle is not really an issue cause sql*plus is sql*plus
regardless, now from the OS side, Solaris can be a pain to bring
Title: Resolved - Row level security and latch waits
Thanks everyone for your input, the development email is rewriting their code using application contexts.
your help is greatly appreciated.
Raj
Rajendra dot
- Original Message -
how different is it to administer oracle on different flavors of unix? Im running
into some annoying nuassances in
syntax between solaris korn shell and hp-unix korn shell.
is it just little syntax differences or is there alot more to it?
You sure it's HP
ah so i was right? wow... with all those posts. I figured i had been mistaken.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/08/26 Tue AM 09:49:34 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Resolved - Row level security and latch waits
Thanks
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything upper case, now lower cass, its a LOWER
function in SQL) thats even in the oreilly korn shell book.
no solaris has to get cute and make you do:
tr [:upper:] {:lower:]
what i mean by that is
so different flavors of linux are more compatible?
i thought the only two unix players out there now are HP and Solaris. who else is out
there?
so is going between unix flavors like going between databases?
From: Nuno Souto [EMAIL PROTECTED]
Date: 2003/08/26 Tue AM 09:59:33 EDT
To:
Title: Message
Try
doing strace -af -o /tmp/strace.out dbassist and see what is it waiting
for.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ramon
E. EstevezSent: Monday, August 25, 2003 9:54 PMTo:
Solaris simply requires you to quote your translates
tr '[A-B]' '[a-b]'
-Original Message-
Sent: Tuesday, August 26, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything
Title: Message
So
far, I've had only 2. Everybody hates me and that's the way it should be for a
real DBA. Makes me all
warm
and fuzzy inside.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April
WellsSent:
John - Thanks for the heads-up. My intention is to truncate all tables on
the target system beforehand, so that should reset the HWM. Then I have a
lot of tables to load, so my plan is to load multiple tables simultaneously,
trying for separate RAID sets, but use only a single insert on an
Title: RE: Resolved - Row level security and latch waits
Everyone was right ... RTFM and STFW and listening to people on this list always helps.
We are making a better effort with design of the contexts. The developers have been redirected to appropriate sections on the FM.
Raj
Title: Message
Hi!
Increasing it from it's default won't probaly
helpto get a better execution plan, unless you have 10-way or even more
complex joins.
However, having a large value of this parameter
with complex joins can push your parse times (QEP calculations) very
high!
That's why one
Taniel, Binley
Thanks for the excellent suggestions.
At this point we have been testing with two smaller test systems, moving
a single table at a time, but initial indications are that the performance
order is:
1. Perl dump to CSV / ftp / SQL*Loader
2. Copy across database link
3. Export/
Title: Message
What
was the final outcome?
Thanks,
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent:
Monday, August 25, 2003 9:19 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: new server + RAID = ???
I thought
Now that Uday and Qusay have been eliminated, a lot of the lesser-known
family members are coming to the attention of American authorities.
Among the brothers:
Sooflay ..the restaurateur
Guday... the half-Australian brother
Huray the sports
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a security level for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a security level for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select
Corrupting would have been sending the damned dbmssupp.sql and its plb file.
Stephane
-Original Message-
Mladen Gogala
Sent: Monday, August 25, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
I'm corrupting youth.
--
Mladen Gogala
Oracle DBA
-Original Message-
One thing that the docs don't mention is that '8'
(the default in 8) is also a special boundary value.
Anything less than 80,000 changes some of ways the
optimizer does it work, ie, its not just a reduction
in permutations.
Can't remember the specifics - join orders spring to
mind but
Yes, it is required in one of our COTS applications.
Inserts into complex views with instead-f triggers.
The views are quite complex, ridiculously so, one might say.
Before setting optimizer_max_permutations=1000, it took a very
long time to parse those views.
Jared
On Tue, 2003-08-26 at
While work related humor has it's place in the workplace and
on this list, humor for humor's sake should be limited to the
OT list.
There are a *lot* of reasons for this. In the case of this
post, there are folks on this list that will find this offensive.
Thank You,
Jared ( list owner )
On
Is anyone attending the 9i Cram Session on Sunday? If so,
could you please email me off-list?
Thanks,
Brian
[EMAIL PROTECTED]
Rahul,
Glad to know that it worked for you. Yes, I have implemented that and it
works quite well in production.
Just make sure you understand that the columns are not really hidden, just
masked - which means they may convey wrong impressions if not used
properly. In my case, I have avoided using
Well, IBM has AIX, a very solid and stable version of unix which works
really
well. SCO has become very popular lately and using SCO Unix will turn you
into
the most popular guy on this list. Then there is Irix, made by SGI. HP
actually has
several unix versions Tru64, HP-UX, Tandem Unix, Ultrix,
I'm Polish and I don't find it offensive. Want some good Polish jokes?
Ken Janusz
Ken Januszewski (prior to 1910)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 11:04 AM
While work related humor has it's place in the
Rahul:
It sounds like your implementation is very similar, in theory, to Oracle's
Fine Grain Access. Are you re-inventing the wheel?
Reginald W. Bailey
IBM Global Services - ETS SW
9.2.0.3.0 Enterprise Edition
on Win2K
using the 9.2.0.1.0 client.
export hangs on exporting object type definitions
TOAD says that it's trying to 'ALTER TYPE OE.ORDER_TYP COMPILE
SPECIFICATION REUSE SETTINGS'
If I query v$session_wait I get:
SID SEQ#
-- --
EVENT
Reginald,
No, FGAC (or VPD or RLS, depending on who you ask) is not about columns;
it's about restricting rows. Within the selected rows, all the columns are
visible. Rahul wanted to mask columns without creating views for each user.
This is the only way to do that.
Hope this helps.
Arup
Title: DBASSIST HANGS
Hi list,
I manage to install 8.1.7 on RH AS 2.1. From Note 230693.1 I downloaded the jre118_v3 patch from blackdown, applied and the dbassist start, but I'm getting ORACLE NOT AVAILABLE.
No more in metalink.
TIA
Note: Why to deal with Linux is so difficult.
Hi!
What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.
Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo
From _the Onion_'s what-do-you-think regular feature, when the news
about Uday Qusay was more recent:
It's great that we got Uday and Qusay. But what about the eapons-way
of ass-may estruction-day?
I'm still laughing at that one...
www.theonion.com
Roy Pardee
Programmer/Analyst/DBA
SWFPAC
And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
NetBSD). Tragically, none of these run Oracle (FreeBSD can run Oracle in
Linux emulation mode - which seems backwards at best). And there's OS X,
which is Apple's UNIX, and also runs Oracle.
As far as AIX, I couldn't
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some procs .
Now I am getting buffer overflow, limit of 100 bytes error from it . Looks like
they are spitting out debug statmts out with dbms_output . How can I stop this to
happen without touching source
I am looking for some expert suggestions for the migration of 300GB database to
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit
and performance on this system is really slow. Export for 2GB table takes 2 hours. All
the data is on EMC symmetric.
We are
i thought linux was just unix designed to run on a PC. how different is the kernel?
From: Matthew Zito [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:24:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
And of course, there's the other
AIX phased out in favor of Linux? I believe that SCO asked for injunction to
prevent IBM
from distributing AIX, and there is a whole saga around SCO and Linux.
According to some,
Unix variants are like higlanders: there can be only one. If you ask Mr.
Darl McBride,
it's going to be SCO.
contact the vendor and ask them to remove the dbms_output calls?
-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting buffer
Mladen Gogala scribbled on the wall in glitter crayon:
AIX phased out in favor of Linux? I believe that SCO asked for
injunction to prevent IBM
from distributing AIX, and there is a whole saga around SCO and Linux.
According to some,
Unix variants are like higlanders: there can be only one.
The Linux kernel is totally different, though you will find some code in it
that is from System 4 UNIX.
Linux is technically not a UNIX, thought it looks and feels and acts like
one. It's also worth noting that all of the UNIXes have, at this point,
significant differences in terms of their
Just fyi - it seems that Oracle had realized this in advance and has
specifically instructed the Oracle Applications 11i installations to set
this to 2000.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The
talk about unprofessional... this stuff should never go into production. which vendor
is it? ill aviod?
cant you juse set serveroutput off? to turn off the output?
From: Kevin Toepke [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:44:42 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
I am sure you will pissed of , if I turn off your machine . ;)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 10:44 AM
Turn off the machine.
--
Mladen Gogala
Oracle DBA
-Original Message-
Sent: Tuesday,
The SCO Linux litigation that is raging right now is such a nightmare of FUD
and absurd legal process. For starters, SCO's UNIX implementation is dead
in the water - not only was it the worst UNIX I've ever worked with, but
even SCO has no plans to aggresively continue development on it. Only
Forgot the smiley!
And, to make up for that, I ran a simple test and found that 'set
serveroutput off' solves the problem.
My code:
BEGIN
dbms_output.put_line('sysdate: ' || sysdate);
END;
/
with serveroutput on started dumping data to the screen in about 5 seconds.
With serveroutput off I
looks like internally from proc its setting dbms_output.enable();
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 11:04 AM
talk about unprofessional... this stuff should never go into production.
which vendor is it?
Turn off the machine.
--
Mladen Gogala
Oracle DBA
-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting buffer overflow, limit
Did you analyze the sys schema by mistake. This can stop the fastest
database. We had a contractor do that to an 8.0.5 database once, and only
once.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Burton, Laura
Sent: Monday, August 25, 2003 4:49
If you cannot recover the database, you *** CAN *** take a cold backup
and open it elsewhere, on a 5.2 box, for example. You only have to make sure
that you loaded the right post_wait extensions. I advise you to use the ones
from 9.2. Boot the machine in 32 bit mode. No migration is necessary,
Different from what? It's very different from NT kernel.
--
Mladen Gogala
Oracle DBA
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
i thought linux was just unix designed to run on a PC. how different is the
linux from unix?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 02:34:28 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
Different from what? It's very different from NT kernel.
--
Mladen Gogala
Oracle DBA
For all you virus/worm lovers out there, justice do come:
FBI Subpoenas Arizona ISP In Sobig Probe
Easynews says it's cooperating with the bureau to find the person
who uploaded the virus to a Usenet group it hosts.
informationweek.com/story/showArticle.jhtml?articleID=13800091
Dick Goulet
This would be alot of extra work and downtime compared to export/import but...
1) upgrade to AIX 4.3.3 You might want to think about using AIX 64 bit here
(you can still run Oracle on 32 bit if you want).
2) upgrade to 8.1.7.4
3) AIX 4.3.3 is binary compatable with 5.1, so you _could do
No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips
Techniques). As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table
Bob,
I understand what you are saying (and your pain). My suggestion would be to
use the 'namesctl dump_tnsnames' command to dump out the current Onames
repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might
want o rename the current TNSNAMES.ORA file just prior to that as
Tanel
Thanks for the ideas. My simple mind says that by fully utilizing the
hardware I can minimize the overall time. But today we were on a conference
call with the application vendor and they were touting their utility for
handling this. Everyone around the table seemed pretty impressed, so
Tanel,
A quick question? How many open dblinks you have used at one time without
any issues? Default setting in init.ora is 4(if I am not wrong) and I never
used it more than that. If Dennis wants to use more than 4 dblinks at one
time, he should modify this param(open_dblinks) in init.ora,
Hi,
I have the following output when I querying dba_tables.
Question 1: This table is created using manual management method, right?
What do I do in order to turn it to Automatic segment-space management?
Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?
I was
not getting result from set_ev because I used set_ev(sid,serial,10046,8,null)
instead of set_ev(sid,serial,10046,8,'')
I
thought that null and '' can be usedwithout
difference.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
Roger,
1. Space management can be specified for a tablespace, not a segment. Create
ASSM tablespace and alter table ... move there.
2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
PCT_INCREASE then.
HTH
Vadim
-Original Message-
Sent: Tuesday, August 26,
Laura,
You might find the problem by checking the things you plan to check, and
by following the advice of the book you're using. But the odds are very
good that you will not. At least not for a long time...
Any application program on your system can tell you where it is spending
its time. Let
Liunx was initially meant to be a posix standard and minix compatible OS
running on 386 for hackers and computer enthusiasts. Even Linus himself
didn't predict it's growth and current status at first. At first it wasn't
even completely independent, it used minix formatted filesystems etc..
But
Title: Message
The current situation is that some rebels still
suggest storing your database on non-protected storage and come ask for help
here when their entire database (including last 3 months archivelogs) crashes
with this single disk..
Tanel.
- Original Message -
From:
I doubt they will ever find the real guy behind this.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 10:19 PM
For all you virus/worm lovers out there, justice do come:
FBI Subpoenas Arizona ISP In Sobig Probe
AFAIK, Apples unix is based on [Open|Free]BSD as well.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 8:24 PM
And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
NetBSD). Tragically, none
Title: RE: Performance Problem
Funny ...
I have tkprof give up analyzing a 4.2G tracefile on a 64bit platform. anyone else experienced this??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
1 - 100 of 125 matches
Mail list logo