hmm,
free() doesn't do sbrk() with a negative to reduce the process space. So yes
the space stays allocated.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 7:58 AM
Hi
SITUATION - On a production APP Server
Title: Details about Tar logged
SITUATION - WithDBServerCPU Idle being 0 %
load average 60-70 % :-
tnsping Connect toone of the Databases (1)takes about
10,000 ms
truss
-fdD tnsping connect string
29504: 20.0006 18.8113 read(3, "\0 K\0\004\0\0\0 "\0\0
?".., 2064) = 75
Thus
18
Hi folks,
how can I tell a PLSQL script not to store it's
UTL_FILE.Put_Line(fHandle,'TEXT') output to the
filesystem of the server, but on the client ?
Whenever I run this locally it's ok. But if the DB is on a network server,
it's filesystem
is used.
I am using NT/SP6/Oracle 8x. Is this
I have to say that I still have an emotional
response to 'shutdown abort', despite knowing
that logically it ought to be perfectly safe.
The reason for this is the lack of stress testing
that goes on at Oracle Corp. In most (if not
all) cases, the only blanket stress test that
the software gets
And if we're only talking a limited number of indexes, you can isolate them
in separate tablespaces/datafiles and look at v$datafile.
Mogens
Sutton, Reed wrote:
Prem,
I found this on Google. Some guy named Thomas Kyte? He sounds like
maybe he might know what he is talking about
Hi leng,
The following works fine with SQL*Plus if you include it in Glogin(Login).sql
column user new_value A noprint
column global_name new_value B noprint
select user from dual;
select global_name from global_name;
set sqlprompt A@B.
HTH ...
Regards
JAI
Kaing, Leng [EMAIL
hi hamid!
what about doing it with by twice altering the sequence:
/* create the seq */
SQL create sequence myseq nomaxvalue nocycle nocache order;
/* reset the seq */
SQL select myseq.currval from dual;
/* assume that curval = 6 */
SQL alter sequence myseq maxvalue 6 cycle;
/* back at 1 */
SQL
What does tnsping from other machines to the slow database, database 1,
return? Is this a problem only from this one machine or from many
machines?
I would wager that the problem is that database 1 2 are being
resolved through different paths at the TNS level. Perhaps one is
using a local
Title: RE: Trace file size...
Hi Jeremiah,
When ever I run a certain Automation script file, I get an error pointing it to a trace file S000.trc or S001.trc, when I check these files they both point out that they are full, *** TRACE FILE FULL *** What should I do to get rid of this error,
Hi Listers,
I have the below query which takes 36 sec. to execute:
SELECT /*+ordered*/
S.HOUSEBILL,
OH.ORDER_REF_NO,
V.CONTAINER_NUM,
S.AEI_REFERENCE,
CE1.SEQUENCE,
TL1.COMPONENT_VALUE,
TL2.COMPONENT_VALUE,(
SELECT
to_char(SCT1.TIMESTAMP,
I totally agree
I am witness of one of these untested combination resulting in true disaster .
And the combination was shutdown immediate to an extremely busy database (with no
response), followed by shutdown abort and all the data files got corrupted. We could
not recover that
There are a lot of good items on your list. Harrison is the definitive work on Oracle
SQL tuning, though it is also worthwhile to pick up the O'Reilly pocket SQL tuning
book as well. Robert Freeman's books are uniformly excellent. Geoff Ingram's book
was a pleasure to read and contains a great
Dear all DBAs,
i'm using Oracle 8.0.5 on Linux 6.4 kernel
2.2.14.
when i try to place the rollback segment
online,
it show error as below:
SQL ALTER ROLLBACK SEGMENT "RB28"
ONLINE;ALTER ROLLBACK SEGMENT "RB28" ONLINE*ERROR at line
1:ORA-01599: failed to acquire rollback segment (28),
I installed the RedHat 8.0 on server and plan to install the ORACLE 8.1.7.
After I type ./runInstaller on console, their is Nothing display.
redhat::/u/CD/Disk1[37]%./runInstaller
redhat::/u/CD/Disk1[38]%Initializing Java Virtual Machine from
All
Have any of you worked with this product that is supposed to improve the
performance of a RDBMS or a OLAP database... Damagement heard about this
product form somewhere and wants us to investigate...
Any feedback is appreciated..
TIA
Babu
_
This e-mail transmission and any
max_rollback_segment is in the
init.ora parameter file.
You will need to bounce the
database after setting the value.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 03, 2003 2:49
PMTo: Multiple recipients of list ORACLE-LSubject:
exp help=yes
Johnson; Michael [EMAIL PROTECTED] wrote on 1/31/03 3:34 pm:
From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when using export and import that I
keep on file.
Im sure he could
Rajesh,
There are unknowns with every feature. ABORT is a feature just as
IMMEDIATE is. In version 7, I encountered a bug with IMMEDIATE that
required recovery from a backup, and eventually manual BBED'ing of the
SYSTEM datafile by Oracle BDE. SO maybe we shouldn't use immediate
either. I'll
Shuan - If you go to
http://www.google.com/search?hl=en
http://www.google.com/search?hl=enie=ISO-8859-1q=max_rollback_segments
ie=ISO-8859-1q=max_rollback_segments
you can find a lot of information on this parameter. Oracle needs to
allocate a finite amount of memory to manage rollback segments,
Babu - Hadn't heard of it, looked at the link you provided. Tell your
management that it isn't needed because Oracle has Materialized Views. ;-)
Seriously, if I were you, I would compare how this tool works against
Oracle's Materialized View feature.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
When we do cold backups, our script issues 'shutdown immediate', if within 3 minutes the db is not shut down, we cancel and issue 'shutdown abort'. In either case, we (again issue) startup/shutdown to make it clean
What is your DISPLAY environment variable set to?
-Joe
--- dist cash [EMAIL PROTECTED] wrote:
I installed the RedHat 8.0 on server and plan to install the ORACLE
8.1.7.
After I type ./runInstaller on console, their is Nothing display.
redhat::/u/CD/Disk1[37]%./runInstaller
Also, a bigger question, why was another schema able to create indexes
in SYSTEM. Was it granted the resource role? If yes, revoke the unlimited
tablespace privilege from it. And also check the default tablespace to
ensure it's not SYSTEM.
-Original Message-
Sent: Monday, February 03,
Ranganath
I notice that the cost for the explain plan is identical. Keep in mind
that the explain plan is a good quick look at how Oracle intends to perform
the query, but is not an actual execution. It can be fooled, and even make
bad choices. When I encounter a query where explain plan isn't
And of course Jonathan Lewis' Practical Oracle8i is another
must-have, though we
are all waiting for the 9i edition (nudge, nudge).
I seem to remember Jonathan cursing the publisher for putting a version on
the book - the vast bulk of the material being relevant for all of 8i and
9i. However,
Hi
brk, sbrk functions are used for DATA segments and we have problem with HEAP. Malloc
allocates space onto heap and not in DATA segment.
Seemingly the man page imply that it should not be used in conjunction with malloc,
calloc ,
that we are using.
Pasting from man pages :-
USAGE
The
try strace ./runInstaller
or
strace ../runInstaller
--
Lyndon Tiu
Quoting Joe Raube [EMAIL PROTECTED]:
What is your DISPLAY environment variable set to?
-Joe
--- dist cash [EMAIL PROTECTED] wrote:
I installed the RedHat 8.0 on server and plan to install the
ORACLE
8.1.7.
Babu,
Hadn't ever heard of the tool. Funny that they're listing a visit to
IOUG-A, but have never been mentioned in the Oracle or Select mag's. Anyway, I
looked the site over and it is interesting at best. We have a similar though
not identical product from Cognos called PowerPlay. As I
Raj - If someone hasn't previously used tkprof, in your opinion should they
start with this utility, or with tkprof and work their way to this?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, February 03, 2003 9:40 AM
To: Multiple
The following query may help locating the high water mark.
1 select f1.file_name, round(f1.bytes / 1024 / 1024) ALLOCATED_MB,
2 round(f2.block_size * (1 + max(u.block# + u.length)) / 1024 / 1024, 2)
HWM_MB
3 from dba_data_files f1,
4 v$datafile f2,
5 sys.uet$ u
I need some help with some SQL pleeeaasseee
I'm trying to do some summay work with some data using some of the
Oracle9i Analytic functions.
Here is the sample data:
SQL select * from sum_test;
ID TODAY CODE VALUE
-- -
Hi:
This morning I found that in our production oracle 8173 db (on Solaris 2.8)
there were some invalid sys package bodies:
SQL select owner, object_name,object_type from all_objects
where status='INVALID'
order by owner desc, object_type desc , object_name; 23
OWNER
Title: RE: Query takes more time when number of IN List value increases
Also see
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT_id=224270.1 this makes it easy ...
Raj
__
Rajendra Jamadagni
We send out Access users to a datamart where we have replicated and
de-normalized tables for them to play with. We don't allow them to query
the production database since they are bound to eventually come up with the
ad-hoc sql query from hell that will bring the database to a screaching
halt.
You are correct.
I asked Jonathan about 9i revision of the book (last fall at Ann Arbor OUG),
and the answer was: he is not planning on it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 03,
Question, Are you running a graphical terminal emulator like Reflections-X? The
installer requires one, damned thing.
Dick Goulet
Reply Separator
Author: Lyndon Tiu [EMAIL PROTECTED]
Date: 2/3/2003 7:29 AM
try strace ./runInstaller
or
strace
Title: RE: Query takes more time when number of IN List value increases
Dennis,
I am not an expert, but I find this utility gives a (relatively) readable output compared to tkprof. I use both, but for starters I'd say, look at both and see what you like. This utility doesn't use tkprof ...
Title: Oracle 9.2 on Windows .NET Server
Hi List,
I have to install a Oracle 9.2 database on a Windows .NET Server (Windows 2003 Server). Anybody did this before, is it possible, are there some things I have to look for?
A lot of questions, every comment is welcome.
regards
Volker
Okay -
The official line -
Every now and again I think that maybe
I could just produce a 9i supplement.
But seriously, there isn't a hope. After
all, it might encourage Larry to bring
forward the launch of Oracle 10.
However, for a small fee, I can supply
current owners of
Where can I download the patch? :)
-Original Message-
Sent: Monday, February 03, 2003 12:07 PM
To: Multiple recipients of list ORACLE-L
Okay -
The official line -
Every now and again I think that maybe
I could just produce a 9i supplement.
But seriously, there isn't a hope.
Is there an "Easy"
way to assign specific tnslistener
ports to a specific
database?
Let's say I
wanted:
1521 to be
prod1
1522 to be
devl1
1523 to be
web1
1524 to be
test1
Right now ports are
basically assigned to servers
which may well be
adequate. But I was asked, and
it seems
Mike,
The listener is assigned the port, not the database. When a connection
request comes in the listener receives it on the port assigned, 1521 being the
default or most popular. Thereafter what happens depends on whether or not your
using connection manager, multi threaded server, or
In the same vane, does anyone know the difference between the Base,
Standard, and Premium versions of RH AS2.1? And will any of these work
with 9i RAC (if the difference is more than just support)? And I don't
suppose it's available for download anywhere for testing, is it?
The RedHat site
I'd really not purchase RH advanced Server 2.1 and just try it on rh
8.0, is this even possible?, I've got like no experience on the
clustering side of operating systems.
I can't see why not, with a few caveats.
First, AS is effectively redhat 7.2 with a different kernel and a couple of
Using a logon trigger works until they figure out
that renaming the executable will let them in.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/02/2003 08:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I'll go along with Dennis, their online brochure offers
no compelling reason to investigate this.
The lack of any mention of MV's ( as in, Why our product
is better than Materialized Views) and the implication that
it won't require tuning by the DBA make it seem rather
suspicious.
my $0.02
Mike,
the
only way that I know of to do this is to run mutiple listeners on your
server. you can set-up multiple listeners within your listener.ora file,
and assign each one the port you want it to use. you then would need to
start each listener separately.
in
your case, your listener
Use the translate command tr. Type man tr for help with using it.
RWB
Guang Mei [EMAIL PROTECTED]@fatcity.com on 02/03/2003 12:39:48 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Hi:
I have a
Hi:
I have a quick question about replacing $ with \$ on unix. I need to
convert string 123$45$678 to 123\$45\$678 through a pipe. I tried with
sed command, but could not get it to work:
essex$ echo 123$45$678 | sed s/$/\$/g
123578$
essex$ echo 123$45$678 | sed s/$/\\$/g
123578$
Maybe there
Title: OT: Help - AIX and Sendmail
Hello everyone ,
Sendmail and mailx isn't working on my two AIX hosts. I can send mail from the host if I do it manually via telnet port 25 but I can't figure out how to configure it properly. My knowledge of networking is basically zilch.
If anyone
echo '123$456$789' | sed 's/\$/\\\$/g'
123\$456\$789
Why? The $ means end of line to sed; so you have to quote it too.
-Original Message-
Maybe there is another syntax that I should use? TIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
I think it's just the support that's different in base vs standard and
premium.
RH made the source RPM available for download, there are litertlly thousands
of
them.
And to answer your previous e-mail, you don't necessarily need RHAS to play
with
RAC. The only reason you need RHAS is if you want
Michael - Before you go using just any port, you may want to ask yourself if
something else uses that port. On most Unix systems it is sort of the honor
system, as was explained to me. There is usually a file (name varies by
flavor of Unix) where you are supposed to register your intention to use
Please note the use of single-quotes (') instead of
double-quotes () in the echo command, as well as the use of
single-quotes in the sed command...
$ echo '123$45$678' | sed 's/\$/\\$/g'
123\$45\$678
Hope this helps...
Hi:
I have a quick question about replacing $ with \$ on
unix.
Title: OT: Sendmail, never mind
Of course I stumbled across the fix two minutes after I threw my hands up.
My apologies for adding to the list volume. Sorry.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Problem here is that sed treats $ as a special characer meaning end of line as well as
the korn
shell meaning variable replacement.
To avoid the shell evaluation, use ' not .
to avoid the sed special charater, escape it.
echo '123$45$678' | sed 's/\$/\\\$/g'
Ron Thomas
Hypercom, Inc
[EMAIL
Title: RE: HyperRoll Experience (http://www.hyperroll.com)
The people who work on Oracle Express
(multi-dimensional DB) are using it with
great success. Note that this does not
include me. I have not used it personally.
Mark Cawi of ThinkFast consulting did a presentation
on HyperRoll at
echo '123$45$678' | sed -e 's#\$#\\$#g'
Guang Mei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/03/2003 10:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT: unix script quetion: to replace $
Title: Details about Tar logged
Vivek
I had similar issues with a large customer. I
solved this by setting up pre-spawned dedicated processes in the listener. Full
in structionsavailable on Metalink. I brought down 1 minute login times to
under 10 seconds, by configuring 20 - 40 prespawned
Hi, Brian:
Thanks for your (and others) help. I can not use signle quotes in echo
in my program. The reason is this:
I am trying to run table analyze in multiple treads (I found doing this
reduce time by 50%). By doing this I run sh script
gather_ISI_table_stats_executeX.sh:
essex$ more
Your first echo needs to be in single quotes or else it results in...
29912:oracle@mybox echo 123$45$678
123578
Once that is done this...
29912:oracle@mybox echo '123$45$678' | sed 's/\$/\\$/g'
123\$45\$678
...or this...
29912:oracle@mybox echo '123$45$678' | sed 's/\$/\\\$/g'
123\$45\$678
Keep in mind that OWS will only support the AS 2.1 platform when dealing
with RedHat distro. If you have a problem with your system, Oracle will
close your TAR as soon as they find out you are not on the supported
platform. Done that/got the e-slap for it.
Rodd Holman
On Mon, 2003-02-03 at
Gary,
You have to rename the clone to the origianal but backing up
the controlfile to trace and then editting the results. Change the use
database to set database to the original name. The restore is as if it was
the original, recovery it, and name it back to the clone. If you still
don't
Use the octal code for the character, and using the quoting
mechanism of your choice:
$ = octal 044
echo '123$45$678' | sed -e s#\044#\\\044#g
Jared
Guang Mei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/03/2003 12:09 PM
Please respond to ORACLE-L
To: Multiple
Would something like this be adaptable to your stuff?
#!/usr/bin/ksh
{
sqlplus -s -XXX
joe/blow@SID
set this and that off
set the other thing and trimspool on
set whatever else
select table_name from dba_tables where owner = 'BUBBA';
} | while read LINE;
Title: awk and ksh question
Hello everyone,
I'm trying to awk through a text file and use that with a passed-in message to send email. Here's an example of my text file:
# DBA's on call
[EMAIL PROTECTED] # Lisa pager
[EMAIL PROTECTED] # Lisa email
Here's my awk statement, which works
Hi:
I ended up solving my problem by changing my query in get_ISI_tabs.sql to:
select 'execute DBMS_STATS.GATHER_TABLE_STATS('''||owner||''','''||
segment_name||''',cascade = TRUE);'
from ( select owner, replace (segment_name, '$','\$') segment_name,
sum(bytes) from
The problem is that if LINE contains $ (dollar sign), as some InterMedia
table names do, the piped command will fail.
Guang
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Stephen Lee
Sent: Monday, February 03, 2003 3:54 PM
To: Multiple recipients
Keep in mind that OWS will only support the AS 2.1 platform when dealing
with RedHat distro. If you have a problem with your system, Oracle will
close your TAR as soon as they find out you are not on the supported
platform. Done that/got the e-slap for it.
This is a very good point. If you
$number to awk means the number-th field.
To pass variables into an awk statement, you generally have two choices:
1. The ugly one where you do a bunch of stuff with double and single
quotes.
2. The correct one where you do something like
/usr/bin/nawk 'statement AWKVAR1 more statement
Jay,
We're talking about the SQL*Plus Worksheet for Windows here, not good old plain
SQL*Plus. Your solution only works for SQL*Plus, but not the Worksheet.
Cheers,
Leng.
-
From: [EMAIL PROTECTED]
Date: Mon, 3 Feb 2003 14:38:35 +0530
Subject: RE: SQL*Plus Worksheet Question
Lisa,
Awk and sh are competing for the interpretation of $1. I messed
around trying to get the replacement not to happen but didn't have
much luck.
Awk is overkill for this anyway. How about:
export FILE=$1
print File is $FILE
for PAGER in `grep -v ^# $FILE | cut -d -f1`
do
print $PAGER
Lisa,
And you're probably reinventing the wheel. Take a look at:
$ man aliases
$ man mailrc
-rje
K Hello everyone,
K I'm trying to awk through a text file and use that with a passed-in message
K to send email. Here's an example of my text file:
K # DBA's on call
K [EMAIL PROTECTED]#
Will this work?
select b.id
, trunc(b.today) tday
, b.code
, b.value
, sum(B.VALUE) over (partition by b.id, trunc(b.today), b.code order
by b.id, trunc(b.today), B.CODE range between unbounded preceding and
CURRENT ROW) val_total
from ( select id, trunc(today) today, code,
Lisa,
Try:
export FILE=$1
print File is $FILE
for PAGER in ${*-$(awk -v FILE=$FILE '!/^#/ {print FILE}'
dba_oncall.txt)};
do
print $PAGER
done
Koivu, Lisa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/03/2003 01:28 PM
Please respond to ORACLE-L
To: Multiple
Thanks for all those replied.
have a nice day!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 9:33 PM
Shuan - If you go to
http://www.google.com/search?hl=en
Friends,
Can logminer be used against 7.3 databases (or rather: 7.3 logfiles)
like it can be used against 8.0?
Best regards,
Mogens
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi, I am new to oracle, I just installed oracle8i in
windows2000, durring the installation I called the
default database test, I wrote a small java class
using the JDBC, everything is working fine, my
question please :
1)can I create another database in oracle (leave the
database test)so I will
Source RPMS are available but thats about it.
joe
Jesse, Rich wrote:
In the same vane, does anyone know the difference between the Base,
Standard, and Premium versions of RH AS2.1? And will any of these work
with 9i RAC (if the difference is more than just support)? And I don't
suppose it's
I wish I could afford fibre :)
Nope this is just a large experiment, so we're going to try hacking it
together with the least amount spent as possible.
We're toying with openssi for our clustering, who knows how this will
end up :)
thanks for the input.
joe
Craig I. Hagan wrote:
I'd
You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the
commands starting from Create database . from
SVRMGRL.
majid [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/04/03 08:43 AM
Please respond to ORACLE-L
To:Multiple recipients of list
Rodd, fully aware but this is just an experiment for a couple of DBAs to
see if we can get it working, the joy of it all ;)
joe
Rodd Holman wrote:
Keep in mind that OWS will only support the AS 2.1 platform when dealing
with RedHat distro. If you have a problem with your system, Oracle will
hi,
When you want to apply patch for your db on linux, for example, 9202, it need the
hangcheck module. and this module need the redhat advanced server kernel, so if you do
your rac with rh8, Can you still apply the patch?
And it is beyond the support of oracle support, when you run into
Dear friends,
Could someone enlighten me on the steps to be carried out using RMAN
and using OS commands for Recovery if :
1. A current redo log file is corrupted.
2. The System TS is corrupted.
Thanks for your help in advance.
Best Regards
Jai
Hi,
In both case, you have to restore an old backup, and do you recovery. If current
redo is corrupted, (unless shutdown cleanly), you have to do incomplete recovery, if
system ts is corrupted, you can do complete recovery if you have all the files needed.
For detailed steps, you should
Oracle 9.2.0.2 RAC on RedHat 7.2 is OK, but 7.2 has no support for CFS or
AIO (As I remember - it has been a while. I switched to AS 2.1, still on
raw devices, months ago.). It was in many respects the least problematic
combination, but is, of course, not officially supported.
As far as the
This question is Discoverer/Jinitiator/Internet related but I'm hoping
someone has a suggestion
We have Discoverer Plus 4i available to our clients through the
Internet. Most of them can download Jinitiator (1.1.8.11) and run
Discoverer without a problem (once their firewall is open). One
Hi,
I also faced the similar type of problem. So we changed the settings in Browser from
automatic setting to manual proxy settings. some times Jinitiator will not read the
PAC file used for proxy settings. That's the reason.
HTH
Venkat
--
On Mon, 03 Feb 2003 21:48:40
Seley, Linda wrote:
88 matches
Mail list logo
