oraclespin.com
Disclosure | An Oracle Spin by Alex Lima
https://oraclespin.com/disclosure
An Oracle Spin by Alex Lima. Sharing My Database Experience. The articles, scripts and all information I publish in my blog are from my experience, readings and sometimes only applied on test systems and different platforms. I do not recommend apply any information posted here in your production system without fully test it in your testing systems. Product and company names mentioned in this website may be the trademarks of their respective owners. Click to email (Opens in new window). March 30, 2015 at ...
oraclespin.com
Oracle Default Users | An Oracle Spin by Alex Lima
https://oraclespin.com/2016/11/28/oracle-default-users
An Oracle Spin by Alex Lima. Sharing My Database Experience. November 28, 2016. 8216;ANONYMOUS’ — HTTP access to XDB. 8216;APPQOSSYS’ — QOS system user. 8216;AUDSYS’ — audit super user. 8216;BI’ — Business Intelligence. 8216;CTXSYS’ — Text. 8216;DBSNMP’ — SNMP agent for OEM. 8216;DIP’ — Directory Integration Platform. 8216;DMSYS’ — Data Mining. 8216;DVF’ — Database Vault. 8216;DVSYS’ — Database Vault. 8216;EXDSYS’ — External ODCI System User. 8216;EXFSYS’ — Expression Filter. 8216;WMSYS’ — Wo...8216;XTIS...
oraclespin.com
Debug | An Oracle Spin by Alex Lima
https://oraclespin.com/tag/debug
An Oracle Spin by Alex Lima. Sharing My Database Experience. How to get dump or list parameters set at session level? May 28, 2012. Example of using tracefile identifier. January 7, 2012. How to turn on debug/trace when running RMAN? November 28, 2010. In Backup and Recovery. How to turn trace and set events using dbms system? August 21, 2009. OEM – Grid Control. SQL – DDL. View aoflima’s profile on Twitter. View alexlima’s profile on LinkedIn. SQLcl to view DDL oraclespin.com/2017/03/16/sql.
oraclespin.com
trace | An Oracle Spin by Alex Lima
https://oraclespin.com/category/trace
An Oracle Spin by Alex Lima. Sharing My Database Experience. How to get dump or list parameters set at session level? May 28, 2012. Example of using tracefile identifier. January 7, 2012. How to use dbms xplan to display execution plan? January 3, 2012. How to check if auditing is turned on and privilege auditing is turned on? January 1, 2012. How to get current session id, process id, client process id? May 15, 2011. Tom Kyte’s utility to collect statistics. Tom Kyte’s following routine is a utili...
oraclespin.com
dump | An Oracle Spin by Alex Lima
https://oraclespin.com/tag/dump
An Oracle Spin by Alex Lima. Sharing My Database Experience. How to get dump or list parameters set at session level? May 28, 2012. How to generate systemdump when the instance is hung? December 26, 2010. How to find/list the events set in a session? July 15, 2010. How to find shared libraries needed to run a binary? Depending on the platform different command may be available, below are the commands for AIX and SUN to find the shared libraries needed to run a binary. This may not show all the librar...
oraclespin.com
attributes | An Oracle Spin by Alex Lima
https://oraclespin.com/tag/attributes
An Oracle Spin by Alex Lima. Sharing My Database Experience. How to change properties/attributes of partition table? June 9, 2012. How to get cursor attributes? Http:/ msdn.microsoft.com/en-us/library/ms186256.aspx. February 15, 2010. OEM – Grid Control. SQL – DDL. View aoflima’s profile on Twitter. View alexlima’s profile on LinkedIn. Oracle continues to hammer at Amazon in the cloud on.mktw.net/2npxrAf. SQLcl to view DDL oraclespin.com/2017/03/16/sql. SQLcl to view DDL oraclespin.com/2017/03/16/sql.
theclevecrew.com
Uncategorized | The Cleve Crew
https://theclevecrew.com/category/uncategorized
We do FAITH, FAMILY and FUN! Skip to primary content. Skip to secondary content. August 27, 2016. Micah continues to ask us to take pictures of many of his creations. He’s definitely got a creative personality and loves to build. Here are this weeks’ pictures as requested by Micah. Miss Amy made us these phenomenal truffle cake pop deliciousness treats. We wanted to take a picture to show our appreciation! She made them to celebrate my birthday and they were the perfect choice! First Week of Homeschool.
theclevecrew.com
video | The Cleve Crew
https://theclevecrew.com/tag/video
We do FAITH, FAMILY and FUN! Skip to primary content. Skip to secondary content. August 27, 2016. Micah continues to ask us to take pictures of many of his creations. He’s definitely got a creative personality and loves to build. Here are this weeks’ pictures as requested by Micah. Miss Amy made us these phenomenal truffle cake pop deliciousness treats. We wanted to take a picture to show our appreciation! She made them to celebrate my birthday and they were the perfect choice! August 26, 2016. E had a g...
oraclespin.com
How to change properties/attributes of partition table? | An Oracle Spin by Alex Lima
https://oraclespin.com/2012/06/09/how-to-change-propertiesattributes-of-partition-table
An Oracle Spin by Alex Lima. Sharing My Database Experience. How to change properties/attributes of partition table? June 9, 2012. At times one would want to change properties/attributes of a table so new partitions are affected by change not the partitions already created, like example compression, change PCTFREE, default tablespace. 045;- enable compression for all operations and change PCTFREE. SQL ALTER TABLE scott.part table MODIFY DEFAULT ATTRIBUTES COMPRESS FOR ALL OPERATIONS PCTFREE 5;. Fill in y...
SOCIAL ENGAGEMENT