Title: Message
Help
System
Admin. got a wild hair and changed the hostname on us for a 9ias v2
server.
Now
none of the processes work and getting all kinds of unhandled java exceptions
regarding hostname
oracle.ias.repository.schema.SchemaException:Unable to connect to
Directory
I
Have the
SysAdmin change the hostname back. Haven't used 9iAS but in the past, the
hostname was embedded in the install config files. You can put in a DNS
alias for your old hostname for a work around.
[EMAIL PROTECTED] 01/23/04 11:44AM
Help
System
Admin. got a wild hair and changed the
Did you change LDAP configuration files? Which LDAP server
was it? WebLogic? WebSphere? iPlanet? iAS? OpenLDAP?
Usually, after changing the host name, servers have to
be reconfigured and re-started? Does your LDAP server
have a GUI admin utility and can you connect to the server
by using that
.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/23/2004 08:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Help - 9ias broke - hostname was changed
Help
System Admin. got a wild hair and changed the hostname
Yes,
but how do I fix it? Do I need to reinstall?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help - 9ias broke - hostname
I
think he lucked out and didn't do this on a highly visible system.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help - 9ias
. This one's days are
limited
to about 10.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/23/2004 08:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Help - 9ias
LOL!!
Ok, Ashish, the problem is you sent 'help' to the list address.
Send HELP to [EMAIL PROTECTED] and all will be well.
Ok, now back to work everyone.
Jared
Odland, Brad [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/2004 07:59 AM
Please respond to ORACLE-L
To:
Abandon hope, all ye who enter here
(Dante Alighieri)
On 01/20/2004 10:24:27 AM, Bill Gentry wrote:
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos
Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
One minor caveat about setting timed_os_statistics. On Solaris, if you set
timed_os_statistics to non-zero, microstate accounting at the OS level is
enabled for the server process. Common practice is to leave it off for
performance reason. But I've never seen experimental data proving the negative
v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level is set to ALL. You can set that at
the session level.
Has anyone done measurements on a busy system to evaluate what the impact
is of setting that system-wide. The impression I have is
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row count from asktom
v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level is set to ALL. You can set that at
the session level.
Has anyone done measurements
Don't be afraid to access v$ views, just beware of the bug that throws a ora-600 when
selecting 'filter_predicates' and 'access_predicates' under 9202. As a workaround,
don't select those two columns. If I were you, I'd make sure that users are *very*
clear that the number you are going to get
. It's built-in to Intermedia.
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 12/30/2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: Re: help with estimate row count from asktom
im concerned about hitting the v
anyone have a better way to do this? im going to post what you said wolfgang on asktom
and see what he has to say.
From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row
: 2003/12/30 Tue PM 01:29:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: help with estimate row count from asktom
Don't be afraid to access v$ views, just beware of the bug that throws a ora-600
when selecting 'filter_predicates' and 'access_predicates' under
Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row count from asktom
v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level
Hi,
It is spending a lot of time waiting for IO and something like that.
If you want to see what is the session waiting for ,just do:
alter session set timed_statistics = true; (ignore it if it is already true)
alter session set events '10046 trace name context forever,level 8';
You full scans within the loops which are hitting the disks, ie.58730
which gives the big difference between cpu elapsed as it's waiting for
IO
Also why do you need
and p.business_country_id=c.countryabbrev
As well as
and p.business_country_id in ( select countryabbrev from c )
Do you want to
I'm not so sure. The query returns no rows and the second to last nested
loop already has only 1 row in the resultset. I'd try to determine what the
most limiting condition is - or set of conditions - those that eliminate
most rows early on and make sure the optimizer starts with that.
I could
(select countryabbrev from c) subquery will have some more predicate (where
clause) to restric few countries. Basically I don't want to select all the
countries. For simplicity sake I remove those where clause(business logic).
Anyway EXECUTION PLAN will not get changed.
-Original
:
Sent by: Subject: RE: Help on tkprof output
[EMAIL PROTECTED
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes).
HTH
SF
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -
Date: Friday, November 14, 2003 8:59 am
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump
Barbs, what this trace file tells you is that the client program
takes much more time delivering the data to oracle then it takes
for oracle to deliver the data to the program. In other words, your
program takes its time between the calls to the database. Maybe you
should run the profiler and see
Barb,
This is a great example of where reading the trace file will tell you
what you need to know. Is the 10 centiseconds of time in 8 1.25
centisecond events or in 1 10 centisecond event and 7 .1 centisecond
events? The location (parse/execute/fetch/post tx) are also important.
Daniel
Barbara
Barb,
I think tkprof prints output in seconds, so I think you're looking at
10.73 seconds of response time here.
First, some definitions:
- The SQL*Net message from client event maps to an OS read() call to
the file descriptor to which SQL*Net is connected.
- The SQL*Net message to client
In other words, you can finish performance analysis of the client
only by finding out where the time is spent on the client side.
If it's an interactive program and you have a homo sapiens interacting
with it, then think time is a factor. If, on the other hand, it's
a batch program, then run a
Daniel, it's seconds, not centiseconds. The tkprof writes things down
in seconds. If it's a 9i trace, then the times within trc files are in
microseconds. In trc file produced by 8i, it's centiseconds. By some magic,
tkprof knows the difference and usually gets the right times.
On 11/12/2003
Daniel:
Does this mean I was supposed to be paying attention
in class??
Here's everything I can find associated with sql*net
message from client in that cursor. Can't figure out
from this how it came up with 10.73 (although that one
wait matches up with the max wait of 10.71)
Am I being
Barbara,
I know how distracted you were with all the jokes being tossed about,
but really...
It looks to me (with just this snippet of trace) that the cursor #3 did
some communication and then waited for 10 seconds for a response.
Without seeing the raw trace file and sequence of events, this is
Barb,
What you're really after is called forward attribution in the book.
You need to see the dbcall that immediately follows each WAIT
nam='SQL*Net message from client' event in the trace file. This will
tell you what database call's execution it was that ended the read().
Cary Millsap
Hotsos
To finish off the answer to your direct question, compute the sum of the
ela values shown in your excerpt:
0 cs
0
1
0
0
0
1
1071
---
1073 cs = 10.73 seconds
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19
The page seems to be dead. A quick search on google:
http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=PL%2FSQL+MD4+and+MD5+
by+Keith+Gardner+X=1
Turned up this page:
http://pajhome.org.uk/crypt/md5/
that has a link to the page you are after:
http://www.gt.ed.net/keith/plsql/
But, as I
1) www.google.com
2) enter search criteria : PL/SQL MD4 and MD5 by Keith Gardner
3) google returns : http://pajhome.org.uk/crypt/md5/
4) Click on link and download MD4/MD5/SHA-1 secure hash algorithms etc.
:-)
Ron
-Original Message-
Paulo Gomes
Sent: 31 October 2003 11:34
To:
The code is available at http://cellar.sourceforge.net/plsql/
On Fri, 2003-10-31 at 03:49, Mark Leith wrote:
The page seems to be dead. A quick search on google:
http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=PL%2FSQL+MD4+and+MD5+
by+Keith+Gardner+X=1
Turned up this page:
Thanks, Jared
Regards
Pg
-Mensagem original-
De: Jared Still [mailto:[EMAIL PROTECTED]
Enviada: sexta-feira, 31 de Outubro de 2003 15:00
Para: Multiple recipients of list ORACLE-L
Assunto: RE: HELP HELP Trying to find this: PL/SQL MD4 and MD5 by Keith
The code is available at http
Have been there, thanks
Regards
PG
-Mensagem original-
De: Ron Perrie [mailto:[EMAIL PROTECTED]
Enviada: sexta-feira, 31 de Outubro de 2003 14:05
Para: Multiple recipients of list ORACLE-L
Assunto: RE: HELP HELP Trying to find this: PL/SQL MD4 and MD5 by Keith
Gardne
1) www.google.com
Forgive me if you've already considered this option and discarded it, but wouldn't a
group by combined with a max() aggregate function give you what you want?
Example:
SQL select
2 a.owner || '.' || a.table_name || '' as tbl,
3 max (b.partition_name) as last_partition
4 from
5
c:\progra~1\RESOUR~1\robocopy
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 03:04
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me
Ron,
It works as you requested on 8.1.7.4.
Ron mª¿ªm
[EMAIL PROTECTED] 10/08/03 05:34PM
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me how to get around this?
echo select 'host c:\program
Ron,
First of all, is echo a SQL*Plis command?
Secondly, I think this will do what you want:
select 'host c:\program files\resource kit\robocopy' from dual;
as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.
If you want to do something else, clarify your
Sorry, this is what I am trying to run. But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.
set heading off;
set feedback off;
set linesize 1000;
What is echo supposed to do? The proper command
should read like this:
select 'host /program\ files/resource\ kit/robocopy' from dual;
On Wed, 2003-10-08 at 17:34, Smith, Ron L. wrote:
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple
Never mind. The error was related to another problem with the script.
Thanks!
Ron
-Original Message-
Sent: Wednesday, October 08, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
Two options:
1. Change \program files\ to \program~1\
That should execute with no problems.
2. Another tact:
select 'host '||chr(34)||'c:\program files\resource kit\robocopy'||chr(34)||
' f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Ron,
one could include that directory in the path, then you would not have to provide the path in the command.
Pd"Smith, Ron L." [EMAIL PROTECTED] wrote:
I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'.
Can anyone tell me how
Select sysdate from dual into variable or rebluid the procedure to have in
variable and give the date in the execute command of the procedure.
-Mensagem original-
De: Malik, Fawzia [mailto:[EMAIL PROTECTED]
Enviada: quinta-feira, 2 de Outubro de 2003 12:50
Para: Multiple recipients of
Here's one way:
define delete_date_format = 'dd/mm/yy'
col old_nls_date_format noprint new_value old_nls_date_format
select value old_nls_date_format
from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
/
alter session set nls_date_format = 'delete_date_format';
accept delete_date
How many control files you have? try to remove it from your initSID ora and
start again. Try to remove one by one, if you have more than one
controlfile. Otherwise restore it whole cold back up if you have.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Stephen,
Thanks for pointer. I am subscribing to that list. My ultimate goal after
installing Linux is to install Oracle. I am still waiting response from
Mladen about this subject, who may be enjoying long weekend in USA.
My problem may be new hardware most possibly built in video on board. I
DIAL 911
-Original Message-
Sent: 18 August 2003 17:14
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Zhou, Tapiwanashe
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Interesting analysis. Thanks.
Henry
-Original Message-
Wolfgang Breitling
Sent: Monday, August 04, 2003 11:49 PM
To: Multiple recipients of list ORACLE-L
Yes, the index can be used, but only the portion up to the first missing
column, or a column where the predicate is not an equal
Yes, the index can be used, but only the portion up to the first missing
column, or a column where the predicate is not an equal predicate, is used.
Those are so-called access predicates. The remaining predicates are
resolved after the row is fetched from the datablock - a so-called filter
Wolfgang,
as long as the leading columns are present in the where clause with an
equal predicate, the index can be used. The first omission or non-equal
predicate breaks the chain and only the part of the index up to that
column
can be used.
Could you please elaborate what you meant by that?
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other
RTFM - Read the following message ;-)
-Original Message-
From: yerragudi reddy [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Help me to unsubscribe
How to unsubscribe to fatcity.
Please help resolve this dispute.
We have a query that runs over 5 hours. Sections of the query are
listed below.
The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID. My
Title: RE: HELP! Index Debate!
How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Title: Message
No
answer for that.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July
31, 2003 3:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: HELP! Index Debate!
How does one know that only one column is being used
Ron,
It has been my understanding that in order for the conpound index to
be used the query had to match the order the index was created. Multiple
indexes would not do a whole lot of good for you just make the optmizer
work harder to figure things out. It would add a confusion factor other
wise
can have facts, having an opinion is an art !
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 4:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
HELP! Index Debate!
No
answer for that.
-Original Message
ORACLE-LSubject: RE: HELP! Index Debate!
do you have corresponding indexeson referenced columns on T1-5
tables ??
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this
email
Provided we are talking cost based optimizer, then the order of the
predicates in the where clause does not matter - except under very rare
conditions to break a tie. Nor is the order of the predicates in the where
clause related to the order of the columns in the index. The only thing
that
Thank you very much for the detailed info!
Ron
-Original Message-
Sent: Thursday, July 31, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
Provided we are talking cost based optimizer, then the order of the
predicates in the where clause does not matter - except under very rare
R,
This would work. You need the package to return the result back into - note
the global v_into variable at the package spec level. I don't think it
would work the way you had set it up originally because the inner exec
immediate would not find the v_into variable.
Good Luck!
PS - WHY do you
turning a dynamic sql into dynamic pl/sql since this type of dynamic
sql does not work. Its rather cleaver.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/07/18 Fri AM 11:59:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: help with dynamic pl/sql
]
cc:
Subject:Re: RE: help with dynamic pl/sql
i should have seen that one... error looks like it wasnt seeing the
variable.
If you do a google search for the online journal 'Oracle Professional'.
Steve Fuerstein has an article where he shows you how to do method 4
dynamic
It looks like you have to join, but the article can be found here:
Method 4 Dynamic SQL with Native Dynamic SQL (online subscribers only)
http://www.oracleprofessionalnewsletter.com/OP/OPmag.nsf/Index/594D98A6AF90025185256D32006A41CE
-Original Message-
From: [EMAIL PROTECTED]
Hi,
I'm currently looking into the
same.
My idea is to create a new table with the
partitions I need, insert the data from the old table, drop the old table and
rename the new table to the old name.
This will invalidate a lot of stuff, which I
still have to find out exactly what, so if
Jack, Munish
First, verify that you have licensed partitioning. Additional cost item.
Second, learn about EXCHANGE PARTITION. This is a highly useful command that
can be used for a multitude of uses. Create a partitioned table and then
exchange your table into it. Extremely fast since it just
Munish,
innocent question, _why_ do you think partitioning will help query
performance? Have you checked asktom site?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Read about exchanging partitions in chapter 17 and especially Converting a Partition
View into a Partitioned Table :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm
Even though you may not be using a partitioned view, you can use this technique to
create the
That is the greatest RTFM answer that I've ever seen!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 25, 2003 9:33 AM
To: Multiple recipients of list ORACLE-L
Read about exchanging partitions in chapter 17 and especially
You first create an empty partitioned table
with the same structure as the original table
and then use "exchange partition" to
exchange partitions with the original table. That way, your original
table
will end up having a single (empy)
partition and the new table will have a full partiton.
Thanks for mentioning it
Just tried a little test and worked like a charm.
alter table part2 exchange partition JUNE2003 with table test_part1
Jacob A. van Zanen
-Original Message-
Sent: Wednesday, June 25, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Jack, Munish
First,
Paula - I don't see where anyone replied, so . . . In Oracle 8i, backing up
the control file with RMAN and then recovering that control file is a dicey
business. I recall that part of the problem is the point in the backup the
control file is backed, maybe not after the file backups. Anyway, I
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
Title: RE: HELP - Microsoft Access error SQLSetConnectAttr failed error.
However, I was able to independently through odbctest and tnsping confirm that the odbc driver working and the alias working through Oracle's Net8. I also noticed with the odbctest that the user had a very small
Need more info:
What are you doing when the error occurs? If it's vb code, can you post it?
Can you connect from the erroring machine via sql*plus?
Can you link a table via the odbc connection open it interactively?
Does it make a difference if you define a new odbc data source link
through
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
Arvind,
Try cutting DB_BLOCK_BUFFERS in half. Yeah it's a strange concept, but if the
swapper is running them giving back some memory to the system may stop it the
improvement in response time will more than make up for the additional wait in getting
data into the cache.
Dick Goulet
Hi!
You didn't send your SHARED_POOL_SIZE parameter
value...
but...
usually, when the machine swaps is due to not enough
memory allocated!
I would check your shared_pool_size, sort_area_size,
and db_block_buffer for verifying that there's enough
memory asigned.
Of course, you should diagnose
Jose - Not enough allocated or too much allocated (from the Oracle
perspective)?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 31, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Hi!
You didn't send your
Arvind ,
Do you have any other instance or application running on same box ?
-ak
- Original Message -
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:54 AM
Hello all,
i am facing swapping problem ..below is the
Dennis...
not enough from (for) the Oracle
and too much (used) from the OS perspective.
That's why you can get swapped data to disk!
JL
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Jose - Not enough allocated or too much allocated
(from the Oracle
perspective)?
Dennis Williams
DBA,
No,
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
Stefan ,
hope you don't have the right version of classes12.zip in your classpath.
if it is not so , u r likely to get ORA-600 even on a simple SELECT.
just set that right.
HTH.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
You should only need the xlC runtime environment (includes libs), not
the actual compilers. The runtime environment should be shipped on your
original installation CD's (email me directly if you need to know which
of the 5 AIX cd's it's on and I'll check when I get back to the office).
You
Here is one that I used for my test database:
create database KED9
maxinstances 1
maxloghistory 200
maxlogfiles 4
maxlogmembers 4
maxdatafiles 100
character set us7ascii
controlfile reuse
datafile '/u801/oradata/KED9/system_01.dbf' size 300M reuse
default temporary tablespace temp
Title: Message
Thanks
for the help!
Ron
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06,
2003 5:49 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Help with a truncate command in a
procedure
(pant pant) Will I
:[EMAIL PROTECTED]]
Date: vendredi 7 février 2003 15:09
À: Multiple recipients of list ORACLE-L
Objet: RE: Help with a truncate command in a procedure
Thanks for the help!
Ron
-Original Message-
Sent: Thursday, February 06, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
(pant pant
Title: Help with a truncate command in a procedure
Truncate is a DDL. So you can't just do
"truncate" like you would with delete which is a DML.
You
didn't say which version of Oracle you are running. If it's 8i,
do
execute immediate "truncate table
.";
Otherwise, look into
Title: RE: Help with a truncate command in a procedure
(pant pant)
Will I be the first to say that you need to use dynamic SQL?
dbms_sql package in Oracle version 8.1
execute immediate in Oracle version = 8.1
-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
I am
Look up info on using execute immediate
This will let you put non-DML-type statements in a PL/SQL block.
-Original Message-
I am not a coder but I received this from one of our developers. I can't
find anything about this anywhere. Can someone tell me how to make the
truncate work?
truncate is a sqlplus command(and DDL), so to do it, you need to use the
dbms_sql(or execute immediate) command, i think.
joe
Smith, Ron L. wrote:
I am not a coder but I received this from one of our developers. I
can't find anything about this anywhere. Can someone tell me how to
make
1 - 100 of 485 matches
Mail list logo
