Space weather

https://www.swpc.noaa.gov/products/wsa-enlil-solar-wind-prediction

Oracle events

Oracle SQL Trace and TKPROF

Event # Level Description
8186 – ALTER SESSION SET EVENTS ‘8186 trace name context OFF’ – VERSIONS BETWEEN query
10005 – Trace latch operations for debugging
10013 1 Monitor Transaction Recovery
10015 1 Dump Undo Segment Headers
10015 3 Identify corrupt undo segments
10021 – KST event to trace control file header writes and reads
10022 – Trace ktsgsp
10027 – Specify Deadlock Trace Information to be Dumped
10028 – Dump trace information during lock / resource latch cleanup
10032 4 Dump Sort Statistics
10031 – Sort Debug Events
10032 10 Dump Sort Statistics
10033 4 Dump Sort Large Run Statistics (blocks dumped to disk and read back) – poss. no levels.
10033 10 Dump Sort Intermediate Run Statistics
10038 – Dump row source tree (QBADRV)
10041 – Dump undo records skipped
10045 1 Trace Free List Management Operations
10046 0 No statistics generated
10046 1 Standard trace output including parsing, executes and fetches plus more
10046 2 Same as Level 1
10046 4 Level 1 + Bind Variables
10046 8 Level 1 + Waits
10046 12 Level 1 + Bind Variables & Waits
10047 – Trace Session Switching
10050 – Sniper Trace
10053 1 CBO ENABLE Optimizer Trace: Dump Optimizer Statistics and Computations
10053 2 CBO ENABLE Optimizer Trace: Dump Optimizer Computations only
10054 – CBO Enable optimizer trace for recursive statement (RPI)
10056 – Dump analyze stats (kdg)
10060 1 Traces a SQL statement ensuring rows column will be populated. See Metalink Note 246821.1
10065 1 Restrict Library Cache Output for State Object Dumps – Library Objects Only
10065 2 Restrict Library Cache Output for State Object Dumps + library object lock details
10065 3 Restrict Library Cache Output for State Object Dumps + library object handle and library object
10072 – Local tempspace tracing – recovery layer
10073 – Latch Cleanup Tracing
10074 – Default trace function mask for kst
10079 2 Trace data sent/received via SQLNet: Dump SQLNet Statistics
10080 – Dump a block on a segment list which cannot be exchanged
10081 1 Dump High Water Mark Changes
10083 – Trace IMCDT in LIMITED mode
10095 – Dump debugger commands to the trace file
10104 10 Dump Hash Join Statistics to the trace file
10128 1 Dump Partition Pruning Information
10128 2 Dump partition iterators
10128 4 Dump optimizer decisions about partition-wise joins
10128 8 Dump ROWID range scan pruning information
10132 12 Dumps SQL statements along with the actual, after compilation, execution plan
10134 – Trace SQL Memory Management for session
10146 – Enable Oracle TRACE collection
10148 – Quarantine trace event
10166 – Trace long operation statistics updates
10200 1 Dump Consistent Read Buffer Status
10201 1 Dump Consistent Read Undo Application
10210 10 Table Integrity Check
10211 10 Index Integrity Check
10216 – Dump the control file header
10218 – Dump the UBA of applied undo
10220 1 Dump Changes to Undo Header
10221 7 Dump Undo Changes
10224 1 Dump Index Block Splits / Deletes Trace
10225 1 Dump Changes to Dictionary Managed Extents
10226 – Trace CR applications of undo for data operations
10228 – Trace application of redo by kcocbk
10231 10 Causes full table scans to skip corrupt blocks, rather than fail with an ORA-01578 error
zzyzx ALTER SESSION SET EVENTS=’10231 trace name context forever’;
10232 10 Dump corrupted blocks symbolically when kcbgotten to the process trace file
10233 10 Traces memory usage statistics
10235 1 Check memory manager internal structures (use with ORA-600/ORA-7445 errors)
10236 – Dump redo on object no. or block type mismatch errors 1410/8103
10241 1 Dump Remote SQL Execution Tracing/Validation
10246 1 Trace PMON Process actions to the trace file
10247 – Turn on scgcmn tracing (VMS ONLY)
10248 10 Trace Dispatcher Processes
10249 10 Trace Shared Server (MTS) Processes (multi-stated servers)
10250 – Trace all allocate and free calls to the topmost SGA heap
10254 – Trace cross-instance calls
10257 – Trace shared server load balancing
10266 – Trace OSD stack usage
10270 10 Debug Shared Cursors
10289 1 Dump a database block in hexadecimal rather than formatted
10290 – Internal sequence tracing event
10292 – Hang analysis trace event
10293 – Trace log switch media recovery checkpoints
10294 – Trace ksrpc
10297 – Trace shared I/O pool
10298 – Trace ksfd I/O
10299 1 Trace prefetch tracking decisions made by CKPT
10300 – Distributed transaction tracing
10302 – Trace create or drop internal trigger
10303 – Trace loading of library cache for internal triggers
10304 – Trace replication trigger
10305 – Trace updatable materialized view trigger
10306 – Trace materialized view log trigger
10307 – Trace RepCat execution
10310 – Trace synchronous change table trigger
10318 – Trace extensible transaction header movements
10319 – Trace PGA statistics maintenance
10320 – Enable data layer (kdtgrs) tracing of space management calls
10325 – Trace control file record section expand and shrink operations
10333 – Dump MTTR statistics each time it is updated
10335 – Trace database open status
10347 – Dump active checkpoint entries and checkpoint buffers
10357 1 Debug Direct Path
10366 – kgnfs tracing
10367 – kgodm tracing
10384 – parallel dataflow scheduler tracing
10390 0x0001 Dump Parallel Execution Slave Statistics – Slave-side execution messages
10390 0x0002 Dump Parallel Execution Slave Statistics – Coordinator-side execution messages
10390 0x0004 Dump Parallel Execution Slave Statistics – Slave context state changes
10390 0x0008 Dump Parallel Execution Slave Statistics – Slave ROWID range bind variables and xty
10390 0x0010 Dump Parallel Execution Slave Statistics – Slave fetched rows as enqueued to TQ
10390 0x0020 Dump Parallel Execution Slave Statistics – Coordinator wait reply handling
10390 0x0040 Dump Parallel Execution Slave Statistics – Coordinator wait message buffering
10390 0x0080 Dump Parallel Execution Slave Statistics – Slave dump timing
10390 0x0100 Dump Parallel Execution Slave Statistics – Coordinator dump timing
10390 0x0200 Dump Parallel Execution Slave Statistics – Slave dump allocation file number
10390 0x0400 Dump Parallel Execution Slave Statistics – Terse format for debug dumps
10390 0x0800 Dump Parallel Execution Slave Statistics – Trace CRI random sampling
10390 0x01000 Dump Parallel Execution Slave Statistics – Trace signals
10390 0x02000 Dump Parallel Execution Slave Statistics – Trace parallel execution granule operations
10390 0x04000 Dump Parallel Execution Slave Statistics – Force compilation by slave 0
10391 0x0001 Dump Parallel Execution Granule Allocation – Summary of each object scanned in parallel
10391 0x0002 Dump Parallel Execution Granule Allocation – Full dump of each object except extent map
10391 0x0004 Dump Parallel Execution Granule Allocation – Full dump of each object including extent map
10391 0x0010 Dump Parallel Execution Granule Allocation – Summary of each granule generators
10391 0x0020 Dump Parallel Execution Granule Allocation – Granule generators except granule instances
10391 0x0040 Dump Parallel Execution Granule Allocation – Granule generators including granule instances
10391 0x0080 Dump Parallel Execution Granule Allocation – System information
10391 0x0100 Dump Parallel Execution Granule Allocation – Reference object for the query
10391 0x0200 Dump Parallel Execution Granule Allocation – kxfralo timing
10391 0x0400 Dump Parallel Execution Granule Allocation – Affinity module
10391 0x0800 Dump Parallel Execution Granule Allocation – Granule allocation during query execution
10391 0x1000 Dump Parallel Execution Granule Allocation – Object flush
10393 1 Dump Parallel Execution Statistics
10399 – Trace buffer allocation
10401 1 KSXP tracing: for RAC kernel
10402 1 SKGXP tracing: for RAC kernel minimal tracing
10402 127 SKGXP tracing: for RAC kernel maximum tracing
10412 – Dump the call stack if an error is signaled
10420 – Trace KSO OS-process operations
10421 – Enable dump from ksbwco if there is no reply
10423 – dump the call stack if the specified error is cleared
10425 – Enable global enqueue operations event trace
10426 – Enable ges/gcs reconfiguration event trace
10427 – Enable global enqueue service traffic controller event trace
10428 – Enable tracing of global enqueue service cached resource
10429 – Enable tracing of global enqueue service IPC calls
10430 – Enable ges/gcs dynamic remastering event trace
10432 – Enable tracing of global cache service fusion calls
10434 – Enable tracing of global enqueue service multiple LMS
10435 – Enable tracing of global enqueue service deadlock detetction
10437 – Enable trace of global enqueue service S optimized resources
10439 – Enable tracing of global cache service fusion calls – part 2
10440 – Enable global enqueue service inquire resource modes trace
10441 – Enable diagnosibility daemon (DIAG) trace
10442 – Enable trace of kst for ORA-01555 diagnostics
10445 – Enable tracing of LMS priority management
10448 – Dump trace for OLTP partial compression features diagnostics
10449 – Enable trace of kst for undo manageability features diagnostics
10453 – Dump compression statistics to trace file
10472 – Dump reading log buffer hit ratio histogram to LGWR trace file
10473 – Enable BRR tracing
10474 – Controlfile time tracing
10478 – DBW0 file identification trace event
10484 – Enable tracing for online data file move operation
10487 – Dump redo memory protection information
10488 – Dump block headers read for media recovery
10490 – Trace OSM misc. events
10491 – Trace OSM messaging (KFN) events
10492 – Trace OSM metadata events
10494 – Trace OSM metadata events
10495 – Trace OSM metadata events
10497 – Trace OSM metadata events
10499 – Trace OSM metadata events
10500 1 Trace SMON Process
10505 – CBO enable dynamic sampling dump to table
10507 – Trace bind equivalence logic
10254 – CMON connection pool trace event
10526 – Enable lightweight thread tracing
10527 – Enable SGA allocation tracing
10528 – Enable ksmg tracing
10529 – Enables SGA range protection tracing
10542 – Enable tracing for block compare
10556 – Enable tracing for multi instance Redo Apply
10569 – Trace datafile header writes
10601 32 Forces the database to consider SQL*Plus a foreign SQL application
10604 – Trace parallel create index
10606 – Trace parallel create index
10607 – Trace index rowid partition scan
10608 10 Trace Bitmap Index Creation
10609 – Trace for array index insertion
10610 – Trace create index pseudo optimizer
10622 – Test or trace online index build or rebuild
10625 – Turn off redo log dump for the index when OERI 12700
10627 – Dump the content of the index leaf block
10639 – Dump library cache during reparse loops
10690 – Set shadow process core file dump type (Unix only)
10692 – Trace preserving buffer across standby role transition
10701 – Dump direct loader index keys
10704 1 Trace Enqueues
10706 1 Trace Global Enqueue Manipulation
10708 10 Print out trace information from the RAC buffer cache
10710 1 Trace Bitmap Index Access
10711 1 Trace Bitmap Index Merge Operation
10712 1 Trace Bitmap Index OR Operation
10713 1 Trace Bitmap Index AND Operation
10714 1 Trace Bitmap Index MINUS Operation
10715 1 Trace Bitmap Index Conversion to ROWIDs
10716 1 Trace Bitmap Index Compress / Decompress
10717 1 Trace Bitmap Index Compaction for Index Creation
10719 1 Trace Bitmap Index DML
10720 – Trace database scheduling
10722 – Trace server level database scheduling
10724 – Trace cross-instance broadcast
10730 1 Trace Fine Grained Access Policy Predicates
10731 1 Dump SQL for CURSOR expressions
10731 2 Dump SQL for CURSOR expressions
10741 – Trace missing BRR generation
10742 – Dump process state on flush buffer_cache
10743 – Define the misbehaved vt dump thresholds
10744 – Disable LMD stale cvak traces and dumps
10756 – Event to enable svpt/autotxn tracing
10757 – Event to control tracing row source: rows to dump per rowset
10758 – Event to control tracing row source: start row number
10759 – Event to control tracing row source: end row number
10760 – Event to control tracing row source: maximum encoded operands to check
10761 – Event to control tracing row source: size of dictionary
10780 – LogMiner API trace event
10781 – LogMiner reader trace event
10782 – LogMiner preparer trace event
10783 – LogMiner builder trace event
10784 – LogMiner dictionary trace event
10785 – LogMiner trace event
10787 – Trace intra-instance broadcast
10788 – Trace call stacks
10790 – LogMiner trace event
10791 – Logical Standby swithover/failover trace event
10792 – Logical Standby XDAT trace event
10793 – Logical Standby trace event
10794 – Logical Standby trace event
10795 – Time Drift (VKTM) Detection Process Trace Event
10796 – Elevate Scheduler Priority trace event
10800 – Disable Smart Disk Scans
10801 – Enable Smart Disk Trace
10805 – Trace state object operations
10809 – Trace state object allocate / free history
10810 – Trace snapshot too old
10811 – Trace block cleanouts
10812 – Trace Consistent Reads
10826 – Enable upgrade/downgrade error message trace
10830 – Trace group by sort row source
10831 – Trace group by rollup row source
10832 – Trace approximate NDV row source
10839 – Trace / debug caching module (qesca.c)
10840 – Trace / debug pl/sql caching module (kkxmInitCache)
10842 – Event for OCI Tracing and Statistics Info
10843 – Event for client result cache tracing
10845 – Enable Director tracing
10847 – OCI dump action is being invoked for internal error ORA-
10850 – Enable time manager tracing
10852 – Enable dumping of the AQ statistics hash table, Enable tracing for Enqueue Dequeue Operations
10853 – Enable tracing for Replicating AQ Operations
10865 – Control tracing of notification operations
10871 – Dump file open/close timestamp during media recovery
10880 – Trace Java VM execution
10883 – Event for Fast Application Notification tracing
10893 – TTC trace event
10907 – Trace extent management events
10908 – Trace temp tablespace events
10909 – Trace free list events
10924 – Import Storage Parse Error Ignore Event
10925 – Trace PL/SQL Execution
10926 – Trace name context forever
10927 – Trace name context forever
10928 1 Trace PL/SQL Execution
10929 – Trace name context forever
10930 – Trace name context forever
10931 – Trace name context forever
10932 – Trace name context forever
10933 – Trace name context forever
10934 – Trace name context forever
10936 – Trace name context forever
10937 – Trace name context forever
10938 1 Trace PL/SQL Execution Statistics
10939 – Trace name context forever
10940 – Trace name context forever
10941 – Trace name context forever
10943 – Trace name context forever
10944 – Trace name context forever
10945 – Trace name context forever
10946 – Trace name context forever
10947 – Trace name context forever
10948 – Trace name context forever
10960 – AQ tracing event
10961 – Enable tracing for Scheduler subscriber cleanup
10975 – Trace execution of parallel propagation
10976 – Internal package related tracing
10977 – Trace event for RepAPI
10979 – Trace flags for join index implementation
10990 – Dump spreadsheet info
12500 10 The SMON time mapping is mainly for flashback type queries to map a time to an SCN so it is probably simplest to copy the content to a holding table then delete ALL rows, then recycle the instance.SMON should start to populate the table with new time / SCN pairs from the time that the instance is started. Setting the 12500 event at system level should stop SMON from updating the SMON_SCN_TIME table.
12760 – ACMS tracing event
16300 – LSBY architected tracing event
16499 – Dump redo transport information
16605 – Event to control fast-start failover diagnostic tracing
16634 – Event for Data Guard NetSlave tracing
16752 – Dump System State
16756 – Dump Hang Analysis
22829 – Enables lateral queries using the undocumented LATERAL() operator
ALTER SESSION SET EVENTS ‘22829 TRACE NAME CONTEXT FOREVER’;
28400 Enable TDE Tracing
28401 1 Disables the sleep time for logon failures caused by row cache locks leaving the system more vulnerable to brute force password attack
28402 Disable TDE Tracing
44410 0 xmlagg() with a GROUP BY can fail with ORA-22813 if the result is too large. No statistics
44410 1 Basic statistics CURSOR, PARSE, EXEC, FETCH ERROR, SORT UMAP, ERROR, UMAP, STATS and XCTEND.
44410 2 Same as level 1
44410 4 Level 1 plus binds
44410 8 Level 1 plus wait events
44410 12 Combine levels 4 and 8

