Hi folks
Ok, I've got this database that I'm tuning.
Anyway, currently the architecture of the views goes several layers deep:
1. Principle table
2. Mview doing some denormalization
3. View on the Mview doing some further flattening of the table and some
calculations.
4. Yet another view,
Alter system checkpoint... You don't say...
Hey, this is the first time this thread has concluded without the
usual you guys better watch out b/c yer gonna break your database!
post.
I'd say this universal support for ABORT over IMMEDIATE represents a
dramatic change in the prevailing DBA
Freeman Robert - IL wrote:
Hi folks
Ok, I've got this database that I'm tuning.
Anyway, currently the architecture of the views goes several layers deep:
1. Principle table
2. Mview doing some denormalization
3. View on the Mview doing some further flattening of the table and
The application is not extremely slow. Actually, i want to do proactive
tuning (instead of reactive). I want to see which application is misusing
the database resources and correct that form or report.. Further, I am
still unable to find the name of the forms/reports module that's currently
i don't see any data in the module/action columns, and ofcourse i don't wanna
re-engineer all those forms/ reports...
further, i can't see the statistics when i enable that parameters
with statistics=YES
I have tried it with the forms preferences statistics as well as runtime command line.
Shuja
thanks for your suggestions Raj.
FRD is nice thing to work. can you also provide more detail on pl/sql
profiler and dbms_support package...
Shuja
"Jamadagni, Rajendra" wrote:
Connor,
Forms is dumb ... I mean it doesn't think it is important
to use dbms_application info, you have to do it
You could try:
select
max(ktuxescnw * power(2,32) + ktuxescnb)
from
x$ktuxe;
This gives you the highest SCN recorded in
any of the undo segment headers. This would
only be an approximation for Oracle 9, as the SCN
seems to increment every 3 seconds in the complete
absence of any
I began using 'shutdown abort' on a regular basis in 7.x
( whenever shutdown immediate became available )
because that was the *only* way to guarantee a shutdown.
Jared
On Sunday 02 February 2003 01:23, Jeremiah Wilton wrote:
Alter system checkpoint... You don't say...
Hey, this is the first
Stephane,
Thanks for your thoughts. :-)
I don't think that replacing a view with an in-line view brings, by
itself, much
benefit.
I guess I see it differently. A MView by it's very nature is
administratively more expensive than a regular view (I'm not talking about
performance here).
Hello everyone, i've been quiet recently, for those of you who know what
I've been up to class has been great, emergency medicine is really kewl.
Now to the oracle stuff,
We're having new requirements by multiple clients to ask about RAC(not
necessarily on linux), so a couple of us thought,
Bill,
I have to live with people who want to usc Access too. I agree wfth you it is a
pain in the a--. Our solution, with damagement's agreement, is to only do what
is possible. I think that in your situation you'll have to do likewise. The
problem being Access's local tables. What may help is
Steve,
Oracle will allow you to create a datafile on a network drive. They just won't
support you unless you have it on a supported storage system (like a NetApp
Filer) and appriopriately configured (read that as meaning a dedicated TCP/IP
cable).
Dick Goulet
Steve Perry [EMAIL PROTECTED] wrote
You're absolutely correct - I have neglected the
acknowledge many of the various places I've seen
proposing the 'alter system checkpoint / shutdown
abort' model, including your web site.
Apologies.
Cheers
Connor
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
Alter system checkpoint... You don't
About
2), you'll have to use dbms_application_info to set teh name explicity. I had
brought this to Formd developmemt'd atten, and I believe they logged an internal
enhancement to do this, I have no idea about the status.
Raj
-Original Message-From: M. Shuja Uddin
Joe, do you know Mike Ault? He might well be the person to talk to about
this. I think he's been doing some work in this area.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you
...kind of a side story on the virtues of ALTER SYSTEM CHECKPOINT...
About 6-7 years ago, I was teaching Oracle Education's Backup and Recovery
Workshop, which was a 3 day class. The first 2 days are blabber/lecture
and the last day is all lab. In that last day, students spend the morning
It could be DBSNMP connecting to the database because of the Intelligent Agent.
Why did I call it un-Intelligent ?
$O_H/rdbms/admin/catdbsnmp.sql grants the DBA role to DBSNMP. The DBA
role includes the RESTRICTED SESSION privilege.
You should be doing a SHUTDOWN IMMEDIATE.
Me ? What do I do
Joe,
I would be very interested in hearing how you go with this. Could you
feedback any information you get on RAC/linux back to the list please.
Thanks greatly.
Cheers,
Craig.
-Original Message-
Sent: Monday, 3 February 2003 10:24 AM
To: Multiple recipients of list ORACLE-L
Hello
They are correct that they don't want you to do it.
The only approved NAS solution by Oracle is Network Appliance's product.
Other NFS, shared drive etc aren't good idea to put Oracle database files.
-Original Message-
Sent: Friday, January 31, 2003 6:16 PM
To: Multiple recipients of list
I didn't apply any service packs to W2K. Let me see with applying the
SP3 also.
Jesse, Rich
I just renamed the file and installation didn't start. So i downloaded
a new version and copied to the concerned folder and installed it. no
change.
Thomas
We had same problems at 2 sites here. I dont allow access in
Production, I can usually scare management enough to keep them
out and I apply a LOGON trigger to stop any connection from
access (and SQLPLUS etc for that matter, unless its a user that I
allow). I do create a copy of PROD every day
guys,
one of my instances here...
has SYSTEM tablespace of size 25G (with one datafile).
it has lot of indexes used by an application.
the total size of indexes in SYSTEM tablespace is 21G.
this was done by someone else and now they want me to :
1)drop some un-used indexes in SYSTEM
Hi Listers,
I have the below query which is taking almost 3 min. to execute.
Can anybody help me in rewriting the query and/or reducing the query
execution time. Please note that V_SHIP is a view created the source for
which is as as follows:
View Source
CREATE OR REPLACE VIEW V_SHIP (
Check dba_free_space to find out how much free space you have
freed up for the SYSTEM tablespace.
Then you can do:
SQLalter database datafile 'path_to_system_tablespace' resize 800m;
800m is just an example.
This will work if the space you freed up are towards the end of the
datafile, not in
'ALTER DATABASE DATAFILE datafile RESIZE 1024M' will resize it to 1GB
Regards
Naveen
-Original Message-
Sent: Monday, February 03, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
guys,
one of my instances here...
has SYSTEM tablespace of size 25G (with one datafile).
it has lot
Eric,
Not sure what you're talking about but here's a stab in the dark...
set sqlprompt mydb.myusername
This changes the output prompt, but not the prompt in the header of the window bar.
If you can figure this one out, please let me know too.
Rgs,
Leng.
-
Hi
SITUATION - On a production APP Server having about 4000 Concurrent application
processes ,
the memory allocated does NOT seem to be getting freed even though the application
program is issuing the respective call to Free the memory .
Qs Any /etc/system parameters , OS patches which should
28 matches
Mail list logo
