Search
Navigation
Top 60 Oracle Blogs
Oakies Blog Aggregator
Resumable
There are two questions about temporary space that appear fairly regularly on the various Oracle forums. One is of the form:
From time to time my temporary tablespace grows enormously (and has to be shrunk), how do I find what’s making this happen?
The other follows the more basic pattern:
My process sometimes crashes with Oracle error: “ORA-01652: unable to extend temp segment by %n in tablespace %s” how do I stop this happening?
Before moving on to the topic of the blog, it’s worth pointing out two things about the second question:
- First, it’s too easy to get stuck at the word temp and leap to the conclusion that the problem is about the temporary tablespace without noticing that the error message includes the specific tablespace that’s raised the problem. If, for example, you rebuild an index in a nominated tablespace Oracle first creates the index as a temporary segment (with a name like {starting_file_number}.{starting_block_number}) in that tablespace then renames it to match the original index name once the rebuild is complete and drops the old index.
- Secondly a process that raises ORA-01652 isn’t necessarily the guilty party – it may be the victim of some other process hogging all the available space when it shouldn’t. Moreover that other process may have completed and released its space by the time you start looking for the problem – causing extra confusion because your process seems to have crashed without a cause. Taking my example of an index rebuild – your index rebuild may fail because someone else was rebuilding a different index at the same time in the same tablespace; but when you check the tablespace all the space from their original index is now free as their rebuild completed in the interim.
So, before you start chasing something that you think is a problem with your code, pause a moment to double-check the error message and think about whether you could have been the victim of some concurrent, but now complete, activity.
I’ve listed the two questions as variants on the same theme because the workaround to one of them introduces the risk of the other – if you want to avoid ORA-01652 you could make all your data files and temp files “autoextensible”, but then there may be occasions when they extend far too much and you need to shrink them down again (and that’s not necessarily easy if it’s not the temporary tablespace). Conversely, if you think your data or temp files randomly explode to ludicrous sizes you could decide on a maximum size for your files and disable autoextension – then handle the complaints when a user reports an ORA-01652.
There are various ways you could monitor your system in near real time to spot the threat as it builds, of course; and there are various ways to identify potentially guilty SQL after the event. You could keep an eye on various v$ dynamic performance views or dba_ administrative views to try and intercept a problem; you could set event 1652 to dump an errorstack (or even systemstate) for post-crash analysis to see what that reported. Neither is an ideal solution – one requires you to pay excessive attention to the system, the other is designed to let the problem happen then leave you to clean up afterwards. There is, however, a strategy that may stop the problem from appearing without requiring constant monitoring. The strategy is to enable (selectively) resumable operations.
If a resumable operation needs to allocate space but is unable to do so – i.e. it would normally be about to raise ORA-01652 – it will suspend itself for a while going into the wait state “statement suspended, wait error to be cleared” which will show up as the event in v$session_wait, timing out every 2 seconds The session will also be reporting its current action in the view v$resumable or, for slightly more information, dba_resumable. As it suspends the session will also write a message to the alert log but you can also create an “after suspend” database trigger to alert you that a problem has occurred.
If you set the resumable timeout to a suitable value then you may find:
- the problem goes away of its own accord and the session resumes before the timeout is reached
or
- you receive a warning and have some time to identify the source of the problem and take the minimum action needed to allow the session to resume
Implementation
The parameter resumable_timeout is a general control for resumable sessions if you don’t handle the feature at a more granular level than the system.
By default this parameter is set to zero which translates into a default value of 7,200 seconds but that default doesn’t come into effect unless a session declares itself resumable. If you set the parameter to a non-zero value all session will automatically be operating as resumable sessions – and you’ll soon hear why you don’t want to do that.
The second enabling feature for resumable sessions is the resumable privilege – a session can’t control it’s own resumability unless the schema has been granted the resumable privilege – which may be granted through a role. If a session has the privilege it may set its own resumable_timeout, even if the system value is zero.
Assume we have set resumable_timeout to 10 (seconds) through the instance parameter file and restarted the instance. If we now issue (for example) the following ‘create table’ statement:
create table t1 (n1, v1 )
pctfree 90 pctused 10
tablespace tiny
as
select
rownum, cast(lpad('x',800) as varchar2(1000))
from all_objects
where rownum <= 20000
/
This will attempt to allocate 1 row per block for 20,000 blocks (plus about 1.5% for bitmap space management blocks) – and tablespace tiny lives up (or down) to its name, consisting of a single file of only 10,000 Oracle blocks. Shortly after starting, the session will hit Oracle error “ORA-01652: unable to extend temp segment by 128 in tablespace TINY”, but it won’t report it; instead it will suspend itself for 10 seconds before failing and reporting the error. This will happen whether or not the session has the resumable privilege – in this case the behaviour is dictated by our setting the system parameter. If you look in the alert log after the session finally errors out you will find text like the following:
2019-10-04T14:01:11.847943+01:00 ORCL(3):ORA-1652: unable to extend temp segment by 128 in tablespace TINY [ORCL] ORCL(3):statement in resumable session 'User TEST_USER(138), Session 373, Instance 1' was suspended due to ORCL(3): ORA-01652: unable to extend temp segment by 128 in tablespace TINY 2019-10-04T14:01:23.957586+01:00 ORCL(3):statement in resumable session 'User TEST_USER(138), Session 373, Instance 1' was timed out
Note that there’s a 10 (plus a couple) second gap between the point where the session reports that it is suspending itself and the point where it fails with a timeout. The two-extra seconds appear because the session polls every 2 seconds to see whether the problem is still present or whether it has spontaneously disappeared so allowing the session to resume.
Let’s change the game slightly; let’s try to create the table again, but this time execute the following statement first:
alter session enable resumable timeout 60 name 'Help I''m stuck';
The initial response to this will be Oracle error “ORA-01031: insufficient privileges” because the session doesn’t have the resumable privilege, but after granting resumable to the user (or a relevant role) we try again and find we will be allowed a little extra time before the CTAS times out. Our session now overrides the system timeout and will wait 60 seconds (plus a bit) before failing.The “timeout” clause is optional and if we omit it the session will use the system value, similarly the “name” clause is optional though there’s no default for it, it’s just a message that will get into various views and reports.
There are several things you might check in this 60 second grace period. The session wait history will confirm that your session has been timing out every two seconds (as will the active session history if you’re licensed to use it):
select seq#, event, wait_time from v$session_wait_history where sid = 373
SEQ# EVENT WAIT_TIME
---------- ---------------------------------------------------------------- ----------
1 statement suspended, wait error to be cleared 204
2 statement suspended, wait error to be cleared 201
3 statement suspended, wait error to be cleared 201
4 statement suspended, wait error to be cleared 201
5 statement suspended, wait error to be cleared 200
6 statement suspended, wait error to be cleared 200
7 statement suspended, wait error to be cleared 202
8 statement suspended, wait error to be cleared 200
9 statement suspended, wait error to be cleared 200
10 statement suspended, wait error to be cleared 200
Then there’s a special dynamic performance view, v$resumable which I’ve reported below using a print_table() procedure that Tom Kyte wrote many, many years ago to report rows in a column format:
SQL> set serveroutput on
SQL> execute print_table('select * from v$resumable where sid = 373')
ADDR : 0000000074515B10
SID : 373
ENABLED : YES
STATUS : SUSPENDED
TIMEOUT : 60
SUSPEND_TIME : 10/04/19 14:26:20
RESUME_TIME :
NAME : Help I'm stuck
ERROR_NUMBER : 1652
ERROR_PARAMETER1 : 128
ERROR_PARAMETER2 : TINY
ERROR_PARAMETER3 :
ERROR_PARAMETER4 :
ERROR_PARAMETER5 :
ERROR_MSG : ORA-01652: unable to extend temp segment by 128 in tablespace TINY
CON_ID : 0
-----------------
1 rows selected
Notice how the name column reports the name I supplied when I enabled the resumable session. The view also tells us when the critical statement was suspended and how long it is prepared to wait (in total) – leaving us to work out from the current time how much time we have left to work around the problem.
There’s also a dba_resumable variant of the view which is slightly more informative (though the sample below is not consistent with the one above because I ran the CTAS several times, editing the blog as I did so):
SQL> execute print_table('select * from dba_resumable where session_id = 373')
USER_ID : 138
SESSION_ID : 373
INSTANCE_ID : 1
COORD_INSTANCE_ID :
COORD_SESSION_ID :
STATUS : SUSPENDED
TIMEOUT : 60
START_TIME : 10/04/19 14:21:14
SUSPEND_TIME : 10/04/19 14:21:16
RESUME_TIME :
NAME : Help I'm stuck
SQL_TEXT : create table t1 (n1, v1 ) pctfree 90 pctused 10 tablespace tiny as select rownum,
cast(lpad('x',800) as varchar2(1000)) from all_objects where rownum <= 20000
ERROR_NUMBER : 1652
ERROR_PARAMETER1 : 128
ERROR_PARAMETER2 : TINY
ERROR_PARAMETER3 :
ERROR_PARAMETER4 :
ERROR_PARAMETER5 :
ERROR_MSG : ORA-01652: unable to extend temp segment by 128 in tablespace TINY
-----------------
1 rows selected
This view includes the text of the statement that has been suspended and shows us when it started running (so that we can decide whether we really want to rescue it, or might be happy to kill it to allow some other suspended session to resume).
If you look at the alert log in this case you’ll see that the name has been reported there instead of the user, session and instance – which means you might want to think carefully about how you use the name option:
2019-10-04T14:21:16.151839+01:00 ORCL(3):statement in resumable session 'Help I'm stuck' was suspended due to ORCL(3): ORA-01652: unable to extend temp segment by 128 in tablespace TINY 2019-10-04T14:22:18.655808+01:00 ORCL(3):statement in resumable session 'Help I'm stuck' was timed out
Once your resumable task has completed (or timed out and failed) you can stop the session from being resumable with the command:
alter session disable resumable;
And it’s important that every time you enable resumability you should disable it as soon as the capability is no longer needed. Also, be careful about when you enable it, don’t be tempted to make every session resumable. Use it only for really important cases. Once a session is resumable virtually everything that goes on in that session is deemed to be resumable, and this has side effects.
The first side effect that may spring to mind is the impact of the view v$resumable – it’s a memory structure in the SGA so that everyone can see it and all the resumable sessions can populate and update it. That means there’s got to be some latch (or mutex) protection going on – and if you look at v$latch you’ll discover that there;s just a single (child) latch doing the job, so resumability can introduce a point of contention. Here’s a simple script (using my “start_XXX” strategy to “select 1 from dual;” one thousand times, with calls to check the latch activity:
set termout off set serveroutput off execute snap_latch.start_snap @start_1000 set termout on set serveroutput on execute snap_latch.end_snap(750)
And here are the results of running the script – reporting only the latches with more than 750 gets in the interval – first without and then with a resumable session:
--------------------------------- Latch waits:- 04-Oct 15:04:31 Lower limit:- 750 --------------------------------- Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken Time ms ----- ---- ------ ------ ------ ------- ------- ------- ----- ------- session idle bit 6,011 0 0 0 0 0 0 0 .0 enqueue hash chains 2,453 0 0 0 0 0 0 0 .0 enqueue freelist latch 1 0 0 0 2,420 0 0 0 .0 JS queue state obj latch 1,176 0 0 0 0 0 0 0 .0 SQL> alter session enable resumable; SQL> @test --------------------------------- Latch waits:- 04-Oct 15:04:46 Lower limit:- 750 --------------------------------- Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken Time ms ----- ---- ------ ------ ------ ------- ------- ------- ----- ------- session idle bit 6,011 0 0 0 0 0 0 0 .0 enqueue hash chains 2,623 0 0 0 0 0 0 0 .0 enqueue freelist latch 1 0 0 0 2,588 0 0 0 .0 resumable state object 3,005 0 0 0 0 0 0 0 .0 JS queue state obj latch 1,260 0 0 0 0 0 0 0 .0 PL/SQL procedure successfully completed. SQL> alter session disable resumable;
That’s 1,000 selects from dual – 3,000 latch gets on a single child latch. It looks like every call to the database results in a latch get and an update to the memory structure. (Note: You wouldn’t see the same effect if you ran a loop inside an anonymous PL/SQL block since the block would be the single database call).
For other side effects with resumability think about what else is going on around your session. If you allow a session to suspend for (say) 3600 seconds and it manages to resume just in time to avoid a timeout it now has 3,600 seconds of database changes to unwind if it’s trying to produce a read-consistent result; so not only do you have to allow for increasing the size of the undo tablespace and increasing the undo retention time, you have to allow for the fact that when the process resumes it may run much more slowly than usual because it spends more of its time trying to see the data as it was before it suspended, which may require far more single block reads of the undo tablespace – and the session may then crash anyway with an Oracle error ORA-01555 (which is so well-known that I won’t quote the text).
In the same vein – if a process acquires a huge amount of space in the temporary tablespace (in particular) and fails instantly because it can’t get any more space it normally crashes and releases the space. If you allow that process to suspend for an hour it’s going to hold onto that space – which means other processes that used to run safely may now crash because they find there’s no free space left for them in the temporary tablespace.
Be very cautious when you introduce resumable sessions – you need to understand the global impact, not just the potential benefit to your session.
Getting Alerts
Apart from the (passive) views telling you that a session has suspended it’s also possible to get some form of (active) alert when the event happens. There’s an “after suspend” event that you can use to create a database trigger to take some defensive action, e.g.:
create or replace trigger call_for_help
after suspend
on test_user.schema
begin
if sysdate between trunc(sysdate) and trunc(sysdate) + 3/24 then
null;
-- use utl_mail, utl_smtp et. al. to page the DBA
end if;
end;
/
This trigger is restricted to the test_user schema, and (code not included) sends a message to the DBA’s pager only between the hours of midnight and 3:00 a.m. Apart from the usual functions in dbms_standard that returnn error codes, names of objects and so on you might want to take a look at the dbms_resumable package for the “helper” functions and procedures it supplies.
For further information on resumable sessions here’s a link to the 12.2 manual to get you started.
Video : Oracle REST Data Services (ORDS) : AutoREST
Today’s video is a demonstration of the AutoREST feature of Oracle REST Data Services (ORDS).
This is based on the following article.
I also have a bunch of other articles here.
The star of today’s video is Connor McDonald of “600 slides in 45 minutes” fame, and more recently AskTom…
Cheers
Tim…
Video : Oracle REST Data Services (ORDS) : AutoREST was first posted on October 7, 2019 at 8:05 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1)
As I promised in my previous post, I’m going to blog more frequently for a change. So here’s a blog entry about some “new” Oracle execution plan displaying scripts that I’ve had since 2011 or so - I just tidied them up recently and added some improvements too. My aim in this blog post is not to go deep into SQL tuning topics, but just show what these scripts can do.
New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1)
As I promised in my previous post, I’m going to blog more frequently for a change. So here’s a blog entry about some “new” Oracle execution plan displaying scripts that I’ve had since 2011 or so - I just tidied them up recently and added some improvements too. My aim in this blog post is not to go deep into SQL tuning topics, but just show what these scripts can do.
What’s new with Oracle database 12.2.0.1.190416 versus 12.2.0.1.190716
There are a couple of underscore parameters changed from spare to named ones.
It’s interesting to see that in sysstat, ‘spare statistic 2’ changed to ‘cell XT granule IO bytes saved by HDFS tbs extent map scan’. This obviously has to do with big data access via cell servers. What is weird is that this is the only version where this had happened.
parameters unique in version 12.2.0.1.190416 versus 12.2.0.1.190716 NAME -------------------------------------------------- _eleventh_spare_parameter _one-hundred-and-forty-seventh_spare_parameter _one-hundred-and-forty-sixth_spare_parameter _tenth_spare_parameter parameters unique in version 12.2.0.1.190716 versus 12.2.0.1.190416 NAME -------------------------------------------------- _bug27693416_kgh_free_list_min_effort _cell_offload_hybrid_processing _dskm_single_instance _seventh_spare_parameter parameter values changed isdefault between 12.2.0.1.190416 versus 12.2.0.1.190716 parameter values unique to 12.2.0.1.190416 versus 12.2.0.1.190716 parameter values unique to 12.2.0.1.190716 versus 12.2.0.1.190416 waitevents unique in version 12.2.0.1.190416 versus 12.2.0.1.190716 waitevents unique in version 12.2.0.1.190716 versus 12.2.0.1.190416 waitevents changed parameter description between 12.2.0.1.190416 versus 12.2.0.1.190716 x$ tables unique to 12.2.0.1.190416 versus 12.2.0.1.190716 x$ tables unique to 12.2.0.1.190716 versus 12.2.0.1.190416 x$ tables columns unique to 12.2.0.1.190416 versus 12.2.0.1.190716 x$ tables columns unique to 12.2.0.1.190716 versus 12.2.0.1.190416 v$ tables unique to 12.2.0.1.190416 versus 12.2.0.1.190716 v$ tables unique to 12.2.0.1.190716 versus 12.2.0.1.190416 v$ tables columns unique to 12.2.0.1.190416 versus 12.2.0.1.190716 v$ tables columns unique to 12.2.0.1.190716 versus 12.2.0.1.190416 gv$ tables unique to 12.2.0.1.190416 versus 12.2.0.1.190716 gv$ tables unique to 12.2.0.1.190716 versus 12.2.0.1.190416 gv$ tables columns unique to 12.2.0.1.190416 versus 12.2.0.1.190716 gv$ tables columns unique to 12.2.0.1.190716 versus 12.2.0.1.190416 sysstat statistics unique to 12.2.0.1.190416 versus 12.2.0.1.190716 NAME ---------------------------------------------------------------------------------------------------- spare statistic 2 sysstat statistics unique to 12.2.0.1.190716 versus 12.2.0.1.190416 NAME ---------------------------------------------------------------------------------------------------- cell XT granule IO bytes saved by HDFS tbs extent map scan sys_time_model statistics unique to 12.2.0.1.190416 versus 12.2.0.1.190716 sys_time_model statistics unique to 12.2.0.1.190716 versus 12.2.0.1.190416 dba tables unique to 12.2.0.1.190416 versus 12.2.0.1.190716 dba tables unique to 12.2.0.1.190716 versus 12.2.0.1.190416 dba tables columns unique to 12.2.0.1.190716 versus 12.2.0.1.190416 dba tables columns unique to 12.2.0.1.190416 versus 12.2.0.1.190716 cdb tables unique to 12.2.0.1.190416 versus 12.2.0.1.190716 cdb tables unique to 12.2.0.1.190716 versus 12.2.0.1.190416 cdb tables column unique to 12.2.0.1.190416 versus 12.2.0.1.190716 cdb tables column unique to 12.2.0.1.190716 versus 12.2.0.1.190416
And here are the differences in symbols (c functions).
Most notable:
– a lot of functions have been added that seem to be part of ‘little cms’, which seems to be a color management suite. I have no idea currently what these are doing in the oracle database executable.
– a significant amount of kola* (kernel objects lob) and prs* (parse) related functions have been added.
code symbol names unique in version 12.2.0.1.190416 versus 12.2.0.1.190716 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- free_ex_data free_ex_data ?? kcrfw_alfs_use_polling (kcrfw_alfs)_use_polling kernel cache recovery file write/broadcast SCN adaptive log file sync ?? kdmoBuildOperand (kdmo)BuildOperand kernel data in-memory data layer optimizer ?? kdmoDecompAvgCostPerSeg (kdmo)DecompAvgCostPerSeg kernel data in-memory data layer optimizer ?? kdmoDecompGetRate (kdmo)DecompGetRate kernel data in-memory data layer optimizer ?? kdmoGetStatHT (kdmo)GetStatHT kernel data in-memory data layer optimizer ?? kdmoIsValidTableCol (kdmo)IsValidTableCol kernel data in-memory data layer optimizer ?? kdmoMinMaxCountPrunableCUsSeg (kdmo)MinMaxCountPrunableCUsSeg kernel data in-memory data layer optimizer ?? kdmoMinMaxProcessPreds (kdmo)MinMaxProcessPreds kernel data in-memory data layer optimizer ?? kdmoPredEvalAvgCostPerSeg (kdmo)PredEvalAvgCostPerSeg kernel data in-memory data layer optimizer ?? kdmoPredEvalGetRate (kdmo)PredEvalGetRate kernel data in-memory data layer optimizer ?? kdpSizeOfGbyKdst (kdp)SizeOfGbyKdst kernel data archive compression: pcode ?? kdp_op_is_char (kdp)_op_is_char kernel data archive compression: pcode ?? kdp_pcode_calc_constant_area (kdp)_pcode_calc_constant_area kernel data archive compression: pcode ?? kdp_pcode_setup_cbks (kdp)_pcode_setup_cbks kernel data archive compression: pcode ?? kdzdcol_agg_cols_imc_dict_dgk_update (kdzd)col_agg_cols_imc_dict_dgk_update kernel data archive compression decompression ?? kdzdcol_gby_dgk_create (kdzd)col_gby_dgk_create kernel data archive compression decompression ?? kdzdcol_gby_find_groups (kdzd)col_gby_find_groups kernel data archive compression decompression ?? kewmcomprmdif (kewm)comprmdif kernel event AWR metrics ?? kkesrc (kke)src kernel compile cost engine ?? kkfdGetQueReason (kkfd)GetQueReason kernel compile fast dataflow (PQ DFO) ?? kkqgCompareTTWAndWoGby (kkq)gCompareTTWAndWoGby kernel compile query ?? kkqgMsqAggAppNampOrArgp (kkq)gMsqAggAppNampOrArgp kernel compile query ?? kkqgMsqUnprs (kkq)gMsqUnprs kernel compile query ?? kkqjfCopyFroNoChn (kkqjf)CopyFroNoChn kernel compile query join analysis join factorization ?? kkqvtOpnInView (kkqvt)OpnInView kernel compile query vector transformation ?? krbr3sf (krbr)3sf kernel redo backup/restore restore and recovery ?? ksunetstat (ksu)netstat kernel service (VOS) user ?? ksws_map_fo_restore_to_text (ksws)_map_fo_restore_to_text kernel service (VOS) workgroup services ?? kubsxiFetchOpenSetCpx (ku)bsxiFetchOpenSetCpx kernel utility ?? kzvdvechk_ownerid (kzvd)vechk_ownerid kernel security data vault ?? qerxaSetXVMCtx (qer)xaSetXVMCtx query execute rowsource ?? qkexrXC_SetOptTyp (qke)xrXC_SetOptTyp query kernel expressions ?? qksbgUnderOFE (qksbg)UnderOFE query kernel sql bind (variable) management(?) ?? qmxqcSetUDFVar2Parm (qmxq)cSetUDFVar2Parm query XDB XML Objects XML ?? qmxqcTreeAplyOp (qmxq)cTreeAplyOp query XDB XML Objects XML ?? qmxqcXPathNeedInputRetNodeRef (qmxq)cXPathNeedInputRetNodeRef query XDB XML Objects XML ?? qmxqtcPathHasPred (qmxq)tcPathHasPred query XDB XML Objects XML ?? qmxtr2IsFroRefdInFUP (qmxt)r2IsFroRefdInFUP query XDB XML Objects XML ?? qmxtr2MrkGrpChains (qmxt)r2MrkGrpChains query XDB XML Objects XML ?? set_dh set_dh ?? code symbol names unique in version 12.2.0.1.190716 versus 12.2.0.1.190416 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- AddConversion AddConversion ?? AllocArray AllocArray ?? AllocEmptyTransform AllocEmptyTransform ?? AllocateToneCurveStruct AllocateToneCurveStruct ?? BilinearInterp16 BilinearInterp16 ?? BilinearInterpFloat BilinearInterpFloat ?? BlackPreservingGrayOnlySampler BlackPreservingGrayOnlySampler ?? BlackPreservingKOnlyIntents BlackPreservingKOnlyIntents ?? BlackPreservingKPlaneIntents BlackPreservingKPlaneIntents ?? BlackPreservingSampler BlackPreservingSampler ?? CLUTElemDup CLUTElemDup ?? CLutElemTypeFree CLutElemTypeFree ?? CachedXFORM CachedXFORM ?? CachedXFORMGamutCheck CachedXFORMGamutCheck ?? Clipper Clipper ?? ComputeAbsoluteIntent ComputeAbsoluteIntent ?? CurveSetDup CurveSetDup ?? CurveSetElemTypeFree CurveSetElemTypeFree ?? CurvesDup CurvesDup ?? CurvesFree CurvesFree ?? DecideCurveType DecideCurveType ?? DecideLUTtypeA2B DecideLUTtypeA2B ?? DecideLUTtypeB2A DecideLUTtypeB2A ?? DecideTextDescType DecideTextDescType ?? DecideTextType DecideTextType ?? DecideXYZtype DecideXYZtype ?? DefaultEvalParametricFn DefaultEvalParametricFn ?? DefaultICCintents DefaultICCintents ?? DefaultLogErrorHandlerFunction DefaultLogErrorHandlerFunction ?? DupMatShaper DupMatShaper ?? DupNamedColorList DupNamedColorList ?? EstimateTAC EstimateTAC ?? Eval16nop1D Eval16nop1D ?? Eval1Input Eval1Input ?? Eval1InputFloat Eval1InputFloat ?? Eval4Inputs Eval4Inputs ?? Eval4InputsFloat Eval4InputsFloat ?? Eval5Inputs Eval5Inputs ?? Eval5InputsFloat Eval5InputsFloat ?? Eval6Inputs Eval6Inputs ?? Eval6InputsFloat Eval6InputsFloat ?? Eval7Inputs Eval7Inputs ?? Eval7InputsFloat Eval7InputsFloat ?? Eval8Inputs Eval8Inputs ?? Eval8InputsFloat Eval8InputsFloat ?? EvalNamedColor EvalNamedColor ?? EvalNamedColorPCS EvalNamedColorPCS ?? EvaluateCLUTfloat EvaluateCLUTfloat ?? EvaluateCLUTfloatIn16 EvaluateCLUTfloatIn16 ?? EvaluateCurves EvaluateCurves ?? EvaluateIdentity EvaluateIdentity ?? EvaluateLab2XYZ EvaluateLab2XYZ ?? EvaluateMatrix EvaluateMatrix ?? EvaluateXYZ2Lab EvaluateXYZ2Lab ?? FastEvaluateCurves16 FastEvaluateCurves16 ?? FastEvaluateCurves8 FastEvaluateCurves8 ?? FastIdentity16 FastIdentity16 ?? FileClose FileClose ?? FileRead FileRead ?? FileSeek FileSeek ?? FileTell FileTell ?? FileWrite FileWrite ?? FixWhiteMisalignment FixWhiteMisalignment ?? FloatXFORM FloatXFORM ?? FreeMatShaper FreeMatShaper ?? FreeNamedColorList FreeNamedColorList ?? GamutSampler GamutSampler ?? GenericMPEdup GenericMPEdup ?? GenericMPEfree GenericMPEfree ?? IdentitySampler IdentitySampler ?? InkLimitingSampler InkLimitingSampler ?? Java_sun_java2d_cmm_lcms_LCMS_colorConvert Java_sun_java2d_cmm_lcms_LCMS_colorConvert ?? Java_sun_java2d_cmm_lcms_LCMS_createNativeTransform Java_sun_java2d_cmm_lcms_LCMS_createNativeTransform ?? Java_sun_java2d_cmm_lcms_LCMS_getProfileDataNative Java_sun_java2d_cmm_lcms_LCMS_getProfileDataNative ?? Java_sun_java2d_cmm_lcms_LCMS_getProfileID Java_sun_java2d_cmm_lcms_LCMS_getProfileID ?? Java_sun_java2d_cmm_lcms_LCMS_getProfileSizeNative Java_sun_java2d_cmm_lcms_LCMS_getProfileSizeNative ?? Java_sun_java2d_cmm_lcms_LCMS_getTagNative Java_sun_java2d_cmm_lcms_LCMS_getTagNative ?? Java_sun_java2d_cmm_lcms_LCMS_initLCMS Java_sun_java2d_cmm_lcms_LCMS_initLCMS ?? Java_sun_java2d_cmm_lcms_LCMS_loadProfileNative Java_sun_java2d_cmm_lcms_LCMS_loadProfileNative ?? Java_sun_java2d_cmm_lcms_LCMS_setTagDataNative Java_sun_java2d_cmm_lcms_LCMS_setTagDataNative ?? LCMS_freeProfile LCMS_freeProfile ?? LCMS_freeTransform LCMS_freeTransform ?? LinLerp1D LinLerp1D ?? LinLerp1Dfloat LinLerp1Dfloat ?? MatShaperEval16 MatShaperEval16 ?? MatrixElemDup MatrixElemDup ?? MatrixElemTypeFree MatrixElemTypeFree ?? MemoryClose MemoryClose ?? MemoryRead MemoryRead ?? MemorySeek MemorySeek ?? MemoryTell MemoryTell ?? MemoryWrite MemoryWrite ?? NULLClose NULLClose ?? NULLRead NULLRead ?? NULLSeek NULLSeek ?? NULLTell NULLTell ?? NULLWrite NULLWrite ?? NullFloatXFORM NullFloatXFORM ?? NullXFORM NullXFORM ?? OptimizeByComputingLinearization OptimizeByComputingLinearization ?? OptimizeByJoiningCurves OptimizeByJoiningCurves ?? OptimizeByResampling OptimizeByResampling ?? OptimizeMatrixShaper OptimizeMatrixShaper ?? Pack1Byte Pack1Byte ?? Pack1ByteReversed Pack1ByteReversed ?? Pack1ByteSkip1 Pack1ByteSkip1 ?? Pack1ByteSkip1SwapFirst Pack1ByteSkip1SwapFirst ?? Pack1Word Pack1Word ?? Pack1WordBigEndian Pack1WordBigEndian ?? Pack1WordReversed Pack1WordReversed ?? Pack1WordSkip1 Pack1WordSkip1 ?? Pack1WordSkip1SwapFirst Pack1WordSkip1SwapFirst ?? Pack3Bytes Pack3Bytes ?? Pack3BytesAndSkip1 Pack3BytesAndSkip1 ?? Pack3BytesAndSkip1Optimized Pack3BytesAndSkip1Optimized ?? Pack3BytesAndSkip1Swap Pack3BytesAndSkip1Swap ?? Pack3BytesAndSkip1SwapFirst Pack3BytesAndSkip1SwapFirst ?? Pack3BytesAndSkip1SwapFirstOptimized Pack3BytesAndSkip1SwapFirstOptimized ?? Pack3BytesAndSkip1SwapOptimized Pack3BytesAndSkip1SwapOptimized ?? Pack3BytesAndSkip1SwapSwapFirst Pack3BytesAndSkip1SwapSwapFirst ?? Pack3BytesAndSkip1SwapSwapFirstOptimized Pack3BytesAndSkip1SwapSwapFirstOptimized ?? Pack3BytesOptimized Pack3BytesOptimized ?? Pack3BytesSwap Pack3BytesSwap ?? Pack3BytesSwapOptimized Pack3BytesSwapOptimized ?? Pack3Words Pack3Words ?? Pack3WordsAndSkip1 Pack3WordsAndSkip1 ?? Pack3WordsAndSkip1Swap Pack3WordsAndSkip1Swap ?? Pack3WordsAndSkip1SwapFirst Pack3WordsAndSkip1SwapFirst ?? Pack3WordsAndSkip1SwapSwapFirst Pack3WordsAndSkip1SwapSwapFirst ?? Pack3WordsBigEndian Pack3WordsBigEndian ?? Pack3WordsSwap Pack3WordsSwap ?? Pack4Bytes Pack4Bytes ?? Pack4BytesReverse Pack4BytesReverse ?? Pack4BytesSwap Pack4BytesSwap ?? Pack4BytesSwapFirst Pack4BytesSwapFirst ?? Pack4BytesSwapSwapFirst Pack4BytesSwapSwapFirst ?? Pack4Words Pack4Words ?? Pack4WordsBigEndian Pack4WordsBigEndian ?? Pack4WordsReverse Pack4WordsReverse ?? Pack4WordsSwap Pack4WordsSwap ?? Pack6Bytes Pack6Bytes ?? Pack6BytesSwap Pack6BytesSwap ?? Pack6Words Pack6Words ?? Pack6WordsSwap Pack6WordsSwap ?? PackALabV2_8 PackALabV2_8 ?? PackAnyBytes PackAnyBytes ?? PackAnyWords PackAnyWords ?? PackDoubleFrom16 PackDoubleFrom16 ?? PackDoublesFromFloat PackDoublesFromFloat ?? PackFloatFrom16 PackFloatFrom16 ?? PackFloatsFromFloat PackFloatsFromFloat ?? PackHalfFrom16 PackHalfFrom16 ?? PackHalfFromFloat PackHalfFromFloat ?? PackLabDoubleFrom16 PackLabDoubleFrom16 ?? PackLabDoubleFromFloat PackLabDoubleFromFloat ?? PackLabFloatFrom16 PackLabFloatFrom16 ?? PackLabFloatFromFloat PackLabFloatFromFloat ?? PackLabV2_16 PackLabV2_16 ?? PackLabV2_8 PackLabV2_8 ?? PackPlanarBytes PackPlanarBytes ?? PackPlanarWords PackPlanarWords ?? PackXYZDoubleFrom16 PackXYZDoubleFrom16 ?? PackXYZDoubleFromFloat PackXYZDoubleFromFloat ?? PackXYZFloatFrom16 PackXYZFloatFrom16 ?? PackXYZFloatFromFloat PackXYZFloatFromFloat ?? PreOptimize PreOptimize ?? PrecalculatedXFORM PrecalculatedXFORM ?? PrecalculatedXFORMGamutCheck PrecalculatedXFORMGamutCheck ?? Prelin16dup Prelin16dup ?? Prelin8dup Prelin8dup ?? Prelin8free Prelin8free ?? PrelinEval16 PrelinEval16 ?? PrelinEval8 PrelinEval8 ?? PrelinOpt16free PrelinOpt16free ?? R_SSL_clear_options R_SSL_clear_options ?? R_SSL_clear_options_by_type R_SSL_clear_options_by_type ?? ReadMPECurve ReadMPECurve ?? ReadMPEElem ReadMPEElem ?? ReadSeqID ReadSeqID ?? ReadSetOfCurves ReadSetOfCurves ?? SaveTags SaveTags ?? TetrahedralInterp16 TetrahedralInterp16 ?? TetrahedralInterpFloat TetrahedralInterpFloat ?? TrilinearInterp16 TrilinearInterp16 ?? TrilinearInterpFloat TrilinearInterpFloat ?? Type_Chromaticity_Dup Type_Chromaticity_Dup ?? Type_Chromaticity_Free Type_Chromaticity_Free ?? Type_Chromaticity_Read Type_Chromaticity_Read ?? Type_Chromaticity_Write Type_Chromaticity_Write ?? Type_ColorantOrderType_Dup Type_ColorantOrderType_Dup ?? Type_ColorantOrderType_Free Type_ColorantOrderType_Free ?? Type_ColorantOrderType_Read Type_ColorantOrderType_Read ?? Type_ColorantOrderType_Write Type_ColorantOrderType_Write ?? Type_ColorantTable_Dup Type_ColorantTable_Dup ?? Type_ColorantTable_Free Type_ColorantTable_Free ?? Type_ColorantTable_Read Type_ColorantTable_Read ?? Type_ColorantTable_Write Type_ColorantTable_Write ?? Type_CrdInfo_Dup Type_CrdInfo_Dup ?? Type_CrdInfo_Free Type_CrdInfo_Free ?? Type_CrdInfo_Read Type_CrdInfo_Read ?? Type_CrdInfo_Write Type_CrdInfo_Write ?? Type_Curve_Dup Type_Curve_Dup ?? Type_Curve_Free Type_Curve_Free ?? Type_Curve_Read Type_Curve_Read ?? Type_Curve_Write Type_Curve_Write ?? Type_Data_Dup Type_Data_Dup ?? Type_Data_Free Type_Data_Free ?? Type_Data_Read Type_Data_Read ?? Type_Data_Write Type_Data_Write ?? Type_DateTime_Dup Type_DateTime_Dup ?? Type_DateTime_Free Type_DateTime_Free ?? Type_DateTime_Read Type_DateTime_Read ?? Type_DateTime_Write Type_DateTime_Write ?? Type_Dictionary_Dup Type_Dictionary_Dup ?? Type_Dictionary_Free Type_Dictionary_Free ?? Type_Dictionary_Read Type_Dictionary_Read ?? Type_Dictionary_Write Type_Dictionary_Write ?? Type_LUT16_Dup Type_LUT16_Dup ?? Type_LUT16_Free Type_LUT16_Free ?? Type_LUT16_Read Type_LUT16_Read ?? Type_LUT16_Write Type_LUT16_Write ?? Type_LUT8_Dup Type_LUT8_Dup ?? Type_LUT8_Free Type_LUT8_Free ?? Type_LUT8_Read Type_LUT8_Read ?? Type_LUT8_Write Type_LUT8_Write ?? Type_LUTA2B_Dup Type_LUTA2B_Dup ?? Type_LUTA2B_Free Type_LUTA2B_Free ?? Type_LUTA2B_Read Type_LUTA2B_Read ?? Type_LUTA2B_Write Type_LUTA2B_Write ?? Type_LUTB2A_Dup Type_LUTB2A_Dup ?? Type_LUTB2A_Free Type_LUTB2A_Free ?? Type_LUTB2A_Read Type_LUTB2A_Read ?? Type_LUTB2A_Write Type_LUTB2A_Write ?? Type_MLU_Dup Type_MLU_Dup ?? Type_MLU_Free Type_MLU_Free ?? Type_MLU_Read Type_MLU_Read ?? Type_MLU_Write Type_MLU_Write ?? Type_MPE_Dup Type_MPE_Dup ?? Type_MPE_Free Type_MPE_Free ?? Type_MPE_Read Type_MPE_Read ?? Type_MPE_Write Type_MPE_Write ?? Type_MPEclut_Read Type_MPEclut_Read ?? Type_MPEclut_Write Type_MPEclut_Write ?? Type_MPEcurve_Read Type_MPEcurve_Read ?? Type_MPEcurve_Write Type_MPEcurve_Write ?? Type_MPEmatrix_Read Type_MPEmatrix_Read ?? Type_MPEmatrix_Write Type_MPEmatrix_Write ?? Type_Measurement_Dup Type_Measurement_Dup ?? Type_Measurement_Free Type_Measurement_Free ?? Type_Measurement_Read Type_Measurement_Read ?? Type_Measurement_Write Type_Measurement_Write ?? Type_NamedColor_Dup Type_NamedColor_Dup ?? Type_NamedColor_Free Type_NamedColor_Free ?? Type_NamedColor_Read Type_NamedColor_Read ?? Type_NamedColor_Write Type_NamedColor_Write ?? Type_ParametricCurve_Dup Type_ParametricCurve_Dup ?? Type_ParametricCurve_Free Type_ParametricCurve_Free ?? Type_ParametricCurve_Read Type_ParametricCurve_Read ?? Type_ParametricCurve_Write Type_ParametricCurve_Write ?? Type_ProfileSequenceDesc_Dup Type_ProfileSequenceDesc_Dup ?? Type_ProfileSequenceDesc_Free Type_ProfileSequenceDesc_Free ?? Type_ProfileSequenceDesc_Read Type_ProfileSequenceDesc_Read ?? Type_ProfileSequenceDesc_Write Type_ProfileSequenceDesc_Write ?? Type_ProfileSequenceId_Dup Type_ProfileSequenceId_Dup ?? Type_ProfileSequenceId_Free Type_ProfileSequenceId_Free ?? Type_ProfileSequenceId_Read Type_ProfileSequenceId_Read ?? Type_ProfileSequenceId_Write Type_ProfileSequenceId_Write ?? Type_S15Fixed16_Dup Type_S15Fixed16_Dup ?? Type_S15Fixed16_Free Type_S15Fixed16_Free ?? Type_S15Fixed16_Read Type_S15Fixed16_Read ?? Type_S15Fixed16_Write Type_S15Fixed16_Write ?? Type_Screening_Dup Type_Screening_Dup ?? Type_Screening_Free Type_Screening_Free ?? Type_Screening_Read Type_Screening_Read ?? Type_Screening_Write Type_Screening_Write ?? Type_Signature_Dup Type_Signature_Dup ?? Type_Signature_Free Type_Signature_Free ?? Type_Signature_Read Type_Signature_Read ?? Type_Signature_Write Type_Signature_Write ?? Type_Text_Description_Dup Type_Text_Description_Dup ?? Type_Text_Description_Free Type_Text_Description_Free ?? Type_Text_Description_Read Type_Text_Description_Read ?? Type_Text_Description_Write Type_Text_Description_Write ?? Type_Text_Dup Type_Text_Dup ?? Type_Text_Free Type_Text_Free ?? Type_Text_Read Type_Text_Read ?? Type_Text_Write Type_Text_Write ?? Type_U16Fixed16_Dup Type_U16Fixed16_Dup ?? Type_U16Fixed16_Free Type_U16Fixed16_Free ?? Type_U16Fixed16_Read Type_U16Fixed16_Read ?? Type_U16Fixed16_Write Type_U16Fixed16_Write ?? Type_UcrBg_Dup Type_UcrBg_Dup ?? Type_UcrBg_Free Type_UcrBg_Free ?? Type_UcrBg_Read Type_UcrBg_Read ?? Type_UcrBg_Write Type_UcrBg_Write ?? Type_ViewingConditions_Dup Type_ViewingConditions_Dup ?? Type_ViewingConditions_Free Type_ViewingConditions_Free ?? Type_ViewingConditions_Read Type_ViewingConditions_Read ?? Type_ViewingConditions_Write Type_ViewingConditions_Write ?? Type_XYZ_Dup Type_XYZ_Dup ?? Type_XYZ_Free Type_XYZ_Free ?? Type_XYZ_Read Type_XYZ_Read ?? Type_XYZ_Write Type_XYZ_Write ?? Type_vcgt_Dup Type_vcgt_Dup ?? Type_vcgt_Free Type_vcgt_Free ?? Type_vcgt_Read Type_vcgt_Read ?? Type_vcgt_Write Type_vcgt_Write ?? Unroll1Byte Unroll1Byte ?? Unroll1ByteReversed Unroll1ByteReversed ?? Unroll1ByteSkip1 Unroll1ByteSkip1 ?? Unroll1ByteSkip2 Unroll1ByteSkip2 ?? Unroll1Word Unroll1Word ?? Unroll1WordReversed Unroll1WordReversed ?? Unroll1WordSkip3 Unroll1WordSkip3 ?? Unroll2Bytes Unroll2Bytes ?? Unroll2Words Unroll2Words ?? Unroll3Bytes Unroll3Bytes ?? Unroll3BytesSkip1Swap Unroll3BytesSkip1Swap ?? Unroll3BytesSkip1SwapFirst Unroll3BytesSkip1SwapFirst ?? Unroll3BytesSkip1SwapSwapFirst Unroll3BytesSkip1SwapSwapFirst ?? Unroll3BytesSwap Unroll3BytesSwap ?? Unroll3Words Unroll3Words ?? Unroll3WordsSkip1Swap Unroll3WordsSkip1Swap ?? Unroll3WordsSkip1SwapFirst Unroll3WordsSkip1SwapFirst ?? Unroll3WordsSwap Unroll3WordsSwap ?? Unroll4Bytes Unroll4Bytes ?? Unroll4BytesReverse Unroll4BytesReverse ?? Unroll4BytesSwap Unroll4BytesSwap ?? Unroll4BytesSwapFirst Unroll4BytesSwapFirst ?? Unroll4BytesSwapSwapFirst Unroll4BytesSwapSwapFirst ?? Unroll4Words Unroll4Words ?? Unroll4WordsReverse Unroll4WordsReverse ?? Unroll4WordsSwap Unroll4WordsSwap ?? Unroll4WordsSwapFirst Unroll4WordsSwapFirst ?? Unroll4WordsSwapSwapFirst Unroll4WordsSwapSwapFirst ?? UnrollALabV2_8 UnrollALabV2_8 ?? UnrollAnyWords UnrollAnyWords ?? UnrollChunkyBytes UnrollChunkyBytes ?? UnrollDouble1Chan UnrollDouble1Chan ?? UnrollDoubleTo16 UnrollDoubleTo16 ?? UnrollDoublesToFloat UnrollDoublesToFloat ?? UnrollFloatTo16 UnrollFloatTo16 ?? UnrollFloatsToFloat UnrollFloatsToFloat ?? UnrollHalfTo16 UnrollHalfTo16 ?? UnrollHalfToFloat UnrollHalfToFloat ?? UnrollLabDoubleTo16 UnrollLabDoubleTo16 ?? UnrollLabDoubleToFloat UnrollLabDoubleToFloat ?? UnrollLabFloatTo16 UnrollLabFloatTo16 ?? UnrollLabFloatToFloat UnrollLabFloatToFloat ?? UnrollLabV2_16 UnrollLabV2_16 ?? UnrollLabV2_8 UnrollLabV2_8 ?? UnrollPlanarBytes UnrollPlanarBytes ?? UnrollPlanarWords UnrollPlanarWords ?? UnrollXYZDoubleTo16 UnrollXYZDoubleTo16 ?? UnrollXYZDoubleToFloat UnrollXYZDoubleToFloat ?? UnrollXYZFloatTo16 UnrollXYZFloatTo16 ?? UnrollXYZFloatToFloat UnrollXYZFloatToFloat ?? WriteMPECurve WriteMPECurve ?? WriteSeqID WriteSeqID ?? WriteSetOfCurves WriteSetOfCurves ?? XFormSampler16 XFormSampler16 ?? _LUTeval16 _LUTeval16 ?? _LUTevalFloat _LUTevalFloat ?? _cms15Fixed16toDouble (_cms)15Fixed16toDouble color management system (little cms) ?? _cms8Fixed8toDouble (_cms)8Fixed8toDouble color management system (little cms) ?? _cmsAdaptationMatrix (_cms)AdaptationMatrix color management system (little cms) ?? _cmsAdjustEndianess16 (_cms)AdjustEndianess16 color management system (little cms) ?? _cmsAdjustEndianess32 (_cms)AdjustEndianess32 color management system (little cms) ?? _cmsAdjustEndianess64 (_cms)AdjustEndianess64 color management system (little cms) ?? _cmsAllocAdaptationStateChunk (_cms)AllocAdaptationStateChunk color management system (little cms) ?? _cmsAllocAlarmCodesChunk (_cms)AllocAlarmCodesChunk color management system (little cms) ?? _cmsAllocCurvesPluginChunk (_cms)AllocCurvesPluginChunk color management system (little cms) ?? _cmsAllocFormattersPluginChunk (_cms)AllocFormattersPluginChunk color management system (little cms) ?? _cmsAllocIntentsPluginChunk (_cms)AllocIntentsPluginChunk color management system (little cms) ?? _cmsAllocInterpPluginChunk (_cms)AllocInterpPluginChunk color management system (little cms) ?? _cmsAllocLogErrorChunk (_cms)AllocLogErrorChunk color management system (little cms) ?? _cmsAllocMPETypePluginChunk (_cms)AllocMPETypePluginChunk color management system (little cms) ?? _cmsAllocMemPluginChunk (_cms)AllocMemPluginChunk color management system (little cms) ?? _cmsAllocMutexPluginChunk (_cms)AllocMutexPluginChunk color management system (little cms) ?? _cmsAllocOptimizationPluginChunk (_cms)AllocOptimizationPluginChunk color management system (little cms) ?? _cmsAllocTagPluginChunk (_cms)AllocTagPluginChunk color management system (little cms) ?? _cmsAllocTagTypePluginChunk (_cms)AllocTagTypePluginChunk color management system (little cms) ?? _cmsAllocTransformPluginChunk (_cms)AllocTransformPluginChunk color management system (little cms) ?? _cmsBuildKToneCurve (_cms)BuildKToneCurve color management system (little cms) ?? _cmsBuildRGB2XYZtransferMatrix (_cms)BuildRGB2XYZtransferMatrix color management system (little cms) ?? _cmsCalloc (_cms)Calloc color management system (little cms) ?? _cmsCallocDefaultFn (_cms)CallocDefaultFn color management system (little cms) ?? _cmsChain2Lab (_cms)Chain2Lab color management system (little cms) ?? _cmsCompileProfileSequence (_cms)CompileProfileSequence color management system (little cms) ?? _cmsComputeInterpParams (_cms)ComputeInterpParams color management system (little cms) ?? _cmsComputeInterpParamsEx (_cms)ComputeInterpParamsEx color management system (little cms) ?? _cmsContextGetClientChunk (_cms)ContextGetClientChunk color management system (little cms) ?? _cmsCreateGamutCheckPipeline (_cms)CreateGamutCheckPipeline color management system (little cms) ?? _cmsCreateMutex (_cms)CreateMutex color management system (little cms) ?? _cmsCreateSubAlloc (_cms)CreateSubAlloc color management system (little cms) ?? _cmsDecodeDateTimeNumber (_cms)DecodeDateTimeNumber color management system (little cms) ?? _cmsDefaultICCintents (_cms)DefaultICCintents color management system (little cms) ?? _cmsDestroyMutex (_cms)DestroyMutex color management system (little cms) ?? _cmsDoubleTo15Fixed16 (_cms)DoubleTo15Fixed16 color management system (little cms) ?? _cmsDoubleTo8Fixed8 (_cms)DoubleTo8Fixed8 color management system (little cms) ?? _cmsDupDefaultFn (_cms)DupDefaultFn color management system (little cms) ?? _cmsDupMem (_cms)DupMem color management system (little cms) ?? _cmsEncodeDateTimeNumber (_cms)EncodeDateTimeNumber color management system (little cms) ?? _cmsEndPointsBySpace (_cms)EndPointsBySpace color management system (little cms) ?? _cmsFloat2Half (_cms)Float2Half color management system (little cms) ?? _cmsFormatterIs8bit (_cms)FormatterIs8bit color management system (little cms) ?? _cmsFormatterIsFloat (_cms)FormatterIsFloat color management system (little cms) ?? _cmsFree (_cms)Free color management system (little cms) ?? _cmsFreeDefaultFn (_cms)FreeDefaultFn color management system (little cms) ?? _cmsFreeInterpParams (_cms)FreeInterpParams color management system (little cms) ?? _cmsGetContext (_cms)GetContext color management system (little cms) ?? _cmsGetFormatter (_cms)GetFormatter color management system (little cms) ?? _cmsGetTagDescriptor (_cms)GetTagDescriptor color management system (little cms) ?? _cmsGetTagTrueType (_cms)GetTagTrueType color management system (little cms) ?? _cmsGetTagTypeHandler (_cms)GetTagTypeHandler color management system (little cms) ?? _cmsGetTransformFormatters16 (_cms)GetTransformFormatters16 color management system (little cms) ?? _cmsGetTransformFormattersFloat (_cms)GetTransformFormattersFloat color management system (little cms) ?? _cmsGetTransformUserData (_cms)GetTransformUserData color management system (little cms) ?? _cmsHalf2Float (_cms)Half2Float color management system (little cms) ?? _cmsHandleExtraChannels (_cms)HandleExtraChannels color management system (little cms) ?? _cmsICCcolorSpace (_cms)ICCcolorSpace color management system (little cms) ?? _cmsIOPrintf (_cms)IOPrintf color management system (little cms) ?? _cmsInstallAllocFunctions (_cms)InstallAllocFunctions color management system (little cms) ?? _cmsLCMScolorSpace (_cms)LCMScolorSpace color management system (little cms) ?? _cmsLinkProfiles (_cms)LinkProfiles color management system (little cms) ?? _cmsLockMutex (_cms)LockMutex color management system (little cms) ?? _cmsMAT3eval (_cms)MAT3eval color management system (little cms) ?? _cmsMAT3identity (_cms)MAT3identity color management system (little cms) ?? _cmsMAT3inverse (_cms)MAT3inverse color management system (little cms) ?? _cmsMAT3isIdentity (_cms)MAT3isIdentity color management system (little cms) ?? _cmsMAT3per (_cms)MAT3per color management system (little cms) ?? _cmsMAT3solve (_cms)MAT3solve color management system (little cms) ?? _cmsMalloc (_cms)Malloc color management system (little cms) ?? _cmsMallocDefaultFn (_cms)MallocDefaultFn color management system (little cms) ?? _cmsMallocZero (_cms)MallocZero color management system (little cms) ?? _cmsMallocZeroDefaultFn (_cms)MallocZeroDefaultFn color management system (little cms) ?? _cmsOptimizePipeline (_cms)OptimizePipeline color management system (little cms) ?? _cmsPipelineSetOptimizationParameters (_cms)PipelineSetOptimizationParameters color management system (little cms) ?? _cmsPluginMalloc (_cms)PluginMalloc color management system (little cms) ?? _cmsQuantizeVal (_cms)QuantizeVal color management system (little cms) ?? _cmsRead15Fixed16Number (_cms)Read15Fixed16Number color management system (little cms) ?? _cmsReadAlignment (_cms)ReadAlignment color management system (little cms) ?? _cmsReadCHAD (_cms)ReadCHAD color management system (little cms) ?? _cmsReadDevicelinkLUT (_cms)ReadDevicelinkLUT color management system (little cms) ?? _cmsReadFloat32Number (_cms)ReadFloat32Number color management system (little cms) ?? _cmsReadHeader (_cms)ReadHeader color management system (little cms) ?? _cmsReadInputLUT (_cms)ReadInputLUT color management system (little cms) ?? _cmsReadMediaWhitePoint (_cms)ReadMediaWhitePoint color management system (little cms) ?? _cmsReadOutputLUT (_cms)ReadOutputLUT color management system (little cms) ?? _cmsReadProfileSequence (_cms)ReadProfileSequence color management system (little cms) ?? _cmsReadTypeBase (_cms)ReadTypeBase color management system (little cms) ?? _cmsReadUInt16Array (_cms)ReadUInt16Array color management system (little cms) ?? _cmsReadUInt16Number (_cms)ReadUInt16Number color management system (little cms) ?? _cmsReadUInt32Number (_cms)ReadUInt32Number color management system (little cms) ?? _cmsReadUInt64Number (_cms)ReadUInt64Number color management system (little cms) ?? _cmsReadUInt8Number (_cms)ReadUInt8Number color management system (little cms) ?? _cmsReadXYZNumber (_cms)ReadXYZNumber color management system (little cms) ?? _cmsRealloc (_cms)Realloc color management system (little cms) ?? _cmsReallocDefaultFn (_cms)ReallocDefaultFn color management system (little cms) ?? _cmsReasonableGridpointsByColorspace (_cms)ReasonableGridpointsByColorspace color management system (little cms) ?? _cmsRegisterFormattersPlugin (_cms)RegisterFormattersPlugin color management system (little cms) ?? _cmsRegisterInterpPlugin (_cms)RegisterInterpPlugin color management system (little cms) ?? _cmsRegisterMemHandlerPlugin (_cms)RegisterMemHandlerPlugin color management system (little cms) ?? _cmsRegisterMultiProcessElementPlugin (_cms)RegisterMultiProcessElementPlugin color management system (little cms) ?? _cmsRegisterMutexPlugin (_cms)RegisterMutexPlugin color management system (little cms) ?? _cmsRegisterOptimizationPlugin (_cms)RegisterOptimizationPlugin color management system (little cms) ?? _cmsRegisterParametricCurvesPlugin (_cms)RegisterParametricCurvesPlugin color management system (little cms) ?? _cmsRegisterRenderingIntentPlugin (_cms)RegisterRenderingIntentPlugin color management system (little cms) ?? _cmsRegisterTagPlugin (_cms)RegisterTagPlugin color management system (little cms) ?? _cmsRegisterTagTypePlugin (_cms)RegisterTagTypePlugin color management system (little cms) ?? _cmsRegisterTransformPlugin (_cms)RegisterTransformPlugin color management system (little cms) ?? _cmsSearchTag (_cms)SearchTag color management system (little cms) ?? _cmsSetInterpolationRoutine (_cms)SetInterpolationRoutine color management system (little cms) ?? _cmsSetTransformUserData (_cms)SetTransformUserData color management system (little cms) ?? _cmsStageAllocIdentityCLut (_cms)StageAllocIdentityCLut color management system (little cms) ?? _cmsStageAllocIdentityCurves (_cms)StageAllocIdentityCurves color management system (little cms) ?? _cmsStageAllocLab2XYZ (_cms)StageAllocLab2XYZ color management system (little cms) ?? _cmsStageAllocLabPrelin (_cms)StageAllocLabPrelin color management system (little cms) ?? _cmsStageAllocLabV2ToV4 (_cms)StageAllocLabV2ToV4 color management system (little cms) ?? _cmsStageAllocLabV2ToV4curves (_cms)StageAllocLabV2ToV4curves color management system (little cms) ?? _cmsStageAllocLabV4ToV2 (_cms)StageAllocLabV4ToV2 color management system (little cms) ?? _cmsStageAllocNamedColor (_cms)StageAllocNamedColor color management system (little cms) ?? _cmsStageAllocPlaceholder (_cms)StageAllocPlaceholder color management system (little cms) ?? _cmsStageAllocXYZ2Lab (_cms)StageAllocXYZ2Lab color management system (little cms) ?? _cmsStageClipNegatives (_cms)StageClipNegatives color management system (little cms) ?? _cmsStageGetPtrToCurveSet (_cms)StageGetPtrToCurveSet color management system (little cms) ?? _cmsStageNormalizeFromLabFloat (_cms)StageNormalizeFromLabFloat color management system (little cms) ?? _cmsStageNormalizeFromXyzFloat (_cms)StageNormalizeFromXyzFloat color management system (little cms) ?? _cmsStageNormalizeToLabFloat (_cms)StageNormalizeToLabFloat color management system (little cms) ?? _cmsStageNormalizeToXyzFloat (_cms)StageNormalizeToXyzFloat color management system (little cms) ?? _cmsSubAlloc (_cms)SubAlloc color management system (little cms) ?? _cmsSubAllocDestroy (_cms)SubAllocDestroy color management system (little cms) ?? _cmsSubAllocDup (_cms)SubAllocDup color management system (little cms) ?? _cmsTagSignature2String (_cms)TagSignature2String color management system (little cms) ?? _cmsTransform2toTransformAdaptor (_cms)Transform2toTransformAdaptor color management system (little cms) ?? _cmsUnlockMutex (_cms)UnlockMutex color management system (little cms) ?? _cmsVEC3cross (_cms)VEC3cross color management system (little cms) ?? _cmsVEC3distance (_cms)VEC3distance color management system (little cms) ?? _cmsVEC3dot (_cms)VEC3dot color management system (little cms) ?? _cmsVEC3init (_cms)VEC3init color management system (little cms) ?? _cmsVEC3length (_cms)VEC3length color management system (little cms) ?? _cmsVEC3minus (_cms)VEC3minus color management system (little cms) ?? _cmsWrite15Fixed16Number (_cms)Write15Fixed16Number color management system (little cms) ?? _cmsWriteAlignment (_cms)WriteAlignment color management system (little cms) ?? _cmsWriteFloat32Number (_cms)WriteFloat32Number color management system (little cms) ?? _cmsWriteHeader (_cms)WriteHeader color management system (little cms) ?? _cmsWriteProfileSequence (_cms)WriteProfileSequence color management system (little cms) ?? _cmsWriteTypeBase (_cms)WriteTypeBase color management system (little cms) ?? _cmsWriteUInt16Array (_cms)WriteUInt16Array color management system (little cms) ?? _cmsWriteUInt16Number (_cms)WriteUInt16Number color management system (little cms) ?? _cmsWriteUInt32Number (_cms)WriteUInt32Number color management system (little cms) ?? _cmsWriteUInt64Number (_cms)WriteUInt64Number color management system (little cms) ?? _cmsWriteUInt8Number (_cms)WriteUInt8Number color management system (little cms) ?? _cmsWriteXYZNumber (_cms)WriteXYZNumber color management system (little cms) ?? bchswSampler bchswSampler ?? cmsAdaptToIlluminant (cms)AdaptToIlluminant color management system (little cms) ?? cmsAllocNamedColorList (cms)AllocNamedColorList color management system (little cms) ?? cmsAllocProfileSequenceDescription (cms)AllocProfileSequenceDescription color management system (little cms) ?? cmsAppendNamedColor (cms)AppendNamedColor color management system (little cms) ?? cmsBFDdeltaE (cms)BFDdeltaE color management system (little cms) ?? cmsBuildGamma (cms)BuildGamma color management system (little cms) ?? cmsBuildParametricToneCurve (cms)BuildParametricToneCurve color management system (little cms) ?? cmsBuildSegmentedToneCurve (cms)BuildSegmentedToneCurve color management system (little cms) ?? cmsBuildTabulatedToneCurve16 (cms)BuildTabulatedToneCurve16 color management system (little cms) ?? cmsBuildTabulatedToneCurveFloat (cms)BuildTabulatedToneCurveFloat color management system (little cms) ?? cmsCIE2000DeltaE (cms)CIE2000DeltaE color management system (little cms) ?? cmsCIE94DeltaE (cms)CIE94DeltaE color management system (little cms) ?? cmsCMCdeltaE (cms)CMCdeltaE color management system (little cms) ?? cmsChangeBuffersFormat (cms)ChangeBuffersFormat color management system (little cms) ?? cmsChannelsOf (cms)ChannelsOf color management system (little cms) ?? cmsCloseIOhandler (cms)CloseIOhandler color management system (little cms) ?? cmsCloseProfile (cms)CloseProfile color management system (little cms) ?? cmsCreateBCHSWabstractProfile (cms)CreateBCHSWabstractProfile color management system (little cms) ?? cmsCreateBCHSWabstractProfileTHR (cms)CreateBCHSWabstractProfileTHR color management system (little cms) ?? cmsCreateContext (cms)CreateContext color management system (little cms) ?? cmsCreateExtendedTransform (cms)CreateExtendedTransform color management system (little cms) ?? cmsCreateGrayProfile (cms)CreateGrayProfile color management system (little cms) ?? cmsCreateGrayProfileTHR (cms)CreateGrayProfileTHR color management system (little cms) ?? cmsCreateInkLimitingDeviceLink (cms)CreateInkLimitingDeviceLink color management system (little cms) ?? cmsCreateInkLimitingDeviceLinkTHR (cms)CreateInkLimitingDeviceLinkTHR color management system (little cms) ?? cmsCreateLab2Profile (cms)CreateLab2Profile color management system (little cms) ?? cmsCreateLab2ProfileTHR (cms)CreateLab2ProfileTHR color management system (little cms) ?? cmsCreateLab4Profile (cms)CreateLab4Profile color management system (little cms) ?? cmsCreateLab4ProfileTHR (cms)CreateLab4ProfileTHR color management system (little cms) ?? cmsCreateLinearizationDeviceLink (cms)CreateLinearizationDeviceLink color management system (little cms) ?? cmsCreateLinearizationDeviceLinkTHR (cms)CreateLinearizationDeviceLinkTHR color management system (little cms) ?? cmsCreateMultiprofileTransform (cms)CreateMultiprofileTransform color management system (little cms) ?? cmsCreateMultiprofileTransformTHR (cms)CreateMultiprofileTransformTHR color management system (little cms) ?? cmsCreateNULLProfile (cms)CreateNULLProfile color management system (little cms) ?? cmsCreateNULLProfileTHR (cms)CreateNULLProfileTHR color management system (little cms) ?? cmsCreateProfilePlaceholder (cms)CreateProfilePlaceholder color management system (little cms) ?? cmsCreateProofingTransform (cms)CreateProofingTransform color management system (little cms) ?? cmsCreateProofingTransformTHR (cms)CreateProofingTransformTHR color management system (little cms) ?? cmsCreateRGBProfile (cms)CreateRGBProfile color management system (little cms) ?? cmsCreateRGBProfileTHR (cms)CreateRGBProfileTHR color management system (little cms) ?? cmsCreateTransform (cms)CreateTransform color management system (little cms) ?? cmsCreateTransformTHR (cms)CreateTransformTHR color management system (little cms) ?? cmsCreateXYZProfile (cms)CreateXYZProfile color management system (little cms) ?? cmsCreateXYZProfileTHR (cms)CreateXYZProfileTHR color management system (little cms) ?? cmsCreate_sRGBProfile (cms)Create_sRGBProfile color management system (little cms) ?? cmsCreate_sRGBProfileTHR (cms)Create_sRGBProfileTHR color management system (little cms) ?? cmsD50_XYZ (cms)D50_XYZ color management system (little cms) ?? cmsD50_xyY (cms)D50_xyY color management system (little cms) ?? cmsDeleteContext (cms)DeleteContext color management system (little cms) ?? cmsDeleteTransform (cms)DeleteTransform color management system (little cms) ?? cmsDeltaE (cms)DeltaE color management system (little cms) ?? cmsDesaturateLab (cms)DesaturateLab color management system (little cms) ?? cmsDetectBlackPoint (cms)DetectBlackPoint color management system (little cms) ?? cmsDetectDestinationBlackPoint (cms)DetectDestinationBlackPoint color management system (little cms) ?? cmsDetectTAC (cms)DetectTAC color management system (little cms) ?? cmsDictAddEntry (cms)DictAddEntry color management system (little cms) ?? cmsDictAlloc (cms)DictAlloc color management system (little cms) ?? cmsDictDup (cms)DictDup color management system (little cms) ?? cmsDictFree (cms)DictFree color management system (little cms) ?? cmsDictGetEntryList (cms)DictGetEntryList color management system (little cms) ?? cmsDictNextEntry (cms)DictNextEntry color management system (little cms) ?? cmsDoTransform (cms)DoTransform color management system (little cms) ?? cmsDoTransformLineStride (cms)DoTransformLineStride color management system (little cms) ?? cmsDoTransformStride (cms)DoTransformStride color management system (little cms) ?? cmsDupContext (cms)DupContext color management system (little cms) ?? cmsDupNamedColorList (cms)DupNamedColorList color management system (little cms) ?? cmsDupProfileSequenceDescription (cms)DupProfileSequenceDescription color management system (little cms) ?? cmsDupToneCurve (cms)DupToneCurve color management system (little cms) ?? cmsEstimateGamma (cms)EstimateGamma color management system (little cms) ?? cmsEvalToneCurve16 (cms)EvalToneCurve16 color management system (little cms) ?? cmsEvalToneCurveFloat (cms)EvalToneCurveFloat color management system (little cms) ?? cmsFloat2LabEncoded (cms)Float2LabEncoded color management system (little cms) ?? cmsFloat2LabEncodedV2 (cms)Float2LabEncodedV2 color management system (little cms) ?? cmsFloat2XYZEncoded (cms)Float2XYZEncoded color management system (little cms) ?? cmsFormatterForColorspaceOfProfile (cms)FormatterForColorspaceOfProfile color management system (little cms) ?? cmsFormatterForPCSOfProfile (cms)FormatterForPCSOfProfile color management system (little cms) ?? cmsFreeNamedColorList (cms)FreeNamedColorList color management system (little cms) ?? cmsFreeProfileSequenceDescription (cms)FreeProfileSequenceDescription color management system (little cms) ?? cmsFreeToneCurve (cms)FreeToneCurve color management system (little cms) ?? cmsFreeToneCurveTriple (cms)FreeToneCurveTriple color management system (little cms) ?? cmsGetAlarmCodes (cms)GetAlarmCodes color management system (little cms) ?? cmsGetAlarmCodesTHR (cms)GetAlarmCodesTHR color management system (little cms) ?? cmsGetColorSpace (cms)GetColorSpace color management system (little cms) ?? cmsGetContextUserData (cms)GetContextUserData color management system (little cms) ?? cmsGetDeviceClass (cms)GetDeviceClass color management system (little cms) ?? cmsGetEncodedCMMversion (cms)GetEncodedCMMversion color management system (little cms) ?? cmsGetEncodedICCversion (cms)GetEncodedICCversion color management system (little cms) ?? cmsGetHeaderAttributes (cms)GetHeaderAttributes color management system (little cms) ?? cmsGetHeaderCreationDateTime (cms)GetHeaderCreationDateTime color management system (little cms) ?? cmsGetHeaderCreator (cms)GetHeaderCreator color management system (little cms) ?? cmsGetHeaderFlags (cms)GetHeaderFlags color management system (little cms) ?? cmsGetHeaderManufacturer (cms)GetHeaderManufacturer color management system (little cms) ?? cmsGetHeaderModel (cms)GetHeaderModel color management system (little cms) ?? cmsGetHeaderProfileID (cms)GetHeaderProfileID color management system (little cms) ?? cmsGetHeaderRenderingIntent (cms)GetHeaderRenderingIntent color management system (little cms) ?? cmsGetNamedColorList (cms)GetNamedColorList color management system (little cms) ?? cmsGetPCS (cms)GetPCS color management system (little cms) ?? cmsGetPipelineContextID (cms)GetPipelineContextID color management system (little cms) ?? cmsGetProfileContextID (cms)GetProfileContextID color management system (little cms) ?? cmsGetProfileIOhandler (cms)GetProfileIOhandler color management system (little cms) ?? cmsGetProfileInfo (cms)GetProfileInfo color management system (little cms) ?? cmsGetProfileInfoASCII (cms)GetProfileInfoASCII color management system (little cms) ?? cmsGetProfileVersion (cms)GetProfileVersion color management system (little cms) ?? cmsGetSupportedIntents (cms)GetSupportedIntents color management system (little cms) ?? cmsGetSupportedIntentsTHR (cms)GetSupportedIntentsTHR color management system (little cms) ?? cmsGetTagCount (cms)GetTagCount color management system (little cms) ?? cmsGetTagSignature (cms)GetTagSignature color management system (little cms) ?? cmsGetToneCurveEstimatedTable (cms)GetToneCurveEstimatedTable color management system (little cms) ?? cmsGetToneCurveEstimatedTableEntries (cms)GetToneCurveEstimatedTableEntries color management system (little cms) ?? cmsGetToneCurveParametricType (cms)GetToneCurveParametricType color management system (little cms) ?? cmsGetTransformContextID (cms)GetTransformContextID color management system (little cms) ?? cmsGetTransformInputFormat (cms)GetTransformInputFormat color management system (little cms) ?? cmsGetTransformOutputFormat (cms)GetTransformOutputFormat color management system (little cms) ?? cmsIsCLUT (cms)IsCLUT color management system (little cms) ?? cmsIsIntentSupported (cms)IsIntentSupported color management system (little cms) ?? cmsIsMatrixShaper (cms)IsMatrixShaper color management system (little cms) ?? cmsIsTag (cms)IsTag color management system (little cms) ?? cmsIsToneCurveDescending (cms)IsToneCurveDescending color management system (little cms) ?? cmsIsToneCurveLinear (cms)IsToneCurveLinear color management system (little cms) ?? cmsIsToneCurveMonotonic (cms)IsToneCurveMonotonic color management system (little cms) ?? cmsIsToneCurveMultisegment (cms)IsToneCurveMultisegment color management system (little cms) ?? cmsJoinToneCurve (cms)JoinToneCurve color management system (little cms) ?? cmsLCh2Lab (cms)LCh2Lab color management system (little cms) ?? cmsLab2LCh (cms)Lab2LCh color management system (little cms) ?? cmsLab2XYZ (cms)Lab2XYZ color management system (little cms) ?? cmsLabEncoded2Float (cms)LabEncoded2Float color management system (little cms) ?? cmsLabEncoded2FloatV2 (cms)LabEncoded2FloatV2 color management system (little cms) ?? cmsLinkTag (cms)LinkTag color management system (little cms) ?? cmsMLUalloc (cms)MLUalloc color management system (little cms) ?? cmsMLUdup (cms)MLUdup color management system (little cms) ?? cmsMLUfree (cms)MLUfree color management system (little cms) ?? cmsMLUgetASCII (cms)MLUgetASCII color management system (little cms) ?? cmsMLUgetTranslation (cms)MLUgetTranslation color management system (little cms) ?? cmsMLUgetWide (cms)MLUgetWide color management system (little cms) ?? cmsMLUsetASCII (cms)MLUsetASCII color management system (little cms) ?? cmsMLUsetWide (cms)MLUsetWide color management system (little cms) ?? cmsMLUtranslationsCodes (cms)MLUtranslationsCodes color management system (little cms) ?? cmsMLUtranslationsCount (cms)MLUtranslationsCount color management system (little cms) ?? cmsNamedColorCount (cms)NamedColorCount color management system (little cms) ?? cmsNamedColorIndex (cms)NamedColorIndex color management system (little cms) ?? cmsNamedColorInfo (cms)NamedColorInfo color management system (little cms) ?? cmsOpenIOhandlerFromFile (cms)OpenIOhandlerFromFile color management system (little cms) ?? cmsOpenIOhandlerFromMem (cms)OpenIOhandlerFromMem color management system (little cms) ?? cmsOpenIOhandlerFromNULL (cms)OpenIOhandlerFromNULL color management system (little cms) ?? cmsOpenIOhandlerFromStream (cms)OpenIOhandlerFromStream color management system (little cms) ?? cmsOpenProfileFromFile (cms)OpenProfileFromFile color management system (little cms) ?? cmsOpenProfileFromFileTHR (cms)OpenProfileFromFileTHR color management system (little cms) ?? cmsOpenProfileFromIOhandler2THR (cms)OpenProfileFromIOhandler2THR color management system (little cms) ?? cmsOpenProfileFromIOhandlerTHR (cms)OpenProfileFromIOhandlerTHR color management system (little cms) ?? cmsOpenProfileFromMem (cms)OpenProfileFromMem color management system (little cms) ?? cmsOpenProfileFromMemTHR (cms)OpenProfileFromMemTHR color management system (little cms) ?? cmsOpenProfileFromStream (cms)OpenProfileFromStream color management system (little cms) ?? cmsOpenProfileFromStreamTHR (cms)OpenProfileFromStreamTHR color management system (little cms) ?? cmsPipelineAlloc (cms)PipelineAlloc color management system (little cms) ?? cmsPipelineCat (cms)PipelineCat color management system (little cms) ?? cmsPipelineCheckAndRetreiveStages (cms)PipelineCheckAndRetreiveStages color management system (little cms) ?? cmsPipelineDup (cms)PipelineDup color management system (little cms) ?? cmsPipelineEval16 (cms)PipelineEval16 color management system (little cms) ?? cmsPipelineEvalFloat (cms)PipelineEvalFloat color management system (little cms) ?? cmsPipelineEvalReverseFloat (cms)PipelineEvalReverseFloat color management system (little cms) ?? cmsPipelineFree (cms)PipelineFree color management system (little cms) ?? cmsPipelineGetPtrToFirstStage (cms)PipelineGetPtrToFirstStage color management system (little cms) ?? cmsPipelineGetPtrToLastStage (cms)PipelineGetPtrToLastStage color management system (little cms) ?? cmsPipelineInputChannels (cms)PipelineInputChannels color management system (little cms) ?? cmsPipelineInsertStage (cms)PipelineInsertStage color management system (little cms) ?? cmsPipelineOutputChannels (cms)PipelineOutputChannels color management system (little cms) ?? cmsPipelineSetSaveAs8bitsFlag (cms)PipelineSetSaveAs8bitsFlag color management system (little cms) ?? cmsPipelineStageCount (cms)PipelineStageCount color management system (little cms) ?? cmsPipelineUnlinkStage (cms)PipelineUnlinkStage color management system (little cms) ?? cmsPlugin (cms)Plugin color management system (little cms) ?? cmsPluginTHR (cms)PluginTHR color management system (little cms) ?? cmsReadRawTag (cms)ReadRawTag color management system (little cms) ?? cmsReadTag (cms)ReadTag color management system (little cms) ?? cmsReverseToneCurve (cms)ReverseToneCurve color management system (little cms) ?? cmsReverseToneCurveEx (cms)ReverseToneCurveEx color management system (little cms) ?? cmsSaveProfileToFile (cms)SaveProfileToFile color management system (little cms) ?? cmsSaveProfileToIOhandler (cms)SaveProfileToIOhandler color management system (little cms) ?? cmsSaveProfileToMem (cms)SaveProfileToMem color management system (little cms) ?? cmsSaveProfileToStream (cms)SaveProfileToStream color management system (little cms) ?? cmsSetAdaptationState (cms)SetAdaptationState color management system (little cms) ?? cmsSetAdaptationStateTHR (cms)SetAdaptationStateTHR color management system (little cms) ?? cmsSetAlarmCodes (cms)SetAlarmCodes color management system (little cms) ?? cmsSetAlarmCodesTHR (cms)SetAlarmCodesTHR color management system (little cms) ?? cmsSetColorSpace (cms)SetColorSpace color management system (little cms) ?? cmsSetDeviceClass (cms)SetDeviceClass color management system (little cms) ?? cmsSetEncodedICCversion (cms)SetEncodedICCversion color management system (little cms) ?? cmsSetHeaderAttributes (cms)SetHeaderAttributes color management system (little cms) ?? cmsSetHeaderFlags (cms)SetHeaderFlags color management system (little cms) ?? cmsSetHeaderManufacturer (cms)SetHeaderManufacturer color management system (little cms) ?? cmsSetHeaderModel (cms)SetHeaderModel color management system (little cms) ?? cmsSetHeaderProfileID (cms)SetHeaderProfileID color management system (little cms) ?? cmsSetHeaderRenderingIntent (cms)SetHeaderRenderingIntent color management system (little cms) ?? cmsSetLogErrorHandler (cms)SetLogErrorHandler color management system (little cms) ?? cmsSetLogErrorHandlerTHR (cms)SetLogErrorHandlerTHR color management system (little cms) ?? cmsSetPCS (cms)SetPCS color management system (little cms) ?? cmsSetProfileVersion (cms)SetProfileVersion color management system (little cms) ?? cmsSignalError (cms)SignalError color management system (little cms) ?? cmsSliceSpace16 (cms)SliceSpace16 color management system (little cms) ?? cmsSliceSpaceFloat (cms)SliceSpaceFloat color management system (little cms) ?? cmsSmoothToneCurve (cms)SmoothToneCurve color management system (little cms) ?? cmsStageAllocCLut16bit (cms)StageAllocCLut16bit color management system (little cms) ?? cmsStageAllocCLut16bitGranular (cms)StageAllocCLut16bitGranular color management system (little cms) ?? cmsStageAllocCLutFloat (cms)StageAllocCLutFloat color management system (little cms) ?? cmsStageAllocCLutFloatGranular (cms)StageAllocCLutFloatGranular color management system (little cms) ?? cmsStageAllocIdentity (cms)StageAllocIdentity color management system (little cms) ?? cmsStageAllocMatrix (cms)StageAllocMatrix color management system (little cms) ?? cmsStageAllocToneCurves (cms)StageAllocToneCurves color management system (little cms) ?? cmsStageData (cms)StageData color management system (little cms) ?? cmsStageDup (cms)StageDup color management system (little cms) ?? cmsStageFree (cms)StageFree color management system (little cms) ?? cmsStageInputChannels (cms)StageInputChannels color management system (little cms) ?? cmsStageNext (cms)StageNext color management system (little cms) ?? cmsStageOutputChannels (cms)StageOutputChannels color management system (little cms) ?? cmsStageSampleCLut16bit (cms)StageSampleCLut16bit color management system (little cms) ?? cmsStageSampleCLutFloat (cms)StageSampleCLutFloat color management system (little cms) ?? cmsStageType (cms)StageType color management system (little cms) ?? cmsTagLinkedTo (cms)TagLinkedTo color management system (little cms) ?? cmsTempFromWhitePoint (cms)TempFromWhitePoint color management system (little cms) ?? cmsTransform2DeviceLink (cms)Transform2DeviceLink color management system (little cms) ?? cmsUnregisterPlugins (cms)UnregisterPlugins color management system (little cms) ?? cmsUnregisterPluginsTHR (cms)UnregisterPluginsTHR color management system (little cms) ?? cmsWhitePointFromTemp (cms)WhitePointFromTemp color management system (little cms) ?? cmsWriteRawTag (cms)WriteRawTag color management system (little cms) ?? cmsWriteTag (cms)WriteTag color management system (little cms) ?? cmsXYZ2Lab (cms)XYZ2Lab color management system (little cms) ?? cmsXYZ2xyY (cms)XYZ2xyY color management system (little cms) ?? cmsXYZEncoded2Float (cms)XYZEncoded2Float color management system (little cms) ?? cmsfilelength (cms)filelength color management system (little cms) ?? cmsstrcasecmp (cms)strcasecmp color management system (little cms) ?? cmsxyY2XYZ (cms)xyY2XYZ color management system (little cms) ?? copy16 copy16 ?? copy32 copy32 ?? copy64 copy64 ?? copy8 copy8 ?? defMtxCreate defMtxCreate ?? defMtxDestroy defMtxDestroy ?? defMtxLock defMtxLock ?? defMtxUnlock defMtxUnlock ?? errorHandler (err)orHandler error recovery ?? free_ex_data_arg free_ex_data_arg ?? from16to8 from16to8 ?? from16toDBL from16toDBL ?? from16toFLT from16toFLT ?? from16toHLF from16toHLF ?? from8to16 from8to16 ?? from8toDBL from8toDBL ?? from8toFLT from8toFLT ?? from8toHLF from8toHLF ?? fromDBLto16 fromDBLto16 ?? fromDBLto8 fromDBLto8 ?? fromDBLtoFLT fromDBLtoFLT ?? fromDBLtoHLF fromDBLtoHLF ?? fromFLTto16 fromFLTto16 ?? fromFLTto8 fromFLTto8 ?? fromFLTtoDBL fromFLTtoDBL ?? fromFLTtoHLF fromFLTtoHLF ?? fromHLFto16 fromHLFto16 ?? fromHLFto8 fromHLFto8 ?? fromHLFtoDBL fromHLFtoDBL ?? fromHLFtoFLT fromHLFtoFLT ?? getILData getILData ?? kcfis_oss_wait_per_ctx (kcfis)_oss_wait_per_ctx kernel cache file management intelligent storage ?? kcfis_set_appliance_ctx (kcfis)_set_appliance_ctx kernel cache file management intelligent storage ?? kcfis_tablespace_is_smart_scannable (kcfis)_tablespace_is_smart_scannable kernel cache file management intelligent storage ?? kdmoCheckGbyAgg (kdmo)CheckGbyAgg kernel data in-memory data layer optimizer ?? kdmoCheckGbyOpn (kdmo)CheckGbyOpn kernel data in-memory data layer optimizer ?? kdmoColsUlvlIsDict (kdmo)ColsUlvlIsDict kernel data in-memory data layer optimizer ?? kdmoGByPushdownCardEst (kdmo)GByPushdownCardEst kernel data in-memory data layer optimizer ?? kdmoGByPushdownValid (kdmo)GByPushdownValid kernel data in-memory data layer optimizer ?? kdmoGenericPcodeCheck (kdmo)GenericPcodeCheck kernel data in-memory data layer optimizer ?? kdmoStorageColCheck (kdmo)StorageColCheck kernel data in-memory data layer optimizer ?? kdmoStorageConstantCheck (kdmo)StorageConstantCheck kernel data in-memory data layer optimizer ?? kdmoStorageOpnCheckAux (kdmo)StorageOpnCheckAux kernel data in-memory data layer optimizer ?? kdmoTabUlvlIsDict (kdmo)TabUlvlIsDict kernel data in-memory data layer optimizer ?? kdmoValidGbyPushdownPredCB (kdmo)ValidGbyPushdownPredCB kernel data in-memory data layer optimizer ?? kdzfCheckDbaMatch (kdz)fCheckDbaMatch kernel data archive compression ?? kdzsDumpKaf (kdzs)DumpKaf kernel data archive compression decompression ?? kfgbCheckInterrupt (kfgb)CheckInterrupt kernel automatic storage management diskgroups background ?? kgh_check_simple_free_canary (kgh)_check_simple_free_canary kernel generic heap manager ?? kgh_get_max_size_on_list (kgh)_get_max_size_on_list kernel generic heap manager ?? kgh_get_visit_limit (kgh)_get_visit_limit kernel generic heap manager ?? kgh_set_fl_effort (kgh)_set_fl_effort kernel generic heap manager ?? kghsrch_best_fit (kghsrch)_best_fit kernel generic heap manager search freelists for a memory chunk ?? kghunalo (kgh)unalo kernel generic heap manager ?? kgzm_encode_identify_ctype (kg)zm_encode_identify_ctype kernel generic ?? kgzm_encode_version_with_reid (kg)zm_encode_version_with_reid kernel generic ?? kjbmisgdbabast (kjb)misgdbabast kernel lock management global cache service ?? kjbmrejectbast (kjb)mrejectbast kernel lock management global cache service ?? kkesrcCard (kke)srcCard kernel compile cost engine ?? kkqjpdrace (kkqjpd)race kernel compile query join analysis predicate push down ?? kkqoreIsUnsupported (kkqore)IsUnsupported kernel compile query or-expansion ?? klxGetBuffer (kl)xGetBuffer kernel loader ?? klxGetLength (kl)xGetLength kernel loader ?? koklc_screate (kokl)c_screate kernel objects kernel side lob access ?? kolaCreateFromExternalSrc (kola)CreateFromExternalSrc kernel objects lob ?? kolaetAssign (kola)etAssign kernel objects lob ?? kolaetChkSize (kola)etChkSize kernel objects lob ?? kolaetCreate (kola)etCreate kernel objects lob ?? kolaetCreateCtx (kola)etCreateCtx kernel objects lob ?? kolaetCreateExternalInline (kola)etCreateExternalInline kernel objects lob ?? kolaetCreateFromExternalInline (kola)etCreateFromExternalInline kernel objects lob ?? kolaetDmpData (kola)etDmpData kernel objects lob ?? kolaetFree (kola)etFree kernel objects lob ?? kolaetGetLength (kola)etGetLength kernel objects lob ?? kolaetGetRawData (kola)etGetRawData kernel objects lob ?? kolaetIsExternalInlineLob (kola)etIsExternalInlineLob kernel objects lob ?? kolaetRead (kola)etRead kernel objects lob ?? kolaetWrite (kola)etWrite kernel objects lob ?? kolamalSage (kola)malSage kernel objects lob ?? kolamfrSage (kola)mfrSage kernel objects lob ?? kolasugc (kola)sugc kernel objects lob ?? kolasugi (kola)sugi kernel objects lob ?? kolrsdesht (kolr)sdesht kernel objects lob refcount ?? kolrsugi (kolr)sugi kernel objects lob refcount ?? kqltprom (kql)tprom kernel query library cache ?? krbCreateGuidStr (krb)CreateGuidStr kernel redo backup/restore ?? krbrCheckLogical (krbr)CheckLogical kernel redo backup/restore restore and recovery ?? krvxdsr (krvx)dsr kernel redo recovery extract ?? ksmsq_memlock_limit_alert_error (ksmsq)_memlock_limit_alert_error kernel service (VOS) memory sga heap message queue services ?? ksmsq_transport_require_memlock (ksmsq)_transport_require_memlock kernel service (VOS) memory sga heap message queue services ?? ksz_oss_get_ip_info (ksz)_oss_get_ip_info kernel service (VOS) oracle storage server (OSS) server layer ?? ksz_skgxp_check_default_query (ksz)_skgxp_check_default_query kernel service (VOS) oracle storage server (OSS) server layer ?? ktmaLgwrHeartbeat (ktma)LgwrHeartbeat kernel transaction transaction monitor (smon) IM transaction ADG ?? ktsttsn_to_tsnpdb (ktst)tsn_to_tsnpdb kernel transaction segment management sort management ?? ktsttsnpdb_to_pdb (ktst)tsnpdb_to_pdb kernel transaction segment management sort management ?? ktsttsnpdb_to_tsn (ktst)tsnpdb_to_tsn kernel transaction segment management sort management ?? kubsjniSkip (ku)bsjniSkip kernel utility ?? kubsxiMapCluUser (ku)bsxiMapCluUser kernel utility ?? kubsxiSetCpx (ku)bsxiSetCpx kernel utility ?? kxfrGetNextSplit (kxfr)GetNextSplit kernel execution parallel query granules ?? kzvdvechk_ownerid_1 (kzvd)vechk_ownerid_1 kernel security data vault ?? oracle_storidx_recompute_ridx_summary oracle_storidx_recompute_ridx_summary ?? prsUnusable (prs)Unusable parse ?? prscViewColAlias (prs)cViewColAlias parse ?? prsc_edition (prs)c_edition parse ?? prscal (prs)cal parse ?? prscap (prs)cap parse ?? prscbl (prs)cbl parse ?? prsccc (prs)ccc parse ?? prscct (prs)cct parse ?? prscdg (prs)cdg parse ?? prscdr (prs)cdr parse ?? prscet_parse_extab (prs)cet_parse_extab parse ?? prscipc_index_placement_clause (prs)cipc_index_placement_clause parse ?? prscisfbdrp (prs)cisfbdrp parse ?? prscisfbtbl (prs)cisfbtbl parse ?? prscnd (prs)cnd parse ?? prscpfil (prs)cpfil parse ?? prscrefv (prs)crefv parse ?? prscrely (prs)crely parse ?? prscspfi (prs)cspfi parse ?? prscvac (prs)cvac parse ?? prsdfl (prs)dfl parse ?? prsfbdrp (prs)fbdrp parse ?? prsfbdrptab (prs)fbdrptab parse ?? prsfla (prs)fla parse ?? prshve_high_val_expr (prs)hve_high_val_expr parse ?? prsicsl (prs)icsl parse ?? prsident (prs)ident parse ?? prsini_iot_init (prs)ini_iot_init parse ?? prsref (prs)ref parse ?? prssoasn (prs)soasn parse ?? prssptoa (prs)sptoa parse ?? qcpiSetFnInOpn (qcpi)SetFnInOpn query compile parse interim ?? qcpiSetFnInSel (qcpi)SetFnInSel query compile parse interim ?? qertbFilter_qertbs (qertb)Filter_qertbs query execute rowsource table access ?? qertbInitXTFilter (qertb)InitXTFilter query execute rowsource table access ?? qertbQueryHXTFilter (qertb)QueryHXTFilter query execute rowsource table access ?? qertbQueryLXTFilter (qertb)QueryLXTFilter query execute rowsource table access ?? qertbUpdateXTFilter (qertb)UpdateXTFilter query execute rowsource table access ?? qertbXTCbk (qertb)XTCbk query execute rowsource table access ?? qesSageIsHDFSTsn (qes)SageIsHDFSTsn query execute services ?? qesxtcCloseScan (qes)xtcCloseScan query execute services ?? qesxtcFetchCurrScan (qes)xtcFetchCurrScan query execute services ?? qesxtcFetchNextScan (qes)xtcFetchNextScan query execute services ?? qesxtcOpenScan (qes)xtcOpenScan query execute services ?? qjsnGenerateCapabilitySet (qjsn)GenerateCapabilitySet query json ?? qjsngCloseSageUga (qjsn)gCloseSageUga query json ?? qjsngCloseUga (qjsn)gCloseUga query json ?? qjsngInitSageUga (qjsn)gInitSageUga query json ?? qjsngStreamFromLobInSage (qjsn)gStreamFromLobInSage query json ?? qjsngStreamFromLob_h (qjsn)gStreamFromLob_h query json ?? qkaQknSTPruneKaf (qka)QknSTPruneKaf query kernel allocation ?? qksSageFlushSgaCIC (qksSage)FlushSgaCIC query kernel sql exadata ?? qksSageFlushSgaCICDump (qksSage)FlushSgaCICDump query kernel sql exadata ?? qksSageFlushSgaImpl (qksSage)FlushSgaImpl query kernel sql exadata ?? qksSageLoadInternalExternalMD (qksSage)LoadInternalExternalMD query kernel sql exadata ?? qksSageMakeTbsHDFS (qksSage)MakeTbsHDFS query kernel sql exadata ?? qkssage_kkxbct (qkssa)ge_kkxbct query kernel sql sampling ?? r_ex_data_clear r_ex_data_clear ?? r_ex_data_update r_ex_data_update ?? r_ssl_ctx_ex_data_clear r_ssl_ctx_ex_data_clear ?? r_ssl_ctx_get_dh_uses r_ssl_ctx_get_dh_uses ?? r_ssl_ctx_set_dh_uses r_ssl_ctx_set_dh_uses ?? r_ssl_ec_cert_algs_are_equal r_ssl_ec_cert_algs_are_equal ?? r_ssl_get_dh_uses r_ssl_get_dh_uses ?? r_ssl_set_dh_uses r_ssl_set_dh_uses ?? releaseILData releaseILData ?? ri_ssl3_base ri_ssl3_base ?? ri_ssl3_ctx_dh_tmp ri_ssl3_ctx_dh_tmp ?? ri_ssl3_dh_tmp ri_ssl3_dh_tmp ?? ri_ssl_cert_dup_params ri_ssl_cert_dup_params ?? ri_ssl_cipher_ctx_cipher_size ri_ssl_cipher_ctx_cipher_size ?? ri_ssl_cipher_ctx_is_aead ri_ssl_cipher_ctx_is_aead ?? sageDataReInitCtx (sageData)ReInitCtx exadata specific data layer ?? sageetProcessInternalTable (sage)etProcessInternalTable exadata specific ?? sageet_fp_buf_corrupt (sage)et_fp_buf_corrupt exadata specific ?? sageet_fp_buf_noalloc (sage)et_fp_buf_noalloc exadata specific ?? sageet_fp_buf_noresize (sage)et_fp_buf_noresize exadata specific ?? sagesqlFindCidInStoridx (sagesql)FindCidInStoridx exadata specific sql ?? seqSetStartWith (seq)SetStartWith sequence numbers ?? seqclp (seq)clp sequence numbers ?? seqmmv (seq)mmv sequence numbers ?? seqsetmin (seq)setmin sequence numbers ??
opt_estimate catalogue
This is just a list of the notes I’ve written about the opt_estimate() hint.
- opt_estimate – using the hint to affect index calculations: index_scan and index_filter
- opt_estimate 2 – applying the hint to nested loop joins, options: nlj_index_scan and nlj_index_filter
- opt_estimate 3 – a couple of little-known options for the hint, “group_by” and “having”.
- opt_estimate 4 – applying the hint at the query block level: particularly useful for CTEs (“with subquery”) and non-mergeable views.
- opt_estimate 5 – a story of failure: trying to use opt_estimate to push predicates into a union all view.
I have a couple more drafts on the topic awaiting completion, but if you know of any other articles that would be a good addition to the list feel free to reference them in the comments.
My Oracle Support (MOS) : Where do we go from here?
Well, it happened again. I lost the plot on Twitter … again. I deleted them a lot quicker this time, but a few people saw them … again…
Today’s “incident” was because I was juggling multiple SRs, where I don’t think I’m getting straight answers, and what I believe is a reasonable level of service.
Having deleted the tweets I put out this one.
I am venting because I have no filter these days, and I am quickly deleting them because I know they will cause problems for some of my friends inside Oracle.
I feel like I want to go to war over this, but I know the best thing to do is to go home and play with tech…
I’m sure the conspiracy theorists out there will make a thing out of these tweets disappearing, but what I said above is it. I was walking away from a fight because of my ties with Oracle, but not because I was worried about the impact on me. I have a lot of friends in Oracle and I know some of them get it in the neck when I lose my shit like this. Then I re-read my post called Oracle ACE = Oracle’s Bitch? and wasn’t too happy with myself.
The first draft of this post was me backing off from a fight. The second draft was me resigning from all ties with Oracle. Now I figure the most sensible thing to do is to try and figure out a way forward.
I have an incredible level of access to information and people within Oracle, but you shouldn’t have to be in my position to get a reasonable level of service. Part of what frustrates me about this is I know I can DM someone and “jump the queue”. Every time I have a meltdown, my DMs light up with people wanting to help, in part because they know me and genuinely want to help, and no doubt in part as damage limitation. It would be really easy to shut up and think, “I’m alright Jack!”, but then I’d become what I said other’s should not!
Where do we go from here?
Part of the Oracle re-branding is about being customer focused. What better place to start than support? It’s pretty clear that Oracle Support is in a really bad place. If someone quotes great resolution/response metrics to me, I would like to point them back to my previous post on the automated responses. I could also mention SRs with a status of “Solution Offered”, where IMHO no valid solution has been offered…
I’m happy to be part of the process. I’m not saying I can help, but I’m willing to try. I could do this in the background, because I now know the people in MOS I should contact, but I feel like this sort of thing needs to be public. To build any level of trust people need to feel like they are being listened to, see an action plan, and see that it’s delivered.
So come on Oracle. Put your money where your mouth is. Where do we go from here?
Cheers
Tim…
PS. You might want to read this old post called Oracle : Technology Company or Service Company?
PPS. I’ve now got some movement on my issues due to internal folks at Oracle, and one of the issues is due to my lack of understanding. 
What’s new with Oracle database 12.1.0.2.190416 versus 12.1.0.2.190716
There are a couple of undocumented spare parameters changed to named undocumented parameters, this is quite normal to see.
With the Oracle database version 12.1.0.2.190416 patched to 12.1.0.2.190716 on linux, the following things have changed:
parameters unique in version 12.1.0.2.190416 versus 12.1.0.2.190716 NAME -------------------------------------------------- _ninth_spare_parameter _one-hundred-and-forty-sixth_spare_parameter _tenth_spare_parameter parameters unique in version 12.1.0.2.190716 versus 12.1.0.2.190416 NAME -------------------------------------------------- _bug20684983_buffer_deadlock_cancel_count _bug22690648_gcr_cpu_min_hard_limit _gcs_disable_imc_preallocation parameter values changed isdefault between 12.1.0.2.190416 versus 12.1.0.2.190716 parameter values unique to 12.1.0.2.190416 versus 12.1.0.2.190716 parameter values unique to 12.1.0.2.190716 versus 12.1.0.2.190416 waitevents unique in version 12.1.0.2.190416 versus 12.1.0.2.190716 waitevents unique in version 12.1.0.2.190716 versus 12.1.0.2.190416 waitevents changed parameter description between 12.1.0.2.190416 versus 12.1.0.2.190716 x$ tables unique to 12.1.0.2.190416 versus 12.1.0.2.190716 x$ tables unique to 12.1.0.2.190716 versus 12.1.0.2.190416 x$ tables columns unique to 12.1.0.2.190416 versus 12.1.0.2.190716 x$ tables columns unique to 12.1.0.2.190716 versus 12.1.0.2.190416 v$ tables unique to 12.1.0.2.190416 versus 12.1.0.2.190716 v$ tables unique to 12.1.0.2.190716 versus 12.1.0.2.190416 v$ tables columns unique to 12.1.0.2.190416 versus 12.1.0.2.190716 v$ tables columns unique to 12.1.0.2.190716 versus 12.1.0.2.190416 gv$ tables unique to 12.1.0.2.190416 versus 12.1.0.2.190716 gv$ tables unique to 12.1.0.2.190716 versus 12.1.0.2.190416 gv$ tables columns unique to 12.1.0.2.190416 versus 12.1.0.2.190716 gv$ tables columns unique to 12.1.0.2.190716 versus 12.1.0.2.190416 sysstat statistics unique to 12.1.0.2.190416 versus 12.1.0.2.190716 sysstat statistics unique to 12.1.0.2.190716 versus 12.1.0.2.190416 sys_time_model statistics unique to 12.1.0.2.190416 versus 12.1.0.2.190716 sys_time_model statistics unique to 12.1.0.2.190716 versus 12.1.0.2.190416 dba tables unique to 12.1.0.2.190416 versus 12.1.0.2.190716 dba tables unique to 12.1.0.2.190716 versus 12.1.0.2.190416 dba tables columns unique to 12.1.0.2.190716 versus 12.1.0.2.190416 dba tables columns unique to 12.1.0.2.190416 versus 12.1.0.2.190716 cdb tables unique to 12.1.0.2.190416 versus 12.1.0.2.190716 cdb tables unique to 12.1.0.2.190716 versus 12.1.0.2.190416 cdb tables column unique to 12.1.0.2.190416 versus 12.1.0.2.190716 cdb tables column unique to 12.1.0.2.190716 versus 12.1.0.2.190416
And here are the differences in symbols (c functions).
The most notable thing to see are:
– almost no functions removed, it is normal to see a bigger number of functions to vanish.
– quite a lot of functions that are added are related to krsr*, kernel redo standby/dataguard remote file server.
– version 12.2 up to version 19 has had an addition of a huge amount of functions related to little cms, but it seems version 12.1 did not get this addition.
code symbol names unique in version 12.1.0.2.190416 versus 12.1.0.2.190716
NAME RESOLVE ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
free_ex_data free_ex_data ??
set_dh set_dh ??
code symbol names unique in version 12.1.0.2.190716 versus 12.1.0.2.190416
NAME RESOLVE ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
R_SSL_clear_options R_SSL_clear_options ??
R_SSL_clear_options_by_type R_SSL_clear_options_by_type ??
free_ex_data_arg free_ex_data_arg ??
kcl_try_cancel (kcl)_try_cancel kernel cache lock manager/buffer cache ??
kcvfdb_set_dict_check (kcv)fdb_set_dict_check kernel cache recovery ??
kewmcdmvbrwm (kewm)cdmvbrwm kernel event AWR metrics ??
kewmcomprmdif (kewm)comprmdif kernel event AWR metrics ??
kewmgetendftm (kewm)getendftm kernel event AWR metrics ??
kfdvaOpRslvFail (kfdva)OpRslvFail kernel automatic storage management disk virtual ATB ??
kfdvaPopRslvFail (kfdva)PopRslvFail kernel automatic storage management disk virtual ATB ??
kfdvaVopRslvFail (kfdva)VopRslvFail kernel automatic storage management disk virtual ATB ??
kfgbCheckInterrupt (kfgb)CheckInterrupt kernel automatic storage management diskgroups background ??
kfis_sageonly_anygroup_all (kfis)_sageonly_anygroup_all kernel automatic storage management intelligent storage interfaces ??
kfnrclFindRmt (kfn)rclFindRmt kernel automatic storage management networking subsystem ??
kgfnConnect3 (kgf)nConnect3 kernel generic ASM ??
kgfnGetCSSMisscount (kgf)nGetCSSMisscount kernel generic ASM ??
kgfpInitComplete3 (kgf)pInitComplete3 kernel generic ASM ??
kjblimcestimate (kjbl)imcestimate kernel lock management global cache service lock table ??
krbCreateXml (krb)CreateXml kernel redo backup/restore ??
krbi_create_xml krbi_create_xml kernel redo backup/restore dbms_backup_restore package DBMS_BACKUP_RESTORE.KRBI_
CREATE_XML CREATETEMPXMLFILE
krcdct_int (krc)dct_int kernel redo block change tracking ??
krcpsckp_canc (krc)psckp_canc kernel redo block change tracking ??
krsr_chk_sna (krsr)_chk_sna kernel redo standby/dataguard (?) remote file server ??
krsr_copy_rcv_info (krsr)_copy_rcv_info kernel redo standby/dataguard (?) remote file server ??
krsr_copy_thread_info (krsr)_copy_thread_info kernel redo standby/dataguard (?) remote file server ??
krsr_get_rta_info (krsr)_get_rta_info kernel redo standby/dataguard (?) remote file server ??
krsr_pic_release (krsr)_pic_release kernel redo standby/dataguard (?) remote file server ??
krsr_reset_sna (krsr)_reset_sna kernel redo standby/dataguard (?) remote file server ??
krsr_rta_adjusted_numblks (krsr)_rta_adjusted_numblks kernel redo standby/dataguard (?) remote file server ??
krsr_sna_io_finish (krsr)_sna_io_finish kernel redo standby/dataguard (?) remote file server ??
krsr_snldt_get_inlist (krsr)_snldt_get_inlist kernel redo standby/dataguard (?) remote file server ??
krsr_snldt_get_simap (krsr)_snldt_get_simap kernel redo standby/dataguard (?) remote file server ??
krsr_update_lamport (krsr)_update_lamport kernel redo standby/dataguard (?) remote file server ??
ksfd_estimate_fobpools (ksfd)_estimate_fobpools kernel service (VOS) functions disk IO ??
ksfd_iorm_throttled (ksfd_io)rm_throttled kernel service (VOS) functions disk IO perform IO ??
r_ex_data_clear r_ex_data_clear ??
r_ex_data_update r_ex_data_update ??
r_ssl_ctx_ex_data_clear r_ssl_ctx_ex_data_clear ??
r_ssl_ctx_get_dh_uses r_ssl_ctx_get_dh_uses ??
r_ssl_ctx_set_dh_uses r_ssl_ctx_set_dh_uses ??
r_ssl_ec_cert_algs_are_equal r_ssl_ec_cert_algs_are_equal ??
r_ssl_get_dh_uses r_ssl_get_dh_uses ??
r_ssl_set_dh_uses r_ssl_set_dh_uses ??
ri_ssl3_base ri_ssl3_base ??
ri_ssl3_ctx_dh_tmp ri_ssl3_ctx_dh_tmp ??
ri_ssl3_dh_tmp ri_ssl3_dh_tmp ??
ri_ssl_cert_dup_params ri_ssl_cert_dup_params ??
ri_ssl_cipher_ctx_cipher_size ri_ssl_cipher_ctx_cipher_size ??
ri_ssl_cipher_ctx_is_aead ri_ssl_cipher_ctx_is_aead ??
Trace Files
A recent blog note by Martin Berger about reading trace files in 12.2 poped up in my twitter timeline yesterday and reminded me of a script I wrote a while ago to create a simple view I could query to read the tracefile generated by the current session while the session was still connected. You either have to create the view and a public synonym through the SYS schema, or you have to use the SYS schema to grant select privileges on several dynamic performance views to the user to allow the user to create the view in the user’s schema. For my scratch database I tend to create the view in the SYS schema.
Script to be run by SYS:
rem
rem Script: read_trace_122.sql
rem Author: Jonathan Lewis
rem Dated: Sept 2018
rem
rem Last tested
rem 12.2.0.1
create or replace view my_trace_file as
select
*
from
v$diag_trace_file_contents
where
(adr_home, trace_filename) = (
select
-- substr(tracefile, 1, instr(tracefile,'/',-1)-1),
substr(
substr(tracefile, 1, instr(tracefile,'/',-1)-1),
1,
instr(
substr(tracefile, 1, instr(tracefile,'/',-1)),
'trace'
) - 2
),
substr(tracefile, instr(tracefile,'/',-1)+1) trace_filename
from
v$process
where addr = (
select paddr
from v$session
where sid = (
sys_context('userenv','sid')
-- select sid from v$mystat where rownum = 1
-- select dbms_support.mysid from dual
)
)
)
;
create public synonym my_trace_file for sys.my_trace_file;
grant select on my_trace_file to {some role};
Alternatively, the privileges you could grant to a user from SYS so that they could create their own view:
grant select on v_$process to some_user;
grant select on v_$session to some_user;
grant select on v_$diag_trace_file_contents to some_user;
and optionally one of:
grant select on v_$mystat to some_user;
grant execute on dbms_support to some_user;
but dbms_support is no longer installed by default.
The references to package dbms_support and view v$mystat are historic ones I have lurking in various scripts from the days when the session id (SID) wasn’t available in any simpler way.
Once the view exists and is available, you can enable some sort of tracing from your session then query the view to read back the trace file. For example, here’s a simple “self-reporting” (it’s going to report the trace file that it causes) script that I’ve run from 12.2.0.1 as a demo:
alter system flush shared_pool;
alter session set sql_trace true;
set linesize 180
set trimspool on
set pagesize 60
column line_number format 999,999
column piece format a150
column plan noprint
column cursor# noprint
break on plan skip 1 on cursor# skip 1
select
line_number,
line_number - row_number() over (order by line_number) plan,
substr(payload,1,instr(payload,' id=')) cursor#,
substr(payload, 1,150) piece
from
my_trace_file
where
file_name = 'xpl.c'
order by
line_number
/
alter session set sql_trace false;
The script flushes the shared pool to make sure that it’s going to trigger some recursive SQL then enables a simple SQL trace. The query then picks out all the lines in the trace file generated by code in the Oracle source file xpl.c (execution plans seems like a likely guess) which happens to pick out all the STAT lines in the trace (i.e. the ones showing the execution plans).
I’ve used the “tabibitosan” method to identify all the lines that belong to a single execution plan by assuming that they will be consecutive lines in the output starting from a line which includes the text ” id=1 “ (the surrounding spaces are important), but I’ve also extracted the bit of the line which includes the cursor number (STAT #nnnnnnnnnnnnnnn) because two plans may be dumped one after the other if multiple cursors close at the same time. There is still a little flaw in the script because sometimes Oracle will run a sys-recursive statement in the middle of dumping a plan to turn an object_id into an object_name, and this will cause a break in the output.
The result of the query is to extract all the execution plans in the trace file and print them in the order they appear – here’s a sample of the output:
LINE_NUMBER PIECE
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------
38 STAT #140392790549064 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=0 pw=0 str=1 time=53 us cost=4 size=113 card
39 STAT #140392790549064 id=2 cnt=0 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 str=1 time=47 us cost=3 size=0 card=1)'
53 STAT #140392790535800 id=1 cnt=1 pid=0 pos=1 obj=0 op='MERGE JOIN OUTER (cr=5 pr=0 pw=0 str=1 time=95 us cost=2 size=178 card=1)'
54 STAT #140392790535800 id=2 cnt=1 pid=1 pos=1 obj=4 op='TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 str=1 time=57 us cost=2 size=138 card=1)'
55 STAT #140392790535800 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 str=1 time=11 us cost=1 size=0 card=1)'
56 STAT #140392790535800 id=4 cnt=0 pid=1 pos=2 obj=0 op='BUFFER SORT (cr=2 pr=0 pw=0 str=1 time=29 us cost=0 size=40 card=1)'
57 STAT #140392790535800 id=5 cnt=0 pid=4 pos=1 obj=73 op='TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=0 pw=0 str=1 time=10 us cost=0 size=40 card=1)
58 STAT #140392790535800 id=6 cnt=0 pid=5 pos=1 obj=74 op='INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 str=1 time=8 us cost=0 size=0 card=1)'
84 STAT #140392791412824 id=1 cnt=1 pid=0 pos=1 obj=20 op='TABLE ACCESS BY INDEX ROWID BATCHED ICOL$ (cr=4 pr=0 pw=0 str=1 time=25 us cost=2 size=54 card
85 STAT #140392791412824 id=2 cnt=1 pid=1 pos=1 obj=42 op='INDEX RANGE SCAN I_ICOL1 (cr=3 pr=0 pw=0 str=1 time=23 us cost=1 size=0 card=2)'
94 STAT #140392790504512 id=1 cnt=2 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=7 pr=0 pw=0 str=1 time=432 us cost=6 size=374 card=2)'
95 STAT #140392790504512 id=2 cnt=2 pid=1 pos=1 obj=0 op='HASH JOIN OUTER (cr=7 pr=0 pw=0 str=1 time=375 us cost=5 size=374 card=2)'
96 STAT #140392790504512 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=4 pr=0 pw=0 str=1 time=115 us cost=2 size=288 card=2)'
97 STAT #140392790504512 id=4 cnt=2 pid=3 pos=1 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 str=1 time=100 us cost=2 size=184 card=2)'
98 STAT #140392790504512 id=5 cnt=1 pid=4 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 str=1 time=85 us cost=1 size=0 card=1)'
99 STAT #140392790504512 id=6 cnt=0 pid=3 pos=2 obj=75 op='TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 str=2 time=8 us cost=0 size=52 card=1)'
100 STAT #140392790504512 id=7 cnt=0 pid=6 pos=1 obj=76 op='INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 str=2 time=7 us cost=0 size=0 card=1)'
101 STAT #140392790504512 id=8 cnt=0 pid=2 pos=2 obj=0 op='VIEW (cr=3 pr=0 pw=0 str=1 time=47 us cost=3 size=43 card=1)'
102 STAT #140392790504512 id=9 cnt=0 pid=8 pos=1 obj=0 op='SORT GROUP BY (cr=3 pr=0 pw=0 str=1 time=44 us cost=3 size=15 card=1)'
103 STAT #140392790504512 id=10 cnt=0 pid=9 pos=1 obj=31 op='TABLE ACCESS CLUSTER CDEF$ (cr=3 pr=0 pw=0 str=1 time=21 us cost=2 size=15 card=1)'
104 STAT #140392790504512 id=11 cnt=1 pid=10 pos=1 obj=30 op='INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 str=1 time=11 us cost=1 size=0 card=1)'
116 STAT #140392791480168 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 str=1 time=62 us cost=3 size=858 card=13)'
117 STAT #140392791480168 id=2 cnt=4 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 str=1 time=24 us cost=2 size=858 card=13)'
118 STAT #140392791480168 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 str=1 time=11 us cost=1 size=0 card=1)'
126 STAT #140392789565328 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 str=1 time=21 us cost=2 size=68 card=1)'
127 STAT #140392789565328 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 str=1 time=12 us cost=1 size=0 card=1)'
135 STAT #140392789722208 id=1 cnt=1 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=0 pw=0 str=1 time=22 us cost=3 size=51 card=
136 STAT #140392789722208 id=2 cnt=1 pid=1 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 str=1 time=16 us cost=2 size=0 card=1)'
153 STAT #140392792055264 id=1 cnt=1 pid=0 pos=1 obj=68 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 str=1 time=25 us)'
154 STAT #140392792055264 id=2 cnt=1 pid=1 pos=1 obj=70 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 str=1 time=19 us)'
If you want to investigate further, the “interesting” columns in the underlying view are probably: section_name, component_name, operation_name, file_name, and function_name. The possible names of functions, files, etc. vary with the trace event you’ve enabled.
Midlands Microsoft 365 and Azure User Group – October 2019
https://oracle-base.com/blog/wp-content/uploads/2019/09/m365-and-azure-3... 300w" sizes="(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px" />
On Tuesday evening I went to the second event of the Midlands Microsoft 365 and Azure User Group. It was co-organised by Urfaan Azhar and Lee Thatcher from Pure Technology Group, and Adrian Newton from my company.
First up was Matt Fooks speaking about security in M365 and Azure. He did an overview and demos of a number of security features, giving an idea of their scope, how easy/hard they were to configure and importantly what licenses they were covered by. Some of this was a bit over my head, but for me it’s about understanding possibilities and what’s available, even if I wouldn’t have a clue what to do with it. Other people in the company do that stuff. At one point I leaned over to one of my colleagues and said, “Could we use that for…”, and he came back with, “Yeah. We’ve done a POC with that. Look!”, then showing me an example of it working with one of our services.
.png){kind=small}
TweetsPopular content
Today's:
Monthly archive
- December 2019 (10)
- November 2019 (43)
- October 2019 (61)
- September 2019 (36)
- August 2019 (40)
- July 2019 (44)
- June 2019 (37)
- May 2019 (43)
- April 2019 (43)
- March 2019 (55)
- February 2019 (25)
- January 2019 (35)
- December 2018 (39)
- November 2018 (53)
- October 2018 (69)
- September 2018 (36)
- August 2018 (68)
- July 2018 (58)
- June 2018 (59)
- May 2018 (64)
- April 2018 (40)
- March 2018 (61)
- February 2018 (67)
- January 2018 (57)
- December 2017 (37)
- November 2017 (45)
- October 2017 (57)
- September 2017 (46)
- August 2017 (61)
- July 2017 (54)
Recent comments
1 year 45 weeks ago
2 years 5 weeks ago
2 years 9 weeks ago
2 years 10 weeks ago
2 years 14 weeks ago
2 years 35 weeks ago
3 years 4 weeks ago
3 years 33 weeks ago
4 years 18 weeks ago
4 years 18 weeks ago