What when both are gone?
IMH opinion, C++/Assembly would probably stay and be in demand. Within c++
probably text based would go earlier than GUI based. To my understanding,
you can code for both in GUI.
Aleem
-Original Message-
Sent: Wednesday, February 13, 2002 6:43 AM
To: Mult
HI Mandal ,
My recomendation is for this book :
Oracle8 to Oraxcle8i upgrade
for Robert G. Freeman , Charles A. Pack
Regards
Gholam
---
> ---
Yea, was not sure but not enough to check :-)
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel
> Carmichael
> Sent: Tuesday, February 12, 2002 7:23 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: optimizer_mode/optimiz
Remco is right: the last predicate in the subquery should be "=" instead of "<>" as we
want to EXCLUDE those ones using the NOT EXISTS. In fact, I think that query will
always return no rows, as the first part is asking for those with searchvalue =
'first one', but not those with no searchval
Get both.
On Tuesday 12 February 2002 07:33, you wrote:
> Hi,
>
> I have just given my oracle 9i upgrade exam. I was
> wondering which certification is best for me next -
> Sun Solaris administration or JAVA certification ?
> I have a 6+ years of Oracle, 4 years of Solaris
> experience and 6 mont
Dear all,
Which FORTRAN version are supported on Oracle 8i? Which one is best
among them?
thanks in advance,
Ahmadsyah Alghozi Nugroho
~ Holly ~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ahmadsyah Alghozi Nugroho
INET: [EMAIL PROTECTED]
Fat City Network Ser
Rob,
I've faced a slightly similar scenario. The main difference being, I didn't
go from a SUN box to a HP box. Instead, it was from one SUN box to another
SUN box. The binaries were installed on the other server and the EMC disks
connected (if that is the right word) to the server. Everything wo
optimizer_mode is a parameter in the init.ora
optimizer_goal is a parameter for the alter session command.
you had them reversed
--- Alex Hillman <[EMAIL PROTECTED]> wrote:
> OPTIMIZER_GOAL is a parameter in init.ora and determines systemwide
> optimizer usage. OPTIMIZER_MODE is parameter in a
I think he's catching on !!!
-Original Message-
Rowski
Sent: Tuesday, February 12, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
I don't want to go for Oracle Masters because of the
compulsory training from Oracle. Why should I spend
big money on training when I have real worl
Java will go a lot sooner
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Jason Rowski [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 4:03 PM
> To: Multiple rec
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi
everybody,
Finally it worked for me.
Thanks
for all your help.
Ashoke
-Original Message-From: orantdba
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 1:02
PMTo: Multiple recipients of
Why would you need coalesce at all?. My understanding that if Oracle cannot
find contiguous free space it try coalesce itself.
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohammad
> Rafiq
> Sent: Tuesday, February 12, 2002 4:53 PM
>
Is there any book for Oracle 8i upgrade
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / M
OPTIMIZER_GOAL is a parameter in init.ora and determines systemwide
optimizer usage. OPTIMIZER_MODE is parameter in alter session command and
determines optimizer used by that session.
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [E
I think Solaris is going to go away soon as it is
going replaced by Linux.The reasons are :
1) Linux is backed by all the major vendors like IBM,
HP, SGI etc. ( even SUN was pressured into offering
Linux on sparc on low end servers).
2) Running Linux is cheap because of the all open
source softw
FYI:
It's available on Metastink and supposedly fixes a lo-o-o-o-o-ta
bugs!
Best,
Sergey Babich
Title: Oracle Advanced Security on Server - Mandatory encryption
I am primarily interested in encryption, not authentication.
I understand that placing the following lines in a client's sqlnet.ora file to REQUIRE encryption to/from the server is:
SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER = MD5
SQLNE
I don't want to go for Oracle Masters because of the
compulsory training from Oracle. Why should I spend
big money on training when I have real world
experience.
Thanks
Jason
--- Joe Raube <[EMAIL PROTECTED]> wrote:
> It depends on which way you want your career path to
> go...
>
> administr
Good point.
-Original Message-
Sent: Tuesday, February 12, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L
Fred,
I'll respond this way. The odma makes its selection on the database to
upgrade based on those available from oratab (with the old database
$ORACLE_HOME). Also the odm
Hi
I used the book 'Oracle 9i : New features' by Robert
Freeman. I had made extensive notes on Oracle 9i new
features from Oracle 9i manuals also. If you are
interested , I can post it online.
The exam is at the same level as Oracle 8i upgrade
exam.
Thanks
Jason
--- Mohammad Rafiq <[EMAIL PR
Jerry,
Thanks for sharing script. We might have better systems as timing was never
be a issue. I just tested my script on 2 systems and it ran between 34.5
mseconds to 4.65 seconds...and on the basis of it is results we coalesce all
such tablespaces. I prefer to keep pctincrease of tablespaces
Hi List,
How can I run a store procedure inside a function?
I have a store procedure to do some DML, and we can not run it from our
application for some sort of limitation, only we can call function from
application side, Is there any way to run this store procedure inside a
function or some thin
Rafiq,
While your script provides a lot of good information, it sure is slow on my system. It
took 1:44 minutes while my script below took 420 mseconds. I was really surprised as
my script has a self-join. Then I checked out dba_free_space_coalesced. It sure is
complicated as it calls on two o
Alexander,
Your example below is very helpful, and explains why I
recalled that duplicating date elements was possible. I
probably used TO_CHAR to test this in the past, while the
other day I was using ALTER SESSION.
My theory on why you can't duplicate elements when setting
NLS_DATE_FORMAT is t
Title: RE: Re[4]: Date format element rule change
Jonathan,
You are right.
From FM:
For input format models, format items cannot appear twice,
and format items that represent similar information cannot be combined.
For example, you cannot use 'S' and 'BC' in the same format string.
And
In the $ORACLE_BASE/oraInventory/logs directory look for ' Patch' string in
the installActions*.log files.
You may find it there... Then you can view that install log file for more
info.
If those log files aren't there, then you are left with the Oracle Installer
to tell you..
- Kirti
-O
Title: RE: parallel execution
While on the topic,
DEGREE VARCHAR2(10) The number of threads per instance for scanning the table
What is a difference between '1' and 'DEFAULT'?
SQL> select degree, count(*) from user_tables group by degree;
DEGREE COUNT(*)
-- --
Is there any Oracle file I can use Unix command "strings" to search for
version/patch info? I don't have x-window session.
James
> -Original Message-
> From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 3:02 PM
> To: Multiple recipients of list ORACLE-L
>
Hi Bob,
1. change the initializaion parameter audit_trail to be:
audit_trail=db
shutdown and restart database
2. connect to the database as a user that has the privilege "AUDIT SYSTEM"
audit session whenever not successful
at this point you can see these unsuccessful logins by monitoring the
d
Oracle does not seem to be listed, but you got to wonder what code
they based their snmp stuff on. You may want to nudge you sysadmin
in the ribs, also.
- Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
To: Ray Stell <[EMA
Load the Oracle Installer and click on Installed Products - will tell you
every patch installed by the Installer, which are all the major ones . . .
minor patches and one-off's that are installed via OS file copy will NOT
show up.
-bill
-Original Message-
Sent: Tue, February 12, 2002 2:0
I tried the steps on 8.1.7.0.0 on Solaris 2.7, and it worked fine. Trying it on
8.1.7.2.0 provided the erroneous(??) results, but only after the table was analyzed.
Has this been filed as a bug?
Brian
Scott Canaan wrote:
> It works fine in 8.1.6.0.0, Sun Solaris 2.6:
>
> SQL*Plus: Release 8.1
haven't done it, and I don't think it can be done... the datafiles,
while Oracle datafiles are still Unix OS files and you can't just copy
a file created on HP to Sun and expect it to work.
You'd have to export and import/rebuild the database
--- Robert Pegram <[EMAIL PROTECTED]> wrote:
> Has a
Or do like ORACLE says they are doing,
and Cluster Intel Based Machines with LINUX.
Then you can get rid of all those competing Hardware Vendors.
-Original Message-
Sent: Tuesday, February 12, 2002 13:39
To: Multiple recipients of list ORACLE-L
Stephane,
In the not so distant futur
There have been a few posts in the past claiming that copying datafiles from
HP to SUN and vice versa was okay.
However, I never received anyone's reply when I asked them how many
Production Databases they have transferred using this method.
Experimenting is fine but one can't run business on s
Hi DBAs,
I want to find out what Oracle patch installed.
Someone just installed Oracle817 binary on our server but no 817
instance setup yet, so can't query v$version.
Thanks
James
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Autho
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi all,
I have never done this particular activity but by following the clues given
in this
thread AND BY reading the documentation I was able to make this work. The
steps I followed were.
1. change the initializaion p
This is all covered in great detail in the 8.1.7 Migration Guide - Chapter 7
titled "Upgrading from a Previous Version 8 Release to the New Oracle8i
Release"
There is no need to install 8.0.5 on the target server.
Just load the cold backup files, adjust init.ora and follow the steps from
the g
We just recently migrated some production databases from 7.3.4 to 8.1.7.3 on
AIX. We have noticed that the amount of memory per dedicated server process
spiked from about 400k to 2m. Anybody have any ideas about why this occurs?
Is this normal? Thanks
--
Please see the official ORACLE-L FAQ:
White Plains, New York company is looking for a solid Oracle Developer/DBA
who also has Java, Informatica, and ETL programming skills for it's I.T. staff.
*Candidates who are not in the White Plains area must be willing to relocate
themselves and have the ability to relocate "quickly".
No relo
What is the difference between optimizet_mode and optimizer_goal parameters?
Are they being used interchangeably?
I've rtmf-ed. It is not clear.
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Fred,
I'll respond this way. The odma makes its selection on the database to
upgrade based on those available from oratab (with the old database
$ORACLE_HOME). Also the odma default execution will want to start that
database before it upgrades the datafiles. On top of that, I would want my
test
Thanks for the responses.
I thought exp/imp was the only way to go, but I feel
much more confident now. That was also Oracle's
response.
BTW, I think they have changed their thinking on this
issue anyway.
Thanks,
Robert Pegram - EDS
Oracle DBA
--- bill thater <[EMAIL PROTECTED]> wrote:
> [E
Fred,
I don't know how you can use the migration utility from one physical
machine to another. I used the export,import method when going across
platforms.
Build the new database on the new server to your desired specs and then
export the tables you want to move to the new database and import th
Stephane,
In the not so distant future, I think we might see a push to
accomplish just what Robert is asking. With the growth of the need for
speed and the decline in the economy, a lot of companies can not afford
to purchase new machines and discard to old. If I was a company that had
a few dif
To REMOVE yourself from th
is mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want
Why not try MINUS
Select x, y, z
>From tab
Where condition=1
Minus
Select x, y, z
>From tab
Where condition=2;
HTH,
Bambi.
-Original Message-
Sent: Tuesday, February 12, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L
Remco,
This is exactly what he wants - all records where the
Fred,
Read the Migration guide for 817.
If you want to take the chance of losing time, put your 805 db back on the
machine and try a migration. If you have never performed a migration, I
think you will either be incredibly lucky if it works ok, or you will be
back-tracking (delete all the files
Is your tablespace fragmented as it is not finding contingous extent ..
TRy to coalesce your subject tablespace and try...
you can use following script to check whether coalesing is required or not..
If percent is < 100 then coalesce it..
select substr(tablespace_name,1,10)TS_NAME,total_extents
This is definitely not a production db. I was just told by Oracle that it
is possible to migrate the 8.0.5 datafiles using 8.1.7 software. They say I
do not need to install 8.0.5 on the "new" server.
Finding instructions in a document covering this is not easy!
-fs
>From: [EMAIL PROTECTED]
>R
A quick question..What was the level of this upgarde test,in your opinion,
and what level of preparation is required..I am planning to appear it in
coming March/April 2002...for 9i OCP upgrade test.
Based on your experience for Solaris, it is better to have certification of
Solaris, IMH opinio
[EMAIL PROTECTED] wrote:
>Has anyone done the following:
>
>Create a db using Oracle Loaded on an HP Server
>- The datafiles, controlfiles, etc will be on EMC
>
>Later,
>Install the oracle binaries on a SUN Server, basically
>unplug the HP from the SYMM, and plug in the SUN and
>bring up th
So, why could you not do just what he is asking ?If you have all the
files of the database (Cold Backup of everything), why could you not install
the 8.1.7 code and then run the migration tool ? The installation of the
Oracle Binaries does not touch the database at all.
-Original Message
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
The
SQL reference has some information...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074
HTH
Tim
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTE
May be to find a certified job that keeps you busy!
-Original Message-
Sent: Tuesday, February 12, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have just given my oracle 9i upgrade exam. I was
wondering which certification is best for me next -
Sun Solaris administratio
[Robert Pegram]
> Create a db using Oracle Loaded on an HP Server
> - The datafiles, controlfiles, etc will be on EMC
>
> Later,
> Install the oracle binaries on a SUN Server, basically
> unplug the HP from the SYMM, and plug in the SUN and
> bring up the database.
What storage format? If
Solaris. Languages come and go (flavor of the month like java), but servers
will be there always.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Jason Rowski [SMTP:[EMAIL PROTEC
This is not a production database. It's just a reporting machine.
Which document are you referring to? The migration guide for 8.0.5 or for
8.1.7? The 8.1.7 guide does not mention a migration process for a
non-installed 8.0.5 software. Does this matter?
Much thanks,
-FS
>From: "Mercadante
Fred,
Don't waste your time installing 8.0.5 unless you plan to go back to it some
time in the future ("Back to the Future"?). Install 8.1.7 and patch to
8.1.7.2 (or higher).
Copy your datafiles to the new system. Make sure that you copy them to the
exact directory structure that existed previou
It depends on which way you want your career path to go...
administrator or developer?
it really depends on what you want to do.
Why not go for Oracle Master?? (big grin)
-Joe
--- Jason Rowski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have just given my oracle 9i upgrade exam. I was
> wonderin
Fred,
You can migrate your 805 to 817 directly. You really need to read the
migration documentation - it is pretty straight forward, and will answer all
your questions.
You will be doing a migration on a test database first, right? - not the
first time on a production database - right? You wil
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
To
track users who tried and logged into the database :
SQL
> audit session;
I
don't know in which section you can find that in the Administrator
Guide.
Rivaldi
-Original Message-From: Mandal, Ashoke
Not sure what you mean by DSD, but we provide a tool called the DataBee
DBATool, that reads an export file, and generates all of the DLL for the
objects within a schema, or the database on the whole (from a FULL export,
generated with the ROWS=N option). You can then either document the DDL
throug
Obviously this WAS not a production database.
If you were not aware that a new OS was being installed and that Oracle was
being wiped out then
step 1 Get a competent SA
I do not know UNIX but I would think you have to
re-install 8.0.5,
do backup
restore 8.0.5 datafiles,redo,controlfiles,etc.
Mod
Further to Waleed' response:
Field name called 'degree'. if > 1 then it invokes parallel process
according to degree level defined if 2 will start 2 processes subject to
maximum of parallel_max_servers defined in your init*.ora or in 8i depending
on your other parallel settings..
Followin
Title: Message
Any good tool to
reverse engineer a DSD either from a DDL or from a user that has full access
to the schema, but not requiring to be logged in as the schema
owner?
ERwin supports reverse engineering from DDL - http://www.cai.com/products/alm/erwin.htm
Hi,
I have just given my oracle 9i upgrade exam. I was
wondering which certification is best for me next -
Sun Solaris administration or JAVA certification ?
I have a 6+ years of Oracle, 4 years of Solaris
experience and 6 months JAVA experience.
What do the Oracle gurus at this list think ? Whi
Remco,
This is exactly what he wants - all records where the first one exists and
the second one does not exist.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, February 12, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L
Thomas,
"NOT EXISTS" an
Robert Pegram wrote:
>
> Has anyone done the following:
>
> Create a db using Oracle Loaded on an HP Server
> - The datafiles, controlfiles, etc will be on EMC
>
> Later,
> Install the oracle binaries on a SUN Server, basically
> unplug the HP from the SYMM, and plug in the SUN and
> bring
If they are using DBMS_ALERT then since it uses
dbms_lock, it could be possible that the locking
problem is one of the application's making (not the
database). I can't remember the specifics, but things
like a long gap between signalling the alert and the
subsequent commit rings a bell as a cause
Can anyone advise me on using the migration utility?
We are finally moving from 7.3.4 to 8.1.7. Has the
utility worked well for you? Known bugs? Any info
greatly appreciated.
THe history, if you want to know. We have been stuck
at 7.3.4 due to a lack of migration path for OPS on
SGI equipment. We
It does, Thanks! RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 9:44 AM
> Ruth,
>
> You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will
give
> you the number of parallel processes to use for the
My probem was, that Oracle Support still does not seem to be able to answer
with a simple 'yes' or 'no', wether I can user Oracle Lite as a readonly
snapshot site. The Oracle Lite documenation is only talking about EE as a
must, but our cutomer has only SE licence. I would need only one way
replic
Well, if you are not able to change CHAR to VARCHAR2, then you can't do
compression in Oracle.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflec
Thanks to everyone who helped me with this problem! Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet acces
Ruth,
If you are requesting info on parallel DML operations then you can
look at the V$PQ_STSSTAT, V_PQSESSTAT, V$PQ_TQSTAT views that show the
parallel executions are running in the database. Also the V$SESSION has
a column called PDML_ENABLED to display if parallel DML is enabled for
the sessio
All,
I would like to audit all the database users upon
logon failure.
I know that someone must have been implemented similar
kind of auditing. Could you please share your
information with me.
At the same time I did create new profile and assign
it to all the database users. This new profile wi
Title: White space compression in Oracle
Bjørn,
Aren't those semantics all host language based? I haven't been
working on Pro-X languages for a while, but I seem to recall that there were
language options (switches, directives) on how the comparisons were
done. Also, you could easily move t
Title: White space compression in Oracle
Note
VARCHAR and CHAR uses different comparison semantics. With CHAR the
shorter one is padded with spaces up to the same length as the longer one and a
byte by byte comparison is used. VARCHAR uses a none padded
method.
-Original Message
Title: Message
Any good tool to
reverse engineer a DSD either from a DDL or from a user that has full access to
the schema, but not requiring to be logged in as the schema
owner?
Michael Cupp, Jr.
Shonac
Corporation
4150 East Fifth
Avenue
Columbus Ohio
43219
Phone:
614-238-4240
Fa
Has anyone done the following:
Create a db using Oracle Loaded on an HP Server
- The datafiles, controlfiles, etc will be on EMC
Later,
Install the oracle binaries on a SUN Server, basically
unplug the HP from the SYMM, and plug in the SUN and
bring up the database.
I was asked this yeste
Here is a shell script I use in UNIX, restrict_and_kill. I included the sql
command to build the sql with the kill commands, killuser_build. It
excludes users with restricted session access and puts the database into
restricted session mode. You can modify these scripts to suit your needs.
HTH
How about DBA_TABLES where degree>1?
Best,
Sergey
-Original Message-
Sent: Tuesday, February 12, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
It there a view which tell which tables are in parallel?I would like to
see which table have parallel execution tu
Hello list,
I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old
8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of
the database. The SA then did a rebuild on the server to upgrade the OS to
SunOS 5.8. There is no Oracle software or data on the s
Hi,
you should not see for the degree if it is in the HINT,
you should see if is turned on for the instance ...
there are some parameters like parallel_max_server,...
Ciao
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 3
Hmmm...I've been executing this a script in TOAD, which seems to account for
some differences. The really wierd thing in TOAD is that the SELECT acually
WORKS CORRECTLY if I insert a COMMENT immediately after the ANALYZE
statement! Of course, comments don't make a lick of difference in this for
Ruth,
You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give
you the number of parallel processes to use for the table. It is also in
the USER_INDEXES/DBA_INDEXES view.
You can set this values by issuing an: Alter table {tablename} parallel 2;
Hope this helps
Tom Mercad
Sounds like you have run into the much annoying problem of missing
foreign key indexes. I would check that out first I think.
-Original Message-
Mascranghe
Sent: Tuesday, February 12, 2002 4:33 AM
To: Multiple recipients of list ORACLE-L
Hi all
We are running on 8.0.5.2.1 database. On
Thomas,
"NOT EXISTS" and "<>" equals "must be at least one"
Right ?
That's not what Zsolt wants ... :-)
-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql
Check the dba_tables there is a column name degree if it is not default ie 1
then parallel executions on that table is turned on
-Original Message-
Sent: Tuesday, February 12, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
It there a view which tell which table
dba_tables
-Original Message-
Sent: Tuesday, February 12, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
It there a view which tell which tables are in parallel?I would like to
see which table have parallel execution turned on.
Thanks is advance,
Ruth
--
Hi,
I am new to Oracle DB. There is a m/c where already Oracle 8.1.7.
I want to know the following info.
a. How to login into Oracle thru sqlplus
-how to know login and passwd?
b. How to see what are the Databases already created.
c. how to create a new Database
d. Is th
What is the PCTFREE setting for the tables? Hope it is not 0.
Here is the quote form one of my article which explains this behavior
--BEGIN QUOTE
Each datablock will have an Interested Transaction List (ITL) that holds the
transaction id of that block during the lif
Title: Fragmentation of data dictionary
Helmut,
X$
tables are NEVER stored in the disk. THey are just memory structures in the SGA
and the contents are zeroed (are reset) when you shutdown the database. THey
will not cause data dictionary fragmentation.
Best Regards,K GopalakrishnanBan
DBA_TABLES.DEGREE?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Gramolini
Sent: Tuesday, February 12, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
It there a view which tell which tables are in parallel?I would like to
see which
Dick - I believe that some replication is available in Standard Edition. My
company is looking to put Oracle in remote sites, with some modest
replication, and wanted to avoid the licensing penalty of EE. As I read the
Oracle document
http://technet.oracle.com/products/oracle9i/pdf/o9i_family_feat
Good morning all,
It there a view which tell which tables are in parallel?I would like to
see which table have parallel execution turned on.
Thanks is advance,
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City
It works fine in 8.1.6.0.0, Sun Solaris 2.6:
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:01:22 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
SQL> set echo on
SQL> alt
Title: Fragmentation of data dictionary
Hi!
I was wondering whether the Oracle data dictionary gets fragmented and whether the dba needs to do something about it. E.g. if granting tons of rights through grants directly to a user (and later revoke them), does the data dictionary get f
[Bjørn Engsig]
>Admittedly, I am no JDCB expert, but I wouldn't expect to see the
>behaviour you see, in particular that each insert seems to produce a
>soft parse. Do you have a non-cached sequence? If you do, that's
>your reason - recursive SYS SQL is (almost) n
1 - 100 of 119 matches
Mail list logo
