under linux redhat :
just do :
$locate shmparam.h or
$locate shmmax.h
Best Regards,
Ramada
From: "Ruth Gramolini" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: identifying shared memory segments
Date: Wed, 21 Mar 2001
If you're on 8.0 or higher, try
insert /*+ APPEND */
into table
select * from other_table;
where "table" is defined as nologging. Then you won't
hit either redo logs or rollback segments..Its the
equivalent of a sqlldr direct load
hth
connor
--- CC Harvest [EMAIL PROTECTED] wrote: I have
I think We can use average column a + average column (estimating), because
of VARCHAR2 in our table, then we determine can determine how many records
inside our database.
I think we can not ignore the overhead bit inside our tablespace, my Guru
said leave 1 row space between PCT_USED and PCT_FREE
Title: RE: about analyse table..
Hi Saurabh,
The Analyse command helps to collect information on the specified table and updates the system table called user_tables with this info
This helps to optimize any query which is run on the table after the table is analyzed. You can take help
Dear DBAs,
I have 2 NT servers, Oracle8 (8.0.5) Server has been installed on each of
them. One server has a database and no database on another. Is it possible
to move or duplicate a database from one servwer to another? Based on my
conceptual understanding, this will work, but I it failed when
Hi there
I have a problem when I install Oracle 816 on NT. I have done it twice
before amd it worked, that was Oracle 805 and 806. Now I am trying to
install and create database on NT, Oracle 8i version, 816.
I get the error ORA-12560, which protocol adapter error, whenever I
try connect to
Hello
I want to run report runtime from another application. So I use a command
line, which launch the report connect to the database.
It works.
But it can't be launched fast.
That's the point at issue.
The users launch one edition : Report runtime is launched, they tape the
parameters neede
Ok, I'll admit my ignorance. What the heck does "1 row" mean? It can't mean the
row length, or you'll end up with a negative PCT_USED.
[EMAIL PROTECTED] 03/22/01 09:35PM
Hi Bambang,
Analyze the table and you'll find the average row length in
USER_TABLES.AVG_ROW_LEN. Subtract 90 bytes
Mandar
Tell them that (if they are really lazy) you can build them a function that
returns ref cursor with Code, description columns and they pass in the
domain/context they want - same for the inserts - so you can get rid of
their comments. To be sincere, I use combination - separate look-up
Chris,
Does the destination table have to be recoverable? If not you could built the table
with the UNRECOVERABLE clause and your problem is solved.
In large inserts from one table to another for archive purposes, I get around the
large RBS problem by using a procedure with a commit every
max(row size) is the sum of all of the columns sizes in the table plus overhead.
The following is the column sizes and the sum formula to calculate the size of a row
in a data block.
NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7
TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS
Hi,
We are preparing to upgrade our databases here from 7.3.4. to 8.1.6..
Do you have any suggestions re. re-organization, "cleaning up" before the
migration is done, or just after it is done, and before I release the
servers to the developers and end users? If you have done this type of
To fill a Basket Ball!!!
[EMAIL PROTECTED] 03/22/01 06:35PM
Jared,
I am still waiting/hoping for an answer...
Why IS there air?
- Donna
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hello Stephen,
Hey, I saw your post on the Oracle list. Thanks for plugging
the book. You can thank Sanjay for that tuning chapter. BTW,
which of his suggestions did you use that did so much good?
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com *
Hallo,
I am doing a reverse engineer of the Oracle database, which means that I am loading
the database into the program Erwin. When it i simported into erwin I willbe able to
seeall the relations, tables, views etc of the database. But when i am doing the
reverse engineer I get many error
Did you set the default oracle_sid? Is the database running when you try to
connect?
-Original Message-
Dumas
Sent: Friday, March 23, 2001 4:50 AM
To: Multiple recipients of list ORACLE-L
Hi there
I have a problem when I install Oracle 816 on NT. I have done it twice
before amd it
To use svrmgrl, the following conditions must be met:
1. the NT Service must be started. (use the "net start" command or
"srvinfo" to display service info)
2. the environment variable ORACLE_SID must be defined
C:\set oracle_sid=DEV
C:\svrmgrl
Oracle Server Manager Release 3.1.7.0.0 -
The SUN/Merant = NT link is ok because it is working
when using Powermart.
We just want to call a stored proc on MS SQL Server
which is not allowed with Powermart 4.6 (it is
supposed to work with Powermart 5) . So the idea is to
call an Oracle Stored proc which would called a MS SQL
Server
Position: Oracle DBA
Salary Range: 75-82K
Location: Columbus, Ohio
*Responsibilities:
Implement physical changes to databases; code and test SQL, applying
knowledge of
database management.
Design logical and physical databases for Data Warehouse and OLTP systems.
Review and evaluate
Roland,
I had a similar experience when trying to reverse engineer a third party
application (I needed a data dictionary but they refused to provide one) with
Oracle Designer. The problem was that the duhveloper made extensive use of
Oracle's object naming exception. We had object (table
IS THERE ANYBODY WHO HAVE KNOWLEDGE ABOUT SALARY IN AUSTRIA AT DBA
POSITION
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
if you have your database in the "CHOOSE" mode for the optimizer (using the
cost-based optimizer) and you don't analyze your tables, Oracle doesn't have
good information to determine the query path.
If you do "analyze table tablename compute statistics" the entire table is
read to gather the
Mary,
We run several DB's on 8.1.6 (HP-UX 11.0) with no problems. Listeners run
just fine for months at a time, especially if you set "logging_listener = off".
One other item that I remember from the 7 to 8.0 migration was a suggestion from
Oracle to "exp system file=/dev/null full=y"
-Original Message-
What do we want to know?
1. Are we on the write way, (do you have any other idea)?
Yes, you're on the right track.
2. Does that concept have some misses?
This concept does not give you the fault tolerance. It will only make
it easy for you to have an up-to-date
If you do not specify a logfile for the import the list will go to stdout.
If you do specify a logfile then the list will be in the logfile.
HTH,
Ruth
PS do an imp help=y to get a list of the parameters, including specifying a
log file.
- Original Message -
To: "Multiple recipients of
Actually, the way Bill Cosby says it is: Any phys ed major knows why
there's air: to blow up basketballs, footballs, and soccer balls.
Ron Rogers wrote:
To fill a Basket Ball!!!
[EMAIL PROTECTED] 03/22/01 06:35PM
Jared,
I am still waiting/hoping for an answer...
Why IS there air?
-
hey yuzie,
As far as your problem is concerned you need
to create an instance with the NT instance manager,
before even you try logging in as internal. Dont get
this confused with the Oracle enterprise manager
instance manager, this is a different component
installed by oracle during
I did the upgrade from 7.3.4 to 8.1.5 about a year ago using export/import
as you plan to do. I used version 7.3.4 export and import utilities and had
no problems. I have been doing cleanup ever since, its a living ;)
Dean Jefferson
Database Administrator
State of Wisconsin
Office of
I have an Oracle 8.1.6 instance on an NT Server. The application has only a
few users. Very often throughout the day it seems response time drops to
about 20 seconds. By the time I log on to look at the problem everything is
back to normal. If I do a simple query the result is returned
Here is an excerpt from Metalink
2.- Starting database via SVRMGRL or SQL*PLUS
Problem:
Launching svrmgr, or attempting a connection in sqlplus to start up the
database, you get an ORA-12560
Solution:
- If the drive is NTFS then check the permissions on the drive
SET ORACLE-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jentzig Sven
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Title: RE: Why is there air?
Actually, in the Bill Cosby routine this
is taken from, I beleive the gym teacher
say volleyball, not basketball.
(I'll listen to it again when I get home tonight ;)
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative
We have run into a big performance issue with our migration from 7.3.4 to
8.1.6.
A single query that SELECTs from a large table, also contains user-defined
functions that
appear in the column-list of the SELECT.
This query is running many times longer than under the old version.
Anybody see
I've done this many times on NT, by shuting down the source database,
copying ALL database files to the new server, creating an instance with the
same SID on the target server and just openning it up and running it.
Here is the statement I use to create the instance. Note that I set the
internal
[EMAIL PROTECTED] wrote:
So for once I need to get off of the rant box and pass a complement to one
group at Oracle that we all love to hate.
Dick Goulet
and thank you for solving a problem i just got on our network monitoring
box! [that's the fiber optic phone network, not the
Hello DBA's
You know, I read somewhere that you can make your log_buffer 10 percent of
your total sga. So if you had a 500mb sga you could have a 50 mb
log_buffer? What do you guys think, the illustrious Ross doesn't like such
large log_buffers.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian,
The thing that is killing us is a single query.
This query does a group by.
It also references some user-defined functions in the column-list of the
SELECT statement.
These user-defined functions are actually SELECTS from 2 other small
tables.
It is not behaving the same way it did in
Thanks. That works on SGI too.
--- Lord David [EMAIL PROTECTED] wrote:
Under unix (Solaris at least): set your oracle environment and run
$ORACLE_HOME/bin/sysresv.
No idea about windoze.
HTH
David Lord
-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent:
Nice, but this construct violates Second Normal Form. I only denormalize for
compelling reasons, like for performance reasons, and I don't see how performance is
enhanced by jamming all this stuff into one big table. You may end up with an index
that has an extra level of index blocks,
List,
Recently there was a discussion concerning the cost of Oracle licenses vs MS Sql
Server licenses wasn't there? That discussion was not an issue at my job - until
today which is why I'm wondering if there were any postings that in any shape or
form justified some of the price differential
Very funny
In Japan, Sony Vaio machines have replaced the
impersonal and unhelpful Microsoft error messages
with their own Japanese haiku poetry, each only 17
syllables.
---
A file that big?
It might be very useful.
But now it is gone.
AKAIK tnsnames.ora will always be supported. Oracle Names is being dropped in 9i in favor of LDAP, and since 8i Oracle ships a new LDAP compliant directory server called Oracle Internet Directory with the database. You can also use any other LDAP directory server such as Microsoft Active
1. Make sure thay your service 'OracleService???' (??? is your db name) is
up.
2. On DOS prompt, enter 'set ORACLE_SID=???'
3. Then connect to svrmgrl
HTH!
Prakash
-Original Message-
Sent: Friday, March 23, 2001 4:50 AM
To: Multiple recipients of list ORACLE-L
Hi there
I have a
There's someone in Charlotte, too (dbBasics I believe) but we never use
them as all our programmers are in Raleigh. I've seen some basic-level
classes float through the universities and tech schools, but I wouldn't
recommend them for non-students. Someone at Global keeps after me, too,
but they
I might be wrong on this but I think you have to create and start the
oracle service first.
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
Did you set the default oracle_sid? Is the database running when you
try to
connect?
-Original Message-
Dumas
Sent: Friday, March 23, 2001
Can't you also analyze an entire schema to make it easier, there's a dbms
package in the admin directory?
kev
-Original Message-
Carmichael
Sent: Friday, March 23, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
if you have your database in the "CHOOSE" mode for the optimizer
Hi Ron,
Let's take a example:
SQL desc emp
NameNull?TypeBYTES
-- -- --
EMPNO NOT NULL NUMBER(4) 21
ENAME VARCHAR2(10)10
JOB
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 17:30
I have an Oracle 8.1.6 instance on an NT Server. The application has only
a
few users. Very often throughout the day it seems response time drops to
about 20
What is the relation between db_name, instance_name, service_names and the
sqlnet alias for an instance. 'Cause in my init.ora file I fdefined the
following things
db_name = "db1"
instance_name=inst1
service_names=service1
And I defined an entry in my tnsnames.ora
Chaim-
I managed to save hardcopy but not soft, so I can't send it but I can comment.
Actually, I was surprised at how little difference there was between Oracle and
SQLServer at moderate usage levels assuming these numbers are accurate and you're
using a similar server configuration. At
Just a FYI about Analyzing...
As of Oracle 8i, Oracle recommends using the DBMS_STATS package instead of
the ANALYZE command or DBMS_UTILITY procedures. The DBMS_STATS package
gathers more statistics than either ANALYZE or the DBMS_UTILITY packages --
potentially resulting in better query
I am not at my terminal where my online docs reside and I can't get out to
metalink ATT - or I wouldn't ask, but:
Can a simple snapshot be created on a view? View on master site tables, I
want a snapsot of the view data on the remote system. Oracle 7.3.3, HPUX.
Thanks,
Scott Shafer
San
Title: Crontab
Hi gurus,
I want to schedule a script to run on the fourth sunday of the month.
How can I do that ?
TIA
-
Luc Demanche
CETELEM
Tél.: 01-46-39-14-49
Fax : 01-46-39-59-88
Hi!
I live in Austria and have a position similar to a DBA
but actually am not a real DBA. I would guess that you
can expect a monthly income (before taxes) of 2.000 up
up to 4.000 US$.
See you in lovely Austria...
DO
-Original Message-
Bahar
Sent: Friday, March 23, 2001 4:16 PM
To:
Well of course, maybe I was assuming too much, my apologies.
Kev
-Original Message-
Hamilton
Sent: Friday, March 23, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
I might be wrong on this but I think you have to create and start the
oracle service first.
--- Kevin Kostyszyn
Harsh,
I thought number would only generally take 4 bytes (I've checked a couple
using vsize on 7.3.4) and varchar will only take what it needs.
Cheers
Iain
-Original Message-
Sent: 23 March 2001 16:32
To: Multiple recipients of list ORACLE-L
Hi Ron,
Let's take a example:
SQL desc
By mistake a user was assigned default tablespace SYSTEM.
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will again import into that "SYSTEM"
tablespace.
Thanks,
- Harsh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
We are setting up a new database server. It's HP-UX 11.0. Oracle 7.3.4 (I
know, we need to upgrade !) has already been installed and configured on it.
Databases have been built and are in use for testing. In a couple of weeks,
we'll be exporting the production database from our old server and
Title: perl problem on linux
I've got some developers trying to get
perl's dbi/dbd stuff working on linux,
and they keep getting ORA-2035 every time
the execute from a for loop.
Anybody seen this before?
Linux kernal 2.2.16 with 8.1.7 client installed
Matt Adams - GE Appliances -
I ran into a situation this week where a session was waiting for results from a failed db link and holding a lock (library cache pin) on the sql it was executing. It never detected the failure and hung waiting for a reply on the link. This caused the pin to be help indefinitely too, which caused
Title: RE: db_name, instance_name, service_names and the sqlnet alias
In my previous e-mail I forgot that you were also asking about service_name.
If you are not running OPS, then the service_name parameter can be omitted. If you ARE running OPS, then you will have to ask someone smarter than
Since you mention there are only a few users, I would take a look at the
jobs these users are running. Maybe one of these users is firing off a
poorly tuned job that brings the database to a grinding halt.
Is the database the only product on the Server? Or are there other
applications ( email
Chuck is correct. You need to run the oradim.exe utility to create the
Oracle_Server service.
--
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation
On
What's wrong with a composite foreign key constaint? Works
for me all the time..
As a duhveloper wont u like to pass one argument to a procedure rather than
two?
I don't care - I am using the wonderful copy-paste.
granular control over the individual code table
You DON'T have
Are all the columns completely filled? ie all the "ename" are 10 chars long
and all the "job" fields are 9 chars. When you use the varchar2 field it
only stores the length _used_.
Jim
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Friday, March 23,
As long as you are keeping the DB_NAME's the same you should be able to get
by with changing the listener.ora and tnsnames.ora files. You will also need
to change your global tnsnames or Onames server references to these db's.
On Friday 23 March 2001 11:30, you wrote:
We are setting up a new
Harsh Agrawal wrote:
By mistake a user was assigned default tablespace SYSTEM.
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will again import into that "SYSTEM"
tablespace.
alter user bob default tablespace tbs1;
then grant a quota
Some good points... different strokes for different folks ya know. :)
exactly.
Partitioning a code table? Really??? Show me the money, er, cache. If your
lookup/validation data is not "mixed together" then why would you need to
partition it?
Why not? If you can imagine a code table with
I am trying to run sqlloader without leaving the my stored procedure but it
seems the only way to invoke it is from the command line or sql plus. Is
there any way to run an os command from within a pl/sql stored
procedure/package?
Thanks,
Eric
--
Please see the official ORACLE-L FAQ:
look at alter user command, yes break out the documentation and begin
reading.
joe
From: Harsh Agrawal [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Moving user to a different tablespace ...
Date: Fri, 23 Mar 2001 08:10:38
What version of Oracle? With 8i + you have the ability to mover a table to
a different tablespace.
Terry
Harsh Agrawal wrote:
By mistake a user was assigned default tablespace SYSTEM.
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will
At one of the Oraccle Applications User meetings, Oracle displayed the new table
layout for the 11i version. It basically was one table with a lot of columns for the
application that was talked about. I asked about the normalization of the data and the
reply was in the form: it will take more
- Original Message -
Preface: I am a developer!
If the DBA wants to have 1 tables, no skin off my nose. A generic
maintenance form and LOV form for a set of tables all with the same format
is not that huge a task.
The best developer argument AGAINST a centralized code table
Title: RE: Log Buffer
Yeah,
illustrioius, that's good thing isn't it? Isn't that what someone called
Lord Vador in Star Wars.noo non no, it was Jabba the hut. Ok, I take
back the illustrious, I'll think of some other large word that sounds
cool!
I
don't, it was just a question, when
If you just have the clients installed on your machine, you need to get the
CD and do an install for Database Administrator, or do a custom install and
install the Oracle8 Utilities.
On Friday 23 March 2001 13:26, you wrote:
Hi all,
I have 805, 815 clients installed on NT4.0. 815's
Thanks for replying.
I need to start this by correcting the subject line I put on this
originally.
I am talking about user-defined FUNCTIONS within a SELECT.
Sorry.
The explain plans look exactly the same.
Strangely enough, the small tables that are read in the user-defined
functions
do NOT
Dear Experts:
This does not make any sense to me, can you help me out?
I have a control file to interpret the mainframe data and then write to my table in Oracle Database.
The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2).
All
Harsh,
The columns size listed in the formula was for the maximum size of the number
column. The remaining columns are fixed in size.
The size of a row is determined by 3 factors:
1. Row header 3 bytes
2. column data varying on size requirements and datatype
3. length byte for each column.
There is a bug with some version of Oracle (I believe it was 8.1.6.0.0, but
don't quote me on that), where even with NO users, oracle.exe would
eventually consume your whole CPU. The CPU utilization ramps up after a db
restart until it gets to 99 or 100.
Open Task Manager and check the
yes, I think that does help. I am thinking I am going to make them larger?
21 requests
-Original Message-
Sent: Friday, March 23, 2001 2:46 PM
To: 'Kevin Kostyszyn '
Hi...
I don't think so...
you must adjust your LOG_BUFFER acoording to:
select substr(name,1,25) Name,
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.
It is very rare to a lot of a benefit once your log
buffer gets more than 512k.
hth
connor
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
Unfortunately the previous suggestion would run every Sunday AND on each day
on the 22nd to the 28th. Your 2 choices are
MM HH 22-28 * * (shell script checks for Sunday before proceeding)
OR
MM HH * * 0 (shell script checks for day of month between 22 and 28 before
proceeding)
Mike
Snipped text
The DBA work on that is easy, but then the developers go
hunting in all the
existing program code that hits the code table (haystack)
to find all the
places where that program code is actually using the code
in question
(needle).
Well, in the case of 100 tables you
Export the user, drop it's objects, alter to user to use the correct tablespace as
it's default tablespace. Set quota on system to none, set quota on new tablespace to
unlimited, import the objects. Done.
[EMAIL PROTECTED] 03/23/01 02:07PM
look at alter user command, yes break out the
Interesting, i have never heard of this bug. What do you mean, all of the
sudden it will suck down the whole processor? How many users?
-Original Message-
Sent: Friday, March 23, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L
There is a bug with some version of Oracle (I
-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.
It is very rare to a lot
Oops,
All right, I give up, I am dumb.
Kev
-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected
if u get this to work let me know. i had a source
view and i got "object type not allowed error' i had
to go to underlying table to create snapshot.
--- [EMAIL PROTECTED] wrote:
Scott,
Yes, "create snapshot name
refresh complete
start with you name it
Hey Kevin,
My Oracle Perf Tuning instructor suggested doubling the LOG_BUFFER until the
requests get under control. Problem is that each bump requires a reboot.
Since ours was severe enough, I went from 1MB to 4MB. When that wasn't
enough, I went to 12MB. This is over the course of almost 12
Luc,
One possible solution:
Run the cron every Sunday and have the first part of your shell script
check to see if that day's date plus seven days falls into another
month.
Regards,
David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth
"DEMANCHE Luc (Cetelem)"
I've found so many bugs in code caused by developers forgetting to add "AND
code_type = 'SOME_VALUE'" to there WHERE clauses when multi-purpose code
tables are used.
Kevin Toepke
-
The information in this electronic mail message is Cendant Confidential
and may be
At 11:47 AM 3/23/01 -0800, you wrote:
The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2).
That looks like the internal representation for a signed number under COBOL. The least significant digit (LSD) is used to store the
Hi, Winnie,
Just a little more research. I wonder how you can have an rdba that big,
0x24070020, which is 604438560 in decimal.
SQL var a number;
SQL exec :a := dbms_utility.data_block_address_file(604438560);
PL/SQL procedure successfully completed.
SQL print
A
-
144
check out Doc ID 941798 at Metalink...
- Original Message -
To: [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 3:36 PM
There is a bug with some version of Oracle (I believe it was 8.1.6.0.0,
but
don't quote me on that), where even with NO users, oracle.exe would
eventually consume
Yong,
Thanks a lot for all the research! :D
The file# that actaully contains this block is 9. My database is not that
big at all.
I did do some research myself and some Oracle analysts in the World Wide
Support does suggest that the influxed blocks are very likely to be a
fractured block.
Is
your mainframe using EBCDIC? If so there is a translation table that
explains what the "}" translates into. The sign of the field is trailing
(E.I.. at the end of the field for non-Cobolers)
These
indicate that the sign of the number is negative.
}=0
R=9
Q=8
P=7
O=6
N=5
M=4
L=-
K=-
J=1
Well, in the case of 100 tables you are still hunting all the
code looking for pieces which are relevant to that changed table.
Depends on your code. I prefer to encapsulate mine, so
reference to a table is enclosed in its own package.
My point is that I can use grep to search the
Bon dia amics d'formigas!
for further background (occasional lefist slant), see:
http://www.context.org/ICLIB/IC03/CoriGord.htm
-
http://www.context.org/ICLIB/IC03/TOC03.htm
-
http://www.context.org/ICLIB/backi.htm
-
http://www.context.org/ICLIB/IC44/Heart.htm
-
They also have some
Hi Kevin,
Yes, it will suck down the whole processor. We had a new implementation,
with ZERO users, that had the problem.
It is a memory leak of some sort. 8163 fixed it.
- Jerry
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March
Any suggestions /books whitepapers on Database Physical Standards
Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
1 - 100 of 113 matches
Mail list logo
