Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this
can anyone explain what are leaf blocks and table high water marks?
thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this
A Leaf Block is an index block. In a B*tree index, index blocks are either
branch blocks (the top blocks within the B*tree index), or leaf blocks
(the lower level index blocks). Branch blocks hold index data that point
to lower level index blocks. Leaf blocks hold every indexed data value and a
can anyone explain what are leaf blocks and table
high water marks?
thanks.
Leaf blocks refer to indexes, and, more generally speaking, trees (I can only advise
you to read Donald Knuth's 'The Art of Computer Programming' volume 3 (Addison-Wesley)
if you want to know all about trees - one of
Okay, anyone using Financials... E-Business suite...
Oracle 11i... whatever you want to call it...
I am trying to apply SOME kind of security to my
databases. It appears that it is critical for everyone to be able to
access production using the APPS id Finance and accounting people,
Paul,
My question is a little off-topic here, but since Ron has already discovered the
source of his problem ...
You state below that Oracle has extended support for a year of 8.1.7.
What do you mean exactly? For instance, when does support actually end, then?
The reason I ask is that
Title: Deleting from Global temporary Tables
Any specific reason what this should be costly ?? Look below for a snippet from a tkprof analysis ... db is 9202, 2 node RAC, everything is LMT and TEMP TS is 16GB
Trace file: abc1_ora_9879592_crenshaj_1014.trc
Sort options: prsela fchela exeela
Mark Thank you very much for explanation. Now I understood the
case.+0 is nothing at statment.It is used only for Oracle does not
use theindex.Regards.Eriovaldo
- Mensagem Original De:
"Mark Richard" [EMAIL PROTECTED]Para: "Multiple
recipients of list ORACLE-L" [EMAIL
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeffrey Beckstrom
INET: [EMAIL PROTECTED]
Fat City Network Services--
Stephane, Thank you very much for explanation.Now I
understood the case.+0 is nothing at statment.It is used only for
Oracle does not use de index.Very good.Best
Regards.Eriovaldo
- Mensagem Original De:
"Stephane Faroult" [EMAIL PROTECTED]Para: "Multiple
recipients of list
support for 8i has been extended to 12/31/2004
--- Caffrey, Melanie [EMAIL PROTECTED] wrote:
Paul,
My question is a little off-topic here, but since Ron has already
discovered the source of his problem ...
You state below that Oracle has extended support for a year of
8.1.7.
What
Title: RE: Database just stops
Where do we send the flowers? I'm assuming that you killed or at least severely wounded him.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]
Hello Gurus,
Have some disk space issues, so looking for ways to cleanup.
Please confirm that my thinking is correct.
I run the command and example output below:-
SQL archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination
On *nix systems, the username/password information will be visible to all via the ps
command. Not good.
-Original Message-
Sent: Tuesday, October 14, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus
No workarounds. You are violating one of the rules of partitioning. You will need to
rebuild the
table and the indexes etc
df2hp103 [IDST]: oerr ora 14060
14060, 0, data type or length of a table partitioning column may not be changed
// *Cause: User issued ALTER TABLE statement
Oh, OK. I just looked at Metalink and saw that this announcement took place less than
a week ago.
I guess the original announcement of desupport panicked quite a few people. Hence the
extension.
Anyway, since I've already recommended upgrades to 9i, I'm going to stick with it.
No reason
You can use the find command to remove archived redo log files older
than x days. The command runs in my hotbackup shell script every other
day and removes files older than 1 day.
find /disk04/oraarch/$ORACLE_SID/log*.arc -mtime +1 -exec rm {} \;
-Original Message-
Sent: Wednesday,
We use cron facility to run a script that copies archived log files, not in use by
archiver
process, (fuser command) to a different location. We also use 'Autosys' software to
run such
scripts on remote servers. Another script, that runs after the 'copying' script,
confirms that the
'copying'
When did they annouce that?
Wasn't the end of error correction 12/31/2003?
Brad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
have you backed up those archive logs before you remove them? you can
remove any archive logs created before you began your most recent
backup, which is NOT the same thing as removing any archive log created
before the oldest online log
--- Denham Eva [EMAIL PROTECTED] wrote:
Hello Gurus,
0.50 to 2.00 depending on Java/XML/XDK etc... etc...
- Kirti
--- Shibu MB [EMAIL PROTECTED] wrote:
Hi all ..
Can anybody tell me how many hours it will take to run the patch
catpatch.sql . I am planning to upgrade the server.
My server info is given below
BANNER
Your backup script should be deleting archive logs after they are backed up. With
RMAN, you could do the following, just to backup and delete your archivelogs:
run
{
allocate channel ch1 type disk format '/bkup4/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1
Thanks for this info about your problem. I will keep it hande for future reference.
May be I got lucky, because I did not encounter major issues when I upgraded 9.2.0.3
to 9.2.0.4 on
HP-UX 11i. Just one lib had to be renamed so Oracle could create it afresh. Other than
that, it
was pretty
April,
We lost this battle with our developers - they have the password, along with strict
instructions to behave.
Nobody else should have the password to any of the schemas (APPS, GL, INV, etc.).
We create logins for users that need them and grant the necessary rights to objects.
As you
In our shop, the APPS DBA runs traces
as APPS. No one outside of the DBA group has the APPS password. We
use Discoverer and Noetix Views for those users who have to look into the
database outside of the application. Each user logs in as himself;
the DBAs have created roles by business unit and
Melanie,
If we didn't have issues with CBO behavior differences, I would be pushing harder to move to 9.2.0.4. The only thing that saved a rollback to 8.1.7.4.6 was setting optimizer_features_enable=8.1.7.
Paul"Caffrey, Melanie" [EMAIL PROTECTED] wrote:
Oh, OK. I just looked at Metalink and saw
If you are using rman you can back up the archive logs and delete them when
the backup was successful as part of your rman backup. We also do extra rman
archivelog backups with deletes every 5 hours over the weekend when there
are big batch jobs running so the archivelog destination doesn't become
Ah, I see.
Thank you, Paul.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Drake
Sent: Wednesday, October 15, 2003 10:45 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Database just stops,
now 8.1.7 support
Melanie,
Hi Brad,
This one caught me off guard too.
You are right in that it was *originally* 12/31/2003.
However, check out Metalink Note 148054.1, dated 10/09/2003.
The extension is noted there.
Regards,
Melanie
-Original Message-
Odland, Brad
Sent: Wednesday, October 15, 2003 10:14 AM
To:
I could be missing something here. If you set the profile option
Utilities:Diagnostics to YES users are allowed to enable trace on a
session without having to provied the APPS password.
Cheers,
Mike Hately
-Original Message-
Sent: 15 October 2003 14:29
To: Multiple recipients of list
Help I am getting the following error on a 9.2.0.3 RAC on Solaris DB:
Any help would be greatly appreciated THanks -Lizz
SQL ALTER TABLE AE ADD ( CONSTRAINT FK_AE FOREIGN KEY (CDR_ID) REFERENCES CDR_TABLE (CALL_ID))/ 2 3 4 ALTER TABLE AE ADD (*ERROR at line 1:ORA-02270: no matching unique
Lizz,
Are
you sure that the PK was created on the CDR_TABLE? It looks like it might
fail because you first created a unique index on the table, then a PK and used
the USING INDEX clause. I would think that the PK would not be created
because you cannot have two unique indexes on the same
Thanks Everyone for there answers! Mujeeb Chowdhry [EMAIL PROTECTED] wrote:
try init 6 [EMAIL PROTECTED] 10/13/03 11:04AM Use 'shutdown now'Then 'reboot -r' [EMAIL PROTECTED] 10/13/03 7:34:24 AM List,Does anyone know the correct Solaris commands to reboot a UNIX Solaris64 bit os system. Is it
FYI... The support is only extended for strategic platforms...
Microsoft Windows XP
Microsoft Windows 2000
Linux x86
HP-UX PA-RISC
IBM OS/390 (z/OS)
Microsoft Windows 98
HP Tru64 UNIX
HP Alpha OpenVMS
Solaris Operating System (x86)
IBM AIX-Based Systems 5L
Fujitsu-Siemens BS2000/OSD
Solaris
Management have been grumbling about the cost of TOAD Professional
licenses, and have been "recommended" a cheaper product called PL/SQL Developer
by Allround Automations (available from Inthink Corporation at $150 a pop). Now,
I've been to the product website, and read up on all its
Our CIO is pushing a platform change from Tru64to Sun. We are currently running a VLDB (~1.5 TB) on Tru64. Does anyone have feedback on the following:
1) Experiences with either/both, preferred platform?
2) Experiences with platform changes? (Time required for migration?)
3) Any other thoughts?
They changed it October 9th, according to the desupport notice.
They didn't change the end of ECS for iAS release 1, it's still June 2004
for those who are running that version.
Patrice.
-Original Message-
Sent: Wednesday, October 15, 2003 11:14 AM
To: Multiple recipients of list
Title: RE: Financials and APPS password
This particular script says it needs apps authority (mostly, select any dictionary which the read only users have)
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the
Title: RE: Financials and APPS password
sorry... my bad.
The script in question is apparently a trace generation script that is to be run from sqlplus
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple
Ah, space, the final frontier. If I'm not mistaken, all
of that can be found in the book written by a guy named
Robert G. Freeman or something like that. The book name
is RMAN Backup Recovery, from Osborne Press,
ISBN 0-07-222662-5. Those are the books for oracle DBA. Its
continuing mission: to
Man! I'm gonna have to migrate off of my IBM PCJr.
-Original Message-
Sent: Wednesday, October 15, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
FYI... The support is only extended for strategic platforms...
Microsoft Windows XP
Microsoft Windows 2000
Linux x86
HP-UX
Hi there!
We are having problems with an Oracle backup. The compiling of the backup
command fails with the error message: RMAN-20242: specification does not
match any archivelog in the recovery catalog
But RMAN is only supposed to backup any archived logs that are there and
then insert them in
Jake,
I have heard horror stories from both Sun *and* Tru64 customers (we were
Sequent, and moved to Sun), but your CIO is probably right in moving out
since support (people, skills, patch and product/application availability)
for Tru64 is slowly vanishing. As well maintenance costs are higher
Hi!
Does anybody out there have any experience with Oracle Warehouse Builder
(9.0.4 or later)?
I am supposed to get my feet wet with it, but have no clues as where to
start...
This is 9i on HP-UX.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Hi!
We are experiencing a weird problem here...
We have automatic undo management enabled and the undo tablespace is 6 GB in
size. undo_retention is set to 30 minutes.
when a certain transaction runs, it fails with ORA-1555 Snapshot too old,
although the undo tablespace only uses 700 MB (out of
We moved from a T64 (ES40 4
CPU) to a Sun (68002 blades 8 CPU) recently. There were no problems with
the export/import of the 1/2 TB database.
One big thing was that the
max block size on Sun for 8174 is 16K. We had used 32K on T64. So we had to
rethink our multi_block_read_counts, etc.
April,
Mike is right, but this also allows users to use the 'Examine' feature
without knowing the APPS password - they can then make *data* changes
*directly* to the database - a very strict Oracle Support no-no and a bigger
problem. The issue with using a Non-APPS user is that APPS uses a ton of
Wheewww.
Thats a reliefwe have been scrambling to get moving to 9.2.0.4 and so
far have been running into some snags. We didn't want to consider 9.0.
dislike being without error correction. As the standard answer is upgrade
and now there are some icky bugs in 9.2.0.3 and to not consider
I ran the same
ddl in 9.2 and had no problems. Check for tables having the same names in other
schemas
Waleed
-Original Message-From: laura pena
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
11:19 AMTo: Multiple recipients of list ORACLE-LSubject:
ORA-02270:
I thought it must be that. You know I've looked at the script and I'll be
damned if I can see why you neeed to be connected as APPS. The argument
seems to be that of the schema owners associated with Oracle Applications
only APPS can be guaranteed to have select access on the DBA_* views.
Note
Helmut,
The SELECT article 'Understanding ORA-0155' by Tim Gorman is a must-read.
Get a subscription to IOUG, or ask Tim nicely and he might give a copy of
the article to you... (Probably better to get an IOUG subs - there is a ton
of excellent articles and tech stuff out there)
John Kanagaraj
Platform is 8.1.7.4,
HP-UX 11.00
I have a complex
view. After rebuilding all indexes this weekend, the view got much
faster. I did a trace on it. Now, a few days later, the view is
getting much slower.Yes, an analyze has run since then, doing an 'estimate
statistics', but anestimate stats
Title: Message
Management wants to standardize to a single tool for support and
maintenance purposes. At least that's the story here. I have heard
good things about PL/SQL Developer. If it's an option, you could checkout
TOra (http://www.globecom.se/tora/)
which is comparable to TOAD and
Is your particular problem reproducible? Without any changes to the cache size?
Many times simply running the job again works.
- Kirti
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Helmut,
The SELECT article 'Understanding ORA-0155' by Tim Gorman is a must-read.
Get a subscription to
John:
Optimizer is a smart boy!!! He knows the column has few distinct values
and decides the BITMAP access would be appropriate and making BITMAP
plans from the BTree indexes. If you delete the stats for that index,
you will get the old behavior.
KG
=
Have a nice day !!
You
are correct in that it is very developer centric. As far, as hidden
charms...I'd have to say the Reports capabilities. You can easily
incorporate your DBA scripts into this little tool. Still not as good as
TOAD (or even TORA) for a DBA but a nice, cheap addition to the
arsenal.
Can anyone point me to a definitive hot back up script for Oracle 9 on AIX,
please
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
I consider a 20242 error as an acceptable one, here is why:
If i ask rman to backup archivelogs that are more than 2days old and
there are none, thats not an error. That is when i see it the most, now
most companies will force a log switch after a set amount of time during
the day so in DR,
hi kirti
i was using the below method to copy archives to drsites and running this cron very frequently. the job used to ship and delete them immediately after successful copy and i used to have fuser check. but soon we started hitting this issue when we used to ship archives even when they are
I drafted an e-mail complaining about losing support for OS/2... then
deleted it.
: )
Patrice.
-Original Message-
Sent: Wednesday, October 15, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
Man! I'm gonna have to migrate off of my IBM PCJr.
-Original Message-
Sent:
List,
I looked on technet.oracle.com for the 9i release 2 client to download. I didn't see it. Is there a place I can pull the Oracle client for 9.2 from the web?
TIA
M.
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
You may also want to consider OraEdit Pro by DKG Advanced
Solutions Inc. (www.dkgas.com)
Shamita
Shamita Singh
Mohawk College
Hamilton, Ontario
--- Rich Gesler [EMAIL PROTECTED] wrote:
You are correct in that it is very developer centric. As far,
as hidden
charms...I'd have to say the
Title: RE: Financials and APPS password
I thought so too. all it really appears to need is select access and select any dictionary. the trace and analysis tools for apps are usually pretty uninvasive... and just do substantial reads.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate
John-
Just got back from a vacation and saw this... Our jr DBA is in the process of doing
this. Care to
share your code???
Thanks,
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Seems this table cdr_table has a disabled constraint:
1 SELECT constraint_name, constraint_type, status, deferrable, deferred FROM 2* user_constraints where table_name='CDR_TABLE'
CONSTRAINT_NAME C STATUS DEFERRABLE DEFERRED-- - --
Have
you looked at Toolkit for Oracle (TOra)?
http://sourceforge.net/projects/tora/
I've
heard rather good things about it.
Matt
Matt Adams - GE Appliances -
[EMAIL PROTECTED]We have enough youth.How about a fountain of
intelligence?
-Original Message-From: Paul Vincent
You
have the unique index defined as global index so my guess any partition
operation (parallel load, etc) will disable the index.
-Original Message-From: laura pena
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
2:14 PMTo: Multiple recipients of list
Ron,
It is really simple - Just recreate the *larger* TRCA tables to use GTT as
shown below:
CREATE GLOBAL TEMPORARY TABLE trca$trace
(
trace_id NUMBER,
trace_filename VARCHAR2(64),
trace_size NUMBER,
trca_date DATE,
hi
does complete refresh of mvs always do a truncate of the table and then does an insert from the master site or is there a possibility when it deletes the records in the table and does a insert of the records from master site.
one more question is whether this functionality has changed from 7
not a problem on most *nix if you use hide.c
http://www.cybcon.com/~jkstill/util/zips/hide.tgz
Jared
Norris, Gregory T [ITS] [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/15/2003 06:49 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sai,
We do not delete the files right away. The 'delete' scripts verifies that the file is
present
(with correct file size) at the destination before deleting it. We have not had any
problems with
this method for over 5 years now.
I never used 8.1.7.2 much, so I can't say how the ARCH process
TORA
-Original Message-From: Paul Vincent
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
10:59 AMTo: Multiple recipients of list ORACLE-LSubject:
Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional
Hi
All,
Couldsomebody help me in
finding the actual size of an oracle table in GB.
TIA,
Rajesh
True,
but last I checked it had a number of limitations...it's basicallya
band-aid,while the patient is hemorrhaging.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
2:09 PMTo: Multiple recipients of list ORACLE-LSubject:
Missed one important point. You can disable that by setting
_b_tree_bitmap_plans to FALSE. Deleting the stats may not be a right
apporach as that may screwup some other plans.
Sorry for missing the important one..
KG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Raj,
Does the table already exist have data or are you
looking for a gestimate?
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Pillai, Rajesh
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15,
2003 3:24 PMTo: Multiple recipients of list
Try:
SELECT segment_type,
segment_name,BLOCKS*8192/1024 "Kb"
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('owner') AND SEGMENT_NAME =
UPPER('table_name');
Tony
-Original
Message-From: Pillai, Rajesh
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15,
2003 3:24 PMTo:
On 10/15/2003 03:24:29 PM, Pillai, Rajesh wrote:
Hi All,
Could somebody help me in finding the actual size of an oracle
table in GB.
TIA,
Rajesh
Select sum(bytes)/1073741824 Baud Rate
from dba_extents
where segment_type='TABLE PARTITION'
and segment_name=upper('table');
--
Mladen Gogala
All
the tables already exist and have data.
Thanks
a lot for your response,
Rajesh
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Table Size
Raj,
Does the
Title: Message
If you
are running stats on this table or can run stats use
dba_segements
Allan
-Original Message-From: Pillai, Rajesh
[mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15,
2003 2:24 PMTo: Multiple recipients of list
ORACLE-LSubject: Table Size
Hi
When retrieving data, does Oracle place just the columns of
interest into the result set or does it place the entire row in
the result set (and filter out the columns of interest later)?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Fink
INET: [EMAIL
Well, if the table is partitioned you'll get a nice fat zero
On 10/15/2003 03:49:36 PM, Stephen Lee wrote:
How about:
select sum(bytes) from dba_segments where segment_name =
'TABLE_NAME';
-Original Message-
Hi All,
Could somebody help me in finding the actual size of an oracle
Steve,
That gives you the size of the segments/extents that are the table, but not
the actual amount of space being used.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, October 15, 2003 3:50 PM
To: Multiple recipients of list ORACLE-L
How about:
select sum(bytes) from dba_segments where segment_name = 'TABLE_NAME';
-Original Message-
Hi All,
Could somebody help me in finding the actual size of an oracle table in
GB.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET:
Title: Message
Allan,
I
cannot run stats on the table
Regards,
Rajesh
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Table Size
If
you are running stats on
List, so ssh forwarding will not work with windows ?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 17:40
Hmm I wonder what the Metalink Technicians would have to say on this.
Patrice.
-Original Message-
How true. My previous query would be incorrect also.
ANALYZE the table COMPUTE STATISTICS (or ESTIMATE STATISTICS if it's a very large
table) and then
select num_rows * avg_row_len from dba_tables
where owner = 'table_owner' and table_name = 'table_name' ;
-Original Message-
Goulet,
K Gopalakrishnan wrote:
John:
Optimizer is a smart boy!!! He knows the column has few distinct values
and decides the BITMAP access would be appropriate and making BITMAP
plans from the BTree indexes. If you delete the stats for that index,
you will get the old behavior.
KG
=
The query proposed by Anthony Hsu assumes that the tablespace has an 8K block size.
Instead use the query below. Of course the result will be in bytes, not gigabytes, but
any good DBA can instantly convert bytes to gigabytes or terabytes at a glance. :)
P.S. I include LOB indexes in the table
It works fine... you just need to run CMAN on the database server. This will
eliminate the redirect to an un-tunneled port.
-Original Message-
Sent: Wednesday, October 15, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
List, so ssh forwarding will not work with windows ?
-
Hi:
We have a program that import a big schema data and then run
DBMS_STATS.GATHER_TABLE_STATS for all the imported tables. Now with oracle
9.2.0.1.0 installed, I thought we could get rid off
DBMS_STATS.GATHER_TABLE_STATS step since it can import satatistics.
However our original db is still
April,
Apart from the issues already pointed out, here are two more -
1. You basically have zero change control in production - anybody can log
in with tthe APPS account and make any changes without prior approval or
testing, and, even worse, without any audit trail. This obviously is a big
This will get you that actual bytes used by the data in the table; however,
it will hit every row in the table and take a long time to run. It takes
one parameter, the table being sized.
rem
rem this code was inspired by Kevin Loney
rem
At what step ?
Oracle reads blocks, so from the datafile up to the db_buffer/db_cache its
blocks.
It would be logical that the filtering occurs after the where clause has
chosen the data matching the search criteria, so in the select step which is
the last step of the query operation.
Stephane
only if your backupset size is more then total_arc_log_file_sizes .
Otherwise there will be more then one pieces , rite ( ??)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 1:19 PM
With RMAN, can I use 'copy
Stephan,
That is correct. The old behavior is not what I want. I have rebuilt and
reanalyzed, deleted stats - tried all sorts of combinations and I cannot get it to use
the bitmapped access as it once did. Again - these are not bitmapped indexes to begin
with.
John
-Original
SarbOx ( Sarbanes Oxley) will change this behavior.
Users and developers will be more limited.
There should be a way to limit DBA's and sysadmins as well.
Data encryption at the db level is the only way I can think of
to prevent that, short of locking out the admins.
Jared
Jay
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the
database servers are mostly Win2k.
Software $0.00
OS $0.0
HW $12k
Jared
Paul Vincent [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/15/2003 08:59 AM
Please respond to ORACLE-L
To:Multiple recipients of
Since you're migrating anyway, have you seriously considered Linux?
Though I like Sun, it doesn't appear to be a good move lately.
Sorry Daniel. :)
Jared
John Kanagaraj [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/15/2003 09:24 AM
Please respond to ORACLE-L
To:Multiple
1 - 100 of 134 matches
Mail list logo