 | | | Oracle List | | On Friday 06 January 2006 11 10 Ken Payton wrote
> Anyone using a good data modeling tool supported on Linux?
Kinda depends on what you mean by 'good ' and by 'data modeling '.
I happen to like OracI think you are saying redo instead on undo.
800GB/day is quite a lot. It depends on whether
your i/o subsystem can sustain this throughput. This can be found out from the storage vendor.
New York New York (downtown) company needs an Oracle DBA with SAP Basis
experience
to join their staff.
Salary range 90-120K..depends on experience.
As this position is in downtown NYC company waDoes anyone have a link to a decent ERD of Oracle 's V$ views (or an
e-copy)? I google 'd a bit on this and most info that I checked referred
to products that you could build a diagram vs. having one. Tracy
I believe that default values for pctfree-10/pctused-40 is not
something that is stored in the database.
I think those values are build in the RDBMS executables.
So to change it you have to beWe are seeing a significant number of these as being
reported by ADDM Report (10.1.0.4).
The suggestions as on Metalink point to have us
increase the rollback segments but since we are using
Auto U
Jeffrey Beckstrom <JBECKSTROM@(protected) > wrote I am looking at v$sort_segment and notice that if take total_blocks
(18848) times block size (8192) you get 147.25 M. Shouldn 't this equal
the 1000M
"J. Dex " <cemail_219@(protected) > wrote I am trying to stand up a database from a tape restore and rename it. The
restore did not include any of the temp datafiles but I think I know what
the teHey Guys
I am working with streams on RHEL4 & EE 10g R2. I have read the docs and
setup a capture DB and a apply DB. I built my scripts using the example
from Note 224255. However the capture job wIs there any issue or configuration required for defining SGA of around 16G on 32G IBM server using Linux RHEL x86_64. I am going to install Oracle 10g Rel 2 64 bit and is 4 node RAC cluster
ThaHello
Solaris 8
Oracle 9.2.0.4
The following piece of SQL is popping up in STATSPACK reports as expensive.
It runs about once an hour. I can see that it is executed as the SYS user
but I donLaura
I just did this quick test
SQL > create temporary tablespace mjbtemp tempfile
'/export/home/oracle/mjbtemp01.dbf ' size 1000m
Tablespace created.
SQL > alter database tempfile '/export/hom > > and hope that the alerts have already been issued at least the day
before I apply the patchset
Do not install a patchset straight away after it is realest. Wait 1/2 of year.
If you have been pushedNot sure about the wrapping but I believe CPU time can easily be double the elapsed time if you have two or more CPUs.
Regards
Brandon
-----Original Message-----
From oracle-l-bounce@(protected)Anyone used this feature yet in 10G R2 and have any idea what type of
CPU overhead is added for encrypting all/most of the data in a
database. Going to go look at the docs now but does this also encrThe only one benefit I heard that restores are faster for when the datafile size is smaller.
"Murching Bob " <bob_murching@(protected) > wrote Traditionally I 've used multiple data files for largHello
--
Edward Lewis
eglewis@(protected)
--
http //www.fastmail.fm - The way an email service should be
--
http //www.freelists.org/webpage/oracle-l
DEEDSD
I have heard good things about Confio DbFlash too...it has come up on this
list several times last year.
I have my own tool so I have (needed to) tired it. I believe it lacks log
file and DB > There is any way to remove column(s) from '* ' if it exists after
> without hardcoding all columns names?
No unfortunately. The '* ' is nothing more than a shorthand way of
selecting all columns.
Hi
I don 't have a Unix box with 10g handy to check on but on my windows
box there is a password file in the %ORACLE_HOME%\database directory
called PWD+ASM.ORA
Use orapwd to change the password fGood afternoon
Does anyone have any experience of moving SYSTEM/SYSAUX tablespace between
ASM disk groups? Can you provide a procedure of how does it work? Many
thanks
Sarah
--
http //www.freelisHi
SSX lock (in Oracle8i) maight be an indication of lock on a child table that
does not has an index on it 's foreign key.
Regards
Mindaugas
copy the two data file from primary again.
Datafile 7 'H \ORACLE\ORADATA\STBY\TOOLS01.DBF '
Datafile 8 'H \ORACLE\ORADATA\STBY\USERS01.DBF '
The the standby will not prompt to log 546
On 1/5/06 Hi Raja
I guess you issue is sligtly different from what is described in the link.
Your database is US7ASCII versus AL32UTF8 talked on the web page.
US7ASCII by definition supports ONLY ASCII characOk I 've read what must be every metalink and google result now and I still
don 't quite understand.
I 'm trying to create a database link from one database to another.
GLOBAL_NAME on the source datayou don 't need sudo to do login with password and run commands..
sudo is more for a use without password..
like David said set the sudoers file..
On 1/5/06 Johnson George <GJohnson@(protected) > wrotePSTEMP2 is the temporary tablespace. I just found my problem. My
temporary tablespace has ran out of space on disk.
Thanks for all your help.
Doris
-----Original Message-----
From Dennis WilliamHi all
I need a GUI tool or several GUI tools that will allow me to do those
things
- Copy data from different databases
- I should be able to select any object to copy
(table partition schema 's
It depends on how you 're looking and
probably which version of Oracle.
GTTs do not cause redo but the undo
on GTTs causes redo so the redo records
on a GTT have only one half of the usual
forwarwhat is the value of a.value+b.value?
On 1/4/06 Onkar N Tiwary <onkarnath.tiwary@(protected) > wrote
>
> Hi
>
> WISH YOU ALL A VERY HAPPY NEW YR.
>
> To find the buffer hit ratio when I executed the |
|
|
