At 12:07 PM 1/22/2003, [EMAIL PROTECTED] wrote:
> It recently came to my attention that the DBA's where I work have
adopted a
> convention where the global_name of a database is the same for the
> production, test, and development instance of that database (obviously,
> they've turned off global n
At 03:48 PM 1/22/2003, Jesse, Rich wrote:
Can you still create DB links between two DBs with the same global name?
While we don't normally use DB links (too many links from development to
production or vice versa), I seem to remember that being an issue. Then
again, my memory isn't the best...
Dan addressed this very well in his earlier post...
Here is what Tom Kyte says in his book (Expert one-on-one Oracle):
"DDL locks are automatically placed against objects during a DDL operation to protect
them from changes by other sessions".
"DDL locks are held for the duration of the DDL
Dan,
If I may, essentially you are saying that changes to data dictionary tables
have to be committed immediately regardless of the outcome of the
transaction.
For instance in the following code, starting with an empty table t1
step 1: insert into table t1 values row1
step 2: create table t2
s
I have never seen () after nextval in 7.3 or 8i or 9i .
-Bp
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 1:48 PM
> Hello everyone.
>
> This one stumps me and I'm wondering if it is a bug that was resolved in
> 9i.
it depends on how you are updating slave databases .
-bp
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 3:39 PM
> We have four machines setup as slave databases which get updated data from
> one Master database every
Oracle does not guarantee that the job will start at the time specified;
it seems
that it usually starts about 1 minute later, at least that's what I see.
This would account for the creep, as when the interval is evaluated, it is
later
than you might expect.
Jared
[EMAIL PROTECTED]
Sent b
Is otrace enabled?
Note: 1020763.6
Note: 45482.1
Tim
-Original Message-
Sent: Wednesday, January 22, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L
Hi All,
We have experienced a *very* slow connect time to a 9.0.1 database via
SQL*Plus (and other apps as well) on a Win2K mach
Vladamir,
This job runs pretty fast, so I don't worry about jobs running
into each other. It's a level 0 statspack.snapshot, it has run
407 seconds in ~ 700 executions.
Jared
Vladimir Begun <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2003 11:34 AM
Please respond to ORACLE-L
We have four machines setup as slave databases which get updated data from
one Master database every 5 minutes. The question is how do I know all
slave machines get updated data completely from the master database, another
word is how do I know there is no missing data when slave machines replicat
Hamid Alavi wrote:
>
> DEAR LIST,
> How can I import from a dump file which has some partionioned table into
> another user with no partitioning.
> Thanks in Advance
>
> Hamid Alavi
>
> Office : 818-737-0526
> Cell phone : 818-416-5095
Create the tables first and IGNORE=Y
--
Regard
And I believe Gaja would be right at the front of the line to agree with you
on that.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Me
Can you still create DB links between two DBs with the same global name?
While we don't normally use DB links (too many links from development to
production or vice versa), I seem to remember that being an issue. Then
again, my memory isn't the best...
Rich
Rich Jesse
The way I understood Gloal names is a global name will have a
.someserver.com
AFAIK... Global names is set/required IF you have your sqlnet.ora with a
line for
GLOBAL_NAMES =.someserver.com
Then you can seperatly identify your instances from the different
servers they are running on
Sqlplus [EM
Don't forget that extent allocation also affects the extent map for the
segment and possibly the high water mark. The hwm can be set without
allocating another extent and allocation of an extent may not alter the hwm
(if you manually allocate an extent). If I deallocate space from an object,
I will
Guang Mei wrote:
>
> Hi,
>
> According to book "Oracle Performance Tuning 101" (By Gaja K. Vaidyanatha),
> page 316:
>
> Oracle SGA Component Percent Memory Allocation
>
> Database buffer cache ~ 80
> Shared Pool area ~ 12
> ...
>
> This means 80% of SGA should be
Hello everyone.
This one stumps me and I'm wondering if it is a bug that was resolved in
9i. Here is sample code.
Create sequence a;
Create table xxx(numtest number, testvalue varchar2(100));
Inside PL/SQL block and from SQL*Plus Prompt;
Insert into xxx(numbest, testvalue) values (a.nex
http://www.infoworld.com/articles/op/xml/02/12/09/021209opwinman.xml
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hos
Hamid - In the target schema, is the table already created? If it isn't, I
would recommend that you create it before you import the data.
Normally partitioned tables are quite large. Are you sure this import
will complete in a reasonable time frame?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
Stephane Faroult wrote:
Vladimir (whose formula I am still trying to understand :-))...
TRUNC(SYSDATE) + (CEIL(TO_CHAR(SYSDATE, 'S') / 60 / :interval) / (24
* 60 / :interval));
P.S.: could you please answer my question ('100% CPU utilization,
urgent') thread?
--
Vladimir Begun
The statemen
Try:
compute sum of bytes on report
break on report
column name format a30 heading 'Memory Structure'
column bytes format 999,999,999,999 heading 'Bytes'
select * from v$sgastat
/
Thanks Dan. The gist of your response was that all changes to the data
dictionary are immediately commited. Seems to make sense to me. Maybe,
thats one reason why one cannot free space below the high water mark. Coz
changes to UET$ has been committed, even though the data was rolled back.
I sent
DEAR LIST,
How can I import from a dump file which has some partionioned table into
another user with no partitioning.
Thanks in Advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The inf
chao_ping wrote:
>
> hi, dba friends:
> Is there someone else who is also using tuxedo as middleware? In my system
>we use tuxedo 7.1 on linux to connect to db server, but when I look at
>v$session.program, it always show something like:
>
>? @app9 (TNS V1-V3)
>? @app9 (TNS V1
1980's??? Yes, but it works, ain't broke, reliable, KISS, and is easy
to implement.
I use cron from my Linux box to connect to the production Oracle
database (OpenVMS) and do a RMAN backup with the catalog on a second
Oracle database (OpenVMS) server. Beats the heck out of trying to get
the backu
I like this solution.. Looking at the second one I proposed, I think
that it actually would end up just running once an hour at 15 after It's
amazing how things look a lot different at midnight and 2pm in the
afternoon.
Cheers!
Robert G. Freeman
Technical Management Consultant
TUSC - The
Hi,
According to book "Oracle Performance Tuning 101" (By Gaja K. Vaidyanatha),
page 316:
Oracle SGA Component Percent Memory Allocation
Database buffer cache ~ 80
Shared Pool area ~ 12
...
This means 80% of SGA should be allocated to "Database buffer cache". Now I
If a job takes longer than the next scheduled time to execute then I see a
problem. Suppose a job runs every 15 mins but runtime is 30 mins, the
number of jobs will increase and compete for the same resources.
I always use cron (80's kinda of control), and the 1st thing I do is check if
th
Very good case described.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 2:16 PM
> Take the case of an insert (we'll call tx1), where space allocation is
> required. As you in
The problem with that formula is that you'll get "creep" and eventually your
15-minute jobs are running 8 minutes late.
Try this one instead:
trunc(sysdate) + (trunc(to_number(sysdate - trunc(sysdate)) * (60/15*24)) /
(60/15*24)) + 1/(60/15*24)
Guaranteed to run every 15 on the 15. At least I t
Actually, Interval is evaluated at the beginning of the job according to
the docs.
I've not seen anyone mention the real cause behind DBMS_Job "creep". That
is the setting of Job_Queue_Interval which, by default, is 60 seconds. So
your jobs will run 1 minute later each time unless you set Inter
As an aside, if you want something to run twice a day at the same time (in
my case 11:50 AM/PM), this seems to work well for an interval:
trunc(sysdate) + (decode(to_char(sysdate,'AM'),'AM',1,2)*12+(11+(50/60)))/24
Enjoy! :)
Rich
Rich Jesse System/Database Administra
[EMAIL PROTECTED] wrote:
Now as discussed, if the job is scheduled to start at 9:00 AM and
runbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15,
and it
will creep 5 minutes every time.
No, as written, my jobs start on every quarter hour, regardless of
runtime.
e.g. 09:00,
Thanks! Works better than the first suggestion.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
Sent: Wednesday, January 22,
Ok, back on this topic again I would *like* to write a query that jaunts
through v$sql and collects and condenses related parallel queries with the
slave processes for all the SQL stored in that view. I'm not seeing any way
to do this for inactive queries... It's fairly easy to identify slave
p
Date: Wed, 22 Jan 2003 09:01:20 -0800
Yes Ron, there is.
For ORACLE FINANCIALS go to
http://www.rchath.com/mail_list.htm
or
http://www.oaug.org/public/oaugnet/oaugnet.html
and follow the instructions.
For other Oracle Products:
http://www.odtug.com/subscrib.htm
http://www.doug.org/list.server.h
Take the case of an insert (we'll call tx1), where space allocation is
required. As you insert records, the table allocated additional extents
(updating fet$ (free extent table) and uet$ (used extent table) in the data
dictionary). These updates to the data dictionary are implicitly committed,
even
Very good point, Raj. I didn't wonder just for the sake it; there was meat
to it ;)
Now that this has been raised, any ideas, anybody?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 12:01 PM
>
> That raises another d
Bp,
Often where the term "Senior DBA" comes up is with company HR
departments. It isn't usual for we DBAs to greet each other with "Hi, I'm a
senior DBA". I agree with Mark's comments, but just wanted to point out this
other aspect to the issue. Sometimes HR people use this as a method for
cate
> It recently came to my attention that the DBA's where I work have
adopted a
> convention where the global_name of a database is the same for the
> production, test, and development instance of that database (obviously,
> they've turned off global naming in the init.ora). They've also set up
Nick,
Thanks for the notes.
I've often wondered how Shareplex
did its thing.
Just for kicks - have you tried writing
a collision handler for streams ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon
> Now as discussed, if the job is scheduled to start at 9:00 AM and
> runbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15,
and it
> will creep 5 minutes every time.
No, as written, my jobs start on every quarter hour, regardless of
runtime.
e.g. 09:00, 09:15, 09:30, 09:45 ...
Hmm... I had only given the code a cursory examination.
Good thing I didn't use it. :)
Jared
Freeman Robert - IL <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2003 10:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Thanks Robert, I like this.
Simplified and still easy to read.
Jared
"Robert Freeman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/21/2003 08:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
Well, I did consider that using 4 jobs , but my overdeveloped sense of
aesthetics and professional hubris (that one mostly) required that it be
done with a single job. ;)
Lots of good suggestions here.
Seems like everyone is always up for a puzzle. :)
Jared
"Arup Nanda" <[EMAIL PROTECT
Yea... I realized that after I sent the email, so I submitted my second
suggestion...
Thanks though for your thoughts!!
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Am
Vladimir,
I beg to disagree. The reason is that we used a number of jobs where the
interval was defined as "sysdate+1" and the job routinely ran for ~30 minutes
every day. The result was that the job migrated over the course of a week by
3.5 hours so that instead of running at 6AM as schedul
hi, dba friends:
Is there someone else who is also using tuxedo as middleware? In my system we
use tuxedo 7.1 on linux to connect to db server, but when I look at v$session.program,
it always show something like:
? @app9 (TNS V1-V3)
? @app9 (TNS V1-V3)
? @app9 (TNS V1-V3)
To answer Arn's question, no, I'm not currently using it. However I can see
some potential in the product.
Rich, Workspace management allows you to "version" a table. You can create
multiple "versions" of the same table (workspaces), and different people can
work in different workspaces and multip
Mark ,
Thanks for the reply . I think learning is a never ending process ,
specially in IT industry where new version of software is out before 30%
adapts the previous version .But is there a line which can be drawn ? No one
knows everything . But experience tells where to look for proper things an
Consistency is the key too imagine what would happen if I dropped a
column or changed it's definition, while a SQL statement or PL/SQL package
was executing. The data that was updated before the change may well be very
different in nature than the data after the change
Borrowing from Ghost
Don't forget the other great tools from SysInternals either, like "Regmon"
and "procexpnt". Great tools that helped me find that my Opera problem
("File not found" errors causing program to crash) is actually MS's really
really cool proxy software. Crap. All MS is crap. Crap, crap, crap.
Ric
[EMAIL PROTECTED] wrote:
One potential problem with DBMS_JOBS as is being discussed here is that Oracle
computes the next_date at the end of the job. They do that so that if a job
-- INTERVAL is a date function, evaluated immediately before the job starts
-- executing...
runs longer than it's
Title: RE: quest SharePlex
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ?
-- Yes
And does Shareplex guarantee that it will
never report a 1555 error regardless of how long it
is shut dow
Yes Ron, there is.
For ORACLE FINANCIALS go to
http://www.rchath.com/mail_list.htm
or
http://www.oaug.org/public/oaugnet/oaugnet.html
and follow the instructions.
For other Oracle Products:
http://www.odtug.com/subscrib.htm
http://www.doug.org/list.server.html
HTH. Milen
-Ursprüngliche
Title: RE: dbms_job - running jobs every 15 minutes
LOL. You are right about the job_scheduler in early
9i.
Had
all sorts of problems when I first started moving stuff to
9.0.1
and 9.0.2 and Oracle was no help figuring out what the
problem was.
I use
cron all the time, but I love t
One thing I've learned Arup, there are 15,000 ways of doing the same thing,
and a good many of those are as good as the other. Cron, dbms_job, at,
whatever works for you!!
Rf
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhe
Where's the challenge when you have the facts?
=)
Mike
-Original Message-
Sent: 22 January 2003 15:05
To: Multiple recipients of list ORACLE-L
Well while we are ranting how about always including the version of the
database, and the platform you are running on too!
RF
Robert G. Fr
Title: RE: dbms_job - running jobs every 15 minutes
LOL.
Ok, I
confess, my name's Robert and I'm a CRON user
Rf
Robert G. FreemanTechnical Management
ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's
everywhere that I am!)Author of several books you can fin
That raises another doubt. For an simple insert statement, could also
update the UET$ or FET$ tables? So, if the purpose was to preserve all
changes to the data dictionary, What's different between OBJ$, COL$ and
these space management tables?
Thanks
Raj
Better yet -- WHAT is Workspace Management?
"Additional training for Oracle 9i" -- Goals for 2003 :)
> -Original Message-
> From: Arn Klammer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 21, 2003 12:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Anyone storing th
How big is the listener log file?? do you truncate/rename it on regular
basis??
just a thought.
Sunil Nookala
Dell Corp.
-Original Message-
Sent: Wednesday, January 22, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L
Hi All,
We have experienced a *very* slow connect time to a 9
Title: RE: dbms_job - running jobs every 15 minutes
Cron? How RELIABLE !!
-Original Message-From: Freeman Robert - IL
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 22, 2003 10:10
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
dbms_job - running jobs every 15 min
Well look at it this way, besides creating/modifying/dropping the object
that you want your also performing a number of updated/inserts/deletes from the
data dictionary. Those data dictionary tables are just that, tables. Now
imagine what a mess would be created if you performed a DDL stateme
One reason for seeing more db_block_gets
than you expect on a full segment scan
is that every extent map block (of which
the segment header block is just one)
is accessed differently. If you have small
extents and large objects, you may have
overshoot the maximum extents allowed
in the segment he
One potential problem with DBMS_JOBS as is being discussed here is that Oracle
computes the next_date at the end of the job. They do that so that if a job
runs longer than it's schedule interval the two invocations will not run into
each other. Now as discussed, if the job is scheduled to start a
The best you can get on linux is sar -d.
> -Original Message-
> From: chao_ping [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 22, 2003 2:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: off topic: iostat -x in linux
>
>
> oracledba??
> dba friends, do you know ho
I have this application which issues a lot of dynamic SQL's with literals,
for each customer who logs in. And on querying v$sgastat, I see 21Mb of
free memory. Does shared_pool_reserved_size show up as "free memory" in
v$sgastat? If not, I might have some further questions?
Thanks
Raj
--
Please
Title: RE: dbms_job - running jobs every 15 minutes
Robert,
I have solid reasons not to trust dbms_job ... it didn't work reliably in
901x. Call me retro ... but "cron" rocks ...
8:)
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
And when your problem is finally resolved, even if it's as magical as the
passage of time, please... please... let the us know that. This is a
educational excercise for all concerned and everyone is interested in the
analysis and the final outcome. Don't you think you owe that much to the
people w
Title: RE: dbms_job - running jobs every 15 minutes
Cron?
How 1980's :-))
RF
Robert G. FreemanTechnical Management
ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's
everywhere that I am!)Author of several books you can find on
Amazon.com!
-Original Messa
Pomi,
This file alrerady exists; and so is the error. You have two options.
(1) Just add a clause REUSE after the datafile name. Oracle will reuse the
existing file. Not recomended. You might accidentally overwrite a good file.
(2) Find out the datafile does not belong to the database
select name
Well while we are ranting how about always including the version of the
database, and the platform you are running on too!
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can
My guess will be to preserve the changes to the data dictionary, which are
just Oracle tables anyway. When you create a table, a record goes to TAB$,
SEG$ and so on and so forth. Unless there is a commit these information is
not visible.
But now that you asked, I wnder why the same objective could
Presuming that PGA_AGGREGATE_TARGET of 500MB is sufficient
for your environment
... it does look as if your PA-RISC processors are slower than the Intel ones
but ... I still wonder..
your statistics show that the number of block-gets for the FTS isn't very high
and cpu time is high.
If you c
Cho,
This is not unusual. I suspect your db_cache_size (or db_block_buffers) in
9.2 is more than db_block_buffers in 8.1. When you do a FTS, all the blocks
are loaded into the buffers first time so 'db block gets' is a non zero
value (it's the physical IO). The next time you do this, the blocks ar
That's exactly what I do. Phew! I thought I was the only one ;)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 8:03 AM
> Personally, I tend to just submit four jobs: one at the top of hour, one
at
> 15 past, one at 3
Title: question about rman
I am jumping in late on this thread and may be way off the
mark but I do all my backups to disk and put them on tape using the OS backup
facility. When recovery is needed I just put the backupsets back on the
original disk. Then rman isn't confused at all. If omn
If the box is swapping memory, connections can be slow since memory has to
allocated for the connection. Just one possibility.
> -Original Message-
>
> We have experienced a *very* slow connect time to a 9.0.1 database via
> SQL*Plus (and other apps as well) on a Win2K machine,
--
Plea
Jonathan Lewis,
Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the
db block gets of fulltable scan is always 4block, no matter what the size of the table
is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan
again and again, bu
Hi Sean
The following site has *some* info about your problem, though the "fix"
isn't too great an explanation, and you also mentioned that you had no
errors in your alert log:
http://www.orafaq.net/archive/comp.databases.oracle.server/2002/03/03/137294
.htm
M.
-Original Message-
Sean
S
hi
what's your exact question?
you mean autocommit like in database applications?
what tool are you using to observe or redard to this phenomenon?
the erd-demon has to send some info via rs232 to make the amplifier -called booster -
work. no info implies no current on the tracks. kind of answwer
Is there a forum for Oracle Financials questions? I am doing backup support
on Oracle Financials and I don't know anything about the product. The /tmp
file on Unix has filled with a couple of very large temp files. I need a
way to tie the files back to a process and hopefully a client. Can anyo
Title: RE: dbms_job - running jobs every 15 minutes
I simplified it by using cron instead ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't r
Title: Database Load & Server Specs
Hi all,
I have three questions, would appreciate if any of you can help me on that, its important because I need these answers to support my claim of our server being over loaded.
First is; is there query to find out the number of transactions at any time?
Short answer is no. Can't think of an
environment where compiled objects can be recreated without quiescence, so its
not just Oracle.
You should use PL/SQL packages instead of
stored procedures or functions so that the "body" of the
package (containing code) can be disassociated and recom
Remove *all* footers (telling you how to subscribe/unsubscribe) added by Oracle-l
list server.
Sorry about that.
- Kirti
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
Deshpan
Hi Kirti,
I am u
Just curious: why are you using PGA_AGGREGATE_TARGET? Are there any limits
on memory capacity that you are in danger of exceeding? You have two CPUs
with 4Gb of RAM; I imagine that you're not in any danger, but it pays to be
sure. I can't think of the HP-UX equivalent to the Solaris "swap" comm
I have a problem understanding why anyone would ask a question and then not
display the exact error number and error message text they are seeing.
There are thousands of error messages in Oracle and the platforms it runs
upon and the APIs it supports, and the text associated with the number is
pra
Hi Kirti,
I am unable to send a message to you privately. Whenever I try to
send a message to you it bounces back with the below forwarded message. How
do I send a message to you privately? Please help.
Thanks and Regards,
Ranganath
> -Original Message-
> From: [EMAIL PROTECT
Your only choice (limited) is do not create standalone procedures ...
package them. But Wait there is more
no matter what you create ... procedure/function/package if it is being
executed, you can't compile it. Who makes changes in live production environment
(other than us) anyways ..
Personally, I tend to just submit four jobs: one at the top of hour, one at
15 past, one at 30 past, and the fourth at 45 past. To alter the frequency,
just "break" or remove one or more of the jobs. Falls into the category of
"not elegant, but it works"...
- Original Message -
To: "Mul
in 9i, you can remove the datafiles as well by using the clause "and
datafiles" on the drop tablespace command.
Saves having to remember to go back and clean up after yourself.
Without that clause, the drop tablespace command works as it did in 8i
Rachel
--- Stephane Faroult <[EMAIL PROTECTED]>
Recently we've had three of our 8.1.7 databases on W2K servers crash with
messages similar to below in relevant alert logs:
ORA-00202: controlfile: ''
ORA-27091: skgfqio: unable to queue I/O
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1453) Insufficient quota to complete
http://www.informationweek.com/story/IWK20030121S0001
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web host
Hi friends
Why DDL statements performs auto commit ? What is the exact reason behind
that one?
Anyone can share his/her opinions!!
Thanks & regards
BanarasiBabu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BanarasiBabu Tippa
INET: [EMAIL PROTECTED]
Fat City Netwo
>Pomin,
>
>Pls check this tablespace whether it's already
>exist in your database.
>Try this script (connect as sys):
>
>SQL > select * from dba_tablespaces where
>tablespace_name = 'TSelCZ_Data';
Would be better in UPPERCASE. Besides, this is far from being enough. When you drop a
tablespace, t
Hello
650 Mhz processors are HP pa RISC processors.
We use automatic PGA management. There are 500MB PGA.
sort_area_size have the dafault value because under automatic PGA
there is not used (or not?).
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sen
oh goodie, then I'm a senior DBA :)
I never did partitioning before this current job. Based on a prior
answer to this question, that would have disqualified me
It's not so much what you have done, as how you think about things.
I've worked with junior DBAs who have a tendency to jump in without
Check your setting parameter for db_block_gets and compare between oracle9.2
and oracle817. Is it equivalent setting parameter ?
> -Original Message-
> From: chao_ping [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 22, 2003 1:54 PM
> To: Multiple recipients of list ORACLE-L
> Subjec
1 - 100 of 109 matches
Mail list logo