AIX – kto pouziva zmazane subory

okrem ineho sa da aj takto zistit

fuser -V -d

Oracle Blog

Tento chlapik ma velmi zauimavy Oracle Blog

https://blog.tanelpoder.com

 

Upratovanie controlfajlu

execute sys.dbms_backup_restore.resetCfileSection( sectionid);

 

sekcia 11 je pre archlogy

12c – zoznam nedokumentovanych parametrov

select
ksppinm,
ksppdesc
from
x$ksppi
where
subsur(ksppinm,1,1) = ‘_’
order by
1,2;

 

Pomale SMB na MacOS

Zda sa, ze apple implementoval feature SMB packet signingu na MacOS, ktora rapidne zabija troughput

na zistenie:

With your share mounted – execute the following command from a Terminal:

smbutil statshares -a

You should get a list of fields for each share you have currently connected. Here are some values to pay attention to:

  • SMB_VERSION – which SMB protocol version is active.
  • SIGNING_SUPPORTED – this means the server side supports signing, it does NOT mean signing is on.
  • SIGNING_ON – if “true” then signing is actually on for this connection.

 

Na vypnutie:

 

Buried in one thread on the Apple Discussion Forum is a suggestion to use the /etc/nsmb.conf file to disable client signing on the client end.

[default]
signing_required=no

