Dear All DBAs,
We are exploring possibilities of developing a system on Oracle
database/UNIX. The data size could be as large as 150GB. We never have the
database this large. I wonder how the backup scenario will look like.
My question is:
1. Where should we send the backup files to? Tape,
Hi
friends,
What are the steps
to follow in order to install Oracle817 on Windows NT in parallel with an
existing database with 7.3.4 version ?
@biy @lemu
[EMAIL PROTECTED]
Database Administration
Engineer
Can any body ?
A block consists of Table directory (Information regarding the tables having
rows in a block)
and
row directory (Information regarding the actual rows in a block).
Is this str. common to Oracle (i.e. previous version also) or specific only
to Ora 8.X
- Harsh
--
Please
Hi,
I have imported a text-file into a table in the database. Now I find that there are
many bad things in some fields, for instance there is a ? instead of the value 0.
Can anyone give me a good example on a procedure that loops through a table and if
found a ? in some fields, replace it
Can anyone tell me which function to use if I want a string to be left positioned,
not centre positioned ?
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
How can I create a file, and the send it through mailsystem imediately
to a mail recipient.We use Lotus Notes mailsystem.
Any good example?
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Anyone who has a good example on a procedure that first deletes all the records in a
table and then
does an insert?
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Currently the application insert data from batch localy and a bit from
online insertion. We have clustering for our database.
noarchive, I do export tables after run batch (daily), weakly copy out all
dbf files and ctl and redo log files. and copy them to tape.
It's that true once the redo log
update table
set dodgy_field = replace( dodgy_field, '?', '0' )
/
-Original Message-
Sent: 06 April 2001 09:45
To: Multiple recipients of list ORACLE-L
Hi,
I have imported a text-file into a table in the database. Now I find that
there are many bad things in some fields, for instance
SWAP Space Increased from 4 GB to 5.5 GB for RAM=4 GB
This Resolved the Problem
The Qs. Though Remains That During the Period of the Entire Transactions'
Run ,
the FREE RAM Memory NEVER Fell to Below 2 GB
Thanks Mike , List
-Original Message-
From: VIVEK_SHARMA [SMTP:[EMAIL
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
From the sites I have worked at recently
Just try RPAD(RTRIM(LTRIM(string)), Length(string))
Roland.Skoldb
Hi,
I developed a web based tool which analyzing event
10046 traces. I'm currently looking for a java servlet
service provider.
this tool does:
- what tkprof does
Plus
- reports all execution plans for SQL statment(I
guess, tkprof reports first, but there is no guarantee
first and other
As all
MS people know , first apply service pack of windows 2000 ...if same problem
occurs stop oracle cmadmin service from the services .
- NIHAR SANGHVINetMagic Solutions Pvt.
Ltd.22,Nirlon Complex,Western Express Highway,Goregaon (E), Mumabai 400
063Phone: 8723003 extn:
How can I in a sqlloader, the control file replace a ? with a 0 at the same as it i
sloading the data into the database?
The ? could be anywhere in any field.
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
With no disrespect to your English, the
Hi Steve,
Good idea, but unfortunately the table statistics and the basic column
statistics (called single-bucket histograms) that are available if you only
analyze the table are not sufficient to determine whether the distribution of
values for any column is uniform or skewed. That means that
We have a NT client program written in VB that uses a single user to connect
to the database. The application does not prompt for a user or password. The
user and password that is used for connection to the database is passed to
the client program as parameters in t he application shortcut.
We
If you are asking about a code,
Probably
Begin
TRUNCATE ...
INSERT INTO
COMMIT
END
In practical this is used for temporary tables I don't know if there is any
other use.
HTH!
Aleem
-Original Message-
Sent: Friday, April 06, 2001 2:10 PM
To: Multiple recipients of
Where,
Forms and/or Reports: Item Property Justification under functiona / Report
has a toolbar button for alignment
PL/SQL: Function RPAD
HTH!
Aleem
-Original Message-
Sent: Friday, April 06, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject:Left position
Bruce,
Here's the quote from MetaLink:
"this is bug 1651014 and is fixed in 9i. the workaround is to set
optimizer_features_enabled=8.1.6."
They were less than forthcoming on any other known bugs in 8.1.7...
probably not to anyone's surprise.
larry
Reardon, Bruce (CALBBAY) wrote:
Larry,
The normal method is to copy out the days worth of archive log file as part
of your normal backup routine. Then maybe keep 2 days worth on-line so that
they are available for a recovery without getting them back from tape.
Keep a watch on the disk space to ensure that the disk does not get full
Hi Hallas and All DBAs
Thank you for your advise.
I have a question if I turn on our archive redo log do I need to copy out
that archive log frequently ?
-Original Message-
John
Sent: Friday, 6 April 2001 7:21 PM
To: Multiple recipients of list ORACLE-L
FOR YOUR INFORMATION
ESIS
Dear DBA Gurus,
I have the following records in Oracle 8.1.6 database (CLOB fields).
idtitle
1 kid's
2 kid and teen
3 kid's
4
Title: RE: OT RE: Oracle being scalable
Eric,
You must have paid Winter Corporation alot for that cleverly
disguised plug for your new system!
:-)
Ross
== -Original Message-
== From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
== Sent: Thursday, April 05, 2001 7:21 PM
== To:
Title: RE: OT RE: Oracle being scalable
No, the one after it that was flawless in every regard, constantly,
forever, and made no mistakes at any time, even in testing and
development.
== -Original Message-
== From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
== Sent: Thursday, April
I would tell them that THEY are then responsible for database recovery if a problem
should occur. If the DBA is to be responsible, then the DBA should be able to utilize
the recovery tools provided by the vendor (Oracle).
[EMAIL PROTECTED] 04/06/01 12:45AM
The developer application running
Sinardy Xing wrote:
The developer application running huge batch inserting data into database,
that is what they told me, if you are me what you will do?
Sinardy,
You definitely want to turn archiving on.
Without it, your recovery options are limited to the last offline backup
of the
Why not just specify BUFFER POOL KEEP in an alter table statement?
[EMAIL PROTECTED] 04/05/01 05:56PM
What is the problem to write something like
Select * from table_name for all tables that you need or if there are too
many such tables - create a new table with names of the tables and use
What's with the complicated "where exists" stuff? I like mine better:
set echo off
set verify off
set feedback off
set heading off
set pagesize 60
set pause off
column tablespace_name format a10
column tablespace_name heading Tspace
create table max_free as
select tablespace_name, max(bytes)
Dear DBA Gurus,
I have given below the procedure as how we are creating the tables,
preference and indexing for the same. Could you please check if there is any
other preference need to be set for CLOB Datatypes which I missed?
1) To create category table.
CREATE TABLE CATEGORY
Here, here!!! If they can dictate the fact the the DB will not be in archive log
mode, they must live with unrecoverability.
Terry
Tim Sawmiller wrote:
I would tell them that THEY are then responsible for database recovery if a problem
should occur. If the DBA is to be responsible, then
Hi All,
I had fair amount of success using Histograms for all indexed columns. I
have been using it since 7.3.4.x version. However, histograms do not offer
any help if the SQL uses bind variables. Most of our application code does
use bind variables and hence does not benefit from this really
Title: RE: failed to extent to the next
Well,
if next_extent=250m, pctincrease=0. bytes *12 = next_extent means
dba_free_space must have a (bytes*12) large space to satisfy the condition. But
I want 12 slots 250m, if I get less than 12 slots 250m, I
will get email. Gee, I am confused
Hi Tom,
If you have a media failure and for some reason (such as having lost an archived
log file) you cannot perform a complete recovery on some datafiles, then you
might need this parameter. It is new for 8i. Previously there was only
'_allow_resetlogs_corruption' which allowed you to do a
EP,
I could not agree more with Paul. We're doing PeopleSoft all of the of
the business logic is in PeopleCode (something like VB), but there is NO
referential integrity or business logic in the database design. Therefore for
anything outside of PeopleSoft that we have to integrate with
** A Moment Of Sympathy For Those Much More Fortunate
Investors have had a hard time lately, as the stock markets
wallow at a fraction of the value they were a year ago, and the
Nasdaq regularly hits new lows. Fortunately, there's a little
solace for those who blew their vacation fund on a
Ranganath,
You've defaulted to in-line storage of CLOBs. You could
specify "Disable Storage In Row" and point the CLOBs to
different tablespaces, thus spreading your I/O out over more
drives. You can also define a custom Basic_Storage
interMedia parameter, by which you spread out the 5 or 6
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, April 06, 2001 15:45
Dear DBA Gurus,
I have the following records in Oracle 8.1.6 database (CLOB fields).
id title
1 kid's
2 kid and teen
3 kid's
4 kid's and teens
If I
Roland,
Try this in your control file:
column1 "replace(:column1, '?', '0')" ,
column2 "replace(:column2, '?', '0')" ,
This will work only with the conventional path.
Prakash
-Original Message-
Sent: Friday, April 06, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
How can
Jack -
Sorry, forgot to mention that this is a Java web application that handles
all of that stuff. I'm afraid all the users see are timeout messages, they
never see the ora-x messages. There have been complaints about
performance, quite possibly tied to this as well. Bah, humbug.
Unfortunately, the one after that was done after the Olympic games had
finished, which
made the number of concurrent requests somewhat smaller
-Original Message-
Sent: Friday, April 06, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L
No, the one after it that was flawless
You should be able to add an entry in the client's ODBC settings for uid and
pwd. It's been a long time since I worked with this stuff...I would search
the M$ web site to be sure, but I think that you can just create two new
strings under the ODBC connection key and the app will not prompt you.
I thought that as well Tim, but wasn't sure whether Oracle loads the table
at startup even if this is specified in the storage clause. The following
test seems to show that it doesn't though:
SQL create table DUMMY_TABLE (id number(3), dummy varchar2(5))
2 storage(BUFFER_POOL KEEP);
Table
Here is a pretty cool way to monitor your tablespaces, and file size
growths, just create the following view (as SYS), and send the results to
the following script to your email daily:
CREATE OR REPLACE VIEW TSFILE_SPACE_VIEW
( TS#,
NAME,
STATUS,
CONTENTS,
LOGGING,
We have a ~500Gb database on Compaq/Alpha HW and we use the multiple-mirror
break technique with a couple of varients. 1) We leave the database up but
put all of the tablespaces in backup mode for the mirror break. The mirror
set is then mounted on our failover system for the write to tape which
I know we had a big discussion about licensing a few weeks ago, but, when
Oracle says for a named user that if a multi-plexing machine can access the
software, then the number of named users must be counted on the front end.
Makes sense. So, if I follow this, they are saying that if I want to
Roland,
The best way that I know of is via your Sendmail deamon. If you've got
Oracle 8.1.6+ (I believe) there is a package that you can include in the
database called SMTP_something that is suppose to do the trick, try these
sites:
http://www.orafans.com/ubb/Forum1/HTML/002804.html
Hi,
Question, particularly to UK list members,
A couple of months ago I recieved a quote from Oracle for some aditional
products and I was quoted prices based on UPUs. (diag pack and tuning pack
for Oracle standard edition)
I thought that named user was the only pricing method.
Are UPUs
Harsh,
Block headers as they are called, have been around in Oracle for as long as
I can remember (Nov 1985). They have gotten a bit larger over the years though.
Dick Goulet
Reply Separator
Author: Harsh Agrawal [EMAIL PROTECTED]
Date:
Actually there was a correction to the story where this note was taken
from. Leisure Suit Larry lost $36 billion, not the mere $16 billion as
originally stated. So I guess that would be closer to 3 million VW's.
Title: oracle background process priorities
After reading the section of Steve Adams book
regarding priority degradtion of background Oracle
processes, I have decided to investigate further.
Has anyone else already looked at this?
Does HP-UX degrade priorities based on lenght
of time a
Hi
My Index tablespace increasing so fast.WHat could be problem.What are the
things to be consider to better manage of Indexes.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the
Title: X$ tables
Hi, DBAs
Anyone know where I can find docs which interpret the definition of X$ tables as well as their columns ?
thanks in advance.
li
Hello List,
I've a simple question.
Why do I see this output when I execute the following
query:
SQL l
1 select a.USERNAME,a.SPID "unix
pid",b.SID,b.serial#,b.osuser,b.program,a.program
2 from v$process a, v$session b
3 where a.spid='unixpid'
4* and a.addr=b.paddr
SQL
USERNAME
Title: RE: OT RE: Oracle being scalable
They did the following Olympics.
Some people paid less atttention when there was
no perceived carcass to feed off.
:)
== -Original Message-
== From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
== Sent: Friday, April 06, 2001 11:46 AM
==
Thanks for the answer Steve.
--- Steve Adams [EMAIL PROTECTED] escribi:
Hi Pablo,
The TM and TX waits are probably normal application
tuning issues. You'll find
some tips about reducing ST enqueue waits on the
Ixora web site, MetaLink and
elsewhere. The CU and SQ waits are relatively
Looks to me like you've either got two users connected to the database from
Windows or one user with two sessions. And if I'm not totally mistaken I
believe that 'OraUser' is a generic entry when the client computer does not have
it's computer name set.
Dick Goulet
Reply
First question is whether you're in Cost Based or Rule Based optimization.
In RBO you are correct that it will read tables right to left unless
instructed otherwise by a hint.
In CBO, Oracle will choose what it thinks is 'best', which most of the time,
but not all of the time :), will be true.
LI,
I don't have anything on this, others may, but in general I stay away from
anything down there. The tables and columns change between versions with some
regularity and there is some VERY strange stuff down there so that it's not a
place to tread lightly. Also if your imbedding things
Depending upon the version of Oracle; which you neglected to mention,
and depending upon whether or not you are using bit-mapped indexes
and depending upon if you are doing inserts into the associated
table, bit-mapped indexes grow exponentially with inserts!
At least the bit-mapped indexes
Looks like oracle reads into keep buffer pool only blocks that it needed but
then keep it there. Would be intersting to know if let say table has more
then 1 block and access is using indexes - so oracle needs to read only 1
block - will be all table loaded into keep buffer pool or only block
Title: RE: OT IBM and the Olympicswas RE: Oracle being scalable
IBM has done the Olympics IT for 40 years.
The Atlanta Olympics -- considered to be the
first Internet Olympics -- was half a decade
ago (Good memory, Mladen!).
After that, IBM hit grand slam after grand slam in
Hi all,
Something strange happened here this morning.
I created a standby database on our standby box this morning (Sun server OS
2.51 Oracle 7.3.4.5), all went well.
I check the status of the listener on the standby box, it was up (I don't
know why I even cared).
The production listener went
Dan,
As I read Oracle on this, your absolutely correct, you have to provide a
'name' for every person who can connect to the webserver. This also means that
if John Doe is not using his license (like he's out sick today) then Jane Doe
Can't use it. Your only "legal" solution in this case
If a select statement orders by a column whose values are not unique, are
the records returned in an order that is guaranteed to be repeatable from
query to query? (Assuming no updates, deletes, or inserts between
queries.)
I would think not, that guaranteed repeatable ordering requires
Joan,
I think if you replaced the
and 12 (select count(*)
with
and 12 (select sum(floor(fs2.bytes/s.next_extent)) it would work as
this should give the count * the number of times the next extent could fit
into the large extents.
Doesn't deal with pctincrease other than 0
Hi there ,
Thanks for the reply .
I am in Cost Based Optimizer ( we all will be now a days ) .
Does that mean , if I want to know ( or decide ) while writting the query , my
driving table , Its not possible ???
If I have a good idea ( size of data in tables , indexes etc.) about the
tables
Dear List Members:
We are in the planning stage of upgrading from NT 40 to Windows2000
and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row. My
question is, has anybody used Win2k Backup to Backup the database ?
Can it handle somehow shutting down the DB for cold Backups ? I
currently
Anup,
This can get into a lengthy discussion, but I'll try to keep it short. In
general you can use this in both CBO and RBO, since in my experience doing
things well for RBO has no ill affect on CBO.
The table order in the 'from' clause should match the order in the 'where'
clause.
You are correct. Even though 95% of the time they WILL be returned in the
same order, it is definitely not guaranteed.
At 09:50 AM 4/6/01 -0800, you wrote:
If a select statement orders by a column whose values are not unique, are
the records returned in an order that is guaranteed to be
Dear List Members:
We are in the planning stage of upgrading from NT 40 to Windows2000
and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row. My
question is, has anybody used Win2k Backup to Backup the database ?
Can it handle somehow shutting down the DB for cold Backups ? I
currently
How about store it in a configuration file or registry and store it
encrypted. Let the application read from the file or registry.
Richard
-Original Message-
Sent: Friday, April 06, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Thanks for the replies on this...but we do not
Basically, that's correct. Oracle _generally_ does a good job choosing an
excellent execution path. In some cases better than can be achieved through
the Rule-based optimizer...However there's that 0.5% that we have to
manually tune. Check out the section on HINTS in your Oracle Docs...you have
a
Nothing strange - you had wrong hostname in the listener.ora
Use localhost instead of DNS hostname in ADDRESS description in listener.ora
and you will never get situation like this. This implies that your listener
and database run on the same box.
Alex Hillman
-Original
We are using oracle 8.1.7 and solaris 5.7.
-Seema
From: "Charlie Mengler" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Index query
Date: Fri, 06 Apr 2001 09:15:49 -0800
Depending upon the version of Oracle; which you
Thanks, it finally works.
Joan
-Original Message-
Iain (metering)
Sent: Friday, April 06, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
Joan,
I think if you replaced the
and 12 (select count(*)
with
and 12 (select sum(floor(fs2.bytes/s.next_extent)) it would
Hi !
There is no document about X$tables outside oracle.
But Steve Adams has some details in his site
(http://www.ixora.com.au) and Jonathan Lewis also
something in his site (http://www.jlcomp.demon.co.uk).
=
Have a nice day !!
We are setting up a test Oracle 8i (8.1.7 with OSDI) on our
mainframe (os/390 v2.8), we can connect to the database instance (ORS1) from
windows NT client, but when we try to connect to it using database links set
up from our unix platform,
we get ORA-12154
TNS: Could not
Millie,
Check both instances and verify if global_names parameter is switched on.
What is the name of your db link?
select * from global_name;
Is it the same as global_name?
I have a problems creating database links when I have global_names parameter
set to TRUE.
I normally switch
Title: RE: failed to extent to the next
Jacques,
I got
one it works fine. However, the report is not 100% correct. For instance,
my next extent is 250m, if I select * from dba_free_space where
tablespace_name='XPC_OBJ_LOB' , it still report to me not enough space for next
12 extent, But it
81 matches
Mail list logo