 | | | Oracle List | | ASSM - Automatic segmnet space management.
There is no such thing as freelist for an ass-managed segment free space is
managed using internal indexes and bitmaps within them in ASSM.
If intereHi
I just appeared in an interview.
When I was asked which filese I will copy for hot backup I said redo too.
Cause I think they can help us always to recover database upto point of time.
> Why Oracle said that to increase the FREELISTS you MUST RECREATE THE
OBJECTS?
Please reference where is this stated?
This is from 9.2 RAC deployment doc
"You cannot change the value of FThis is a cut from asktom.oracle.com
Hi..
I have Gmail invitations guyz..
Let me know still someone is left with Gmail.
Please send me personal mail instead of doing Repy to all.
- Chiku
Chirag@(protected)
--
http //www.freeliWell Well Well...
Thanx.... I think I m missing the following.
Pumps means night jobs which will repopulate my other tables for look
ups from some external client back end systems.
I m doiI should clarify that a bit though the hash join appears to follow an
ORDERED hint and join the tables based on the FROM clause order if the
ORDERED hint is used. This is based on the 10053 's that At 12 59 PM 10/1/2004 Freeman Robert - IL wrote
>And the optimizer chooses this plan (this is from the 10046 for that
>statement)
>
>STAT #1 id 1 cnt 999 pid 0 pos 1 obj 0 op 'HASH JOIN (cr Hi DBAs
My conpany wants to buy PowerDesigner.
But there are few version of PowerDesigner
- PowerDesigner Business Process Architect
- PowerDesigner DataArchitect
- PowerDesigner DeveloperThe index_name column of DBA_CONSTRAINTS was new with version 9 and only
contains an entry when the constraint_type 'P ' for primary key or 'U '
for unique constraint. In other words this column I had the same problem recently. Try setting the LOCAL environment variable
to your SID name.
John Smiley
--- snip ---
I 'm a *nix command line type DBA who has next to no experience
directly sThanks a lot John
2. Oracle Wait Interface A Practical Guide to Performance Diagnostics &
Tuning Shee
Is this an specialized book for trace like Millsap 's book?
Do you know another book spThe best source of information I 've ever seen on how to interpret a 10046
trace is Cary 's "Optimizing Oracle Performance ". You might also find
MetaLink Notes 39817.1 and 224270.1 useful.
The OWIHi
What 's the current policy on posting job openings here?
We 're interviewing and everyone I 've spoken with so far thinks that buffer
cache hit ratios are one of the most important tuning toolHi All
We have a database running on Unix server. We plan to have an application that will run on Windows server to execute some DBA tasks on the Database on the Unix server. It is possible to haHi could you please share which events you use to do a deep optimization
when generating traces out than 10046.
For example which event could be useful to analyze histograms.
Thanks in advancis oracle breaking your connection with a policy or is it being done by the operating system? ora-3113 usually occurs when the OS times you out. its possible that the OS cut off your connect and your I 'm setting up a procedure to purge old data from an application
table. For keep the run-time manageable I 'm fetching the relevant
rowids with an explicit cursor using the BULK COLLECT clause. O
I had a similar problem. I didn 't have an oraInventory directory. Look in
you oraInst.loc file (on AIX it is /etc) and see where the inventory_loc is.
Mine is actually in the Oracle Home. TDan
Thanks for taking the time to provide such a detailed explanation. I 'm
probably missing something but it appears that this explanation of how
one-at-a-time (linear) join orders can match HI
I have created a view .. on the table x
select * from x
SNO
-----
1
2
3
4
5
6
7
8
create view xview as select * from x
Added a column to tHi Robert
> > > For hash joins the optimizer creates the hash table on the smaller
row
> > > source. In this case it 's obviously DEPT.
>
>If this is true then why isn 't the LIO the same regardleThanks for ur suggestions everybody.
i was very much worried about DBSNMP and multiple
oraInventory . But dbsnmp doesn 't seem to care about
inventory and only reads /etc/oratab to discover the insHi friends
I have a Database in which few tables are for Transaction.
As the number of transactions will be more than 10000 per day I need
to decide the tuning strategy for the tables having On Thu 30 Sep 2004 19 51 12 -0400 nn20002@(protected)
<nn20002@(protected) > wrote
> Now how do I know that the foreign key constraint is using the index or not.
Assuming an update is takingI always say "cancel " for network configuration and just copy our standard
sqlnet.ora tnsnames.ora and ldap.ora to the network/admin directory.
Tom Mercadante
Oracle Certified Professional
All
We had a database production problem yesterday where the system was
maxed out at 100% CPU (ENV AIX 4.3 Websphere 4.3 ORCL 8.1.7.4). Upon
a quick investigation of the v$session_wait table My apologies. I somehow mangled the name when looking for it.
On Sat 2 Oct 2004 17 30 35 -0400 Mike Rothouse <mrothouse@(protected) > wrote
> In my environment it appears in 9.2.0.4 on Solaris Mark
I actually got the info from Steve 's site. I was just wondering what
other people thought about this. I was thinking of increasing the block
size on our indexes because I had also heard tLet me know if someone found the answer.
I m still trying.
" The boss " is a creature who never gets happy whatever u do. -)
- Chirag
On Thu 30 Sep 2004 14 38 53 -0700 (PDT) Alex |
|
|
