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
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
Title: RE: decrease initial extent
alter table tbl_name 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
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: 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: 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//
environment
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
Title: RE: External Tables question
Raj, here is an example of control file:
load data
into table TABLE_NAME truncate
(piece recnum
...
)
Alex.
-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 05, 2003 8:25 AM
To: Multiple
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
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
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
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
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
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
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 recipients
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 - update row piece
Title: RE: How do I find out the size of a index
You can also do:
analyze index INDEX_NAME 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,
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
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;
begin
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
user.exe_cmd$$(p_cmd in varchar2)
as
begin
execute immediate p_cmd;
end;
execute user.exe_cmd$$('grant select on
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:
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-LSubject:
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 $READY
exit |
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: 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
TX Transaction
For
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
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.
HTH.
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
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.
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(*)
-- --
1 598
.
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
Subject: Re[4]: Date
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
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: 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: 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: 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
Title: RE: Column Title
Binay,
Only this database has
cursor_sharing=force
in initSID.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
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
43 matches
Mail list logo