Wednesday, April 13, 2016

COLLABORATE16: Day 2 (and lots of Me!)

Database Security - Case Study for Enterprise License Features - @aprilcsims

Oracle External Password Store - something worth looking into so you do not need to put passwords in clear text or pass them around.
Some features in Advanced Security Option now moved to Enterprise License (and free) because of Cloud encryption needs.
271825.1 - Passwords "Is the password encrypted when I logon"
Wireshark can see scripts in plain text if there is no encryption!
Database auditing - table privileges, system privileges, logon/logoff trigger- AUDIT SESSION WHENEVER NOT SUCCESSFUL is the base you need to start with.
dba_stmt_audit_opts - a new table I did not know about!
1299033.1, 553225.1
LogRotate on Linux - this might be worthwhile for our environment!
Open Source product LogSearch lets you collate log files for analysis later.
Use orapki to create the wallet with -auto_login_local so it can't be transferred to another server!
1114599.1 testing the wallet on another server
Sqlnet.ora parameter WALLET_LOCATION
Dead Connection Detection - zero length packets being dropped by the new Cisco router!
Some Unified Auditing is on with a fresh 12c DB installation so check v$options!

Blogging: The How and Why to Propel Your Career -

You may ask yourself "why are you going to a session on blogging if you already blog?" and that would be a great question but I think there is always room for improvement in all things so I went to several sessions during the conference on this topic to try and pick up new tips or tricks that can make me deliver better content to my readers.

Craig redesigned his website to focus on Oracle performance because he had a site that was not focused at all and it was difficult to decide what to do.
The plan: making the best decision, getting started, what to write about, tuning your blog.
Are you interested in blogging?  You can download this from soon!
Blogging takes time, so WHY do it?  Help others, help yourself, career goals - OracleACE, independent consultant, business owner, shift in career path, career development.
A blog is your living resume
"Inbound marketing"
What you can expect: perceived as an authority, develop a following, think a question through to completion, become a better writer and communicator, increased conference participation, develop thicker skin, encouragement (from readers) is a life giving.
Turned comments off - this was interesting to me, and made me think a bit!
Define your objectives: be honest about your market and impress them, do not do it just to be famous.
Measure your objectives: views, clicks and downloads, email volume, conference invites, career objectives, recognition, registrations for on-site training, memberships, consulting work.
Purposefully design your blog: reflection of you, aligns with objectives, easy to read, easy to be found, easy to migrate, easy to change format, easy to build content.
Choosing a platform: hubspot, wordpress, blogger, build your own.
Learn to create basic graphics - a good tip that I took away, and something I have heard in another arena and an obvious weakness in my armor.
How often to post?  Once a week, keep content size and scope very small 3:1 rule, break up larger topics into a series, mix "how it works" to "how to do" - this ws pretty interesting too, because when I fail to post I see it as a failure but Craig seems to be saying to reduce the amount of content so you do not burn out.
What to write about?  Watch and listen to what others are interested about, write what you have already written about, what interests you, what other people are wondering about (Cloud anybody?)
Tuning your blog, pictures, sign up, latest/popular posts, charts, video - all great tips to take away!
SEO: be easy to be found, be the answer to the question, create a title as if solving a problem, use Google to suggest titles, repeat key words in your post, content is king - don't try to fool Google.
Make it enjoyable, spacing easier to read!
Search "inbound Marcus" for an ebook about the topic.

Analyzing Oracle Workflow Data for Increased System Performance - Me!

Right after lunch can be a difficult spot to be in, but I was pleasantly surprised when about 20 people showed up and seemed to be enjoying the session!  They even asked some really good questions which should give me some good ideas for the next version of this presentation.

OAUG Workflow SIG Meeting - Various (and Me!)

Check out the website for the presentation that John Peters put together!
We also had a visit from Oracle and they demoed the Mobile approval solution which was great!  I am thinking about trying to lead a project to get this going at work, that is how great it looks!!
Oh, and I am a Board Member of this SIG as well now!  I do not know what title or role, but I am there!

E-Business Suite R12: Application Lessons Learned for Support and Implementers - Me!

Even though there were about 100 people that had showed interest in this in the application, I was REALLY surprised when I had around 40 people show up for this session!  I did get time to add some new information to the presentation, even something I have not blogged about yet, and was able to cover all of the content in 46 minutes (obviously shooting for 45 so I was happy) with a lot of people writing MOS notes down or making notes about some of the project lessons that came from our experience (and did not have MOS notes)!

Deep Dive into the Internals of a SELECT Statement -

I was really interested to get a lot more on this topic after the session I had the day before that was all talking about finding out when a parse is hard, soft, soft hard, or harder soft, if you are having issues running a SQL statement and while I did not get as much out of it as I thought, I really was inspired to start digging deeper into the internals!

Cursorttrace level 580, address <hash_value from v$sql>
Oradebug setmypid
Oradebug set library_cache 4
obj$, tab$, ind$, seg$, objauth$ - Data Dictionary information
10053 trace shows a lot of this data
x$bh is the buffer header structure

No comments:

Post a Comment