0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email I’m pleased to confirm that my paper ” Logging or Nologging: That is the Question!” submitted to the Perth and Gold Coast conferences was accepted. See you at: October,6 and 7 – AUSOUG…
What I need to know to become a DBA?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email About the DBA job: Most of the people that I talk to who have difficulties starting out in their DBA career really have an issue trying to absorb the mountainous volumes of information that…
LOGGING or NOLOGGING, that is the question – Part II
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email By Francisco Munoz Alvarez Redo Generation and Recoverability The purpose of redo generation is to ensure recoverability. This is the reason why, Oracle does not give the DBA a lot of control over…
LOGGING or NOLOGGING, that is the question – Part I
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email By Francisco Munoz Alvarez Introduction The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever”, or just…
Differences between UNDO and REDO
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email To clear this question we have this table: UNDO REDO Record of How to undo a change How to reproduce a change Used for Rollback, Read-Consistency Rolling forward DB Changes Stored in Undo segments…
What is the difference between Rollback and Undo Tablespace? OTN Forum By user user503050
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email There might be confusion while undo and rollback segment terms are used interchangeably in db world. It is due to the compatibility issue of oracle. Undo Oracle Database must have a method of maintaining…
EM mess – by Slyt – OTN Forum
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email I tried to run EM on certain host: [oracle@SQLAB db10g]$ emctl dbconsole start TZ set to Poland EM Configuration issue. /u01/app/oracle/product/10.2.0/db10g/SQLAB_e2k not found. OK. No such dir indeed. So: [oracle@SQLAB db10g]$ emca -config dbcontrol…
want to migrate 9.2.0.1db on windows data to 10.2.0.2 db on SunOs10, and planning to use full exp/imp..will this work ? by DBA2008 – OTN Forum
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Hi DBA2008, I recommend you to create all the structure first, then import all the data. Pre-create tablespaces, users, and tables in the new database to improve space usage by changing storage parameters. When…
How to create a Temp Tablespace Group on 10g? by America OTN Forum
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Tablespace Groups Oracle now has the concept of grouping multiple tablespaces together in what they call a tablespace group. This allows you to create multiple temporary tablespaces, assign these temporary tablespaces to a tablespace…
can someone tell any difference between express edition and standard edition for oracle 10g – by seyiisq -OTN Forum
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Oracle XE: Express Edition (XE) is a free, downloadable version of the Oracle database server. Oracle XE can only be used on single processor machines. It can only manage up to 4 GB of…