Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SGA Config

609950Jul 13 2009 — edited Jul 13 2009
Hi All,
I'm having one database running on solaris environment and database version is 10Gr2(10.2.0.1). In this server total memory is 16G and oracle is using only 6G. I just wanted to know maximum how much memory can be used for oracle without hampering the other os process means is there any ratio between OS and Oracle memory distribution?

looking for your valuable suggestion.

Comments

TexasApexDeveloper

Many links available via Google to resolve this issue:

Let me google that for you

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

Jitesh Gurnani-Oracle

Hi,

Sure, thanks a ton mate. Any alternative approach would be really helpful.

Regards,

Jitesh Gurnani

TexasApexDeveloper

Alternative method??  Please explain further..

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

Jitesh Gurnani-Oracle

Hi Texas,

I have already googled it and tried the methods. The intention of asking a question here is to know if someone has tried something different or to get insights from others thoughts.

Anyways, thanks for your help.

jwellsnh

Hi Jitesh,

You said:

I have come across a tricky situation and would need the assistance of Apex community members here.

I would require to build a matrix report in Apex over a table containing 2 columns and about 500 rows.

The matrix report should be of 20 X 25 (col X rows) format to display the entire data in the table.

Is this your vision or are they user requirements?

I cannot see how this is practically feasible.  As a recommendation; maybe someone from the PL/SQL forum can!  Post your challenge over in that forum and see if don't get a better response.  I wish you good fortune.

Jeff

TexasApexDeveloper

So let me get this straight....  You have a table with 2 columns and about 500 rows....  You WISH/NEED to build a matrix (Cross-tab) style report that will ultimately be 20 columns by 25 rows across.. Does this address the question?  Can you post a sample of your data and your desired look of the report??

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

fac586

Jitesh Gurnani wrote:

I have come across a tricky situation and would need the assistance of Apex community members here.

I would require to build a matrix report in Apex over a table containing 2 columns and about 500 rows.

The matrix report should be of 20 X 25 (col X rows) format to display the entire data in the table.

XY question, where the proposed "solution" has huge semantic, accessibility, and usability problems.

A matrix report displays a measure along two or more dimensions. A table with 2 columns can only contain either 2 dimensions, 1 dimension and 1 measure, or 2 measures. it is therefore impossible to create a true matrix report from a table containing only 2 columns.

Why 20 columns×25 rows? Semantically, what is being represented by the rows and columns in this "matrix"? How are they related?

Now this table data needs to be displayed as a matrix report of 3 X 5.

The idea here is to only display the col_data to the end users.

The col_data text would be coloured as red or green depending on the col_status as up or down respectively.

Conditional html formatting needs to be applied in this case.

Since a significant proportion of the population are unable to distinguish red from green, it is essential to consider the accessibility and usability implications of displaying information using these colours.

If the colours are intended to convey meaning then provision must be made to transmit the information using multiple channels, not just colour.

The problem here is we don't have matrix report in Apex. This needs to be achieved in sql query.

While generating a matrix report using sql query, we can select only one column and the status column is missed out.

Hence the data required for conditional formatting ( colouring) is not even selected if we generate a matrix report using sql query.

No idea what this means. Please clarify.

There are many ways of creating a matrix report in APEX.

There are many ways of creating a matrix report in SQL. We don't know which you are referring to, and consequently don't know why you consider that only one column can be selected, leaving the status column "missed out".

Jitesh Gurnani-Oracle

Please consider the sample data below containing 15 rows and 2 columns

Table A

Col_data Col_status

a         up

b         up

c         up

d         up

e         down

f         up

g         up

h         up

i         up

j         up

k         up

l         up

m         up

n         down

o         up

Now this table data needs to be displayed as a matrix report of 3 X 5.

The idea here is to only display the col_data to the end users.

The col_data text would be coloured as red or green depending on the col_status as up or down respectively.

Conditional html formatting needs to be applied in this case as in the below report.

col1col2col3col4col5
abcde
fghij
klmno

This is a user requirement on an actual table containing 500 rows.

Jitesh Gurnani-Oracle

Hi Texas,

I have posted the user requirement with sample data and a sample report.

Regards,

Jitesh Gurnani

Anton Scheffer

It's not "tricky" at all, or do I miss the point?

select max( case when mod( rn, 3 ) = 1 then col_data end ) col1

    , max( case when mod( rn, 3 ) = 2 then col_data end ) col2

    , max( case when mod( rn, 3 ) = 0 then col_data end ) col3

    , max( case when mod( rn, 3 ) = 1 then col_status end ) col1_stat

    , max( case when mod( rn, 3 ) = 2 then col_status end ) col2_stat

    , max( case when mod( rn, 3 ) = 0 then col_status end ) col3_stat

    , ceil( ( rn ) / 3 )