After unmounting & remounting the SMB share, I verified this returns transfer speeds to normal.

You can do this in one single command as follows:

printf "[default]\nsigning_required=no\n" | sudo tee /etc/nsmb.conf >/dev/null

Then unmount and remount any SMB shares.

Portknocking a SSH

${IPTABLES} -A INPUT -p tcp --dport 7777 -m recent --set --name portknock
${IPTABLES} -A INPUT -p tcp --syn --dport 22 -m recent --rcheck --seconds 60 --name portknock -j ACCEPT
${IPTABLES} -A INPUT -p tcp --syn --dport 22 -j DENY

snad po 60ty krat;) iptables restore pri boote elegantne

apt-get install iptables-persistent

On install, it should save your current iptables config. Otherwise you can save them to these files (depending on v4 or v6) and iptables-persistent will load them on boot 🙂

iptables-save > /etc/iptables/rules.v4
ip6tables-save > /etc/iptables/rules.v6

“strace” na MacOS & SIP

..sa vola dtrace

/usr/sbin/dtrace a ma niekolko uskali

1;) vyzaduje root-a, odporucam sudo dtrace sudo -u myuser traced_command

2;) existuje nieco ako SIP

As you may now Apple released their new OS X revision 10.11 this year with a great security feature built-in: System Integrity Protection. In a nutshell, this mechanism protects any system data and important filesystem components (like /System or /usr) from being modified by user; even if they are root. SIP also disables any use of code-injection and debugging techniques for third-party software, so some of your favorite hacks may not work anymore. – ;))

