ora600tom.wordpress.com
Jun-13 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2013-notes/june-2013
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Oracl 12c optimization changes:-. Similar to cardinalty feed back in the previous versions. Make use of the past execution statistics and create new better plan. Http:/ docs.oracle.com/cd/E16655 01/server.121/e15858/tgsql astat.htm#TGSQL451. Database can gather stats for any bulk load. For a partitioned table, global...
ora600tom.wordpress.com
Apr-13 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2013-notes/apr-13
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Http:/ www.oraclealchemist.com/news/cloning-your-oracle-installation/. IPMI – Intelligent Platform Management Interface. U01/app/11.2.0.3/grid/bin/crsctl set css ipmiadmin radmin $ IPMI BMC password: CRS-4229: The IPMI information change was successful. Where radmin is the administrative user for IPMI. Ipmi si 33377 0.
ora600tom.wordpress.com
Aug-14 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2014-notes/aug-2014
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. While activating the standby database, hit an internal error. ALTER DATABASE ACTIVATE STANDBY DATABASE. ERROR at line 1:. ORA-00600: internal error code, arguments: [krse arc complete.4], [], [], [], [], [], [], [], [], [], [], []. ALTER DATABASE ACTIVATE STANDBY DATABASE. ERROR at line 1:. Pre cellCLI LIST ACTIVEREQUEST.
ora600tom.wordpress.com
2013 Notes | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2013-notes
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Please select from the menu. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Notify me of new comments via email.
ora600tom.wordpress.com
May-14 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2014-notes/may-14
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. OS watcher location in Exadata (Linux). To see a compressed file. Bzcat file name head -10. SQL monitor details using DBMS SQLTUNE. DBA HIST ACTIVE SESSION HISTORY aggregate with SQL PLAN LINE ID or SQL PLAN OPERATION to see in which line operation the time is spent. You can purge / enable /disable storage indexes. Exada...
ora600tom.wordpress.com
2014 Notes | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2014-notes
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Please select from the menu. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Notify me of new comments via email.
ora600tom.wordpress.com
RMAN | Thomas Saviour's Blog
https://ora600tom.wordpress.com/rman
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. RMAN – Block Recovery using Flashback Log. In this post, I will explain how RMAN can recover a corrupted block with out a backup but from Oracle Flashback Logs. This is a new feature in 11g. To start with I have enabled the flashback in the database level, which will capture all changes to the database. Both copy and RMA...
ora600tom.wordpress.com
May-13 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2013-notes/may-2013
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Hanganalyze using oradebug for identifying blocking sessions. SQL oradebug setmypid SQL oradebug dump hanganalyze 3 SQL oradebug tracefile name. Http:/ oracle-randolf.blogspot.co.uk/2011/01/adaptive-cursor-sharing.html. Http:/ www.oracle.com/pls/db112/homepage. DB FLASH CACHE FILE= link to the SFC. LAG and LEAD functions...
ora600tom.wordpress.com
Mar-14 | Thomas Saviour's Blog
https://ora600tom.wordpress.com/mynotes/2014-notes/march-14
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. LOG BUFFER size can vary from 8MB to 256MB. If ASYCHORNUS log transport is configure, it is better to keep log buffer 128MB or above to enable ‘in memory log’ hits for log transport. See the note: 951152.1. See the view x$logbuf readhist. About exadata storage indexes, by Arup :. Leave a Reply Cancel reply. Get every new...
ora600tom.wordpress.com
Scripts and Tips | Thomas Saviour's Blog
https://ora600tom.wordpress.com/scripts-and-tips
Thomas Saviour's Blog. ORA-19566 with Free Extents. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Oracle Session and Process Tracing. Faster Primary Key creation or enabling. Your daily scripts. Add a comment if you want a new script. Oracle Session and Process tracing. DBA HIST SYSMETRIC SUMMARY. Dba hist active sess history. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Streams – we do.
SOCIAL ENGAGEMENT