|
||||
|
Does flashback logs generates even if the flashback option is disabled? Answer: Yes, when you have guaranteed restore point exists in your database. No, if you does not have guaranteed restore point. Please read further. SQL> select log_mode,flashback_on from v$database; LOG_MODE FLASHBACK_ON ———— —————— ARCHIVELOG NO SQL> […] In Oracle 11gR2 11.2.0.2 there is a new clause added to the truncate table SQL statement allowing to release the space allocated even for extents corresponding to the minextents storage clause. Prior to 11.2.0.2 truncate table statement with its different flavor of clauses was used to delete all the rows from the table and possibly […] The following is the real nice work from http://intermediatesql.com/oracle/what-is-the-difference-between-sql-profile-and-spm-baseline/ This was very good post and awesome write up which help my blog readers too. End to end on sqlprofiles and spm, happy reading, thanks to Maxym.
SQL Profiles Note —– – SQL profile "SYS_SQLPROF_012ad8267d9c0000" used FOR this statement
and […] Hi, Suppose you have been asked about how much reads/writes happening and what are the wait events that occured for a object(table) in a given period or overall. so then read on…. We have different ways to get the Table level statistics like waits/reads/logical reads/physical reads /writes etc.
1) In Oracle 8i […] Hello All, One of our fellow DBA posted me this link about disk basics and disk partitioning in solaris servers. Thanks to him (Shiva Krishna) Nice video. Thanks to the author. Hope this helps you all to understand the basics of disk management. [youtube=http://www.youtube.com/watch?v=HExfJZ_Qd3Y] Hi, Thanks to my colleague(Bhanu) fo raising this, Issue with ASM disks not persistent in reboot (due to some mis configuration in creating devices or its assignments, thats a different story) causing ASM disks to be failed, fortunately the Voting Disk and the OCR were on the normal redundancy group which does not lid […] How many types of SCN, well the better question would be how many places the SCN is stored. Well, there are not MANY types of SCN which are there actually but stored many places with different names and different purposes. The SCN will be only one number, a incremented value of every 3?(5 seconds […] Hello Thanks to my colleague (Satish) to share this. Here is the nice script to find the relative object name that is having block corruption, ofcourse the the v$database_block_corruption will populate only when you run the rman command. 1) RMAN> Backup validate check logical database; This will populate the v$data_block_corruption with rows about the blocks […] Tracing datapump is not straight forward, you can trace the datapump worker(dw00) or datapump master(DM00) with 10046 to get the sql etc or use the TRACE option in expdp/impdp Where in expdp has an option called trace where you can trace the session associated to datapump and then see what its waiting for or running […] Hello, When using parallel query, Oracle uses one of these methods of performing parallel queries or DML: Parallelize by block range Parallelize by partition Parallel processing using slave processes go and read on […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!