mile od Applu Anyway:

Completely disable SIP

Although not recommended by Apple, you can entirely disable System Integrity Protection on you Mac. Here’s how:

  1. Boot your Mac into Recovery Mode: reboot it and hold cmd+R until a progress bar appears.
  2. Choose the language and go to Utilities menu. Choose Terminal there.
  3. Enter this command to disable System Integrity Protection:
    $ csrutil disable
  4. It will ask you to reboot — do so and you’re free from SIP!
The Good

You’re able to do anything you want with the OS, yay! ٩(⸝⸝⸝◕ั ௰ ◕ั⸝⸝⸝ )و

The Bad

You’re not safe: there’re plenty of rootkits in a wild which can infect your system. Actually, you’re as safe as on OS X 10.10 or 10.9, so judge for yourself.

Partially disable SIP

Fortunately, SIP is not monolithic: it’s built from many different modules we can disable/enable separately. Let’s take a look at a typical csrutil status output:

$ csrutil status
System Integrity Protection status: enabled

Configuration:
    Apple Internal: enabled
    Kext Signing: enabled
    Filesystem Protections: enabled
    Debugging Restrictions: enabled
    DTrace Restrictions: enabled
    NVRAm Protections: enabled

I can count 6 different subsystems out here. Here’s the way to selectively disable any of them:

  1. Repeat steps 1 and 2 from «Completely disable SIP» section above.
  2. Now in Terminal enter these commands:
    $ csrutil clear # restore the default configuration first
    $ csrutil enable --without dtrace # disable dtrace restrictions *only*

    That’s it: use csrutil enable + --without flag with a name of a module you want to disable:

    $ csrutil enable --without kext
    $ csrutil enable --without fs
    $ csrutil enable --without debug
    $ csrutil enable --without dtrace
    $ csrutil enable --without nvram
    # this one below is different, not sure why. Don't encourage you to disable it anyways…
    $ csrutil enable --no-internal
  3. Reboot and enjoy your OS again.
The Good

If you only disable dtace module you’re still quite safe: SIP will keep an eye on your filesystem and kernel extensions as well as on any software trying to inject code.

The Bad

You’re still unable to attach dtrace to restricted processes

$ sudo dtruss echo "demo" dtrace: failed to execute echo: dtrace cannot control executables signed with restricted entitlements

alebo spusti vo virtualke

( http://internals.exposed/blog/dtrace-vs-sip.html )