What are you trying to get? Column values or (TABLE,COLUMN)
combination? You could probably use a function like this:
create or replace function trickery(T varchar2,C varchar2, V number)
return number deterministic
as
qry varchar2(2048);
cnt number:=0;
begin
qry='select count(*) from '||T||' where
i hv to write an sql query in which i hv to fetch all the tables frm the
database having a column say EMPNO and where the value of this empno column
is say 9 and this should be thru a single sql query
is this possible ?
Thanks and Regds,
Rohan
__
Mark - Thanks for the correction. When I looked at what I said about the transaction
before a DDL command a second time, I myself wondered if I'd gotten it right. If
you've tested it, and the transaction is always committed, I'll take your word for it.
Arup - I don't normally use Oracle's buil
Perhaps I got it wrong, but, John - are you saying that the entries are part
of the rollback, i.e. if the transaction that caused the audit trail entries
to be created is rolled back, the audit trail enries are rolled back as
well?
The auditing entry is NOT part of the transaction, it's created vi
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 coura
Life is much easier, just use "audit execute on "
No need for the x$ :)
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 dictionary views
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: Multip
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
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 in
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 in
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
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
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 blocksi
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 an
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:[EMA
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 an
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 also
The only privilege you can grant to yourself :
GRANT RTFM TO [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: Fr
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
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."
[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:
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
> -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?
http://w
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 Fr
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 PROTECTE
Thanks for your input, Naveen. But, It is hard to do that since everything
is under Production Support Team control.
Best Regards,
Prasad
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 da
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 lis
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 - to_date
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 (
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 DOC
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".
-> -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. thunder
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)
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,
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
dat
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 backup,
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 each:
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
-
--
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 th
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 R
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 er
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
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 ga
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
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
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 Di
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 PROT
The Jobs are not broken
I haven't resolve this yet, all jobs work fine on one database but on 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 Mes
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 transactional
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 comm
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:
Vi
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
informa
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.
<[E
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 utili
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 tablespac
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,
Mauri
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 / -mt
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
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 table
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,
Mauricio Vélez
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
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
P
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 sor
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 query’s
result set? If so, then you’ll eliminate 87,629 database calls.
As Tom Kyte says, “Tune the
QUESTION, not the query.”
Cary Millsap
Hotsos Enterp
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 reci
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 cha
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 tran
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 ORACLE
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
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
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."
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
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
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 chan
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?
Mauric
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 to disable this "feature":
Navigate to the Tools->Options
menu
Cl
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,
ju
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 Ti
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
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
Its
easy to disable 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
-Or
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
Bill
The line breaks get
removed from *incoming* mail, so I don't think it matters what 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 automaticall
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
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. An
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 fil
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 removing line breaks an
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 decreasi
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: http://www.oraf
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 h
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]
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
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
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.
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
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
know which files/directories are growing.
Is there any way
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
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: [EMAIL
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
1 - 100 of 104 matches
Mail list logo
