Dear all,
I have a text file of 70 rows. After
usingsql*loader to load it into my table, I select * from my table it only
show 802 rows.
Some people told me that's because of buffer. Who
would like to show me how I ought to do? Thanks you and sorry for my bad
english.
BaoDuy
Yes..you might need to set the buffer to some more
higher ?? but did you check on your log file or is there any bad file produce
??
They
might be data error while loading it..
-Original Message-From: Ngo BaDu
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:50
PMTo:
Hi
You have corrupted oracle blocks. You can run dbverify to check your
datafiles if you have more. To solve this one you could simply drop the
index and recreate it later. Oracle will no longer use that block marked as
corrupted.
Make sure you check the state of your harddrive.
Jack
Title: RE: Different behavior of Too_many_rows exception in pl/sql betwe
if you are looking for one row only, then A and C will do. Since C involves a little bit of more coding and A does the same thing, A would be a better choice. But if you are coding to trap too many rows, then you should
I like Amsterdam a lot, but I think Boston is still my favorite city :0)
Met vriendelijke groet,
g
-Original Message-
Sent: Thursday, June 21, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Sounds like I'm working in one of the more relaxed countries of the
world,
with a low
Hi Ravindra,
Bein in the same situation like you a few months ago I manage to figure out 2
solutions at your problem:
1. There is a nice Excel add-in called SecondWind which is able to perform
export operations from Oracle to Excel in a very nice manner and formatted in
the way which you
Hi
Would external procedures be a way of doing this if bitand didn't exist ?
Just that there is a lot of very cool C code out there.
Have RTFM, but I'm a C compiler dunce and cc turned out to stand for
completely confused :-)
Has anyone managed to use external procedures ? Is it hard to do ?
Check your bad file and your error log file for sqlldr it should explain
what happend.
Ngo BaDu
Ngo BaDu wrote:
Dear all,
I have a text file of 70 rows. After using sql*loader to load it
into my table, I select * from my table it only show 802 rows.
Some people told me that's because of buffer.
Rubbish.
Who would like to show
me how I ought to do? Thanks you and sorry for my
Hi Jeremiah Wilton,
just visited your site and read
Hot backup mode explained
that is mindboggling
oops
thanks a lot for this
got some more stuff like this
you will do good if you can enlighten me
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of
On Fri, Jun 22, 2001 at 12:45:34AM -0800, Amar Kumar Padhi wrote:
if you are looking for one row only, then A and C will do. Since C involves
a little bit of more coding and A does the same thing, A would be a better
choice. But if you are coding to trap too many rows, then you should check
What did your log say.
How many records in your bad file?
Jack
Ngo BaDu
Title: RE: Auditing
Hi Norrell,
I just tested ur case.
Can you tell me, how it's possible , when doing auditing, oracle will refer to the sys.aud$ table itself, correct?.
If i droped it (even there is a synonym on that name),
Oracle giving an error, it's not able to find the
db: 8i
front-end: forms
6i
server: sun os
5.7
We have a
requirement to store and display images in forms 6i. We are in the process of
evaluating the use of bfile datatype, do let me know about the limitations if
any.
1. Is it
mandatory to have the image
db:
8i
front-end: forms
6i
server: sun os
5.7
We have a
requirement to store and display images in forms 6i. We are in the process of
evaluating the use of bfile datatype, do let me know about the limitations if
any.
1. Is it
mandatory to have the image
Hi BaoDuy,
Yup I understand your problem, you can check your sqlloader control file
under what Ravinder said bad file,
Your table constraints reject your bad data because you use conventional
path,
if you use direct path bad data also will inserted into your table but your
contraints will be
you need to get rh 7.1 whic is kernel 2.4 and run theupgrade, its pretty
easy anymore, it even tells you if u dont have enough space.
email me at [EMAIL PROTECTED] a telephone number(assuming you're in
the US) and we can talk if you want.
making it happen on RH since its not certified was not
Hi
I heard, that there is a OLE2 package in Forms 6, which has capability to
create Excel file from blocks on forms.
Below is an example that one guy sent me about this issue... Hope it helps -
check the package in forms.
CREATE or REPLACE FORCE PROCEDURE export_transaction_to_excel IS
Title: RE: Auditing
why don't u create a separate tablespace for
containing the audit information.
it depends on ur requirements what level of
auditing u want.
and also what diff info u want to
store.
create a separate tablespace and create the aud$
table in it by selecting from sys.aud$.
Title: RE: Auditing
Hi
all,
In
what follows is the oracle documentation for auding by
triggers:
Auditing Through Database Triggers
You
can use triggers to supplement the built-in auditing features of ORACLE.
Although you can write triggers to record information similar to that recorded
Laura,
Attached is a script that does the job reasonably well.
But I would suggest that you go to www.toadsoft.com and download their
latest free version of Toad. It has a very good schema compare function
that will provide you with a list of differences.
You will need a database link to
All,
My current application (still under development) is experiencing Oracle
deadlock problems. The applications people are performing stress testing
where the application is being repeatedly called simulating actual users
hitting the database.
The application is written using VB thru ADO and
Raymond,
You asked why you could delete the records in a procedure, but not truncate
the table. A delete command is a DML command, while a truncate table
command is DDL. There is a distinct difference between these two types of
commands. DDL commands (Data Definition Language) are used to
I am using external stored procedures (C/C++), mostly to execute OS commands
from PL/SQL code.
Pretty straightforward (following docs), works fine. Should be accurate
mapping C-types to PL/SQL types.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message
We have the following situation here. On an AIX SP I need to connect
from one SP node (that just has the Oracle client) to another SP node
(that has the Oracle database). There are actually three IP addresses I
can put in the client's tnsnames.ora; one that uses the normal
backbone, one that
On Thu, 21 Jun 2001,Raymond Lee Meng Hong scribbled on the wall in glitter...:
-Is this command avaiable in Oracle 7 ???
-I got this error in TOAD.
nope it's an 8ism. for 7 you need to use the dbms_sql package.
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL
On Thu, Jun 21, 2001 at 03:15:36PM -0800, George Schlossnagle wrote:
And to get their values:
select KSPPINM, KSPPSTVL ,KSPPDESC
from sys.x_$ksppi ksppi, sys.x_$ksppcv ksppcv
where substr(KSPPINM,1,1) ='_' and ksppi.indx = ksppcv.indx;
sys.x$ksppcv
Here is a script that will list all of the undocumented parameters. I got
is from one of the lists.
select KSPPINM,
nvl(KSPPSTVL,'NULL'),
KSPPDESC
from x$ksppi x, x$ksppcv y
where x.INDX = y.INDX
and translate(KSPPINM,'_','#') like '#%'
order by KSPPINM;
HTH,
Ruth
- Original Message -
I get an error
There was an error displaying this link.
when I tried to view it.
Terry
Charles Wolfe wrote:
Red
Hat to play in Oracle's arena
June 19, 2001, 5:50 p.m. PT
http://news.cnet.com/news/0-1003-200-6325676.html?tag=st.ne.1003.saslnk.saseml
The Linux seller will announce new
database
Tom,
You should have 2 of these traces, one for each process involved. In this
case, the processes are 22, 18 and 24, 27. If you run them through tkprof,
they will be more readable, but the information is there. You need to look up
the table, based on the resource id that was given under
Title: RE: Clusters and IOT's
Thanks to all those who replied. I can see using IOT's but I don't find much practicality in clusters. Later everyone. Have a great weekend. Ivan
Hi
Your deadlock problem seems to be related to distributed transactions since your processes are holding and waiting for DX type locks. DX enqueues are taken for distributed queries. Do you have queries accessing the remote tables over the database links ?
As far as I know, even queries
Sorry, it looks like ADDRESS LIST does work. It is just that it takes
about 2 minutes before it recognizes that the first one failed before it
tries the second one. Any ideas how to speed that up. I am assuming it
is some kind of timeout feature dealing with Pinging an IP address;
(maybe at
Hi Danisment Gazi Unal,
Itprof's suggestion is valid that I should be able to
use an index to speed up this query.
But my objective here is to help sorting. Many users
write adhoc queries to into my warehouse and all are
not going to be tuned queries. Many go for full
tablescans on some big
Title: RE: How to do a bitwise OR from SQL*Plus
Hi neyman,
Thank god, i had a requirement to transfer data files from ftp server to oracle directory, and then am processing it...
Can you tell me method, how to write the external stored procedures and call from pl/sql.
thanks in advance.
In urder to TRUNCATE a table you have to have ge granted DELETE ANY TABLE. A very
dangerous situation.
ROR mª¿ªm
-Original Message-
Sent: Thursday, June 21, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
Hello guru , how can I execute a truncate table in PL/SQL ?? It only
i think i've been there and done that(Kevin T u know what i'm
talking about),
Question, do you have bitmap indexes on the tables being
updated? if so, then thats your culprit.
joe
[EMAIL PROTECTED] 06/22/01 09:35AM
All,My current application (still under development) is
experiencing
System : Sun E10K
OS : Sun solaris 2.8
Oracle : 8i Rel 3 64bit option
Database : OPS
Type : OLTP
# concurrent users : 1000 (including US and international users Europe, Asia
Australia)
Our System admin suggesting us to go for File system (veritas, without
Veritas quick i/o) instead of raw
This
should work now.
http://news.cnet.com/news/0-1003-200-6325676.html?tag=st.ne.1003.saslnk.saseml
Is it
8.1.6.3?? It had lots of deadlock problems.
[EMAIL PROTECTED] 6/22/01 9:35:56 AM All,My
current application (still under development) is experiencing Oracledeadlock
problems. The applications people are performing stress testingwhere
the application is being repeatedly called
I am starting to think that it is a memory leak, it's just to huge to be
anything else. I will calculate the size of the tables, that will be the
best sign of whats happening.
Interesting point, which I am sure everyone knows already, is that Oracle
does not let NT manage VM, it takes
You can also use ^L^M to get a line break and return in your prompt. You
will need to press ^V (ctrl and V at the same time), then press the L or
M key.
--Michael
-Original Message-
Sent: Thursday, June 21, 2001 5:03 PM
To: Multiple recipients of list ORACLE-L
The sequence number is
Taking a look at these parameters, I notice that the first two relate to a
NUMA POOL? What is this? If anyone has read any of Clive Custlers novels -
they would think National Underwater Marine Agency :)
Any insight oh list gurus?
Cheers
Mark
-Original Message-
Gramolini
Sent:
Tom,
Thank you very much for the script and the toad
suggestion. I really appreciate your time, both the
script and Toad will come in handy.
Laura.
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
Laura,
Attached is a script that does the job reasonably
well.
But I would suggest
The DX resource is a new one on memaybe i just
haven't had coffee yetare you, by chance, in a
distributed database environment? are links involved?
-Original Message-
Sent: Friday, June 22, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
All,
My current application
Tom,
The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:
Rows waited on:
Session 27: no row
No row indicates that the deadlock is due to a lack
of available ITL slots in the datablock.
Unfortunately resolving this
Hi all
We are running oracle 8.1.6 on DYNIX 4.4.7.
CUrrently the BUFPCT is set to 25 and during this
weekend will be increased to 30. I'd like to be
able to check whether this affects oracle in any way.
What statistics should I be looking at? I was thinking
of using a vmstat (to check of
doesnt look too promising for RH to "certify" oracle running
on it.
Such is the life of a hacker(in the good way, not a cracker),
making stuff run on unsupported platforms :)
joe
[EMAIL PROTECTED] 06/22/01 11:05AM
This
should work now.
- run iostat -xtc to monitor disks while benchmark is running. svc time
will
show any i/o bottle necks.
Qs. - In iostat -xtc , Any VALUE of svc_t which if occurs can be Taken
as Abnormally High ?
- Try configuring multiple database writers. (Rule of thumb is 1 per
cpu)
Qs. - Since
It
does work, but izzit anything more than vaporware?
Is
there any reason for "more" open source db ware? Why not
perk
up MySQL or Interbase?
I
don't get tingles from this, actually
-Original Message-From: Wolfe, Charles
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22,
Good point on discussion material, but not having a place to
test it is not. You can get darn near every piece of software to use with
a one user dev license to use to your heart's content, hence the reason i'm
using 9i right now, i'd never put anything on it in production but i at least
Title: RE: How to do a bitwise OR from SQL*Plus
Here is simple function, that I pu into dll (it's on
NT):
extern "C" void __declspec(dllexport) os_cmd(char *cmd_string,
short cmd_string_indicator,
short cmd_string_length,
int e_mode,
short e_mode_indicator,
int *ret_val)
{
int exec_mode;
I like that idea Ross, maybe I'll just bring all of you DBA geniouses in and
you guys can corner him with a hot cattle prod:)
Thanks again for all of your help Rossinater!
Kev
-Original Message-
Sent: Thursday, June 21, 2001 6:54 PM
To: Multiple recipients of list ORACLE-L
yea,
Where is the fun in that? To quote a previous coworker Any clod can have
facts, but having an opinion is an art. Besides, you missed the two key
words of the question: and why? I was hoping to spark a nice extended
discussion on the inner workings of Oracle that everyone could enjoy while
1) use sar on SVR4 systemsvmstat is a BSD thing
2) DYNIX rocks
3) IMHO yer BUFPCT is too high. If this is a dedicated
database server ( i.e. no other apps on it ) and
you are using ptx's DirectIO ( check with yer SA,
or run truss on a shadow ) you really don't need
I know you're joking, but...NonUniformMemoryAccess.
kind of a shared everything cluster variant, originally
fielded by Sequent...now IBM and HP i think.
And...i think the new GS-series Compaq Wildfire crap has
some kind of NUMA sauce.
-Original Message-
Sent: Friday, June 22, 2001
Thanks Ray
-Original Message-
Sent: Friday, June 22, 2001 8:41 AM
To: Multiple recipients of list ORACLE-L
On Thu, Jun 21, 2001 at 03:15:36PM -0800, George Schlossnagle wrote:
And to get their values:
select KSPPINM, KSPPSTVL ,KSPPDESC
from sys.x_$ksppi
Non Uniform Memory Access (aka, Sequent machines? NUMA-Q?) Check O'Reilly's
website, they have an excerpt from Oracle Parallel Processing:
Non Uniform Memory Access systems Non Uniform Memory Access (NUMA) systems
consist of several SMP systems that are interconnected in order to form a
larger
Ross, it's not that votes don't count, it's that most of the people don't
know how to follow instructions or ask for help! Besides, it's not the
first election where something like that happened:)
Kev
-Original Message-
Sent: Thursday, June 21, 2001 11:25 PM
To: Multiple recipients of
I run script in the background which contain export command. If userid wrong
it give me message that job stopped
(bash). Process is stopped and I can see it using ps command. Apparently it
waits that username be entered interactively. I need automatically to
terminate the process and print
Hi,
did some one have locking problems with Oracle 8.1.7 EE? A Forms
application, that ran for more than a year day and night, with 10-60
concurent user. It worked fine with oracle 8.1.6. SE. Since the upgrade to
8.1.7. we hade some repeatedly occuring locking problem, though could not
Does anyone have a handy function for calculating the Median of data ??
It
seems like it should be simple ...but
Kevin,
Maybe not as simple as you think. :)
Here's an example in SQL. You may want to dig through the
archives, as this was discussed at some lenght a few months
ago.
Ross
Oracle : 8.0.5
Platform : Sun
Currently we have cron job every night (starting from 11pm) to do export. I
changed the setting direct to y two days ago while leaving all other
parameters unchanged, hoping to gain some performance. I am a bit surprused
to find that it did not. It actually took
Waleed;
Well, I am afraid, its not going to be this simple on my version of
Oracle, 8.0.5. Apparently, you can not do an order by in the from
statement on this version so I can not get the crucial order of the data.
Thanks anyway. I may have to resort to an pl/sql function.
-Original
Khedr;
That was the kind of thing I was looking for. A simple select
(relatively) that can be added to another data select that I have for a
report I am producing for a client.
Thanks
And thanks to all that answered !
Kevin
-Original Message-
Sent: Thursday, June 21, 2001 7:01 PM
Taking a look at these parameters, I notice that the first two relate to
a
NUMA POOL? What is this? If anyone has read any of Clive Custlers
novels -
they would think National Underwater Marine Agency :)
Mark,
NUMA is a shared memory bus architecture for Intel chips, it's been
around for
Hi,
is it possible to run DBA*Studio 8.1.7 on the Web through a browser?
Thanks in advance.
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
wow. great post.
-Original Message-
Sent: Friday, June 22, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Tom,
The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:
Rows waited on:
Session 27: no
Has anyone managed to use external procedures ? Is it hard to do ?
What's
the stability ? And performance ?
Greg,
I wrote an article on encryption that may be of some use. It uses external
procedures
and includes information on setting it up.
Like many things Oracle, it's much easier to
Hello Johnson,
There are great papers at
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/
But, I still disagree with you. Becasue, tuning SORT will not make benefit
in your case.
yes, you are right, it's not easy to generate good SQL if SQL is generated
by end-users. I don't know your
On Fri, Jun 22, 2001 at 08:11:03AM -0800, Kevin wrote:
Ross, it's not that votes don't count, it's that most of the people don't
know how to follow instructions or ask for help! Besides, it's not the
first election where something like that happened:)
Kev
-Original Message-
Sent:
Just to clearfy my previous question (as follow):
if 1 has F and A and B, that what I want.
If 1 has F all the time, that's not what I want.
If 1 has A, B, C, but never F, that's not what I want
either.
--- Leslie Lu [EMAIL PROTECTED] wrote:
Hi,
If I have this:
Customer_id Status
Hi,
If I have this:
Customer_id Status
-- ---
1 F
1 A
1 B
2 F
2 F
3 A
3 B
How do I found out a customer who has both F and not F
for them. (If he only gets F, or gets other than F,
that's fine). In this
Hi Anita
If it is an ITL problem, then the resource type would be TX instead of DX. If the ITL table is full then the process requesting an ITL entry in that block will randomly select one of the transaction holding an ITL entry and wait for that process to complete or rollback. Since the
FWIR, recerate the table as user sys but specify a different tablespace. Does not
require synonyms,
views, act of vodoo, etc.
Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Karaoke- Japanese for migraine.
Hi Leslie,
This will be crude but it's a start. Gang, feel free to correct/improve:
select customer_id
from table_name
where
customer_id in (select customer_id from table_name where status = 'F')
and
customer_id in (select customer_id from table_name where status = 'A')
and
customer_id in
SELECT *
FROM customer c1
WHERE status = 'F'
AND EXISTS (SELECT 1
FROM customer c2
WHERE c2.customer_id = c1.customer_id
AND c2.status != 'F');
-Original Message-
Sent: Friday, June 22, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Just to clearfy
A developer is struggling with a temporary table issue. He created a
session specific temporary table, and is executing two procedures from the
web server. The first procedure populates the temporary table, but the
second procedure does not see that data. He has worked with another DBA,
they
DUHHH!! Now why didn't I think of that!! Having had to deal with installs of
our products on a couple of NUMA-Qs it should have sprung to mind - Guess
I'm still in holiday mode - or coffee deprived (I suspect both :)
Having said that - I still didn't know what NUMA stood for - Thanks for the
Brijesh
There are few conditions where the optimizer will select CBO even when the optimizer_mode is set to rule. Do you have any objects in the schema with a parallelism 1 (tables and indexes) ? One of the common problem is that DBAs rebuild the index with higher parallelism and forget to
Is 'F' the largest value? If so, then:
SELECT
customer_id
FROM
(
SELECT customer_id
, SUM(DECODE(status,'F',1,0)) stat_f
, SUM(DECODE(status,'F',0,1)) stat_no_f
FROM my_table
:-)
Yes! And anything you have, i'll be glad to try!
-Original Message-
Sent: Friday, June 22, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L
Ross have you stopped taking your medication again :)
Dave
Ross Mohan wrote
Snip
a) I *like* NT, actually.
Snip
--
Ray, have you been not inhaling again?
;-)
-Original Message-
Sent: Friday, June 22, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
On Fri, Jun 22, 2001 at 08:11:03AM -0800, Kevin wrote:
Ross, it's not that votes don't count, it's that most of the people don't
know how to
Here is one way:
select distinct customer_id c1 where exists
(select 'X' from customer_id where customer_id = c1.customer_id and status
= 'F')
and exists
(select 'X' from customer_id where customer_id = c1.customer_id and status
'F')
At 10:05 AM 6/22/01 -0800, you wrote:
Just to clearfy my
Yes. You can enable OEM through the web and DBA Studio comes along with
it. That is what I do to maintain all our databases. I am using OEM 2.2
which has HTTP server bundled in the OEM CD. The same can be done with OEM
2.1, but you may have to configure your existing APACHE... webserver to
work
I thought that DIRECT=Y was for imports only. It makes since because in the import you
are placing the data directly into the blocks with out a redo log.
I have no idea why there was a difference in the times unless it was the extra
overhead for a command that was not used.
ROR mª¿ªm
[EMAIL
How about:
select f.customer_id
from table_name f, table_name a, table_name.b
where f.customer_id = a.customer_id and
f.customer_id = b.customer_id and
a.customer_id = b.customer_id and
f.status = 'F' and
a.status = 'A' and
b.status = 'B';
Much cleaner than the one
FWIR, if there is a tie between two indexes, oracle will use the index that was
created/recreated
most recently.
Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Karaoke: Japanese for migraine
Is this what you are trying to do?
select a.customer_id
from table a, table b
where a.customer_id = b.customer_id
and a.status = 'F'
and b.status 'F'
Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Karaoke: Japanese for migraine
Bala
I don't see any responses. So, please ignore if this is already answered.
First of all, In Sun, you have to use RAW for an Oracle Parallel Server database. (I am not sure whether you can use Veritas Quick I/O to configure OPS, my guess would be no). Second, if it is a performance
Ron,
ok i'm now confused,
exp direct=n|y
imp no such option
sql_loader has direct also.
or am i missing something here?
joe
[EMAIL PROTECTED] 06/22/01 03:00PM
I thought that DIRECT=Y was for imports only. It makes since
because in the import you are placing the data directly into the
Ross,
I'm not sure why it is being done. We had an audit of
our systems done by IBM people and that's one of their
recommendations. I think their logic is you hit ratio
is pretty high - 99% - so you can do with less
memory.
This server is not a dedicated Oracle server, we are
running another
i dont think thats a valid statement anymore, "but the administration overhead you will face
is negligible compared to the performance boost you can achieve.
"
You said it has been a few years
since then, have you tried any of the "new" type filesystems,
recently?
joe
[EMAIL PROTECTED]
Anita
Riyaj,
Thanks
for the replies. My email server "went away" for awhile, so I am just
getting your replies now.
Anita,
I am able to modify INITRANS for the tables (I tried this on a test table), and
I will try this. Right now, we are performing other stress tests to narrow
down the
8.1.5 has some known performance problems, but 8.1.6 resolved them.
I always run timed_statistics = true.
There is a slow down of .1-5% depending on who you talk to, I don't think it
is much more than 1%.
Walking on water and developing software from a specification are easy if
both are
I dunno. Does the BUFFER still
matter when DIRECT=Y?
If so, I either remove it
entirely, or multiply it by about a factor of five or so.
my $0.02
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43
PMTo: Multiple recipients of list
Dear DBA's:
Have any of you come across this bizzare behavior? We have an application
that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on
an 8i database.
A user has been granted access through a role. This role APP_READ only has
select privileges on all the tables for the
When you have timed statistics on all your doing is when oracle acquires a
resource it stores the time, then it is done, it stores a time. This is
very low resource task, even compared to many of the smallest transactions.
Most transactions outweigh the time to do this by 100 - 1000 fold or
hi,
does any body know when forms 3.0 is released. Does any body have forms history of
releases
Thanks
Deen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deen Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
On Fri, 22 Jun 2001,Krishnan, Manjula R. scribbled on the wall in glitter...:
-Dear DBA's:
-
-Have any of you come across this bizzare behavior? We have an application
-that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on
-an 8i database.
-
-A user has been granted access
1 - 100 of 153 matches
Mail list logo