Title: RE: Old thread - trace file location
For 9.2 users:
Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs;
Alex.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 21, 2004 12:24 PM
To: Multiple r
Title: RE: SQL Area Reloads
No, "reload" does not include initial load.
"reload" - Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk.
"First_loads" = pins - pinhits - reloads
Alex.
-Original M
Title: RE: decrease initial extent
If you use "keep " it will.
Alex.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 03, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: decrease initial extent
That will not do any
Title: RE: decrease initial extent
alter table deallocate unused keep 1;
Alex.
-Original Message-
From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 03, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: decrease initial extent
Is there any w
Title: RE: dbms_support on 8i
Jared,
You are right. dbmssupp.plb are different.
dbmssupp.sql are the same.
This is an output on 9.2.0 which leads me to the wrong conclusion, sorry about that.
SQL> select sys.dbms_support.package_version from sys.dual;
PACKAGE_VERSION
Title: RE: dbms_support on 8i
Jared,
Files are the same in 7.3.4 and 9.2.0. You can use any of this in 8.1.7. Oracle Corp. did not ship those files with 8.1.7, you can ask Oracle Support to get it.
Alex.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: Initalization files, etc
Jared,
You can do this with PFILE as well. And to resolve a problem there is (not complicated) solution.
Alex.
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 24, 2003 10:05 AM
To: Multiple recipients of
Title: Message
This
is new features of 9.2. The same on LINUX.
oerr ORA 2859528595, 0,
"Extproc agent : Invalid DLL Path"// *Cause: The path of DLL supplied
for the extproc execution is invalid.// *Action: Check if the DLL path is
set properly using the
EXTPROC_DLLS//
envir
Title: RE: External Tables question
Raj, here is an example of control file:
load data
into table truncate
(piece recnum
...
)
Alex.
-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 05, 2003 8:25 AM
To: Multiple recipients of l
Title: RE: Cache a table
Mladen,
John Beresniewicz did some test (last one I know of in 2000 with Oracle 8.0) with diffent values of
_db_aging_cool_count
_db_aging_freeze_cr
_db_aging_hot_criteria
_db_aging_stay_count
_db_aging_touch_time
_db_percent_hot_default
_db_percent_hot_keep
_db_perc
Title: RE: Cache a table
Sure, Wolfgang. Thank you for the correction.
Alex.
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 21, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cache a table
I suppose you mean "2%
Title: RE: Cache a table
John,Tom,
There is a difference between pools {DEFAULT vs. KEEP and RECYCLE}.
By default only DEFAULT pool use "mid-point" insert. It is controlled by hidden parameters
_db_percent_hot_default (Percent of default buffer pool considered hot) default 50
_db_percent_hot
Title: RE: space taken up by number data types
Jared, Ryan,
Number data types does not reserved any space. Amount of used spaced depend on the stored value. For the same value size is the same, however, look at Steve Adams' site or run this test and see:
drop table t;
create table t (n1 num
Title: RE: _cpu_count vs cpu_count
Tanel,
33 cpu_count initial number of cpu's for this instance system modifiable
34 _cpu_count current number of cpu's for this instance non-modifiable
For most of hidden parameters x$ksppsv.ksppstvl set to 0 by default.
Alex.
-Original Me
Title: RE: 9.2.0.4 anyone
Parameter name "_kghdsidx_count", default in 9.2.0.3 is 1, description "max kghdsidx count".
Do not know what it is for.
Alex.
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:29 PM
To: Multiple recipie
Title: RE: how can I see which database I am logged into without
In 9.2, in SQL*Plus
prompt &_connect_identifier
Alex.
(Thanks to Connor McDonald)
-Original Message-
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:54 PM
To: Multiple reci
Title: RE: alter system dump logfile
Here is for LAYER 11. Full list is too long.
Layer 11: KCOCODRW - Row
opcode 1 : KDOIUR - interpret undo redo
opcode 2 : KDOIRP - insert row piece
opcode 3 : KDODRP - drop row piece
opcode 4 : KDOLKR - lock row piece
opcode 5 : KDOURP - upda
Title: RE: How do I find out the size of a index
You can also do:
analyze index validate structure;
select blocks, lf_blks, br_blks, btree_space, used_space from index_stats;
Alex.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 13,
Title: RE: ora-600 when analyzing IOT
Only missing data in *_TABLES is "avg_row_len" which, probably, can be used for estimating hash area for hash join.
Also, columns statistics will not be generated, probably more important.
Alex.
-Original Message-
Does it mean, that if I don't
Title: RE: Who Says Oracle does not listen
Performance.
You do check, and the DBMS does check internally.
Alex.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 22, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Who Says Orac
Title: RE: Who Says Oracle does not listen
From ORACLE own script:
Rem
Rem Drop tables without raising errors if they do not exist
Rem
declare
PROCEDURE drop_force(tab varchar2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
Title: RE: Question related to security
Dennis,
If you have "CREATE ANY PROCEDURE" and "EXECUTE ANY PROCEDURE" privileges, you can on 8.1 and up:
create or replace procedure
.exe_cmd$$(p_cmd in varchar2)
as
begin
execute immediate p_cmd;
end;
execute .exe_cmd$$('grant select on . to <
Title: RE: Space... confusion
April,
2000M = 2097152000
2097168384 - 2097152000 = 16384 = 16K
2097156096 - 2097152000 = 4096 = 4K
OS size equal to ORACLE size plus 1 FS block.
Check FS blocksize.
Alex.
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Thurs
Title: RE: Table Scans
Mladen,
Look up definition of x$bh.flag.
For example, http://www.jlcomp.demon.co.uk/buf_flag.html
Correction to the query, join should be x.obj=o.data_object_id
And as a note, one needs to take care about clustered tables.
Alex.
-Original Message-
From:
Title: RE: extremely long parse time
Matt,
optimizer_mode = FIRST_ROWS means CBO, and for SYS schema without statistics.
Oracle 8.1.7.2 on HP-UX 11.
optimizer_mode = CHOOSE
I run your original SELECT, then with the hint FIRST_ROWS.
From trace file:
PARSING IN CURSOR #1 len=888 dep=0
Title: extremely long parse time
Matt,
Is it
Oracle 9?
If
yes, time is in microseconds.
Alex.
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, September
26, 2002 10:30 AMTo: Multiple recipients of list
ORACLE-LSubjec
Title: RE: How to reproduce a hanging connect attempt
Jared,
It is adequate.
Below is snip from Steve Adams's script (db_check.sh) and I successfully used similar technique for some time.
-- snip
rm -f $READY
print "
connect nobody/really
host touch $RE
Title: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based training)
FWIW
There is a document (id 283852) on Metalink updated on 03-SEP-2002 created by "CENTER OF EXPERTISE" named
THE COE PERFORMANCE METHOD
A PERFORMANCE METHODOLOGY FOR ENTERPRISE-WIDE INFORMATION SYSTEMS
which
Title: RE: listener configuration on HP serviceguard clusters
Matt,
We have two nodes cluster with three packages; two of them have more than one database.
Oracle software installed on each node. Each listener belongs to node, not to package.
When packaged started on the node it will startup
Title: RE: buffer cache
First query does exactly this, but can be very slow, I mean very.
Second query runs much faster, but care needs to be taken about CLUSTERs, all objects in cluster share the same data_object_id.
Alex.
-- buffers distribution by segments
select
count(*) buffers
,e.tab
Title: RE: Large enqueue waits.
John,
ADDR Addres
INDX Index
INST_ID Instance ID
KSQSTTYP Enqueue Type
KSQSTGET Number of GETs
KSQSTWAT Number of WAITs
CF Controlfile Transaction
CU Bind Enqueue
SQ Sequence Number Enqueue
ST Space Management Transaction
TM DML Enqueue
Title: RE: Zero-term'd machine in V$SESSION from Winders
Rich,
I tested on 8.1.7.2 on HP.
For Windows client (7.3, 8.0, 8.1) "machine" has null terminator, "terminal" does not.
For HP client neither does.
For backgrounds "machine" does not, but "terminal" set to "UNKNOWN" with null terminator.
Title: RE: Currval and buffer gets
Waleed/Kevin/Jonathan ...,
8.1.7.2 on HP-UX 64bit.
Modified version:
declare
n1 number;
n2 number;
ss date;
begin
n1 := sys.dbms_utility.get_time;
for i in 1..10 loop
select sysdate into ss from sys.x_$dual;
end loop;
n2 := sys.dbms_utility.get_time;
Title: RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO
Robert,
Let me disagree with you.
Cold *backup* is the same in archivelog mode and in noarchivelog mode.
The *recovery* is (could be) different.
Consider the following. I make a cold backup of a production DB, and res
Title: RE: wrong result from select
Thanks everyone.
Bug# 2225065 Assigned to Development.
Alex.
-Original Message-
From: Alexander Feinstein
Sent: Friday, February 08, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: wrong result from select
Hi,
Can anybody try
Title: OO4O config
Hello,
Friend of mine ask me, if there is a way to do a setup Oracle cliets
on Windows (95/98/NT/2000), to be able to use two applications
one of which is using OO4O 8.1.5 and other OO4O 8.1.6.
Has anybody knows about such setup?
Alex.
e same format string.
And:
NLS_DATE_FORMAT specifies the default date format
to use with the TO_CHAR and TO_DATE functions.
Alex.
-Original Message-
From: Jonathan Gennick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 1:21 PM
To: [EMAIL PROTECTED]
Cc: Alexander Feinstein
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(*)
-- --
Title: RE: Re[2]: Date format element rule change
You can, using to_char, but not in "alter ... nls ..."
SQL> select to_char(sysdate,'Mon (MM) DD, ') from dual;
TO_CHAR(SYSDATE,'
-
Feb (02) 11, 2002
1 row selected.
Alex.
-Original Message-
From: Jonathan Gennick
Title: RE: wrong result from select
This seems to be a bug in 8.1.7.2...searching our database for known issues.
Awaiting Internal Response
TAR# 1975492.995
Alex.
-Original Message-
From: Ron Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 4:09 PM
To: Multiple
Title: RE: Date format element rule change
8.1.7.2.0 64bit HP-UX 11.0
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, ';
ERROR:
ORA-01816: month may only be specified once
Alex.
-Original Message-
From: Jonathan Gennick [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 1
Title: wrong result from select
Hi,
Can anybody try this on 9i?
set echo on
alter session set optimizer_mode=choose;
alter session set cursor_sharing=force;
create table tb1 (f1 number(4));
insert into tb1 values (1999);
insert into tb1 values (2000);
insert into tb1 values (2001);
insert
Title: RE: stopiing write to listener.log
You can try something like this:
ORACLE_HOME=/u000/app/oracle/product/8.1.7; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc; export PATH
CURR_DATE=`date +%Y%m%d`
$ORACLE_HOME/bin/lsnrctl set log_file $ORACLE_HOME/network/log/listener.log
Title: RE: Slightly OT : RDA from Oracle
John,
I am just trying version 2.71 on HP-UX 11 with Oracle 8.1.7.2.
There are issues with security, collection certain types of statistics, etc.
Will have more information next week.
Alex.
-Original Message-
From: John Kanagaraj [mailto:
Title: RE: Column Title
Binay,
Only this database has
cursor_sharing=force
in init.ora file.
This is a bug, you can check Metalink.
Alex.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 4:55 AM
To: Multiple recipients of list
Title: RE: Column Title
Binay,
It is a bug related to cursor_sharing=force.
Try alter session set cursor_sharing=exact.
Alex.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 9:25 AM
To: Multiple recipients of list ORACLE-
Title: RE: Cleaning up before upgrades / migrations; avoiding upgrade problems
Patrice,
That is what I did:
1. Install 8.1.7.
2. Create new DB.
3. Migrate old DB from 7.3.4 to 8.1.7.
4. Create new LMTs for tables and indexes.
5. Move all tables to new tablespaces (adjust PCTFREE and PCTUSE
47 matches
Mail list logo