from ( select col_data, col_status, row_number() over (order by null) rn from tablea )  

group by ceil( ( rn ) / 3 )

fac586

Jitesh Gurnani wrote:

Please consider the sample data below containing 15 rows and 2 columns

Table A

Col_data Col_status

a         up

b         up

c         up

d         up

e         down

f         up

g         up

h         up

i         up

j         up

k         up

l         up

m         up

n         down

o         up

Now this table data needs to be displayed as a matrix report of 3 X 5.

The idea here is to only display the col_data to the end users.

The col_data text would be coloured as red or green depending on the col_status as up or down respectively.

Conditional html formatting needs to be applied in this case as in the below report.

col1 col2 col3 col4 col5
a b c d e
f g h i j
k l m n o

This is a user requirement on an actual table containing 500 rows.

The "user" does not know what they are doing.


Semantics

This is not a matrix report. It does not have 2 dimensions defined along the row and column axes. It does not display a measure in each cell that is dependent on the relationship of those dimensions.

Why does the data need to be displayed as 3×5 rows?

What are the column headings col1-col5? What is their relationship to the data?


Accessibility

This is how this "report" might appear to users with common colour blindness conditions:

  • Protanopia
  • Deuteranopia
  • Protanomaly

How are these users to interpret this? Are they seeing red/green values? Or red/amber/green?

This is how it might be experienced by visually impaired users when read by a screenreader, or through a one line Braille display:

row 1 col1 a col 2 b col3 c col4 d col5 e

row 2 col1 f col 2 g col3 h col4 i col5 j

row 3 col1 k col 2 l col3 m col4 n col5 o

These users get none of the information transmitted through the colour channel at all.

Usability

How are all users of the system to understand what this is displaying? Is there a legend or key explaining the meaning of the report? Are they supposed to be able to interact with the data in any way?


If—instead of this "matrix" nonsense—the actual requirement is to display 500 linear, unrelated values in a 20×25 grid, then explain the full requirements in order that the appropriate HTML structure, semantics, and accessibility features can be determined. Include:

  • The actual nature of the data
  • The meaning and derivation of the up/down red/green metrics
  • The required sort order
  • The required layout (across-down or down-across)
  • Realistic sample data

Also include (as always):

  • Your full APEX version
  • Full DB version, edition and host OS
  • Browser(s)/version(s) used
  • UI/Theme
fac586
Answer

ascheffer wrote:

It's not "tricky" at all, or do I miss the point?

  1. select max( case when mod( rn, 3 ) = 1 then col_data end ) col1 
  2.     , max( case when mod( rn, 3 ) = 2 then col_data end ) col2 
  3.     , max( case when mod( rn, 3 ) = 0 then col_data end ) col3 
  4.     , max( case when mod( rn, 3 ) = 1 then col_status end ) col1_stat 
  5.     , max( case when mod( rn, 3 ) = 2 then col_status end ) col2_stat 
  6.     , max( case when mod( rn, 3 ) = 0 then col_status end ) col3_stat 
  7.     , ceil( ( rn ) / 3 ) 
  8. from ( select col_data, col_status, row_number() over (order by null) rn from tablea )    
  9. group by ceil( ( rn ) / 3 ) 

Perhaps it's not in SQL terms, but that's not the only consideration...

Marked as Answer by Jitesh Gurnani-Oracle · Sep 27 2020
Anton Scheffer

I did include the status information

I did not add any ordering which doesn't exists in the table
It's up to the OP to hide information by using the col_stat to colour fields

Jitesh Gurnani-Oracle

Fac586,

This is a realistic sample data and this is how the requirements have been given. Instead of looking at colour blindness it would be great if you could look at a possible solution.

When ascheffer could understand the requirement and give a feasible solution, I am not sure as to why you are worried about colour blind people.

In plain simple terms, the solution given by ascheffer does work to an extent. Thanks for your time and assistance.

Anton Scheffer

That makes me wonder to what extent my solution doesn't fullfill your requirements?

And why you pick an answer by fac586 as the correct one?

jwellsnh

Nice solution for a 3x5 array of data but is it "practically feasible" for a 20x25 array?  I guess I would have to see the solution in it's business context to appreciate the design.

Jeff

1 - 16
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 10 2009
Added on Jul 13 2009
1 comment
258 views