Hi Tracy,
A few observations
1. Can we use a more selective where clause?( Currently we
are going for a PK Range Scan. Can we change the where clause to go for a PK
Uniq scan?)
2. The Fetch time is very high.I guessthe fetch
is a single row fetch. We can tune the code for bulk fetch by
Hi Tim,
Are you sure it's still owned by Veritas? Doesn't look that way when I
checked it just now.
Mogens
Tim Gorman wrote:
Helmut,
Register with http://www.oraperf.com; and run those STATSPACK reports
through the YAPP analyzer, which will reformat them in such a way that they
make sense.
Not sure if that is what you want... and not sure if this will really work,
just a quick thought...
Invalidate the procedure, so next time it will be used, it will be
recompiled, and then you can see at LAST_DDL_TIME in ALL_OBJECTS to find out
when it was used first after invalidating.
Regards
Title: Message
Tim
Its something to do
with outlook removingline breaks and thereby mangling the formatting of
the command. In my Outlook, there is a message in the header of the mail
saying something like 'Extra line breaks in this message were removed. To
restore click here.' When I did
A BIG thanks to Jared Bruce for all your efforts guys. And as bruce
says See you in a minute on the new list.
Thank you,
Venu!
-Original Message-
Bruce A. Bergman
Sent: Thursday, January 22, 2004 9:44 PM
To: Multiple recipients of list ORACLE-L
Yes, this is legitimate.
Jared and I
Hallo all,
Anyone whom know how to write the trigger if you just want a trigger to be fired if
only two fields in a table is changed, not all of them?
Any good example?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET:
Title: RE: Trace output
Satheesh,
Row source operation is the run time execution plan. The execution plan is added when you run tkprof and you use parameter explain=user/password Connect to ORACLE and issue EXPLAIN PLAN and this is theoretical plan. In version 9.2 those two plans can
Title: Message
Hi All,
Sorry for an OT question, but nowhere else to go. Pretty new to Solaris
so might be a naive question. Need a pointer on how to do
this.
The disk space in the machine is constantly decreasing. And I want to
knowwhich files/directories are growing.
Is there any way to
Ron,
I agree, uniform sizing is best. I hardly ever use automatic except for small
development databases and small MISC tablespaces and even then I think Why
didn't I use use uniform 64K ?
Cheers,
Chris
Quoting Ron Rogers [EMAIL PROTECTED]:
Brad,
For LMT's I prefer uniform sizing that I
Thanks a lot, Bruce. Much appreciated.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
The list archives here will be available as long as Fat City continues to be in
existence, so those of you who are
searching for old topics are quite welcome to use the facilities here.
Hi,
anyone has read and implement as note 216205.1 ?
any comment or suggestion ?
regards
-Original Message-
From: hernawan [mailto:[EMAIL PROTECTED]
Hi all,
I have process in Oracle apps 11.5.8 which need
very lot CPUs and long time to complete.
for about 17,000 invoices it
what are the specs of that box? what does it cost? Ive never worked on
something that big. how big is the database your working on?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 11:24 PM
So, my intention to set P_A_T to
well, I can't get to the site at the moment to test it.. if I remember
correctly, Anjo said he had leased it to Veritas for a couple of
years, while retaining permanent ownership.
On the other hand, he's on this list, he can confirm or deny that
himself!
--- Mogens_Nørgaard [EMAIL PROTECTED]
Hi,
check out Mogens site, he has a PL/SQL tool for storing trace files
in a repository. Its called TraceFile Repository and was written by
Torben Holm and its free - have a look http://www.miracleas.dk/tools/Mir
TFR104.zip -t might be an alternative for you? - it has a web based
front end using
There are a series of metalink notes detailing memory leaks with the PGA in 9203. Has
anyone had critical problems? Oracle recommends patching to 9204 to fix this, but it
just came out and we prefer to be conservative with our patches.
--
Please see the official ORACLE-L FAQ:
Check out the du (disk usage) command.
man du
[EMAIL PROTECTED] 01/23/04 03:44AM
Hi All,
Sorry for an OT question, but nowhere else to go. Pretty new to Solaris
so might be a naive question. Need a pointer on how to do
this.
The disk space in the machine is constantly decreasing. And I
Title: Message
-Original Message-From: Lord David
[mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004
3:14 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!
Tim
Its something to
do with outlook removingline breaks and
Naveen,
Since you are new to Solaris, how new are you to unix/linux? If you
are already aware of anything, I apoligize:
spool the output of df -k to a file. I really like the script command
for this. Wait some time (long enough for more disk to get used) and do
it again (rename the first
I read the paper about the adaptive memory and how it
gets wasted, but with 10G SGA you can afford to be a bit
wasteful. I would set workarea_size_policy to manual and
then set sort_area_size to 32M and hash area size to 128M.
With the memory sizes you mentioned, there shouldn't be any
problems.
Hi All,
I have a before update trigger for a local table. I know Oracle does not
commit the inserting audit entry into the audit log table until the user
commits the changes on the audited table. Can I assume Oracle issues one
commit for both changes? When commit fails, both changes will be
Title: Message
Bill
The line breaks get
removed from *incoming* mail, so I don't think it matterswhat your default
new mail format is.I think its a new 'feature' in Outlook 2003 - I
found this quote in the 'Whats new in Microsoft Office'in online help:
-
Extra line breaks automatically
Use:
when updating col1, col2,...
clause.
Better yet, read oracle docs.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 3:19 AM
To: Multiple recipients of list ORACLE-L
Hallo all,
Anyone whom know how to write the trigger
Title: Message
Its
easy todisable this "feature":
Navigate to the Tools-Options
menu
Click the "Email Options"
Button
Uncheck the "Remove extra line breaks in
plain text messages" checkbox
Click Okay about 30 times and your're
done!
Kevin
-Original Message-From: Lord
Title: Message
Thanks Kevin,
couldn't see for looking
--
David LordSenior DBAIron Mountain (UK)
Ltd-Original
Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED]
Sent: 23 January 2004 14:30To: Multiple recipients of list
ORACLE-LSubject: RE: !!Please Read - Oracle-L is
moving!!
Title: Message
I like the fine message provided when you right
click on Extra line break in this message were removed. To restore,
click here..that is No help topic is associated with this
item oh great.
Julio
Cesar Quijada-Reina
Programmer Analyst
Computer
Services at Alfred State
I've tried to get ahold of Anjo off-list several times. I'm sure he is
busy, but I really need to get ahold of him. Can someone off-list ask
him to e-mail me at either/both of these addresses?
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Thanks
Stephen
[EMAIL PROTECTED] 01/23/04 12:19AM
Hi Tim,
We for one don't like ANYTHING invalid in production database ... either it is valid
or it gets dropped.
Raj
-Original Message-
Sent: Friday, January 23, 2004 2:24 AM
To: Multiple recipients of list ORACLE-L
Not sure if that is what you want... and not sure if this will really work,
Title: Message
Thanks guys!
From: Kevin Toepke
[mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:30
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
!!Please Read - Oracle-L is moving!!
Its
easy todisable this "feature":
Navigate to the Tools-Options
menu
Click the
Hello everybody
Im woriking on NT and there are two 8i databases on it
One database can execute jobs normally, but the other one not execute any job.
I proved submitting the same procedure to both database and worked on the first one but not on the second one.
How can I resolve this?
Mauricio
Jared,
Thanks! I'd like to try perl, but I have to admit I am totally naive on
this subject. I am thinking to take a course. (free for me) How much
efforts in order to set this up?
ps, your graph is very impressive. I still have trouble to make the
graph from excel. Thanks to Dennis, after I
I tried to create tablespace with 16K (default on my
init.ora blocksize =8k). I have error happen. The
database version is 9.2.0.4.
SQL create tablespace index1 logging datafile
'/u0/oradata/leg92/index1.dbf' size 20m
2 blocksize 16384
3 autoextend on
4 next 1280k
5
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 you tried firebird?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The box said I needed to have windows 98 or better...So I installed linux.
Why not stop using Outlook. I've been happy with Eudora for 1.5
years now.
Hemant
Hemant
At 07:54 AM 23-01-04 -0800, you wrote:
Thanks
guys!
From: Kevin Toepke
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 23, 2004 9:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: !!Please Read
I issued commit and
job_queue_processes = 4
job_queue_interval = 10
in init_SID.ora file
so I don't know why the jobs are not working
regards,
Mauricio Vélez
[EMAIL PROTECTED] wrote:
A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in
dba1
I think you must first create a buffer cache for this block size.
http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 23, 2004 10:29 AM
To: Multiple recipients of list
A two-phase commit is simply a way to make sure that commits happen in a distributed
transaction the same way that they do in a local transaction. The absolute rule is:
Everything commits or Nothing does. In-between, with some parts committed and some
not, is NOT tolerable. So in your
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
Hi Jared,
Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again.
Thanks,
Quamrul
From: Joan Hsieh <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple
Tracy,
Take a look at the thing calling this 43,814
times. Can this query be used as an inline view for the thing using this querys
result set? If so, then youll eliminate 87,629 database calls.
As Tom Kyte says, Tune the
QUESTION, not the query.
Cary Millsap
Hotsos Enterprises,
One way to determine where to start looking is via find:
find / -mtime -1 -type f -print | xargs ls -ld
This will find all files touched within the list day.
If you get the gnu version of find, you can use '-mmin -30' to find all
files touched in the last 30 minutes.
You can then play with
Hi everybody
I have the following question
How can I querya table's views?
For example I have the table students and I want to know the views related to this table.
Thanks,
Mauricio Vélez
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
And ... what is the error number that you get ?
Note : If you are creating a tablespace with the non-standard blocksize,
you must have db_cache_Xk_size configured and running for your instance
before you create the tablespace.
Hemant
At 08:29 AM 23-01-04 -0800, you wrote:
I tried to create
I run it on Linux. Should work ok on Win2k, though I haven't tried it.
The modified YAPPPACK and Perl scripts are at
http://www.cybcon.com/~jkstill/util/zips/yapp_chart.tgz
Works in 8i and 9i.
Jared
Quamrul Polash [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/23/2004 09:04 AM
Please
Ah, we've discussed this system a couple times in the past.
Jared
PS.
Ok, ya'll move to the new list now, ya hear!
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/22/2004 08:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL
Naveen - Are you using autoextend on any of your datafiles?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 23, 2004 11:39 AM
To: Multiple recipients of list ORACLE-L
One way to determine where to start looking is via find:
find /
The table you want to look into is USER_OTN, Column DOCUMENTATION.
On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote:
Hi everybody
I have the following question
How can I query a table's views?
For example I have the table students and I want to know the views
related to this table.
Thanks,
Because, you left db_16k_cache_size parameter to the default value of 0 (zero).
- Kirti
--- dba1 mcc [EMAIL PROTECTED] wrote:
I tried to create tablespace with 16K (default on my
init.ora blocksize =8k). I have error happen. The
database version is 9.2.0.4.
SQL create tablespace
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
Seriously, and without any trace of a smile, I can say that someone
doing that on a high visibility system would stand a very good chance
of having the opportunity to seek new employment.
PS.
If you're reading this, subscribe to the new list. This one's days are limited
to about 10.
You may want to define DB_16K_CACHE_SIZE in init.ora, or
use ALTER SYSTEM to set this value.
HTH,
Krishna
~~
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
Title: Message
Query
DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and
referenced_type='TABLE'.
-Original Message-From: Mauricio "Vélez
[mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004
9:50 AMTo: Multiple recipients of list ORACLE-LSubject:
Are
the jobs "broken"??
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Mauricio "Vélez
[mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004
12:04 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Jobs are not working
I issued
SAP R/3 has taken advantage of this approach for a long time now. It buffers
tables based on settings in the R/3 data dictionary and can buffer single rows,
groups of rows, or entire tables. Tables which are used to store configuration
information are typically fully buffered, while
The Jobs are not broken
I haven't resolve this yet, alljobswork fineon one database buton the other not.
How can I resolve this?
Mauricio Vélez
"Goulet, Dick" [EMAIL PROTECTED] wrote:
Are the jobs "broken"??
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original
Can
you execute the "what" column's contents in SQL*PLus. Sometimes table
permissions get in the way.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Mauricio "Vélez
[mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:56
PMTo: [EMAIL
On 01/23/2004 11:29:32 AM, Mauricio V?lez wrote:
How can I resolve this?
By reading the administrators guide.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote:
Because, you left db_16k_cache_size parameter to the default value of
0 (zero).
- Kirti
He probably has left db_16k_cache_size parameter but the problem
described here is with syntax, not the cache size. Parser stops
looking or file attributes
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 was
You gather it wrong :)
Oracle stores date in 8 bytes, one for each: year, month, day, hour,
min, ... etc.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Droogendyk, Harry
Sent: Friday, January 23, 2004 12:40 PM
To: Multiple recipients of list ORACLE-L
Folks:
From what I
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
Title: Message
Mauricio:
Define
the exact symptoms of your problem.
For
example:
How
are the jobs being submitted?
Are
you getting an error message upon submission?
How do
you know they're not running?
Have
you queries dba_jobs_running?
Please
respond with any diagnostic error
Ref: Fix subscription errors after Final Confirmation
message
I'm on Yahoo. The workaround is to send the Final
Confirmation message (with that //job stuff) back
using the Forward button (not Reply). You have to
cut-paste the address.
The problem with Reply is caused by HTML formatting in
the
John,
Thanks for your very detail explanation.
From: John Flack [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: commit for triggers
Date: Fri, 23 Jan 2004 09:09:34 -0800
A two-phase commit is simply a way to make sure that
Igor
Sorry but Oracle uses 7 bytes for a date
century (1 byte)
year (1 byte)
month (1 byte)
day (1 byte)
hour (1 byte)
minute (1 byte)
second (1 byte)
SQL desc d
Name Null?Type
-
Harry,
Can you explain why you need to raw internal value? Just curious.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 23, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L
You gather it wrong :)
Oracle stores date in 8 bytes, one for
Hi,
I'm getting a little confused between expired backups and obsolete backups.
As I understand it, expired means the backups are no longer on disk.
Obsolete means the backup is too old(?).
Since I have a data ware house, I only have room on disk for 1 backup.
Prior to running my weekly
Thomas:
I'm a SAS guy who must pull Oracle data from the back-end DB.
SAS stores dates internally as elapsed days since Jan 1, 1960. If I request
an Oracle date field, SAS creates a datetime variable, number of seconds
since midnight Jan 1, 1960. Rather than use SAS functions to extract the
Harry
This list is moving to freelists, but I'll assume you knew that.
Actually the base value for the standard Oracle dates is Jan 1, 4712 BC.
There is a Julian function that will return the number of days since the
base. To return the Julian,
select to_char(sysdate,'J') from dual;
Also,
John,
I agree w/ everything you said, except for the autocommit functionality.
Autocommit setting has no impact on whether DDL will commit or rollback
any in progress transaction. DDL always commits an in-progress
transaction. The short example below speaks for itself. (8.1.7.4 on
Solaris 2.8)
- -Original Message-
- From: Ron Thomas [mailto:[EMAIL PROTECTED]
- Sent: Friday, January 23, 2004 11:49 AM
- To: Multiple recipients of list ORACLE-L
- Subject: winders email client.
-
-
-
- have you tried firebird?
firebird is a web browser without an email client. thunderbird is
Paula - You put on your saddest face, match that with your body language,
shuffle into the sys admin's cube and solemly announce you're going to have
to fix this, change the hostname back. Then brighten a little, come closer
and whisper I think I can keep anyone from finding out what you did.
Mladen,
Any privileges required to view this table, or just common sense? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Friday, January 23, 2004 1:24 PM
To: Multiple recipients of list ORACLE-L
The table you want to look into is USER_OTN, Column
Oops...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Peter Gram
Sent: Friday, January 23, 2004 2:54 PM
To: Multiple recipients of list ORACLE-L
Igor
Sorry but Oracle uses 7 bytes for a date
century (1 byte)
year (1 byte)
month (1 byte)
day (1 byte)
hour (1 byte)
minute
Thomas:
I'm aware of the to_char function and the various options. However as you
alluded to, that lands in SAS as a character literal, e.g. '22/01/2004'
requiring me to convert it to internal format before I can use it in SAS.
I think I have to use my work around:
select date_fld -
Kirti,
So is April 12th the latest date you heard for when 10g might be
released?? Because it was the end of 2003, but I didn't know it had
slipped all the way into April...
-Original Message-
Kirtikumar Deshpande
Sent: Wednesday, January 21, 2004 7:24 PM
To: Multiple recipients of list
Thanks to all who replied with helpful comments, pointers, links etc...
-Original Message-
Sent: January 23, 2004 3:24 PM
To: Multiple recipients of list ORACLE-L
Harry
This list is moving to freelists, but I'll assume you knew that.
Actually the base value for the standard Oracle
Thanks for your input, Naveen. But, It is hard to do that since everything
is under Production Support Team control.
Best Regards,
Prasad
Where can you get this firebird browser?
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
[EMAIL PROTECTED]
[EMAIL
http://texturizer.net/firebird/
[EMAIL PROTECTED] wrote:
Where can you get this firebird browser?
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: winders email client.
Where can you get this firebird browser?
Yup. Answered this without drinking coffee first...
Firebird, aka phoenix- one of the best browsers out there. I use it exclusively.
Thunderbird- email client. I read IMAP not MAPI in your email.
Slithering back to my hole...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The box said I needed
[EMAIL PROTECTED] wrote:
Where can you get this firebird browser?
http://mozilla.org/
--
Bricklen Anderson
PresiNET Systems
http://www.PresiNET.com
Live Demo: https://www.presinet.com/secure/login
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bricklen Anderson
INET:
email client- http://texturizer.net/thunderbird/
browser- http://texturizer.net/firebird/
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The box said I needed to have windows 98 or better...So I installed linux.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 23, 2004 3:09 PM
To: Multiple recipients of list ORACLE-L
Thomas:
I'm a SAS guy who must pull Oracle data from the back-end DB.
SAS stores dates internally as elapsed days since Jan 1, 1960. If I
The only privilege you can grant to yourself :
GRANT RTFM TO user [WITH GRANT OPTION];
Igor Neyman wrote:
Mladen,
Any privileges required to view this table, or just common sense? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Friday,
Hi,
The bug I saw on the course was 3194895, but I am not able to see this one
Myself with my account, maybe some internal use only, but take a look at
Docs 3156574 or 2790318 this looks similar
The teacher also mentioned a patch to lift the 1GB pga limit to 5Gb
But I am not able to find this
Harry,
Look at the to_char function in Oracle. It will convert a date field to
*any* format you want.
for example:
select to_char(date_field,'mm/dd/ hh24miss') will return a date in the
format as noted. You have about as many options as you probably need. You
can combine as many format
Title: Message
Mauricio:
Is
job_queue_processes set to a value higher than 0?
Did
you commit after submitting the job?
John R. Johnson Anheuser-Busch Companies Server Technology and DBA Services Oracle Database
Administration
-Original Message-From:
Michael Fontana [mailto:[EMAIL
Do you
have 4 jobs currently running? Maybe you need more
processes.
John
-Original Message-From: Mauricio "Vélez
[mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004
11:04 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Jobs are not working
I issued commit
Comment in-line
On 01/23/2004 11:29:25 AM, dba1 mcc wrote:
I tried to create tablespace with 16K (default on my
init.ora blocksize =8k). I have error happen. The
database version is 9.2.0.4.
SQL create tablespace index1 logging datafile
'/u0/oradata/leg92/index1.dbf' size 20m
2 blocksize
i heard tom kyte speak in december. He said first quarter 2004 for solaris.
most people seem to still be on 8i. We have both 8i and 9i instance here. It will
probably be a year before many employers are using it anywy.
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2004/01/23 Fri PM 03:24:45
I contined testing with pl/sql testprogram and found some interesting prove
about this 1 gb limit for pga with pat set.
All tests are done on hpux11.11 9.2.0.4
Testprogram
create or replace procedure testarray( psize number ) as
begin
declare
TYPE nAllotment_tabtypIS TABLE OF number
Folks:
From what I gather, Oracle stores dates as the number of elapsed days since
Jan 1, 1968. When I query a column of type 'DATE', it returns me the
default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD')
etc... to define many output formats.
What can I do to get the raw
Folks:
From what I gather, Oracle stores dates as the number of elapsed days since
Jan 1, 1968. When I query a column of type 'DATE', it returns me the
default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD')
etc... to define many output formats.
What can I do to get the raw
Raj,
I am no X$ expert either, but X$KGLOB is exposed to us lowly DBAs as
V$DB_OBJECT_CACHE and KGLHDEXC is actually the EXECUTIONS column.
Prasada, you can check V$DB_OBJECT_CACHE for TYPE in ('PACKAGE','PACKAGE
BODY') and KEPT = 'NO' and keep pinning these using DBMS_POOL.KEEP via a
scheduled
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04
databases. We are planning on upgrading our 8i databases this year. The
rate we are going it probably will be two years before we get to 10g.
Sandra
-Original Message-
Sent: Friday, January 23, 2004 5:39 PM
To:
Life is much easier, just use audit execute on proc name
No need for the x$tables :)
Regards,
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 11:19 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Is there anyway to find out from data
On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote:
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04
databases. We are planning on upgrading our 8i databases this year.
The
rate we are going it probably will be two years before we get to 10g.
Sandra
That would be a very
1 - 100 of 104 matches
Mail list logo